Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T17:41:33.507' ,`MLSNumber` = '98587672' ,`ListAgentFullName` = 'Lizabeth Comiskey' ,`ListOfficeName` = 'Comiskey Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.297390' ,`Longitude` = '-94.928295' ,`PhotoCount` = '50' ,`PostalCode` = '77554' ,`RoomCount` = '7' ,`ListPrice` = '1250000.00' ,`Status` = 'Active' ,`StreetName` = 'Isles End' ,`StreetNumber` = '103' ,`StreetSuffix` = 'Road' ,`City` = 'Tiki Island' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '3' ,`SqFtTotal` = '2434' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOSTLY FURNISHED --BEAUTIFUL BAY FRONT HOME WITH PRIVATE POOL\r\nHome has the \"WOW\" Factor!\r\nThe kitchen and Family Room is wide open and ideal for entertaining with incredible views of Inter-coastal and Deer Island.\r\nTwo Primary\'s and Two Office Nooks!\r\nYou will love the pool entertainment area' ,`Acres` = '0.122' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tiki Island' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 7 S C BUNDICK SUR LOT 27 TIKI ISLAND SEC 11' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '5314' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '160' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '26 - Hitchcock' ,`SchoolElementary` = 'HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HITCHCOCK HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (HITCHCOCK)' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Other Style' ,`Subdivision` = 'Tiki Island' ,`TaxAmount` = '16127' ,`TaxRate` = '2.2119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707143' WHERE `Matrix_Unique_ID` = '207730961' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T17:57:44.203' ,`MLSNumber` = '60955798' ,`ListAgentFullName` = 'Christopher Dahl' ,`ListOfficeName` = 'DTP Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.740230' ,`Longitude` = '-95.491788' ,`PhotoCount` = '50' ,`PostalCode` = '77057' ,`RoomCount` = '8' ,`ListPrice` = '595000.00' ,`Status` = 'Active' ,`StreetName` = 'Briar Ridge' ,`StreetNumber` = '2410' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3058' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in gated Briar Grove Court which is minutes from the Galleria. This 3058 sq foot home is 2 story when you walk into the home you will enter the 2 story foyer. Downstairs you will find high ceiling in the dining area and family room. The family room features a built in bar area with sink and wine rack, triple moldings , gas fireplace and lots of windows for natural light. The kitchen has granite countertops, island with a gas cooktop, breakfast bar and the breakfast room. Upstairs you will find 3 bedrooms and the utility room with a washer and dryer. Located minutes from the Galleria, great shopping and dining.' ,`Acres` = '0.0792' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Briargrove' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TR 1 BRIAR GROVE COURT' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '3449' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Briar Grove Court' ,`TaxAmount` = '12634' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707143' WHERE `Matrix_Unique_ID` = '208387225' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T17:30:16.003' ,`MLSNumber` = '48354281' ,`ListAgentFullName` = 'Pamela Evans' ,`ListOfficeName` = 'Texas 1st Choice Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.376914' ,`Longitude` = '-95.115485' ,`PhotoCount` = '49' ,`PostalCode` = '77517' ,`RoomCount` = '3' ,`ListPrice` = '649000.00' ,`Status` = 'Active' ,`StreetName` = 'Cherry' ,`StreetNumber` = '4522' ,`StreetSuffix` = 'Street' ,`City` = 'Santa Fe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1998' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'YOUR FIRST IMPRESSION WILL BE \"WOW!\" WHEN YOU SEE THIS NEW BEAUTIFUL 3 BEDROOM TRADITIONAL HOME NESTLED ON 3 PLUS ACRES. HOME FEATURES BRAND NEW 2 CAR 24 X 25 GARAGE & 30 X 30 WORKSHOP HUGE STOCKED POND PALAPA AREA WITH HOT TUB AND TV MOUNT. HOME IS GATED WITH CODE ENTRY. NEWLY POURED BACK PORCH AREA. CHILDREN\'S BEDROOMS EACH HAVE A VANITY SINK AREA! HUGE ISLAND AND PICTURESQUE WINDOW IN BEAUTIFUL KITCHEN HOSTING GORGEOUS GRANITE COUNTER TOPS THAT GO ON FOR DAYS AND WHIRLPOOL STAINLESS APPLIANCE PACKAGE SURE TO PLEASE THE WIFEY, ALL THE WHILE OVERLOOKING COVERED FRONT PORCH AND POND AREA WHICH WILL BE FABULOUS FOR ENTERTAINING YOUR GUESTS. ALL INTERIOR WALLS IN BEDROOMS ARE INSULATED FOR WARMTH AND NOISE CONTROL FOR DAY SLEEPERS! ALSO HAS A 570\' DEEP WATER WELL!!!! THIS HOME HAS A LOT TO OFFER COME TAKE A LOOK AND MAKE AN OFFER TODAY!' ,`Acres` = '3.174' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 611 I & G N RR SUR SEC 17 PT OF LOT 9 (9-10) BLK 67 ARC' ,`LotDesciption` = 'Cleared' ,`LotSize` = '138259' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'ROY J. WOLLAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Controlled Access,Lockbox Front,No Photos/No Videos,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Arcadia Townsite' ,`TaxAmount` = '9603' ,`TaxRate` = '2.3536' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663707143' WHERE `Matrix_Unique_ID` = '209198671' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T17:32:20.960' ,`MLSNumber` = '62986589' ,`ListAgentFullName` = 'Denise Moore' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.635022' ,`Longitude` = '-95.753108' ,`PhotoCount` = '30' ,`PostalCode` = '77406' ,`RoomCount` = '12' ,`ListPrice` = '925000.00' ,`Status` = 'Active' ,`StreetName` = 'Garcitas' ,`StreetNumber` = '2714' ,`StreetSuffix` = 'Creek' ,`City` = 'Richmond' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4618' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home has it all. Primary and 3 more bedrooms are downstairs. Possible 5th bedroom (currently the media room) is upstairs along with a game room, balcony, and a full bath. There is a huge dining room as you enter through the front door, a library with built in bookshelves overlooks the patio for those cozy mornings or evenings reading a book. The study and laundry room are located near the kitchen, both have a lot of storage space. A butler\'s pantry with wine fridge is there too! The kitchen that has it all overlooks the family room with a fireplace. There is a half bath located near the kitchen. On one side of the house there are three bedrooms, one has its own bathroom and the other two are Jack and Jill. There is tile on the first floor, bedrooms have carpet, and the primary room has wood floor. Both water heaters have been replaced in the last couple of years, the roof replaced a few months ago, the sprinkler system covers the entire yard and landscaping lights recently put in.' ,`Acres` = '0.8986' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TEXANA PLANTATION SEC 5, BLOCK 2, LOT 20, ACRES 0.8986, (ACR' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '39143' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Other Style' ,`Subdivision` = 'Texana Plantation Sec 5' ,`TaxAmount` = '14941' ,`TaxRate` = '2.1648' ,`WaterSewer` = 'Aerobic,Septic Tank,Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707143' WHERE `Matrix_Unique_ID` = '209455991' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T16:07:03.467' ,`MLSNumber` = '34458256' ,`ListAgentFullName` = 'Yolanda Graham' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.489945' ,`Longitude` = '-94.960643' ,`PhotoCount` = '11' ,`PostalCode` = '77539' ,`RoomCount` = '10' ,`ListPrice` = '800000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 517' ,`StreetNumber` = '2756' ,`StreetSuffix` = 'Road' ,`City` = 'San Leon' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1816' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '5 ACRES WITH NO RESTRICTIONS THAT CAN BE ZONED COMMERCIAL OR RESIDENTIAL NEAR THE SAN LEON PENINSULA! This 5 Acre estate is loaded with amenities and fronts FM 517 in a high-traffic area that could make this property just perfect for a business, RV Park, Vacation Rental, or just your very own home with (2) income-producing apartments. Includes a 50x60 steel frame Pavillion, 3-stall horse barn w/tack room; inground pool, pond, and much more! The main home -2 bedrooms, 2 baths, and a covered patio. The Guest House has 1 bedroom, office, kitchen, and utility room. The Apartment above the Guest House can be rented as an income-producing property or used as a game room with a bedroom, bath, and kitchen. San Leon a growing community is known for great fishing, excellent seafood, and is central to Galveston, Houston, and neighboring Kemah, Texas City, Clear Lake, and League City. THE PROPERTY IS BEING SOLD \"AS-IS.\" The Sellers are motivated to sell and will entertain all offers.' ,`Acres` = '5' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Central Electric,Heat Pump' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 10 PAGE 7 LOT 7 (7-3) BLK 28 SAN LEON FM HM TRS' ,`LotDesciption` = 'Other,Water View' ,`LotSize` = '217800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SAN LEON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'San Leon Farm Home Tracts' ,`TaxAmount` = '15069' ,`TaxRate` = '2.521' ,`WaterSewer` = 'Aerobic,Public Sewer,Public Water,Well' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707143' WHERE `Matrix_Unique_ID` = '210306134' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T16:18:25.083' ,`MLSNumber` = '90146519' ,`ListAgentFullName` = 'Johnathen Reyes' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.734108' ,`Longitude` = '-95.609689' ,`PhotoCount` = '27' ,`PostalCode` = '77082' ,`RoomCount` = '6' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Ashford Creek' ,`StreetNumber` = '12707' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1784' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Updated house!!!! Updated kitchen!! updated bathrooms!!!!\r\nUpdates include kitchen cabinets, granite countertops, appliances, lights, spotlights, most doors, interior paint, baseboards, carpet,\r\nluxurious waterproof vinyl laminate planks, and many more!!!\r\nThe following items were replaced in 2022: roof, a/c and heating, water heater.' ,`Acres` = '0.1253' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 3 ASHFORD PARK SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5460' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '280' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'HEFLIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'O\'DONNELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Ashford Park Sec 06' ,`TaxAmount` = '4999' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707144' WHERE `Matrix_Unique_ID` = '210483262' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T17:09:31.933' ,`MLSNumber` = '95617019' ,`ListAgentFullName` = 'Melissa Morales' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.850091' ,`Longitude` = '-95.807966' ,`PhotoCount` = '26' ,`PostalCode` = '77493' ,`RoomCount` = '11' ,`ListPrice` = '303300.00' ,`Status` = 'Active' ,`StreetName` = 'Crimson Flagg' ,`StreetNumber` = '5259' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1795' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Like new, well-maintained home on a cul-de-sac! Gorgeous and easy-to-maintain wood-look tile floors throughout entire downstairs living areas including the living room with lots of natural light. Open concept kitchen features a spacious breakfast bar with seating, granite counters, travertine backsplash, tall espresso-stained cabinets, and a bright and airy breakfast room. All bedrooms are upstairs with a split floor plan for the ultimate in privacy! Primary bedroom has an en-suite bath with dual sinks and a separate walk-in shower. On the other side of the game room are two more bedrooms and a bath. Don\'t miss the fully fenced backyard with a patio slab and lots of green space, perfect for entertaining! Built-in pest control system. Washer, dryer, and fridge stay. Community has all the amenities, including a splash pad and playground just a short distance away!' ,`Acres` = '0.1154' ,`Area` = '25' ,`BuilderName` = 'KB' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 39 BLK 1 KATY MANOR SEC 6' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '5025' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '468' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Katy Manor' ,`TaxAmount` = '7058' ,`TaxRate` = '3.4768' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707144' WHERE `Matrix_Unique_ID` = '210710870' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T17:52:23.410' ,`MLSNumber` = '19733015' ,`ListAgentFullName` = 'Leslie Fernandez' ,`ListOfficeName` = 'Texas Ally Real Estate Group,' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.732767' ,`Longitude` = '-95.496713' ,`PhotoCount` = '26' ,`PostalCode` = '77057' ,`RoomCount` = '6' ,`ListPrice` = '329000.00' ,`Status` = 'Active' ,`StreetName` = 'Fairdale' ,`StreetNumber` = '6363' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1756' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this charming home nestled just minutes from the Galleria in a quiet gated community. This three story home features a family/game room on the first floor that can be easily be converted to a 3rd bedroom. A private outdoor brick patio ready for entertaining family and friends! The second floor features an open floor plan with access to the living and dining room area. It\'s modern gourmet kitchen features granite countertops, stainless steel appliances and a wine rack. The master and second bedrooms are on the third floor and conveniently offer personal ensuite bathrooms. Enjoy the stand up shower or relaxing jet tub located in the master bedroom!! The washer and dryer connections are on the third floor utility closet. The A/C unit has recently been serviced. INCLUDED IN SALE: DRAPERIES, REFRIGERATOR, WASHER AND DRYER.' ,`Acres` = '0.0399' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Galleria' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 1 FAIRDALE PLACE RESERVE T/H 2ND R/P AMEND' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '1738' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PILGRIM ACADEMY' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairdale Place Reserve' ,`TaxAmount` = '7030' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707144' WHERE `Matrix_Unique_ID` = '210842393' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T16:46:08.900' ,`MLSNumber` = '86346830' ,`ListAgentFullName` = 'Olga Parks' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819593' ,`Longitude` = '-95.698159' ,`PhotoCount` = '12' ,`PostalCode` = '77084' ,`RoomCount` = '8' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Appletree Hill' ,`StreetNumber` = '18834' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2032' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful newly renovated 1-story home with 4 bedrooms, 2 baths, 2 car garage, master bedroom with large walk-in closet. master bath with tub & separate shower and double sinks, kitchen with granite countertops, gas range, gas fireplace, and large back yard. Updated stove, microwave, light fixtures, fresh paint, and new luxury vinyl laminate flooring in master bed. Wonderful subdivision with tennis courts, playgrounds & pool. LOW TAXES & LOW HOA fees! Never flooded. Zoned to Katy ISD Schools within walking distance. Near I-10 with quick access to Energy Corridor, West Houston Medical Centers, restaurants and more. \r\n\r\nMake your appointment soon!' ,`Acres` = '0.1574' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 1 BARKERS RIDGE SEC 1 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6856' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '485' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'SCHMALZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MAYDE CREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Barkers Ridge Sec' ,`TaxAmount` = '5353' ,`TaxRate` = '2.487' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663707144' WHERE `Matrix_Unique_ID` = '210844617' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T17:06:49.353' ,`MLSNumber` = '14655105' ,`ListAgentFullName` = 'Nancy Ware' ,`ListOfficeName` = 'Coldwell Banker Realty, Cy-Fair Office' ,`SellingAgentFullName` = 'Agnes Casimiro' ,`SellingOfficeName` = 'Texas Homestead, Realty' ,`Latitude` = '29.804887' ,`Longitude` = '-95.424654' ,`PhotoCount` = '29' ,`PostalCode` = '77008' ,`RoomCount` = '11' ,`ListPrice` = '499999.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = '21st' ,`StreetNumber` = '1415' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3081' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy all The Heights area has to offer in this beautiful 3 story home nestled in the heart of sought-after Shady Acres neighborhood. Here you will find you are within walking distance of the White Oaks Bayou Trail System, coffee shops, eateries, shopping and nightlife. This open concept living area features hardwood floors, vaulted ceilings, crown molding, gas fireplace and two walk out balconies. The gourmet kitchen boasts granite countertops, walk in pantry and stainless appliances including a wine cooler. In addition to three bedrooms, the home also has two rooms and a full bathroom located on the first floor that could easily be converted into a huge guest/mother-in-law suite or home office. Great floorplan with an abundance of storage. Outside there is fenced in yard space with enough room for grilling or running room for the furry friend. Easy access to 610, I45 and 290. No flooding, no HOA.' ,`Acres` = '0.0625' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 CASTONE COURT AT WEST TWENTY FIRST STREET' ,`LotDesciption` = 'Other' ,`LotSize` = '2724' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Castone Court/West 20 1st St' ,`TaxAmount` = '11985' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707144' WHERE `Matrix_Unique_ID` = '210998422' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T16:22:04.823' ,`MLSNumber` = '17583841' ,`ListAgentFullName` = 'Collin Nguyen' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.800632' ,`Longitude` = '-95.476176' ,`PhotoCount` = '19' ,`PostalCode` = '77055' ,`RoomCount` = '8' ,`ListPrice` = '339000.00' ,`Status` = 'Active' ,`StreetName` = 'Dearborn' ,`StreetNumber` = '7406' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nice 3 bedrooms and 1 bath home with ceramic-tile throughout. Updated bathroom, cabinets and granite kitchen countertops, Hardiplank Siding in 2015 and 2016. Roof was installed in 2015. New 2\" wood blinds throughout. Large backyard. Located in the heart of Spring Branch. This home is surrounded by many new construction homes within the area, and it is minutes from the Galleria and Downtown area. Easy access to freeways (I-10/610/290).' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6960' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HOUSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pine Terrace' ,`TaxAmount` = '5510' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707144' WHERE `Matrix_Unique_ID` = '211143625' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T17:29:43.790' ,`MLSNumber` = '39633533' ,`ListAgentFullName` = 'Lisa Weatherby' ,`ListOfficeName` = 'LMW Property Management' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.368798' ,`Longitude` = '-95.151532' ,`PhotoCount` = '43' ,`PostalCode` = '77328' ,`RoomCount` = '9' ,`ListPrice` = '525000.00' ,`Status` = 'Active' ,`StreetName` = 'Oakridge' ,`StreetNumber` = '71' ,`StreetSuffix` = 'Drive' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2375' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '5 Acres backs up to Sam Houston National Forest! Private! Fenced 3/4Acre pond and separate fenced pond/pasture in back! Recently updated 4br/2b custom built home, new flooring, Stone fireplace, beautiful country ranch style with clawfoot bathtub upstairs! Lots of natural light from picture windows! Will have NEW AC/Heat at close of escrow! Separate one story 1br/1b rental house or use as guest/mother inlaw quarters. Covered RV hookups! Storage Shed! Plenty if cleared area in back to build another home or workshop! Acreage!!' ,`Acres` = '5.0045' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Coldspring/South San Jacinto County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'A350 I&GNRR CO, TRACT 32.1, ACRES 5.0045' ,`LotDesciption` = 'Waterfront,Wooded' ,`LotSize` = '217996' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'NORTHSIDE ELEMENTARY SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Oak Ridge' ,`TaxAmount` = '3829' ,`TaxRate` = '1.9249' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707144' WHERE `Matrix_Unique_ID` = '211273263' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T17:06:28.293' ,`MLSNumber` = '36997058' ,`ListAgentFullName` = 'Ronnie Dees' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.464746' ,`Longitude` = '-94.607370' ,`PhotoCount` = '31' ,`PostalCode` = '77650' ,`RoomCount` = '7' ,`ListPrice` = '519900.00' ,`Status` = 'Active' ,`StreetName` = 'Whitecap' ,`StreetNumber` = '2599' ,`StreetSuffix` = '' ,`City` = 'Port Bolivar' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cozy and Quiet 3 bedroom 2 full bath beach house in Holiday Beach Subdivision. Enjoy the serene gulf winds and ocean sounds on your covered upper or lower patios with partial view of the beach and gulf waters. Beautiful vinyl wood-look flooring, granite countertops, recessed lighting and ceiling fans throughout. Living area made for entertaining with an easy open floor plan. Spacious living room boasts large windows allowing in plenty of natural light creating a bright and open space. Gourmet kitchen features a breakfast bar, undermount sink, stainless appliances and tile backsplash. recent updates/upgrades to include: New breaker box, A/C serviced, added 6\" of insulation, new roof vents, New deck, new soffit throughput, new lighting, new paint inside & out, new water heater, new appliances, new toilets, vanity & fixtures!! Property located in flood zone A! Schedule your showing of this perfectly priced home today!!' ,`Acres` = '0.1736' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 65 B FRANKS SUR LOT 243 HOLIDAY BEACH' ,`LotDesciption` = 'Corner,Subdivision Lot,Water View' ,`LotSize` = '7562' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Holiday Beach' ,`TaxAmount` = '4802' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707145' WHERE `Matrix_Unique_ID` = '211282806' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T17:03:08.800' ,`MLSNumber` = '76618961' ,`ListAgentFullName` = 'Edgar Martin' ,`ListOfficeName` = 'RE/MAX GO' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.544925' ,`Longitude` = '-95.491857' ,`PhotoCount` = '46' ,`PostalCode` = '77545' ,`RoomCount` = '7' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Youpon Glen' ,`StreetNumber` = '2803' ,`StreetSuffix` = 'Way' ,`City` = 'Fresno' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2801' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a very large and unique 4 bedroom single story home busting with features. As you enter on your left will be a large open area that you can design with furniture to your liking. There is a Large Media room, large Family room(with Fireplace), Kitchen with an Island accented directly above it by a beautifully tinted Sky Lite to see the stars at night. The Kitchen L Shaped long Counter Top Bar will handsomely seat 5 Guest. Then there is the Giant Master bedroom with an included Bath/Shower and Oversized walk-in Closet. But there are many more extras to this home … come see for yourself.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Winfield Lakes Sec 7, Block 1, Lot 83' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6569' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PARKS ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'HIGHTOWER HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Winfield Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707145' WHERE `Matrix_Unique_ID` = '211541306' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T17:56:46.267' ,`MLSNumber` = '85801661' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.852738' ,`Longitude` = '-95.742516' ,`PhotoCount` = '7' ,`PostalCode` = '77449' ,`RoomCount` = '4' ,`ListPrice` = '334990.00' ,`Status` = 'Active' ,`StreetName` = 'Oakwood Meadows Lane' ,`StreetNumber` = '21627' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1796' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FANTASTIC BRAND NEW DR HORTON HOME IN THE BEST LOCATION!! Perfect 1 story floor plan with everything you have been looking for!! Great open living spaces, modern finishes, designer details, 2 bedrooms down, lovely primary suite, and so much more!! Beautiful island kitchen! Perfect for entertaining!! Great game room on the second floor!! Lovely outdoor space with useful covered back patio! Includes landscape package!! Don\'t miss this opportunity!! Hurry and call today! This property will sell fast!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 24 Block 2 Section 25' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'GOLBOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'MCDONALD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jasmine Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707145' WHERE `Matrix_Unique_ID` = '211605003' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','211736043','1663707145','211736043','2022-09-05T16:21:45.747','77429792','Alisha Maknojia','AVOREC','','','30.071086','-95.540053','36','77379','8','475000.00','Active','Windsor View','7427','Drive','Spring','3','1','4','2753','Single-Family','Everything you were looking for in a GORGEOUS two story house! This beauty features a brick and stone exterior with 4 bedrooms and 3.5 bathrooms, study room, a two story family room with lots of natural light, and a huge backyard! Situated in the master planned community of Laurel Park, the amenities are endless. You are also in close proximity to Grand Parkway, Grand Parkway Marketplace, lots of restaurants and shopping! You don\'t want to miss out on this house, call for a showing today!','0.1722','14','Princeton Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Spring/Klein/Tomball','Central Gas','1','LT 10 BLK 2 LAUREL PARK NORTH SEC 1','Subdivision Lot','7500','Appraisal District','','1055','0','','3','Gas Oven,Single Oven','0','','','Gas Cooktop','','Composition','32 - Klein','MUELLER ELEMENTARY SCHOOL','KLEIN CAIN HIGH SCHOOL','DOERRE INTERMEDIATE SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','2','Contemporary/Modern,Other Style,Traditional','Laurel Park North Sec 1','10840','3.2565','Water District','2017','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212136664','1663707145','212136664','2022-09-05T17:38:24.217','37388290','Patricia Rodriguez','Ambassador Realty','','','28.966548','-95.447268','35','77541','11','189900.00','Active','Avenue K','301','','Jones Creek','3','0','6','2733','Single-Family','A beloved family home for many years, this 6 bedroom, 3 bath home is ready to find its new family! A rare opportunity to own over 2700+ sq ft on over half an acre corner lot in Jones Creek. Yes, it needs some updating and TLC, but you can feel the love that has existed within its walls. You can make it a showplace once again for you and your family! This home offers a formal living room, formal dining room, large kitchen with breakfast bar open to the huge den with fireplace and built-in bar. Primary bedroom downstairs with 2 more oversized bedrooms all with walk in closets. Upstairs you will find 3 more bedrooms, and a full bath with oversized storage room. The indoor utility room also host a huge pantry area. Priced low to allow for its needed repairs, this home also offers a large screened in porch, separate shop, and huge garage. Sold \"As Is Where Is\" Don\'t let this one pass you by!','0.5612','5','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','','Mock Fireplace','1','Freeport','Central Gas','0','DURAZNO GARDENS NO 2 (A0020 S F AUSTIN DIV 18) BLK 11 LOT 3-','Corner','24446','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','7 - Brazosport','AUSTIN ELEMENTARY SCHOOL (BRAZOSPORT)','BRAZOSPORT HIGH SCHOOL','FREEPORT INTERMEDIATE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','2','Traditional','Durazno Gardens 2','3607','2.5124','Septic Tank,Well','1970','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212169187','1663707145','212169187','2022-09-05T16:26:35.980','82677382','Jenna Myers','eXp Realty, LLC','','','29.816657','-95.534940','31','77080','9','469000.00','Active','Parana Drive','2506','','Houston','2','0','4','1993','Single-Family','Charming + impeccably updated home nestled on quiet cul-de-sac in the heart of Spring Shadows that you won\'t want to miss. Steps away from Phase 2 of the Spring Branch Trail, this beauty boasts an impressive inventory of updates including modern kitchen with Carrera Marble, freshly renovated bathrooms, recent roof, HVAC, PEX plumbing, windows, water heater, Luxury Vinyl Plank Flooring, modern paint, fixtures, appliances, the list keeps going! Cozy up by the restored fireplace with a picture perfect view of the covered porch & shaded backyard ready to host your next hangout or holiday. The light filled, efficient layout lends itself to countless possibilities to make it perfectly yours. Minutes from CityCentre, Memorial City and walk/bike trails (never flooded!) with endless nearby dining options & activities, you\'ll be sure to love it here. Tour today!','','24','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Wood Burning Fireplace','1','Spring Branch','Central Gas','1','Lot 41 Block 5 Spring Shadows Section 4','Cul-De-Sac,Subdivision Lot','7280','Appraisal District','','336','0','','2','','0','','','','','Composition','49 - Spring Branch','SPRING SHADOW ELEMENTARY SCHOOL','NORTHBROOK HIGH SCHOOL','SPRING WOODS MIDDLE SCHOOL','Accompany,Appointment Required,Request Online Appointment,Supra Keybox','Appraisal District','1','Ranch','Spring Shadows','','','Public Sewer,Public Water','1968','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212194088','1663707145','212194088','2022-09-05T16:09:14.863','15551414','Blake Vincent','DUX Realty, LLC','','','29.750714','-95.387480','39','77006','11','669900.00','Active','WHITNEY','2008','Street','Houston','2','1','3','2312','Single-Family','MCD\'s new division is here in Houston\'s well established inner loop neighborhoods. MazzTao Homes features a new, stylish, well priced, quality home, but w/an entirely different price point. You no longer have to compromise location to buy somewhere or something else, that you just don’t really want. This home is extremely versatile w/a functional floor plan. This 2-story home is energy efficient w/spray foam insulation, smart screen thermostat, variable speed furnace & two-stage condenser w multi-level zoning, 1st floor living, granite/quartz countertops, GE appliance, generous primary walk-in closet, flex room, private driveway & approx 450sf yard space w/built-in pest control sys. Retail, restaurants, & more are walking distance away. Major freeways, downtown, medical center, &parks are all w/in minutes. Ask about customization options during construction ONLY! Photos are of MODEL HOME - use as guide. Illustrations are for marketing purposes only. ALL info must be verified by Buyer.','','16','Mazzarino Cons & Dev','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','','','Montrose','Central Gas,Zoned','0','LT 2 BLK 1 WHITNEY VILLAS','Subdivision Lot','2275','Other','','','1','To Be Built/Under Construction','2','Convection Oven,Electric Oven,Single Oven','0','','','Gas Cooktop,Gas Range','','Composition','27 - Houston','WILLIAM WHARTON K-8 DUAL LANGUAGE ACADEMY','LAMAR HIGH SCHOOL (HOUSTON)','GREGORY-LINCOLN MIDDLE SCHOOL','Appointment Required','Builder','2','Contemporary/Modern,Traditional','WHITNEY VILLAS','','','Public Sewer,Public Water','2023','Builder'); --> New record created successfully