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-10-02T07:23:22.480' ,`MLSNumber` = '33874952' ,`ListAgentFullName` = 'Dehong Marchtaler' ,`ListOfficeName` = 'RE/MAX Eastside' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.985703' ,`Longitude` = '-94.746788' ,`PhotoCount` = '48' ,`PostalCode` = '77575' ,`RoomCount` = '3' ,`ListPrice` = '189900.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 140' ,`StreetNumber` = '399' ,`StreetSuffix` = '' ,`City` = 'Liberty' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1178' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3b, 2ba on a beautiful flat half-acre. Renovations done: new beautiful flooring, new kitchen cabinets with gorgeous Statuario classical quartz countertops, stainless steel sink, new sheetrock, all new plumbing drain and pressure throughout the entire house pex plumbing all new valves and high-end fixtures, new 3-ton HAVC, new furnace, new ductwork, brand new 200 AMP breaker box, new toilets, new tubs, large smart led touch screen mirrors. Well water, Septic tank has been serviced with new lid. new bathroom vanities and new fresh paint interior and exterior. new molding, new lightings, new insulation on newly built ceiling. Appliances include brand new stove and dishwasher. Also has a shed for your storage and a covered patio for outdoor BBQ or grill. Don\'t forget the new gutter around the house and brand-new decks both front and back. This is a great house for any first-time buyer or a rental to generate cash-flow. A turnkey and move in ready house. County living at its best!' ,`Acres` = '0.5' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Liberty' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '000051 WILLIAM HARRIS, TRACT 52, ACRES .5' ,`LotDesciption` = 'Cleared' ,`LotSize` = '21780' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '73 - Liberty' ,`SchoolElementary` = 'LIBERTY ELEMENTARY SCHOOL (LIBERTY)' ,`SchoolHigh` = 'LIBERTY HIGH SCHOOL (LIBERTY)' ,`SchoolMiddle` = 'LIBERTY MIDDLE SCHOOL (LIBERTY)' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'William Harris' ,`TaxAmount` = '523' ,`TaxRate` = '1.9555' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664717218' WHERE `Matrix_Unique_ID` = '209712304' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T06:22:09.970' ,`MLSNumber` = '51954928' ,`ListAgentFullName` = 'John Newsom' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.783069' ,`Longitude` = '-96.147697' ,`PhotoCount` = '34' ,`PostalCode` = '77474' ,`RoomCount` = '7' ,`ListPrice` = '155000.00' ,`Status` = 'Active' ,`StreetName` = 'Live Oak' ,`StreetNumber` = '803' ,`StreetSuffix` = 'Street' ,`City` = 'Sealy' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Unique property in Sealy, Tx . Could be residence or continue as a church. 1/2 acre lot. Room for garage addition . Unrestricted corner lot. Possibilities are endless.' ,`Acres` = '0.4659' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Space Heater,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'A005 SAN FELIPE DE AUSTIN T T ACRES 0.4659' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '20295' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '109 - Sealy' ,`SchoolElementary` = 'SEALY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEALY HIGH SCHOOL' ,`SchoolMiddle` = 'SEALY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'None' ,`TaxAmount` = '644' ,`TaxRate` = '2.149' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1664717218' WHERE `Matrix_Unique_ID` = '210093241' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T07:32:49.927' ,`MLSNumber` = '87586975' ,`ListAgentFullName` = 'Shannon Hall' ,`ListOfficeName` = 'Gulf Coast, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.210581' ,`Longitude` = '-95.344426' ,`PhotoCount` = '45' ,`PostalCode` = '77302' ,`RoomCount` = '6' ,`ListPrice` = '419900.00' ,`Status` = 'Active' ,`StreetName` = 'Sandstone' ,`StreetNumber` = '17192' ,`StreetSuffix` = 'Street' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2189' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '$5,000 towards buyer\'s closing cost! Sellers have filled this stunning Perry home w/ amazing upgrades to give it that custom feel! Beautiful entry w/ 12ft trayed ceiling, custom light fixture & wood look tile flooring throughout main areas. Spacious office area just off the entry w/ 8ft clear view doors. Living room w/ wall of windows overlooking covered patio, accent wall, large fan & totally open flow to the kitchen & dining areas. The perfectly planned kitchen features quartz counters, custom painted island, large counter height bar, corner walk-in pantry, all stainless appliances, upgraded hardware, gorgeous drop lights & ample cabinet space! Primary bedroom features sliding barn door to an absolutely gorgeous bathroom w/ centered garden tub, double vanities, separate shower w/ rainfall head. Secondary bath features custom tile surround, shiplap accent wall & brass sliding door! Outdoor kitchen w/ gas grill and refrigerator. 5 acre lake, splash pad & more!' ,`Acres` = '0.148' ,`Area` = '19' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S216900 - ARTAVIA 01, BLOCK 3, LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6446' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '925' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Artavia 01' ,`TaxAmount` = '1679' ,`TaxRate` = '3.1988' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1664717219' WHERE `Matrix_Unique_ID` = '210229738' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T07:49:19.390' ,`MLSNumber` = '54014535' ,`ListAgentFullName` = 'Lucy Alvarado' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.888033' ,`Longitude` = '-95.424304' ,`PhotoCount` = '16' ,`PostalCode` = '77088' ,`RoomCount` = '5' ,`ListPrice` = '199999.00' ,`Status` = 'Active' ,`StreetName` = 'Willow Rock' ,`StreetNumber` = '1422' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1038' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful corner lot home that has a huge, cleared back yard with covered patio. Perfect for children or pets\r\nto enjoyed it. Plenty of parking space. The possibilities are endless. Conveniently located near 45N and easy access to HWY 249. All appliances stay. Burglar Bars throughout home that were installed in 2019. No low ballers. Make sure you are able to afford this home before seeing it.' ,`Acres` = '0.1696' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 11 BLK 20 WILLOW RUN SEC 5' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot' ,`LotSize` = '7387' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'HILL ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'EISENHOWER HIGH SCHOOL' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Willow Run Sec 05' ,`TaxAmount` = '3644' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1664717219' WHERE `Matrix_Unique_ID` = '210703756' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T06:23:14.193' ,`MLSNumber` = '61731832' ,`ListAgentFullName` = 'Bruce Brittimes' ,`ListOfficeName` = 'Brittimes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.956700' ,`Longitude` = '-95.733515' ,`PhotoCount` = '42' ,`PostalCode` = '77433' ,`RoomCount` = '9' ,`ListPrice` = '679000.00' ,`Status` = 'Active' ,`StreetName` = 'Partners Voice' ,`StreetNumber` = '18615' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3705' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Seller will contribute toward interest rate buy-down.\r\nLuxury at its finest 4/3.5/3 single story home. It’s time to treat yourself with this beautiful semi-custom home with awesome curb appear in Bridgeland Community. Come enjoying this beautiful craftmanship home from the high ceiling\'s custom interior trimmings down to the freshly polished wood floors in the formal living area and the formal dining area. The bonus room/sunroom is connected to the living room. When it\'s time to retreat come and enjoy your humongous prime bedroom with bonus room for lounging and private time. Too many upgrades to name: Custom Kitchen Cabinets, custom tiles, chandeliers in prime closets, 4-year-old installed roof w/ 30 yrs warranty, newly in HVAC system and more.' ,`Acres` = '0.2089' ,`Area` = '25' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 4 SHORES SEC 4' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '9100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1255' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'POPE ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '15826' ,`TaxRate` = '3.4329' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664717219' WHERE `Matrix_Unique_ID` = '210846320' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T07:57:44.500' ,`MLSNumber` = '85910971' ,`ListAgentFullName` = 'Bridget Hensley' ,`ListOfficeName` = 'Re/Max Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.042396' ,`Longitude` = '-95.709739' ,`PhotoCount` = '32' ,`PostalCode` = '77480' ,`RoomCount` = '7' ,`ListPrice` = '354999.00' ,`Status` = 'Active' ,`StreetName` = 'Victory' ,`StreetNumber` = '204' ,`StreetSuffix` = 'Lane' ,`City` = 'Sweeny' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2238' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME to 204 Victory Lane! This stunning custom built home nested on huge lot with trees on an established cul-de-sac is waiting for you in the highly desirable Sweeny ISD! Features include 4 spacious bedrooms and 3 full bathrooms with a split floor plan for added privacy for the master suite! Master bath offers a nice size claw tub and walk in shower! A gourmet kitchen with a 6 burner gas stove, tons of storage for your baking and cooking needs! Lots of built-ins! Additional charming living area, perfect for a home office or game room! Retreat after a long day on the covered patio, tons of shade for outdoor fun and entertaining! Plenty of space for a sparkling pool! This home has never flooded Don\'t delay and schedule your showing for this gem today!' ,`Acres` = '0.3' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PROMISED LAND ESTATES SEC 2 (SWEENY), LOT 7' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '13068' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '51 - Sweeny' ,`SchoolElementary` = 'SWEENY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SWEENY HIGH SCHOOL' ,`SchoolMiddle` = 'SWEENY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Promised Land Estates Sec 1-2' ,`TaxAmount` = '8167' ,`TaxRate` = '2.8427' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664717219' WHERE `Matrix_Unique_ID` = '210898562' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T07:02:58.283' ,`MLSNumber` = '88923904' ,`ListAgentFullName` = 'Shari Postel' ,`ListOfficeName` = 'RE/MAX Northwest, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.038260' ,`Longitude` = '-95.557096' ,`PhotoCount` = '50' ,`PostalCode` = '77379' ,`RoomCount` = '11' ,`ListPrice` = '1390000.00' ,`Status` = 'Active' ,`StreetName` = 'Florham Park' ,`StreetNumber` = '18' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '3' ,`BedsTotal` = '5' ,`SqFtTotal` = '6919' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Reduced! Custom Mediterranean Villa built by award winning architects & designers! Amazing 1.38 acres on golf course w/well & septic. Very private lot in Villages of Gleannloch Farms. Features 4/5 bedrooms, 3 full baths & 3 half baths with a hard to find 5-car garage! Private, gated courtyard entrance w/fountain & colonnades. Custom solid wood front doors, high ceilings, custom chandeliers, built-ins & original features throughout! Main family room has custom Cantera stone columns, concrete floors, wood beams, French doors w/amazing views to the veranda & huge outdoor living space. Open island kitchen. Primary bedroom is amazing! Custom study down, as well as pub/media room. Upstairs has 3 large bedrooms+ game room (could be 5th) & huge balcony with great views! Enjoy the outdoor kitchen, fireplace, beach entry pool, spa & waterfalls. Sprinklers, mosquito system, water softener. Needs a little love & is a gorgeous home! Klein ISD. Fantastic Gleannloch Farms has so many amenities!' ,`Acres` = '1.3761' ,`Area` = '14' ,`BuilderName` = 'SullivanHenryOggero' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 1 THE ESTATES 2ND PAR R/P VILLAGES OF GLEANNLOCH F' ,`LotDesciption` = 'In Golf Course Community,On Golf Course,Subdivision Lot' ,`LotSize` = '59941' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '5' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'HASSLER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Villages Gleannloch Farms' ,`TaxAmount` = '27561' ,`TaxRate` = '2.0766' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664717219' WHERE `Matrix_Unique_ID` = '211204334' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T06:49:42.833' ,`MLSNumber` = '68063415' ,`ListAgentFullName` = 'Carolyn Cooling' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.587736' ,`Longitude` = '-95.046988' ,`PhotoCount` = '50' ,`PostalCode` = '77586' ,`RoomCount` = '18' ,`ListPrice` = '2850000.00' ,`Status` = 'Active' ,`StreetName` = 'Lakeway' ,`StreetNumber` = '1319' ,`StreetSuffix` = 'Drive' ,`City` = 'Seabrook' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '7100' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Situated in one of Houston Bay Areas most sought after neighborhoods, Taylor Lake Shores is 30 miles from The Houston Medical Center and Downtown Houston. This spacious six bedroom home is equipped with two downstairs bedrooms, multiple work/study areas, River Oaks Theater style media room, personal gym overlooking the lake, and a reading room just up a private stairway from the primary bedroom. Expansive second level balcony with staircase provides waterfront access, and allows one to step outside and enjoy the view from almost every room. This luxury waterfront home has a mega sized 7 car garage with workshop that can also accommodate an RV or boat along with 4 additional vehicles, a backyard oasis complete with a lagoon style swimming pool, swim up bar, ten seat spa, water slide with footbridge, waterfalls, and grotto cave seating. For water sport enthusiasts, there is a boat house with boat slip, jet ski lift, and plenty of room to store your water toys.' ,`Acres` = '0.7054' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 1 TAYLOR LAKE SHORES SEC 1 AMEND' ,`LotDesciption` = 'Corner,Water View,Waterfront,Wooded' ,`LotSize` = '30727' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '7' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ROBINSON ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Taylor Lake Shores Sec 01 Amd' ,`TaxAmount` = '34367' ,`TaxRate` = '2.279' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664717219' WHERE `Matrix_Unique_ID` = '211279214' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T07:10:39.430' ,`MLSNumber` = '70435312' ,`ListAgentFullName` = 'Mary Ragland' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.850649' ,`Longitude` = '-95.705079' ,`PhotoCount` = '37' ,`PostalCode` = '77449' ,`RoomCount` = '8' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Old Crow' ,`StreetNumber` = '19203' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1723' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A beautiful Saratoga home located in the highly sought-after Plantation Lakes neighborhood is on the market. In addition to being open to the dining and family rooms, the kitchen is amazing. This home has many upgrades. This house has three bedrooms, two bathroom s, and a home office or flex room. It was completed at the end of 2017 and is occupied by the original owners. Across the street from the home is a splashpad, and a community pool is nearby. Looking for a new owner for this \"Open Concept\" home. Schedule a private viewing today.' ,`Acres` = '0.1406' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 48 BLK 1 PLANTATION LAKES SEC 23' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6124' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '465' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'EMERY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (CY-FAIR)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Plantation Lakes' ,`TaxAmount` = '6102' ,`TaxRate` = '3.011' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1664717220' WHERE `Matrix_Unique_ID` = '211554483' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T06:46:03.970' ,`MLSNumber` = '59512878' ,`ListAgentFullName` = 'Evelyn Laniado' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.675385' ,`Longitude` = '-95.830295' ,`PhotoCount` = '30' ,`PostalCode` = '77406' ,`RoomCount` = '4' ,`ListPrice` = '379999.00' ,`Status` = 'Active' ,`StreetName` = 'Lilac Croft' ,`StreetNumber` = '10131' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2266' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 2 story Brick and stone home front elevation with inviting covered front porch. Walk in to Open concept Cherry Slate kitchen cabinets with elegant Iced White Quartz counter tops with an eased edge and and a mesh mount tile kitchen back splash to compliment it all. Luxury Vinyl wood floors throughout the entry, kitchen, dining, utility room and powder room. Stainless steel Whirlpool kitchen appliances including a gas cook-top, built-in microwave, oven and dishwasher. Walk up the stairs to a loft area, perfect for Family gatherings. All 4 bedrooms up with walk-in closets and 2 bathrooms. Home Also has double Low E pane tilt out windows and fixed windows in the family room and dining area bringing in lots of natural light. Ready for move in and to be called Home.' ,`Acres` = '0.126' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CREEKSIDE RANCH SEC 12, BLOCK 1, LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5490' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '825' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Creekside Ranch Sec 12' ,`TaxAmount` = '6148' ,`TaxRate` = '2.5248' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664717220' WHERE `Matrix_Unique_ID` = '211791457' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T07:44:42.183' ,`MLSNumber` = '26378101' ,`ListAgentFullName` = 'Thomas Schwenk' ,`ListOfficeName` = 'Coldwell Banker TGRE' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.306758' ,`Longitude` = '-94.777005' ,`PhotoCount` = '45' ,`PostalCode` = '77550' ,`RoomCount` = '6' ,`ListPrice` = '439000.00' ,`Status` = 'Active' ,`StreetName` = 'Winnie' ,`StreetNumber` = '901' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1874' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location, location, location! Close to UTMB & Rosenburg Park. Only a 5 block walk to Seawall & to the 14th Street corridor. Close and convenient to the nearby Strand/Postoffice historic downtown entertainment district w/ great restaurants, art galleries, cafes & shopping! The sellers have used this as their second home, a weekender, not as a STR. This beautiful Craftsman style home exudes charm throughout, with stained glass and leaded windows, gas fireplace, original hardwood floors, spacious rooms, high ceilings throughout, pocket doors, a grand baluster, lovely curved staircase that showcases the beautiful woodwork, & lovely stacked side porches. A bonus is the utility room w/ a full bath down. All bedrooms & a 2nd bathroom up. Window units. Appliances convey (most purchased in 2021) as does the remaining furniture. New pex plumbing 2021. Attached garage and a list of all features & updates to the home are in docs. Appraisal incorrectly states the house was built in 1962.' ,`Acres` = '0.0721' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR N 73 FT OF LOT 7 (7-2) BLK 309 GALVE' ,`LotDesciption` = 'Corner' ,`LotSize` = '3139' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Galveston Townsite' ,`TaxAmount` = '5840' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664717220' WHERE `Matrix_Unique_ID` = '211810242' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T07:59:07.147' ,`MLSNumber` = '41313370' ,`ListAgentFullName` = 'Shane Light' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.558369' ,`Longitude` = '-95.673937' ,`PhotoCount` = '35' ,`PostalCode` = '77479' ,`RoomCount` = '10' ,`ListPrice` = '719900.00' ,`Status` = 'Active' ,`StreetName` = 'Shepherds' ,`StreetNumber` = '2007' ,`StreetSuffix` = 'Place' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4016' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 2-story stucco beauty on a HUGE cul-de-sac home site in Greatwood Shores! This 4 bed, 3.1 bath home is situated on an over 18,000 sq ft homesite with water views from the lush back yard and completely redon balcony and covered patio to include surface re-grading & replacement, and lighting replacement in 2020. The entire yard features professional landscaping replacement & improved backyard drainage as well. A complete home stucco replacement was done in 2020 with a transferable warranty. New roof completed 2019 including solar-powered attic vent fan, both AC units replaced with high efficiency Trane 18 seer units 2015 & 2016, whole house surge protector in 2020, All exterior fences replaced - metal fence in 2015 & wood fence in 2020, The outdoor space offers a bug free screened in covered patio complete with built-in gas grill and exhaust vent added as well as replaced porch screens, surfacing of floor, ceiling, ceiling fan, & outdoor speakers 2020! You have to see this one!' ,`Acres` = '0.4168' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Levee District,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GREATWOOD SHORES SEC 4, BLOCK 2, LOT 4' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot,Water View' ,`LotSize` = '18156' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '910' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'DICKINSON ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Georgian' ,`Subdivision` = 'Greatwood Shores Sec 4' ,`TaxAmount` = '11889' ,`TaxRate` = '2.3013' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664717220' WHERE `Matrix_Unique_ID` = '211982621' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T07:55:07.220' ,`MLSNumber` = '52875658' ,`ListAgentFullName` = 'Ryan St George' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.825112' ,`Longitude` = '-95.802240' ,`PhotoCount` = '37' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Scarlatti Cantata' ,`StreetNumber` = '24718' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2125' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Two Story plan with 4 Bedrooms, 2.5 Baths, Master Bedroom is down, Gameroom up overlooks Entry, Kitchen and Dining area open to Family Room, All Bedrooms upstairs have walk-in closets and High Ceilings, Covered Back Patio, Front and Back Yards has Sod and Sprinkler Systems. The back of home has a lake view. Interior repainted 2022. Elevation stone and brick. All smoke alarms replaced 2022.\r\nYour family will flourish in a new home in the Katy community of Camillo Lakes. Amenity-rich, the community will soon boast an amenity center with a resort-style pool as well as two sparkling lakes open for water sports. Camillo Lakes’ excellent location off the Grand Parkway and Interstate 10 puts you near favored Katy attractions such as Typhoon Lagoon as well as shopping and dining at Katy Mills Mall. Young residents attend highly regarded Katy ISD schools, including Leonard Elementary, Haskett Junior High and Paetow High School.' ,`Acres` = '0.1136' ,`Area` = '25' ,`BuilderName` = 'Legend Homes' ,`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 27 BLK 4 CAMILLO LAKES SEC 1' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '4950' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'LEONARD ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,No Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Camillo Lakes Sec 1' ,`TaxAmount` = '8649' ,`TaxRate` = '3.5333' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664717220' WHERE `Matrix_Unique_ID` = '212082847' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T07:37:00.647' ,`MLSNumber` = '60293480' ,`ListAgentFullName` = 'Alma Martinez' ,`ListOfficeName` = 'Rice Realty Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.996698' ,`Longitude` = '-95.723543' ,`PhotoCount` = '15' ,`PostalCode` = '77429' ,`RoomCount` = '4' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Riley Ridge Lane' ,`StreetNumber` = '15210' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2902' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful & spacious two story home in much desired Cypress-Fairbanks SD. Home features a huge covered backyard patio that is perfect for entertainment or those special family celebrations. Covered patio measures approximately 18 X 26. You will enjoy the new bamboo flooring upstairs. Laminate flooring in master. crown molding throughout the downstairs living area and freshly painted interior. large bedrooms with Walk-in closes. a large game room upstairs, downstairs master suite, granite counter tops, KItchen Island and 42” kitchen cabinets and much more, Conveniently located near great shopping, dining, and entertainment. Easy access to US 290 & TX 99 Parkway. Room measurements are an approximation, buyer to verify. Call and schedule your tour today!' ,`Acres` = '0.1345' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 1 CYPRESS LANDING EAST SEC 1 AMEND' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5858' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '660' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'KEITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'GOODSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Lndg East Sec 1' ,`TaxAmount` = '7670' ,`TaxRate` = '2.761' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664717221' WHERE `Matrix_Unique_ID` = '212162384' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T07:15:35.687' ,`MLSNumber` = '27258428' ,`ListAgentFullName` = 'Aide Bueno' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.627244' ,`Longitude` = '-95.400132' ,`PhotoCount` = '31' ,`PostalCode` = '77047' ,`RoomCount` = '6' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Dandy Park' ,`StreetNumber` = '11702' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2612' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful move-in ready home with pool!! Open floor plan, perfect for entertaining family and friends. Mounted television in family room stays. Upgraded lighting in dining, kitchen, & breakfast room. Huge back yard with covered patio and no back neighbors. Easy access to Hwy.288, Beltway 8, and the Medical Center.' ,`Acres` = '0.2348' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 1 CITY PARK WEST SEC 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10230' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '735' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground,Vinyl Lined' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ALMEDA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'City Park West Sec 01' ,`TaxAmount` = '7259' ,`TaxRate` = '3.0307' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664717221' WHERE `Matrix_Unique_ID` = '212374466' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T07:25:56.500' ,`MLSNumber` = '46201111' ,`ListAgentFullName` = 'Kara Costolow' ,`ListOfficeName` = 'J.L. Wyatt Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.396632' ,`Longitude` = '-94.898737' ,`PhotoCount` = '37' ,`PostalCode` = '77590' ,`RoomCount` = '4' ,`ListPrice` = '214900.00' ,`Status` = 'Active' ,`StreetName` = '12th' ,`StreetNumber` = '318' ,`StreetSuffix` = 'Avenue' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2043' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming home is located in the heart of Texas City. Featuring 3 generous size bedrooms with walk-in closests and 2 full bathrooms. The home is situated on a sizeable lot with large mature oaks and a white picket fence surrounding the front yard. The kitchen and dining room provide plenty of space for entertaining and features a wood burning fireplace. Beautiful arches throughout the house add an extra charm to this property. Priced to be able to move in and add your own personal touch on cosmetic upgrades and finishing. Furnishing within the home are negotiable. Schedule your showing today!' ,`Acres` = '0.2152' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 205 PAGE 5 LOTS 8 THRU 10 BLK 318 TEXAS CITY' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9375' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'ROOSEVELT-WILSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TEXAS CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BLOCKER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Texas City' ,`TaxAmount` = '5212' ,`TaxRate` = '2.5335' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664717221' WHERE `Matrix_Unique_ID` = '212599710' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T07:12:11.627' ,`MLSNumber` = '2885450' ,`ListAgentFullName` = 'Hector Alpuing' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.029765' ,`Longitude` = '-95.534238' ,`PhotoCount` = '44' ,`PostalCode` = '77379' ,`RoomCount` = '9' ,`ListPrice` = '339900.00' ,`Status` = 'Active' ,`StreetName` = 'Ralick' ,`StreetNumber` = '7502' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2704' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home on huge half acre corner lot in established Memorial Northwest Subdivision. Home boasts 4 bedrooms, 2.5 baths, 2 car garage and both formal dining and living rooms. Upgrades include new roof, A/C, granite counter tops, stainless steel appliances, travertine tile backsplash, crown molding, and recently tiled 2nd floor balcony to name a few. Zoned to highly desired Klein ISD and has a neighborhood community center, fitness room, tennis courts, splash pad & pool. Never Flooded. Make your appointment today!' ,`Acres` = '0.5234' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 1 017*M1876900-001-001-003 MEMORIAL NORTHWEST SEC 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '22800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '693' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'THEISS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Northwest Sec 01' ,`TaxAmount` = '5117' ,`TaxRate` = '2.3213' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664717221' WHERE `Matrix_Unique_ID` = '212623482' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T07:42:41.610' ,`MLSNumber` = '54702968' ,`ListAgentFullName` = 'Sydney Harrell' ,`ListOfficeName` = 'Longevity Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.209154' ,`Longitude` = '-95.576566' ,`PhotoCount` = '32' ,`PostalCode` = '77354' ,`RoomCount` = '10' ,`ListPrice` = '389900.00' ,`Status` = 'Active' ,`StreetName` = 'Ponderosa' ,`StreetNumber` = '7202' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2258' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this beautifully custom-built one story home sitting on almost half an acre! The roof is only 5 years old, and A/C 3 years. Driving up you’re welcomed by beautifully landscaped home w/ a semi-circle driveway along with a wrap-around porch, great for entertaining outside or even to enjoy a day on the patio when there\'s beautiful weather. Upon entry you are greeted with a spacious living room with sleek hardwood floors and gas log fireplace. This custom-built home feature 3 oversized bedrooms along with private full bathrooms for each suite as well as exceptionally sized walk-in closets. Enjoy the enormous backyard and sunroom that comes complete with mature trees and offers plenty of room to add a pool plus an outdoor kitchen area. Schedule your private viewing today!' ,`Acres` = '0.4444' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WESTWOOD 02, BLOCK 11, LOT 34' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '19360' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'BEAR BRANCH ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westwood 02' ,`TaxAmount` = '5550' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Aerobic,Septic Tank' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664717221' WHERE `Matrix_Unique_ID` = '212696761' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T06:23:37.530' ,`MLSNumber` = '18247969' ,`ListAgentFullName` = 'Bruce Brittimes' ,`ListOfficeName` = 'Brittimes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.637938' ,`Longitude` = '-95.512749' ,`PhotoCount` = '10' ,`PostalCode` = '77071' ,`RoomCount` = '3' ,`ListPrice` = '272000.00' ,`Status` = 'Active' ,`StreetName` = 'La Rochelle' ,`StreetNumber` = '7806' ,`StreetSuffix` = 'Circle' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2508' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Seller will contribute toward interest rate buy-down.\r\nFonmeadow Community, introducing this beautiful 3 bedrooms, 3.5 bathrooms and 2 car garage home. Living Room and formal dining room are breathtaking. Gas wood burning fireplace in the living room. Granite tops in kitchen and bar area. Kitchen is connected to sun room. Large Primary bedroom on the 1st floor. 2nd floor have 2 bedrooms and very large gameroom. Walking distance to community park and pool.' ,`Acres` = '' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'lt 73 blk 1 Fonmeadow Sec 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GROSS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'WELCH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'fonmeadow' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664717221' WHERE `Matrix_Unique_ID` = '212795186' --> 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','213090594','1664717222','213090594','2022-10-02T07:49:18.377','72690392','Joy Samuel','Prompt Realty & Mortgage, Inc','','','29.586755','-95.575299','0','77459','6','399000.00','Active','Ring','2511','Court','Missouri City','3','0','4','2578','Single-Family','Wow!!!!!! Huge Cul-de- sac lot for swimming pool etc.!!!! NEVER FLOODED! Very tenderly cared 4-bedroom 3 bath High elevation overlooking to Oyster Creek and walk trail. Iron fence, contemporary interior, crown molding, huge primary room with two closets, jetted tub and standing shower.\r\none bedroom downstairs. All bedrooms are with new carpet. All modification has done in timely manner. Fort Bend\'s rated school zone and in First colony. Elementary school within the subdivision. All the amenities are with in 5 minutes of distance. All the measurements are approximate. Please verify upon visit.','0.3388','29','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Wood Burning Fireplace','1','Missouri City Area','Central Gas','1','PLANTATION CREEK SEC 2-A, BLOCK 2, LOT 3','Cul-De-Sac','14760','Appraisal District','','812','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','19 - Fort Bend','LEXINGTON CREEK ELEMENTARY SCHOOL','DULLES HIGH SCHOOL','DULLES MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','2','Traditional','Plantation Creek Sec 2-A','7996','2.71','Public Sewer,Public Water,Water District','1993','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T06:41:45.340' ,`MLSNumber` = '78524442' ,`ListAgentFullName` = 'Nicolette Lee Flores' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.574603' ,`Longitude` = '-95.249735' ,`PhotoCount` = '50' ,`PostalCode` = '77089' ,`RoomCount` = '9' ,`ListPrice` = '449900.00' ,`Status` = 'Active' ,`StreetName` = 'Hatton Terrace' ,`StreetNumber` = '2517' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3267' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This immaculate two year old brick home is BETTER than new with extensive upgrades throughout. With four true bedrooms, primary down, three FULL bathrooms + a half bath, PLUS an additional study through French doors away from it all, open flex spade upstairs, AND media room wired for all of your gaming or movie theater needs (or a secondary study!)- your family will definitely be able to adapt these great spaces to fit their unique needs. Wood-looking tile on the first floor allows for a grand entrance. Tall ceilings throughout allow all the natural light to filter through. The spacious backyard with the covered extended patio and gas line for your grill has views of the community lake and trails. Designer light fixtures all STAY, as well as the coordinated brass hardware on the cabinets. Spray foam insulation and all of the traditional energy efficient features Meritage Builders are known for are here! Community amenities include pool, splash pad, trails, and rec center. Come see us!' ,`Acres` = '0.1705' ,`Area` = '3' ,`BuilderName` = 'Meritage' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 3 RIVERSTONE RANCH AT CLEAR CREEK SEC 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7425' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '825' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'SOUTH BELT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'THOMPSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverstone Ranch/Clear Crk Sec' ,`TaxAmount` = '12787' ,`TaxRate` = '3.6869' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664717222' WHERE `Matrix_Unique_ID` = '213108158' --> 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','213213628','1664717222','213213628','2022-10-02T07:37:48.350','15953702','Jamie McMartin','Compass RE Texas, LLCKaty','','','29.734255','-95.865462','49','77494','10','519990.00','Active','Freemans View','28502','Court','Katy','3','1','4','2853','Single-Family','D.R. Horton\'s Two story Pattison model! ATTACHMENTS SHOW COLOR PACKAGE. 4 Bedrooms! 3.5 baths! Full guest room upstairs with private bath! Gorgeous Kitchen with stunning 42\" Cabinets, Silestone counters and stainless steel 5 burner range! Covered patio ready for the week-end BBQ\'s! This is a \"SMART HOME\" with camera doorbell and whole home system. Controlled from your hub or smart phone! Included is everything you are looking for in a community- resort pool, splashpad, fitness center, sports fields, lakes & walking trails all included and ready for you! Please verify with sales agent options and upgrades.**PHOTOS ARE WHAT YOU CAN EXPECT FROM THE FLOORPLAN! THEY DO NOT SHOW ACTUAL PROPERTY***At this time the builder does not sell to Investors in this neighborhood*','','36','D.R. Horton','','Electric Dryer Connections,Washer Connections','','Mud','1','','0','Katy - Southwest','Central Gas','1','Lot 141; Block 2; Section 60','Cleared,Corner,Cul-De-Sac,Subdivision Lot','6064','Other','','1250','1','To Be Built/Under Construction','2','Gas Oven,Single Oven','0','','','Gas Range','','Composition','30 - Katy','CAMPBELL ELEMENTARY SCHOOL (KATY)','JORDAN HIGH SCHOOL','ADAMS JUNIOR HIGH SCHOOL','Appointment Required,No Supra Keybox','Builder','2','Traditional','Tamarron','','3.37','Public Sewer,Public Water,Water District','2022','Builder'); --> New record created successfully