| Column Name | Type | Null | Default |
|---|---|---|---|
| id | int(11) | NO | NULL |
| source | varchar(50) | YES | NULL |
| title | varchar(255) | YES | NULL |
| price | int(11) | YES | NULL |
| location | varchar(255) | YES | NULL |
| type | varchar(50) | YES | NULL |
| description | text | YES | NULL |
| reference | varchar(100) | YES | NULL |
| images | text | YES | NULL |
| bedrooms | int(11) | YES | NULL |
| bathrooms | int(11) | YES | NULL |
| date_added | datetime | YES | current_timestamp() |
| featured | tinyint(1) | YES | 0 |
| blacklisted | tinyint(1) | NO | 0 |
| blacklisted_date | datetime | YES | NULL |
| plot_size | int(11) | YES | NULL |
| build_size | int(11) | YES | NULL |
✅ Both plot_size and build_size columns exist!
| ID | Reference | Plot Size | Build Size | Beds | Baths |
|---|---|---|---|---|---|
| 1 | esp | 23897m² | 150m² | 1 | - |
| 2 | alou | 88000m² | 48m² | - | - |
| 3 | pmil | NULL | 160m² | 4 | - |
| 5 | Fra | 62000m² | 74m² | - | - |
| 10 | Alti | 10000m² | 30m² | - | - |
| 11 | Td1 | 10539m² | 50m² | - | - |
| 12 | Riverside 18 | 6951m² | 180m² | - | - |
| 13 | Ja | NULL | 125m² | 3 | 1 |
| 14 | Mdv | 100000m² | 95m² | 1 | 1 |
| 15 | Vv | 18900m² | 150m² | - | - |
Summary:
✅ RSS cache file exists: rss_cache.xml
Last modified: 2025-12-16 14:31:12
| Reference | Status | Plot Size | Build Size |
|---|
❌ No items found in RSS feed!
| Metric | Count | Percentage |
|---|---|---|
| Total Properties | 68 | 100% |
| With Plot Size | 55 | 81% |
| With Build Size | 66 | 97% |
| With Both Sizes | 53 | 78% |
Here's what your data looks like:
Reference: esp Title: A simply stunning finca in a private location with superb views. The land is both flat and terraced ... Plot Size: 23897 Build Size: 150 Price: €25,000 --- Reference: alou Title: A large finca with a traditional stone casita to reform. Located in a beautiful and tranquil positio... Plot Size: 88000 Build Size: 48 Price: €18,000 --- Reference: pmil Title: A traditiona village house to restore in Benifallet a location ever popular for its proximity to the... Plot Size: NULL Build Size: 160 Price: €15,000 ---← Back to Admin