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-03T06:54:28.430' ,`MLSNumber` = '79193415' ,`ListAgentFullName` = 'Evan Howell' ,`ListOfficeName` = 'Evan S. Howell, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.683840' ,`Longitude` = '-95.341628' ,`PhotoCount` = '11' ,`PostalCode` = '77033' ,`RoomCount` = '3' ,`ListPrice` = '125000.00' ,`Status` = 'Active' ,`StreetName` = 'Southlea' ,`StreetNumber` = '5214' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1862' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 bedroom 1 bath vacant home sold as is.' ,`Acres` = '0.1478' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 13 BLK 11 SOUTH PARK SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6438' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KELSO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'South Park Sec 02' ,`TaxAmount` = '2545' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804968' WHERE `Matrix_Unique_ID` = '207128658' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T07:56:58.690' ,`MLSNumber` = '54575104' ,`ListAgentFullName` = 'Blanca Salinas' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.989476' ,`Longitude` = '-95.174346' ,`PhotoCount` = '34' ,`PostalCode` = '77346' ,`RoomCount` = '10' ,`ListPrice` = '305000.00' ,`Status` = 'Active' ,`StreetName` = 'Summer Anne' ,`StreetNumber` = '18711' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2959' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW ROOF!! NEW CARPET!!Schedule your tour to view this beautiful house with all the space you need in every area of the house. As you come in, you see a two-story foyer and huge formals, then as you continue your tour find the family room to entertain your guest and family, Kitchen opens to family room. Going up the stairs your will find this spacious game room, all around, you will find these spacious bedrooms, and the huge master with a huge master bath and for real walking closet for all your needs. So don\'t wait to schedule your tour to view this awesome property waiting for your own touch. All measurements are approximate, if important do your own diligence.' ,`Acres` = '0.1446' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 27 BLK 4 ATASCOCITA SOUTH SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '430' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'TIMBERS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Atascocita South Sec 04' ,`TaxAmount` = '4829' ,`TaxRate` = '2.3974' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804969' WHERE `Matrix_Unique_ID` = '208453227' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T06:19:03.593' ,`MLSNumber` = '44034368' ,`ListAgentFullName` = 'Kimberly Harding' ,`ListOfficeName` = 'RE/MAX Synergy' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.549912' ,`Longitude` = '-95.034233' ,`PhotoCount` = '50' ,`PostalCode` = '77565' ,`RoomCount` = '8' ,`ListPrice` = '570000.00' ,`Status` = 'Active' ,`StreetName` = 'Narcissus' ,`StreetNumber` = '123' ,`StreetSuffix` = 'Road' ,`City` = 'Clear Lake Shores' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '2963' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come and see this one-of-a-kind gem Located right across from the water in Clear Lake Shores. Featuring exposed wood ceilings in the main living area, custom kitchen with stainless appliances, gas range and a large open concept dining and living area. Watch the boats go by from your beautiful sunroom. Enjoy winters by your wood burning fireplace in the in the den. Host guests on the first floor in their own private suite. Serve drinks in the custom built in bar and throw big parties in the large private pool and covered entertainment area. 4+ car deep garage and oversized driveway. Get in now to see this beauty in this highly sought-after golf cart community. Come and see this magical home today!' ,`Acres` = '0.1837' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Electric,Heat Pump' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 18 M MULDOON SUR LOTS 2201 THRU 2204 CLEAR LAKE SHORES' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '8000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Clear Lake Shores' ,`TaxAmount` = '9939' ,`TaxRate` = '1.8341' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1664804969' WHERE `Matrix_Unique_ID` = '208902223' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T07:59:49.027' ,`MLSNumber` = '28327576' ,`ListAgentFullName` = 'Dao Vo' ,`ListOfficeName` = 'Intercontinental Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.968069' ,`Longitude` = '-95.393783' ,`PhotoCount` = '12' ,`PostalCode` = '77073' ,`RoomCount` = '11' ,`ListPrice` = '282000.00' ,`Status` = 'Active' ,`StreetName` = 'Ranch View' ,`StreetNumber` = '18439' ,`StreetSuffix` = 'Trail' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3136' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Big house can use for 5 bedrooms, Master bedroom down stair with tile floor and large decorated Bathroom with luxury shower room. Up stair 3 bedrooms, adding a huge Family room, a Media room, a Study/jym room.....Really for a big family. Back yard with Wood Desk patio; Large side subdivision vacant lot for playing outdoor .....A home in good condition as new.' ,`Acres` = '0.1085' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 1 REMINGTON CREEK RANCH SEC 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '4725' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '410' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'PARKER ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'DAVIS HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'TEAGUE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side,No Supra Keybox,Request Online Appointment,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Remington Crk Ranch Sec 1' ,`TaxAmount` = '5813' ,`TaxRate` = '2.8445' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804969' WHERE `Matrix_Unique_ID` = '208964249' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T07:42:25.913' ,`MLSNumber` = '15700879' ,`ListAgentFullName` = 'Mitch Beasley' ,`ListOfficeName` = 'Douglas Elliman Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.728008' ,`Longitude` = '-95.399753' ,`PhotoCount` = '32' ,`PostalCode` = '77006' ,`RoomCount` = '19' ,`ListPrice` = '5500000.00' ,`Status` = 'Active' ,`StreetName` = 'North' ,`StreetNumber` = '1604' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '8602' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Villa at 1604 North Blvd, is an architectural masterpiece highlighting Italian luxury in the heart of Houston. The estate recently experienced its own renaissance through an extensive no expense spared remodel. Located in the prestigious Boulevard Oaks Historical District, The Villa combines the finest materials, and antique architectural embellishments collected throughout Europe and Italy. The kitchen was beautifully redesigned and the second floor renovation included the addition of multiple luxurious ensuite bedrooms and a fully upgraded owners suite. The home is equipped with modern conveniences including an elevator, a whole house generator and smart house technology. The Villa showcases beautiful hand painted frescos, and impressive masonry and statues. This palazzo is centrally located to all that Houston has to offer. The property truly lives up to the Italian phrase, “La Dolce Vita”, which means “the good life”, embrace that adage by visiting Villa 1604 North today.' ,`Acres` = '' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Rice/Museum District' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 2 Edgemont' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1075' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range,Grill' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'POE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Edgemont' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1925' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804969' WHERE `Matrix_Unique_ID` = '209119818' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T07:55:27.387' ,`MLSNumber` = '37871040' ,`ListAgentFullName` = 'Dao Vo' ,`ListOfficeName` = 'Intercontinental Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.631174' ,`Longitude` = '-95.679105' ,`PhotoCount` = '18' ,`PostalCode` = '77498' ,`RoomCount` = '6' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Orchard Summit Dr' ,`StreetNumber` = '12702' ,`StreetSuffix` = '' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2248' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Home inside and outside. Master bedroom down stair. Marble counter top of kitchen; A large Dining room. No flood zone and never flooding. Nice and quiet neighborhood.' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Stratford Park Village 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6192' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '430' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'OYSTER CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = '' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stratford Park Village Five' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804969' WHERE `Matrix_Unique_ID` = '209223169' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T07:48:43.100' ,`MLSNumber` = '4145942' ,`ListAgentFullName` = 'John Stanley' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = 'Alberto Escobedo' ,`SellingOfficeName` = 'NB Elite Realty' ,`Latitude` = '29.924564' ,`Longitude` = '-95.294265' ,`PhotoCount` = '19' ,`PostalCode` = '77396' ,`RoomCount` = '11' ,`ListPrice` = '280000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Ravendale' ,`StreetNumber` = '14106' ,`StreetSuffix` = 'Road' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2830' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'TONS OF ROOM HERE...OLDER HOME LOCATED IN A QUIET NEGHBORHOOD OF HUMBLE WITH AN ABOVE GROUND POOL, WELL, SEPTIC, NO HOA AND LOW TAXES. REMODELLED SEVERAL YEARS AGO, TILED FLOORS,CABINETS, BLACK APPLIANCES,GRANITE COUNTER-TOPS. SITS ON TWO LOTS WITH PLENTY OF ROOM FOR CHILDREN TO PLAY. COULD EASILY BE A FIVE OR SIX BEDROOM HOME IF SOMEONE IS LOOKING FOR MORE SLEEPING AREA. ALL ROOMS ARE OF EXCELLENT SIZE.....YOU WON\'T BE DISAPPOINTED.' ,`Acres` = '0.1664' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Humble Area South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 217 & 218 BLK 1O HUMBLE ROAD PLACE' ,`LotDesciption` = 'Cleared' ,`LotSize` = '14250' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'JOHNSON ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'MACARTHUR HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'ALDINE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Humble Road Place' ,`TaxAmount` = '2097' ,`TaxRate` = '2.1553' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804969' WHERE `Matrix_Unique_ID` = '209510897' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T07:46:23.327' ,`MLSNumber` = '25042961' ,`ListAgentFullName` = 'Efren Hernandez' ,`ListOfficeName` = 'Texas Prominent Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.063177' ,`Longitude` = '-95.371532' ,`PhotoCount` = '21' ,`PostalCode` = '77373' ,`RoomCount` = '7' ,`ListPrice` = '280000.00' ,`Status` = 'Active' ,`StreetName` = 'Rendezvous' ,`StreetNumber` = '3111' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2441' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully maintained 2 story home sitting in the comfort of a cozy cul-de-sac. New A/C unit 2022. New interior paint done in 2022, new wood flooring done in 2022, professionally cleaned from the bottom up. This home offers you comfortable 4 bedrooms (with the flexibility of an office, study, gym, etc.) 2 full bath that are both double sinked, 1 half bath for your guest, and a relaxing tub in the primary bathroom. Kitchen opens up to the family living room and breakfast room so you never miss a single word of communication. Upstairs contains a game room for all the entertainment that your family or friends might need. Backyard is fully fenced giving you privacy so you can host gatherings or simply soak in the sun!' ,`Acres` = '0.1394' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 2 BRECKENRIDGE FOREST SEC 4' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6073' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '416' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'GLORIA MARSHALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Breckenridge Forest Sec 04' ,`TaxAmount` = '6067' ,`TaxRate` = '2.8117' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804970' WHERE `Matrix_Unique_ID` = '209560048' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T07:30:30.457' ,`MLSNumber` = '55472119' ,`ListAgentFullName` = 'Ashley Day' ,`ListOfficeName` = 'Compass RE Texas, LLCHeights' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.801526' ,`Longitude` = '-95.393081' ,`PhotoCount` = '47' ,`PostalCode` = '77008' ,`RoomCount` = '10' ,`ListPrice` = '1299000.00' ,`Status` = 'Active' ,`StreetName` = 'Columbia' ,`StreetNumber` = '1644' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3732' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Remodeled and Expanded Historic bungalow on premier block in Houston Heights. Fabulous open floor plan downstairs features beautiful hardwood floors and gorgeous windows. Chef and entertainer\'s kitchen wows with over-sized granite island, custom cabinetry, wine fridge, and double oven. 4th Bedroom or Office downstairs features en suite Full Bath with walk in shower that also serves as powder room. Upstairs, relax in dynamite Primary Suite and Bath with his and her closets. Bonus room upstairs features wet bar. 2 Secondary Bedrooms upstairs feature natural light and walk in closets. Amazing Storage throughout. Low maintenance yard with built in summer kitchen and covered patio. Alley access to secure automated gate, leading to over-sized 2 car garage with epoxy flooring. Walkable to favorite Heights hotspots, including iconic 19th Street, Chiloso\'s, Jenni\'s Noodle House, the Jogging Trail, and Heights Hike and Bike Trail. Zoned to Field Elementary, National Blue Ribbon winner.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 24 BLK 113 HOUSTON HEIGHTS' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'FIELD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'HOUSTON HEIGHTS' ,`TaxAmount` = '12974' ,`TaxRate` = '2.55896' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1920' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804970' WHERE `Matrix_Unique_ID` = '209865337' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T07:43:03.460' ,`MLSNumber` = '45725997' ,`ListAgentFullName` = 'Jennifer Jaeger-Karp' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.075402' ,`Longitude` = '-95.447885' ,`PhotoCount` = '22' ,`PostalCode` = '77388' ,`RoomCount` = '10' ,`ListPrice` = '269500.00' ,`Status` = 'Active' ,`StreetName` = 'Emerson Ridge' ,`StreetNumber` = '1910' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1707' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 1910 Emerson Ridge Drive. Located in the highly sought after community of Hannover Springs, it is move-in ready. NO FLOODING! The open floor plan allows plenty of natural light into the home. The heart of the home is welcoming. Amazing kitchen with plentiful cabinets, gas range, & more! The master bedroom is large and private. Washer/Dryer, refrigerator, and all furniture are negotiable. This home is conveniently located close to I-45, 99, and minutes from Exxon Campus and Springwoods Village shopping with easy access to all areas.' ,`Acres` = '0.1415' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 3 HANNOVER SPRINGS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6164' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '177' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'SALYERS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'SPRINGWOODS VILLAGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hannover Spgs Sec 02' ,`TaxAmount` = '5287' ,`TaxRate` = '2.8668' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804970' WHERE `Matrix_Unique_ID` = '209895468' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T06:14:02.813' ,`MLSNumber` = '10334924' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.504650' ,`Longitude` = '-95.718948' ,`PhotoCount` = '35' ,`PostalCode` = '77406' ,`RoomCount` = '7' ,`ListPrice` = '500785.00' ,`Status` = 'Active' ,`StreetName` = 'Garnet Peak' ,`StreetNumber` = '5915' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2858' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Relax in the comfort and luxury of The Brookdale dream home plan. The spacious study presents a versatile opportunity to create your ideal home office, fun and games parlor, or arts and crafts workshop. Cook up culinary delights in the streamlined kitchen that features a deluxe pantry and a presentation island. Your open floor plan offers a sunlit space ready to fulfill your lifestyle and décor ambition. Calm relaxation and sensational social gatherings are waiting for you on your serene covered patio. Your awe-inspiring Owner’s Retreat provides a glamorous way to begin and end each day, and includes a superb en suite bathroom and a wardrobe-expanding walk-in closet. Each spare bedroom and guest suite supports growing minds and personalities by combining unique features and plenty of space to thrive. Contact our Internet Advisor to learn more about this incredible new home plan.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Block 1' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CARTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Stonecreek Estates' ,`TaxAmount` = '' ,`TaxRate` = '3.22' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664804970' WHERE `Matrix_Unique_ID` = '209959249' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T06:54:46.963' ,`MLSNumber` = '37109378' ,`ListAgentFullName` = 'Rosanna Hamilton' ,`ListOfficeName` = 'RE/MAX Leading Edge' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.247333' ,`Longitude` = '-95.233336' ,`PhotoCount` = '40' ,`PostalCode` = '77577' ,`RoomCount` = '16' ,`ListPrice` = '795000.00' ,`Status` = 'Active' ,`StreetName` = 'Palm' ,`StreetNumber` = '323' ,`StreetSuffix` = 'Drive' ,`City` = 'Liverpool' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '2630' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A slice of Waterfront paradise awaits you! Featuring 2 homes overlooking a spacious yard with beautiful landscaping and amazing flagstone entertainment areas! The outdoor stone fireplace and beautiful Palapa are just the beginning of the many features this one-of-a-kind property has to offer. Approximately 225 ft of waterfront boasts 2 boat houses with lifts, another screened-in Palapa on the second story for relaxing and watching the boats glide by! A cargo lift gives you the extra boost to the second story. Don\'t forget the shop with ample storage for your toys and a large workbench. The second home (on the right, sold furnished) would be great for the mother-in-law, privacy for guests, or extra rental income. Come see all that this property has to offer for your family and friends! No HOA, Buyer to verify all room dimensions and information.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Stove' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Electric,Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'HARBORVIEW HOMESITES (A0011 HENRY AUSTIN), LOT 18, 19, SEC 1' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '19311' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'WALT DISNEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'ALVIN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harborview Homesites' ,`TaxAmount` = '3553' ,`TaxRate` = '2.2507' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804970' WHERE `Matrix_Unique_ID` = '210708073' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T06:04:01.220' ,`MLSNumber` = '52107140' ,`ListAgentFullName` = 'Daisy Garcia' ,`ListOfficeName` = 'Keller Williams Elite' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.675395' ,`Longitude` = '-95.032815' ,`PhotoCount` = '28' ,`PostalCode` = '77571' ,`RoomCount` = '3' ,`ListPrice` = '220000.00' ,`Status` = 'Active' ,`StreetName` = 'N 13th' ,`StreetNumber` = '812' ,`StreetSuffix` = 'Street' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2465' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this gorgeous house that has been fully renovated. You walk in to a large spacious open floor plan that will give you plenty of space for you and your family. This house is located on a corner lot and so you will have plenty of outdoor space for all your social gathering plus you are surrounded by trees making it quiet and peaceful. The home features a spacious breakfast nook that includes a wine fridge! Appliances are included as well! Selling as is' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1A LAPORTE TERRACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9576' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'LA PORTE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'La Porte Terrace' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804970' WHERE `Matrix_Unique_ID` = '210721495' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T07:43:15.270' ,`MLSNumber` = '77160009' ,`ListAgentFullName` = 'Marci Pendley' ,`ListOfficeName` = 'The Davy Group' ,`SellingAgentFullName` = 'Marci Pendley' ,`SellingOfficeName` = 'The Davy Group' ,`Latitude` = '29.557149' ,`Longitude` = '-95.687705' ,`PhotoCount` = '16' ,`PostalCode` = '77479' ,`RoomCount` = '8' ,`ListPrice` = '379000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Wild Rye' ,`StreetNumber` = '1722' ,`StreetSuffix` = 'Trail' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2475' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely corner home with oversized 3-car garage! First floor primary, plus one secondary bedroom down. 3rd bedroom ensuite privately located on the second floor. The upstairs is oversized and makes a terrific game room, bedroom or home office. For additional living space, the home includes a large, covered patio in the back for relaxing and entertaining. The kitchen features a light, bright island and breakfast bar with granite counter tops that open to the large family room with high ceilings. Stainless steel appliances, new carpet, fresh paint, refrigerator included. The large primary bedroom has ensuite bathroom featuring tub and separate shower with seamless glass doors. Bedroom includes a French door leading to covered patio outside. Solar shades keep this home nice and cool in the summer, and warm and cozy in the winter. Crown molding throughout, lots of closet space, recessed lighting, and skylights make this a must see today!' ,`Acres` = '0.1731' ,`Area` = '30' ,`BuilderName` = 'David Weekely' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GREATWOOD GREEN SEC 1, BLOCK 2, LOT 1' ,`LotDesciption` = 'Corner,Cul-De-Sac,In Golf Course Community,Patio Lot,Subdivision Lot' ,`LotSize` = '7539' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric 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,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Greatwood Green Sec 1' ,`TaxAmount` = '7011' ,`TaxRate` = '2.3013' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804971' WHERE `Matrix_Unique_ID` = '210873070' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T06:49:38.180' ,`MLSNumber` = '13622763' ,`ListAgentFullName` = 'Rhonda Walker' ,`ListOfficeName` = 'DOSS Pros, LLC' ,`SellingAgentFullName` = 'Jaime Black' ,`SellingOfficeName` = 'Martin & Black Real Estate LLC' ,`Latitude` = '29.531315' ,`Longitude` = '-95.304792' ,`PhotoCount` = '22' ,`PostalCode` = '77584' ,`RoomCount` = '5' ,`ListPrice` = '300000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Balmorhea' ,`StreetNumber` = '5409' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1886' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME TO 5409 BALMORHEA! Exceptional starter home. Home features a NEW ROOF, a pleasant entry way, leading to a split floor plan with charming updates from wood tile flooring, 12ft ceilings with an open living concept for a comfortably inviting feel. Home offers abundant living room space for any mood with a cozy fireplace. Kitchen boasts high-bar with granite counter tops, breakfast area with separate dining room. Large primary bedroom with the primary bath featuring newly updated separate vanities, custom mirrors, garden soaking tub, walk-in shower and walk in closet. Rear exit leads to your private deck where you can lounge and enjoy the beautiful sunset of the Texas sky or entertain your guests at the fire pit under a gorgeous moon light. Fencing offers double gated opening. Garage is wired with speakers. Home is wired for an alarm system, with 2 alarm cameras and recording box. Utility boxes accessible at the front of home. Come visit your new home. THIS IS 5409 BALMORHEA!' ,`Acres` = '0.1504' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'PARK VILLAGE ESTATES SEC 5 (A0509 HT&BRR) (PEARLAND) BLK 2 L' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6551' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'MAGNOLIA ELEMENTARY SCHOOL (PEARLAND)' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH SOUTH' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Park Village Estates Sec 5 A0' ,`TaxAmount` = '6677' ,`TaxRate` = '2.8451' ,`WaterSewer` = 'No Sewer,No Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804971' WHERE `Matrix_Unique_ID` = '210930255' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T06:54:53.950' ,`MLSNumber` = '72141551' ,`ListAgentFullName` = 'Lannie Christensen' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.926010' ,`Longitude` = '-95.572124' ,`PhotoCount` = '28' ,`PostalCode` = '77064' ,`RoomCount` = '8' ,`ListPrice` = '239900.00' ,`Status` = 'Active' ,`StreetName` = 'Golden Grain' ,`StreetNumber` = '10930' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1596' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Roof and Dry during Harvey! Harvest Bend cute open floor plan home. Boasts soaring ceilings and tile floors. Wood burning fireplace for those chilly nights in Texas. Sunken tub in Master with skylights to relax in the evenings. Large backyard for entertaining and outside cooking. Convenient location to Beltway 8 and shopping.' ,`Acres` = '0.1566' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Willowbrook South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 1 HARVEST BEND SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6820' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '368' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'FRANCONE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'CAMPBELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harvest Bend Sec 02' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804971' WHERE `Matrix_Unique_ID` = '211135273' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T06:14:42.593' ,`MLSNumber` = '80267403' ,`ListAgentFullName` = 'Remo Castillo' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.801221' ,`Longitude` = '-95.309344' ,`PhotoCount` = '10' ,`PostalCode` = '77026' ,`RoomCount` = '8' ,`ListPrice` = '189800.00' ,`Status` = 'Active' ,`StreetName` = 'Kress' ,`StreetNumber` = '4503' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A Big Discount for a Quick Sale !!!! Great Property provides best living with easy access to downtown and public transit. It has 3 comfortable bedrooms with a friendly open plan. Extra storage ( 17 X 17 ). It has a great in-law apartment. A large yard with plenty of space to entertain, & relax.' ,`Acres` = '0.2342' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'LT 296 BLK 16 LIBERTY GARDENS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ISAACS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Liberty Gardens' ,`TaxAmount` = '2004' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1664804971' WHERE `Matrix_Unique_ID` = '211141045' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T07:38:56.313' ,`MLSNumber` = '53292983' ,`ListAgentFullName` = 'Peggy West' ,`ListOfficeName` = 'Peggy West Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.833740' ,`Longitude` = '-95.468393' ,`PhotoCount` = '27' ,`PostalCode` = '77092' ,`RoomCount` = '8' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'De Milo' ,`StreetNumber` = '5129' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1522' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'JUST LISTED! Welcome to the most charming & well-loved home in sought-after Oak Forest. 5129 De Milo has been tastefully restored leaving a touch of its original charm. Owners have cared for this home meticulously. Features 4 Bedrooms, large Family room overlooking screened porch & wonderful Dining room with original hard wood floors, doublewide driveway with covered carport. Primary bedroom with adjoining Bonus Room - Perfect for baby room or home office. Fresh paint, new A/C (1 year labor warranty, 10 year equipment warranty), roof replaced. Large fenced backyard ready for family fun! Established Oak Forest subdivision has easy access to major freeways. Near great restaurants & shopping. They have their very own “Oak Forest Restaurant Week” with many participating restaurants. Home is move-in ready!' ,`Acres` = '0.1446' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 7 BLK 14 OAK FOREST SEC 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SMITH ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Forest Sec 16' ,`TaxAmount` = '5423' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804971' WHERE `Matrix_Unique_ID` = '211611615' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T06:10:54.837' ,`MLSNumber` = '74095125' ,`ListAgentFullName` = 'Lina Le' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.018414' ,`Longitude` = '-95.294615' ,`PhotoCount` = '17' ,`PostalCode` = '77338' ,`RoomCount` = '7' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Lionsgate' ,`StreetNumber` = '20414' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2592' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to a beautiful 2-Stories house with gorgeous looking inside, upgraded 80% of the house, roof is 5 year old, new AC units, and located in the desire neighborhood of Kenswick. This beautiful house 4bd and 2.5 bath property is equipping with an automated sprinkler system, freshly interior painted, wood floor looking throughout the entire house, and new kitchen granite countertops. The primary bedroom and the other 3 bedrooms are upstairs. Easy access to HWY US 59 and Hardy Toll Rd. Close to George Bush Airport, close to Walmart, Dear brook mall, and many other shopping centers. This house was never flooded. DON\'T MISS IT!' ,`Acres` = '0.1951' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TR 38 BLK 1 KENSWICK SEC 5' ,`LotDesciption` = 'Cleared' ,`LotSize` = '8497' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'JONES ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kenswick Sec 05' ,`TaxAmount` = '5014' ,`TaxRate` = '2.7433' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804972' WHERE `Matrix_Unique_ID` = '211712117' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T07:40:04.470' ,`MLSNumber` = '95548294' ,`ListAgentFullName` = 'Moni Bohnisch' ,`ListOfficeName` = 'Douglas Elliman Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.752554' ,`Longitude` = '-95.470683' ,`PhotoCount` = '50' ,`PostalCode` = '77056' ,`RoomCount` = '15' ,`ListPrice` = '2798000.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar Creek' ,`StreetNumber` = '5454' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5310' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'An exquisite home, undergone extensive renovation with style & grace by the skillful & talented “Taylor & Taylor Design”. Located in a premier desirable Tanglewood neighborhood w/inviting front elevation this spectacular home offers comfortable living, entertaining spaces both indoor & out added to a perfectly proportioned floor plan. Grand foyer opens to regal reception, gracious formals, home off & elegant staircase. Family rm w/fireplace, wet bar, wine rm & wine storage overlooking gracious gardens. Gourmet island kit designed to accommodate multipurpose preparation. Open to breakfast area & family rm. Oversized Primary w/sitting area, F/P, next to a workout rm or 2nd office. Lavish primary spa-like bath w/Lg dressing area. 3 add’l secondary bdrms. Third floor bedroom/game rm or media w/full bth. Gated sizeable motor court w/ample parking leads to 3 car garage. Guest quarters w/full bath & kitchenette. Close proximity to Uptown, Galleria & all Fine Shopping & Dining.' ,`Acres` = '' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Tanglewood Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 25 TANGLEWOOD SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'TANGLEWOOD' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804972' WHERE `Matrix_Unique_ID` = '211730357' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T07:38:30.620' ,`MLSNumber` = '81770615' ,`ListAgentFullName` = 'Tiffani Reynolds' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.850574' ,`Longitude` = '-95.805165' ,`PhotoCount` = '28' ,`PostalCode` = '77493' ,`RoomCount` = '9' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Ivory Glass' ,`StreetNumber` = '5306' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2237' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful and immaculate 1.5 story home full of upgraded features. You will feel right at home with the tall ceilings and large tiles throughout the common areas. As you walk past the entrance there are two secondary bedrooms that share a full-sized bathroom. Continue down the hall to the CUSTOM kitchen finished in 2021. This kitchen is an entertainer\'s dream space with an open concept floor plan looking over the dining room and living room. The features in the kitchen are endless, from the professional grade range, vent hood, and oven to the pot-filler and deep sink. This kitchen has it all. The living room also features upgraded wood laminate flooring and recessed lighting. From the living room, enter the primary retreat and en-suite with a large shower and custom-built closet. Finally, upstairs is a half story bonus room perfect for a theatre, game room, or study area. Outside condenser replaced in 2022. Schedule your showing today!' ,`Acres` = '0.1188' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 3 KING CROSSING SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5177' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '880' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BETHKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'King Crossing' ,`TaxAmount` = '8189' ,`TaxRate` = '3.4768' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804972' WHERE `Matrix_Unique_ID` = '211791752' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T07:54:18.467' ,`MLSNumber` = '89376304' ,`ListAgentFullName` = 'Suzan Odom' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.455321' ,`Longitude` = '-94.630378' ,`PhotoCount` = '23' ,`PostalCode` = '77650' ,`RoomCount` = '3' ,`ListPrice` = '695000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue G' ,`StreetNumber` = '1994' ,`StreetSuffix` = '' ,`City` = 'Crystal Beach' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1548' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand New Ocean View Beauty! She is a NEW Luxury Custom Build with all the bells and whistles. Includes all upscale furnishings and finishes both inside and out and comes professionally decorated compliments of Designs By Janette! They have spared no detail. If your looking for a turn key custom build you found it! Entire outer frame has blown installation 6\". All inter walls have installation for sound, heat & retention. (2) A/C units (2 ton/1 1/2 ton 16 seer. Hot water is a loop system with pump and 2-way timer. Stereo system, Wifi speaker controlled on all porches & patios. Wifi Camera system with 12 cameras. Outdoor BBQ, TV, Fire Pit, Stereo, an entertainment paradise! There are so many extra features...this is not a cookie cutter home. This is a Turn Key Custom Build. This Beach Beauty with Ocean Views would make a perfect full time home or investment opportunity with ALL 3 BEDROOMS COMPLETE WITH THEIR OWN ENSUITE BATHS! LYFT INCLUDED!' ,`Acres` = '0.1148' ,`Area` = '33' ,`BuilderName` = 'Chase Construction' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 179 J SHAW SUR LOT 6 BLK 4 GULF SHORES SEC 1' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View' ,`LotSize` = '5000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric 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` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Gulf Shores 1' ,`TaxAmount` = '515' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Aerobic,Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664804972' WHERE `Matrix_Unique_ID` = '211826401' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T07:17:09.610' ,`MLSNumber` = '60365971' ,`ListAgentFullName` = 'Susan Thomas' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.656851' ,`Longitude` = '-95.491070' ,`PhotoCount` = '31' ,`PostalCode` = '77035' ,`RoomCount` = '13' ,`ListPrice` = '415000.00' ,`Status` = 'Active' ,`StreetName` = 'Bellfort' ,`StreetNumber` = '5823' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2509' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Truly stunning updated one story home close to 610, shopping, dining and medical center. This home features a formal living room and formal dining room, a separate breakfast area, 4 bedrooms, 2 1/2 bathrooms, utility room and large air conditioned sunroom. Gorgeous kitchen with high end stainless steel appliances, custom cabinetry, stunning granite countertops, an island and peninsula. Spacious family room with engineered hardwoods, brick fireplace, crown molding and french doors allowing lots of natural light to come in.The primary and hall bath feature quartz countertop, dual sinks and custom cabinetry. The secondary bedrooms have new carpet and walk in closets. The primary bedroom features engineered hardwood flooring, two closets, french doors, crown molding and a unique feature wall. Beside amazing interior features, the home has many functional and mechanical updates as well. New AC, replaced underground plumbing, replaced windows and foundation leveled with lifetime warranty.' ,`Acres` = '' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 21 BLK 78' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10370' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ANDERSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'FONDREN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Parkwest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804972' WHERE `Matrix_Unique_ID` = '211826571' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T06:58:08.480' ,`MLSNumber` = '21574881' ,`ListAgentFullName` = 'Debra Cooper' ,`ListOfficeName` = 'Connect Realty' ,`SellingAgentFullName` = 'Deanna Zugheri' ,`SellingOfficeName` = 'Keller Williams Metropolitan' ,`Latitude` = '30.187851' ,`Longitude` = '-95.470708' ,`PhotoCount` = '38' ,`PostalCode` = '77381' ,`RoomCount` = '9' ,`ListPrice` = '560000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Tapestry Park' ,`StreetNumber` = '82' ,`StreetSuffix` = 'Circle' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2371' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location, Location, Location! Fabulous move-in ready, one story home in the front of The Woodlands, in sought after village of Grogan\'s Forest! Nestled on a premium lot with views from your front porch of a lovely community Park and a peaceful greenbelt in back surrounded by mature trees that bloom a beautiful shade of purple. The open concept floor plan features an island kitchen with circular bar that connects to the breakfast room and living room with cozy fireplace. This beautifully maintained home features a covered front porch and covered back porch with an extended travertine patio. Other amenities include wood flooring, sculptured carpeting in all bedrooms and in large home office. This energy efficient home has additional insulation along with double pane windows and a radiant barrier. Newly painted, interior and exterior! Original Owners! Walk or bike to town center, Market Street, and Hughes Landing; shop, dine enjoy!' ,`Acres` = '0.1996' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S959909 - WDLNDS GROGANS FOREST 09, BLOCK 2, LOT 3' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Wooded' ,`LotSize` = '8694' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'LAMAR ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Wdlnds Grogans Forest 09' ,`TaxAmount` = '8396' ,`TaxRate` = '2.1319' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1664804972' WHERE `Matrix_Unique_ID` = '212178459' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T07:45:27.463' ,`MLSNumber` = '62281435' ,`ListAgentFullName` = 'Art Martinez' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.784472' ,`Longitude` = '-95.432199' ,`PhotoCount` = '29' ,`PostalCode` = '77008' ,`RoomCount` = '7' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Eureka' ,`StreetNumber` = '6622' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2240' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exquisite home in Houston’s inner loop with easy freeway access to 610 and I10. Exceptionally well kept, updated and spacious are just a few words to describe this 2 story home with covered patio. Upon entering the quaint side gate you will find hardwood floors throughout home. The 1st floor consists of a wide entry with open floor plan to large kitchen, dining area and brightly lit living room. Kitchen features a 4 person seated island with granite countertop, stainless undermount 33\"wide sink and wine fridge. Tall trimmed upper cabinets surround island for ample storage along with the under stairway pantry. Living room is back lit with double stacking transom and single/double hung vinyl windows. Back of the home visitors will find the recently updated stamped concrete covered patio. Oversized Grande bedroom has marble topped double vanity and makeup station, garden tub and standing shower with updated tile pan and long closet with built in shoe shelves.' ,`Acres` = '0.0574' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Timbergrove/Lazybrook' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 14 BLK 1 EUREKA VISTA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Eureka Vista' ,`TaxAmount` = '9876' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804973' WHERE `Matrix_Unique_ID` = '212189380' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T07:29:59.087' ,`MLSNumber` = '57770209' ,`ListAgentFullName` = 'Peggy West' ,`ListOfficeName` = 'Peggy West Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.775398' ,`Longitude` = '-95.533181' ,`PhotoCount` = '44' ,`PostalCode` = '77024' ,`RoomCount` = '14' ,`ListPrice` = '5395000.00' ,`Status` = 'Active' ,`StreetName` = 'Gage' ,`StreetNumber` = '7' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '8304' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You are just in time for our NEW lower PRICE! Beautiful Mid-Century Modern home! #7 GAGE COURT! Rare, sought-after ONE-STORY. Located in Bunker Hill Gardens. Heart of Memorial! Under construction. This Modern /Contemporary features hi ceilings, spacious rooms, and natural light everywhere. This house has it all! West Wing has Primary Bdrm w/cathedral ceilings & FP. Heavenly 14’walk-through shower highlights Primary Bath. Also, in the West Wing: is a Jaw-Dropping Study (38’x20’ w/18’ ceilings), ideal as an art gallery, trophy room, or true working office. You\"ll love the Family area: includes wine room, butler’s pantry & wet bar. Kitchen is filled w/custom cabinetry, a hidden Catering Kit. Amazing utility rm/hm office looks out on the front lawn. Rare 4-car garage w/adjacent hobby/sport/wkout rm. Large pavilion, w/outdoor kit & bathrm. Plenty back yard for putting green, garden, or whatever pleases you. There are simply too many features to list in this amazing custom-designed home.' ,`Acres` = '0.8639' ,`Area` = '23' ,`BuilderName` = 'AG Russo Homes Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 1 BUNKER HILL GARDENS' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '37632' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range,Grill' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'BUNKER HILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'BUNKER HILL GARDENS' ,`TaxAmount` = '31374' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664804973' WHERE `Matrix_Unique_ID` = '212195335' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T06:59:27.120' ,`MLSNumber` = '46931430' ,`ListAgentFullName` = 'Otilia Robles' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.603734' ,`Longitude` = '-95.192572' ,`PhotoCount` = '17' ,`PostalCode` = '77034' ,`RoomCount` = '7' ,`ListPrice` = '314950.00' ,`Status` = 'Active' ,`StreetName` = 'High Banks Ln' ,`StreetNumber` = '13442' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2253' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful two-story home on a corner lot with 4 bedroom 2 1/2 bath. Open floor plan. All bedrooms offer spacious walk-in closet space. A gorgeous backyard is great for entertaining with a “Texas” sized covered patio. Near NASA, Ellington Field, shopping, schools, hospitals, and entertainment. Never flood it. We look forward to hearing from you!' ,`Acres` = '' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 5 CLEARVIEW VILLAGE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5168' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '325' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'TEAGUE ELEMENTARY SCHOOL (PASADENA)' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (PASADENA)' ,`SchoolMiddle` = 'BONDY INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Clearview Village Sec 03' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804973' WHERE `Matrix_Unique_ID` = '212208582' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T06:44:35.033' ,`MLSNumber` = '34512559' ,`ListAgentFullName` = 'Guylaine Belley' ,`ListOfficeName` = 'Century 21 Realty Partners' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.042943' ,`Longitude` = '-95.509718' ,`PhotoCount` = '50' ,`PostalCode` = '77379' ,`RoomCount` = '11' ,`ListPrice` = '485000.00' ,`Status` = 'Active' ,`StreetName` = 'Arbor Spring' ,`StreetNumber` = '17426' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3714' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SOPHISTICATION MEETS COMFORT in this exquisite home located in the prestigious community of Spring Creek Oaks. The subtleties of the architecture is sensed when choices were made for the location of each rm. The pronounced openness as you step foot in the two story foyer is providing seamless flow for ease of entertaining. Formal living & dining rm w/abundance of natural light, accent crown molding & hardwood flooring. Impressively proportioned gourmet kitchen serves as the heart of the home with quartz island with cooktop, breakfast bar, walk-in pantry, lots of cabinet space & breakfast area. Family room w/centerpiece fireplace and built-ins overlooks a picturesque patio embellished by lush landscaping, salt water pool, hot tub & in-ground grill. Spacious primary bedrm w/raised ceiling, bathrm w/soaking jetted tub, seamless marble surround shower & dual walk-in closets. 3 well appointed secondary bedrms upstairs w/game rm & 2 full bathrms. Built-ins in study & hardwood flooring.' ,`Acres` = '0.23' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 27 BLK 1 SPRING CREEK OAKS SEC 8' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Wooded' ,`LotSize` = '10017' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '991' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KUEHNLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Creek Oaks Sec 08' ,`TaxAmount` = '8621' ,`TaxRate` = '2.5965' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804973' WHERE `Matrix_Unique_ID` = '212240969' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T07:20:47.400' ,`MLSNumber` = '36412148' ,`ListAgentFullName` = 'Orrin Padgett' ,`ListOfficeName` = 'RE/MAX Synergy' ,`SellingAgentFullName` = 'Christy Buck' ,`SellingOfficeName` = 'Infinity Real Estate Group' ,`Latitude` = '29.443582' ,`Longitude` = '-95.096592' ,`PhotoCount` = '40' ,`PostalCode` = '77539' ,`RoomCount` = '6' ,`ListPrice` = '279900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Sun River' ,`StreetNumber` = '409' ,`StreetSuffix` = 'Lane' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1553' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for that new home feel!? This could be the house for you! First-class curb appeal with brick all the way around, freshly painted shudders with a matching brand new front door! As you enter you notice the bright feel with all new paint, new wood look floors, new light fixtures and ceiling fans. The kitchen has brand new appliances, new marble countertops, new slow close custom cabinets with under cabinet lighting. A brand new gas range has just been installed with a brand new hood and custom backsplash! As you walk into the living room, you feel the fireplace drawing you in with shiplap and brand new brick tile! The primary bedroom has a custom barn door, built ins for the walk in closet, and updated bathroom with new countertops, faucets, fixtures and cabinets. Even the laundry area has been redone! The garage with epoxy flooring and custom finish, even has its own sink! New baseboards, kitchen sink and spray foam in the attic for efficiency! Never flooded and New AC 2019' ,`Acres` = '0.1327' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BAY COLONY POINTE SEC 5 (2003) ABST 19, BLOCK 2, LOT 20, ACR' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5782' ,`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` = '17 - Dickinson' ,`SchoolElementary` = 'CALDER ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay Colony Pointe' ,`TaxAmount` = '5346' ,`TaxRate` = '2.8897' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804973' WHERE `Matrix_Unique_ID` = '212252975' --> 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','212327862','1664804974','212327862','2022-10-03T06:28:37.950','84552917','Stephanie Binkley','Stephanie Ripple','','','29.567723','-95.229335','11','77581','6','325000.00','Active','Marsala','1509','Drive','Pearland','2','0','2','1732','Single-Family','Over 55 gated community. This home has been completely updated. Kitchen, Both bathrooms, all flooring and paint. It is gorgeous and ready to move in. Two bedrooms with a spacious additional room that can be used for an office or workout room. The clubhouse in the subdivision is amazing. It offers a complete work out facility for your use. A library, pool, walkway/ bike trail around the lake. Not to mention the functions and parties held for the entire subdivision. Refrigerator/ washer and dryer are included..','0.1292','3','','','','','Sellers Disclosure','1','','','Pearland','Central Gas','1','LT 19 BLK 5 BELLAVITA AT GREEN TEE SEC 1','Subdivision Lot','5629','Appraisal District','','262','0','','2','','0','','','Electric Cooktop','','Composition','9 - Clear Creek','WEBER ELEMENTARY','CLEAR BROOK HIGH SCHOOL','WESTBROOK INTERMEDIATE SCHOOL','Appointment Required,Lockbox Left Side','Appraisal District','1','Traditional','Bellavita At Green Tee Sec 01','6791','2.8854','Public Sewer,Public Water','2001','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T06:50:47.833' ,`MLSNumber` = '2866880' ,`ListAgentFullName` = 'Otilia Robles' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.600276' ,`Longitude` = '-95.211355' ,`PhotoCount` = '29' ,`PostalCode` = '77089' ,`RoomCount` = '10' ,`ListPrice` = '238990.00' ,`Status` = 'Active' ,`StreetName` = 'Sagehaven Dr' ,`StreetNumber` = '11230' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1585' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful, all brick, one-story, split 3-bedroom/ 2-bathroom home in the popular established neighborhood of Sagemont. As you walk in the door to your right you will find a spacious flex room perfect for a formal dining room, home office, gym, game room, or 2nd living room. The remodeled bathrooms and kitchen, solid surface flooring (no carpet), freshly painted interior, mature trees, private backyard, epoxy garage floor, and added sunroom with a private office make this home a must see. Easy access to major freeways. Close to hospitals, Ellington Field, NASA, Galveston, Kemah, San Jacinto College South, University of Houston Clear Lake, BayBrook Mall, and many restaurants and entertainment venues. Low tax rate and maintenance fund.' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 10 SAGEMONT SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7580' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '50' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'STUCHBERY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'THOMPSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sagemont Sec 02' ,`TaxAmount` = '259934' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804974' WHERE `Matrix_Unique_ID` = '212341085' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T06:10:34.447' ,`MLSNumber` = '43291483' ,`ListAgentFullName` = 'Remo Castillo' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.853445' ,`Longitude` = '-95.272812' ,`PhotoCount` = '26' ,`PostalCode` = '77078' ,`RoomCount` = '9' ,`ListPrice` = '229900.00' ,`Status` = 'Active' ,`StreetName` = 'Seeker' ,`StreetNumber` = '9718' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1478' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Property ! . Fully Remodeled !!!!! New Roof !!!!! Please schedule an appointment to see this property Today !!!' ,`Acres` = '0.1515' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 19 BLK 12 GLENWOOD FOREST' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HILLIARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Glenwood Forest' ,`TaxAmount` = '2989' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1664804974' WHERE `Matrix_Unique_ID` = '212401933' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T07:30:50.970' ,`MLSNumber` = '7110958' ,`ListAgentFullName` = 'Mark Bland' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.919781' ,`Longitude` = '-95.066938' ,`PhotoCount` = '13' ,`PostalCode` = '77532' ,`RoomCount` = '11' ,`ListPrice` = '299995.00' ,`Status` = 'Active' ,`StreetName` = 'Feverfew Trail' ,`StreetNumber` = '6306' ,`StreetSuffix` = '' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1616' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! Lovely Two Story Cul-de-sac home. 3brd, 2 1/2bth with all bedrooms up. Master bedroom has a stand up shower along with soaking garden tube for those long stressful days. The kitchen has maple cabinets with quartz countertops. Living room has a corner fireplace with a maple mantel that compliments the tile flooring. Located near Crosbys 46-acre Park. Contract your real estate agent and make your appointment now.' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'K Hovnanian' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Block 22 Lot 1 Crosby Park Village' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3999' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'CROSBY ELEMENTARY SCHOOL (CROSBY)' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Crosby Park Village' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664804974' WHERE `Matrix_Unique_ID` = '212410712' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T07:49:53.643' ,`MLSNumber` = '72726736' ,`ListAgentFullName` = 'Emily Perez' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.784797' ,`Longitude` = '-95.042552' ,`PhotoCount` = '14' ,`PostalCode` = '77520' ,`RoomCount` = '4' ,`ListPrice` = '269000.00' ,`Status` = 'Active' ,`StreetName` = 'Burnett' ,`StreetNumber` = '517' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2224' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your dream home in the beautiful Lakewood Subdivision! This home has been fully renovated and it\'s ready for it\'s new owners! NEW Roof 2022. NEW flooring throughout. NEW Paint throughout (Interior and Exterior) NEW Appliances. NEW Quartz countertops in kitchen and primary bathroom. NEW Vanities in both bathrooms. NEW HVAC system. NEW Hot water heater. NEW Pex plumbing. NEW Electrical ran. Foundation repaired with a lifetime warranty. Partial new fence on the left and right side of home. SO MANY UPDATES! It\'s almost a brand new home! You don\'t want to miss this one; Contact your agent and schedule a showing today!' ,`Acres` = '0.4004' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 37 BLK 56 LAKEWOOD SEC K' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '17440' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'BAYTOWN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakewood Sec K' ,`TaxAmount` = '4918' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804974' WHERE `Matrix_Unique_ID` = '212414698' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T07:33:53.210' ,`MLSNumber` = '40503898' ,`ListAgentFullName` = 'Michelle Weaver' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.805882' ,`Longitude` = '-95.521019' ,`PhotoCount` = '44' ,`PostalCode` = '77080' ,`RoomCount` = '10' ,`ListPrice` = '725000.00' ,`Status` = 'Active' ,`StreetName` = 'Livernois' ,`StreetNumber` = '9367' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3376' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning, custom Brookfield home in popular Spring Branch Oaks that has it ALL! Elegantly appointed & energy efficient (new Trane AC units), high end finishes sweep this light filled open layout, ideal for entertaining. Park-like oversized lot is accented by beautiful PebbleTec waterfall pool/spa with waterfall. Fresh exterior paint & new roof, covered front patio & spacious back pool deck make for enjoyable outdoor living. Interior features study, gameroom, 3 bedrooms down, separate suite up, mud room, bonus storage & more. Gourmet kitchen flaunts large island, rich cabinetry & fridge. Great central location w/ easy access going East or West in SBISD.' ,`Acres` = '0.3598' ,`Area` = '24' ,`BuilderName` = 'Brookfield' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 235 BLK 22 SPRING BRANCH OAKS SEC 4' ,`LotDesciption` = 'Cleared,Subdivision Lot,Wooded' ,`LotSize` = '15672' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '20' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'SPRING BRANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING WOODS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Branch Oaks Sec 04' ,`TaxAmount` = '12940' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804974' WHERE `Matrix_Unique_ID` = '212460248' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T06:59:53.250' ,`MLSNumber` = '24499891' ,`ListAgentFullName` = 'Meriam Shaw' ,`ListOfficeName` = 'Keller Williams Elite' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.909136' ,`Longitude` = '-95.082271' ,`PhotoCount` = '36' ,`PostalCode` = '77532' ,`RoomCount` = '8' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Chamfer' ,`StreetNumber` = '907' ,`StreetSuffix` = 'Way' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2040' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You must see this warm and cozy abode with NO BACK NEIGHBOR! This home has 4 Bedrooms and 2 Full bath with improved attic Storage approximately 500 sqft. Enjoy the Covered back patio & 3 CAR GARAGE. This home comes with generator it’s very well maintained. Located at Newport Subdivision that features a wide golf course, a beautiful lake, outdoor pool, an open tennis court and a playground that your kids will enjoy. Make an Appointment Today!' ,`Acres` = '0.1635' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Gas,Other Heating' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 5 NEWPORT SEC 8 PAR R/P' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '7143' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '480' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'CROSBY ELEMENTARY SCHOOL (CROSBY)' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Newport' ,`TaxAmount` = '6146' ,`TaxRate` = '2.7105' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804974' WHERE `Matrix_Unique_ID` = '212530572' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T07:58:52.913' ,`MLSNumber` = '58058748' ,`ListAgentFullName` = 'Sharon Gebhard' ,`ListOfficeName` = 'Texas Premier Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.617266' ,`Longitude` = '-95.589220' ,`PhotoCount` = '48' ,`PostalCode` = '77478' ,`RoomCount` = '4' ,`ListPrice` = '459000.00' ,`Status` = 'Active' ,`StreetName` = 'Bendwood' ,`StreetNumber` = '26' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2575' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous home in desired Bendwood section of Sugar Creek on the golf course! This spacious well thought out home features tons of storage throughout. This home is perfect for entertaining. Gorgeous Austrian crystal chandelier in entryway. The living room features a built in fireplace and wet bar. Large kitchen and formal dining room. The bedrooms feature huge walk in closets and built ins. Main bedroom features a panick button that turns on all lights in the house. The third bedroom could serve as a home office. \r\n Enjoy the upper deck and downstairs patio. Lots of updates including electrical panel with whole house surge protector, new Gorilla Glass windows, new exterior doors, gas water heater with leak detector, and upgraded alarm system. Paneled garage with built in cabinets. HOA fee includes mowing and edging. Schedule your showing today!' ,`Acres` = '0.1688' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SUGAR CREEK SEC 8, LOT 26' ,`LotDesciption` = 'On Golf Course' ,`LotSize` = '7354' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1259' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'DULLES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sugar Creek Sec 8' ,`TaxAmount` = '6483' ,`TaxRate` = '2.0094' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804975' WHERE `Matrix_Unique_ID` = '212548742' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T07:43:00.233' ,`MLSNumber` = '10222793' ,`ListAgentFullName` = 'Tracy Montgomery' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.988955' ,`Longitude` = '-95.181076' ,`PhotoCount` = '33' ,`PostalCode` = '77346' ,`RoomCount` = '8' ,`ListPrice` = '329900.00' ,`Status` = 'Active' ,`StreetName` = 'Stark Point' ,`StreetNumber` = '18423' ,`StreetSuffix` = 'Court' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2018' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3/4 bedroom updated home located in Eagle Springs on a quiet cul-de-sac. No carpet in home. Wood laminate floors thru out except kitchen, baths and utility is Tile. Refrigerator, Washer and Dryer included. Recently installed 8/22 Granite counters and new sinks in Kitchen and baths. Kitchen has breakfast bar, SS appliances, and a ton of counter and cabinet space for storage. Kitchen is open to the large family room that has beautiful flooring, crown molding and tile fireplace. Escape to the master suite with high ceilings and french doors that lead to a room that can be used as an office, work out area or nursery. Master bath has double his/her sinks, jetted tub, separate shower, and His and Her walk in closets. Spacious secondary bedrooms/closets and bathroom complete this home. Head outside to the backyard where there is enough room to have a swing-set and/or garden.' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 46 BLK 3 EAGLE SPRINGS SEC 7' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6929' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '825' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'EAGLE SPRINGS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'TIMBERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Eagle Springs' ,`TaxAmount` = '6003' ,`TaxRate` = '3.2233' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804975' WHERE `Matrix_Unique_ID` = '212576069' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T07:11:03.137' ,`MLSNumber` = '966817' ,`ListAgentFullName` = 'Steve Owen' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.717160' ,`Longitude` = '-95.790269' ,`PhotoCount` = '50' ,`PostalCode` = '77494' ,`RoomCount` = '11' ,`ListPrice` = '625000.00' ,`Status` = 'Active' ,`StreetName` = 'Catalina Harbor' ,`StreetNumber` = '23018' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3078' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Elegant 4 bedroom, 3.5 Katy home is ready for you to call your own! The moment you enter the grand foyer you are greeted by the perfect mix of sophistication and function. Formal dining room and home office with French doors at the entrance. The large living room with a cozy fireplace and large windows is at the heart of the home. Ideal kitchen with a large island, bright breakfast nook with patio access, built-in appliances, built-in desk, a pantry, and ample prep space. Enviable downstairs primary suite with bay windows, sitting area, separate shower, jetted tub, separate vanities, and walk-in closet. Texas-sized game room with bonus study nook shares the second floor with the spacious secondary bedrooms and baths. The fourth bedroom can be used as a home gym, hobby room, or guest room. The picturesque backyard with a covered patio, lush landscaping, shady trees, and water views provides extra outdoor entertaining space. 3D tour online!' ,`Acres` = '0.1791' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'AVALON AT SEVEN MEADOWS SEC 3, BLOCK 1, LOT 3' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Grill' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'GRIFFIN ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'SEVEN LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'BECKENDORFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Avalon At Seven Meadows' ,`TaxAmount` = '10867' ,`TaxRate` = '2.3145' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804975' WHERE `Matrix_Unique_ID` = '212580418' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T07:47:23.230' ,`MLSNumber` = '39259609' ,`ListAgentFullName` = 'Elaine Reynolds' ,`ListOfficeName` = 'Orchard Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.937380' ,`Longitude` = '-95.712913' ,`PhotoCount` = '38' ,`PostalCode` = '77433' ,`RoomCount` = '17' ,`ListPrice` = '559000.00' ,`Status` = 'Active' ,`StreetName` = 'Breton Bridge' ,`StreetNumber` = '27102' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '3653' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Click the Virtual Tour link to view the 3D walkthrough. Your dream home awaits. Situated on a cul-de-sac lot within the desirable Cypress Creek Lakes community with six bedrooms, four bathrooms, multiple living and dining areas, and recent renovations - this property is turnkey! Sleek and pristine kitchen remodel includes new electric stainless-steel stove and range hood, self-cleaning oven, undermount stainless sink, new countertops, white cabinetry and subway tile backsplash. Full interior repaint and new LVP flooring. Ideal open floor plan with soaring high ceilings and plenty of natural light creating a bright and airy atmosphere throughout. Elegant primary suite conveniently located on the main level featuring walk-in closet, double vanities, separate shower, and garden tub. Upper loft provides additional living space. Fenced backyard with storage shed, covered patio, and plenty of room to relax or entertain outdoors. You don\'t want to miss this one!' ,`Acres` = '0.2656' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 37 BLK 2 CYPRESS CREEK LAKES SEC 6' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '11570' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WARNER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Creek Lakes Sec 6' ,`TaxAmount` = '9455' ,`TaxRate` = '2.801' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804975' WHERE `Matrix_Unique_ID` = '212665730' --> 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','212683325','1664804975','212683325','2022-10-03T06:14:55.027','37786851','Ivannia Recio','Ace Realty','','','29.845327','-95.260535','29','77078','8','179999.00','Active','Lake Forest','8830','Boulevard','Houston','1','0','4','1018','Single-Family','Remodeled four-bedroom home with Hardie siding. Freshly painted inside. Home has tile and carpet throughout. New central ac/ heat (gas) installed with new duct work. New meter can and breaker box that is within code. Kitchen has custom cabinets and granite countertops. New electric stove with gas connection available. New water heater. LED lighting and ceiling fans in the room as well as the bedrooms. Beautiful white tile in bathrooms. Blown-in attic insulation. Spacious backyard for entertaining. Make your appointment today!!','0.1653','2','','','','','Sellers Disclosure','','','','Northeast Houston','Central Electric','0','LT 3 BLK 4 LAKE FOREST','Subdivision Lot','7200','Appraisal District','','','0','','0','','0','','','','','Composition','27 - Houston','ELMORE ELEMENTARY SCHOOL','KASHMERE HIGH SCHOOL','KEY MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','1','Other Style','Lake Forest','954','2.3307','Public Sewer,Public Water','1950','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T07:37:44.163' ,`MLSNumber` = '34289268' ,`ListAgentFullName` = 'Ola Kuku' ,`ListOfficeName` = 'Fairdale Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.444812' ,`Longitude` = '-95.447458' ,`PhotoCount` = '28' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Amethyst Glen Dr' ,`StreetNumber` = '9411' ,`StreetSuffix` = '' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2616' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MUST SEE!! \nThe upgrades are very nicely done. \nGorgeous 2 story, 5 bedroom, 2.5 bath home situated in a gated community. \n\nUPGRADES: \n- High-end waterproof Vinyl flooring throughout downstairs, including the Master bedroom, \n- Brand new carpets in the 4 bedrooms\n- Premium tiles in bathrooms and laundry room.\n- Updated shower 3D Subway tiles in Master bathroom & second bathroom. \n- Recently added stainless steel appliances and full fence.\n\nGreat value home will go quickly don\'t miss this opportunity. Enjoy time with the family at the community tennis courts, Splashpad Texas, junior Olympic sized swimming pool, basketball court, and clubhouse, or travel amongst the miles of paved walking trails.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Blk 2 Lot 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6673' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'SANCHEZ ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sterling Lakes At Iowa Colony' ,`TaxAmount` = '10324' ,`TaxRate` = '3.4099' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804975' WHERE `Matrix_Unique_ID` = '212736737' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T07:10:19.693' ,`MLSNumber` = '26407377' ,`ListAgentFullName` = 'Steve Owen' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.732990' ,`Longitude` = '-95.842678' ,`PhotoCount` = '46' ,`PostalCode` = '77494' ,`RoomCount` = '11' ,`ListPrice` = '470000.00' ,`Status` = 'Active' ,`StreetName` = 'Pennington Trace' ,`StreetNumber` = '3423' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2534' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ready for you to call your new home! This stunning 4 bedroom, 2 bath Katy home warmly welcomes you the moment you enter the grand foyer! Beautiful designer touches throughout. The spacious and open floor plan is ideal for hosting gatherings! The inviting living room with a fireplace sits at the heart of the home and opens to the kitchen! The modern eat-in kitchen offers an island with sink and seating, built-in stainless steel appliances, a tiled backsplash, a walk-in pantry, and a bright breakfast nook. The serene primary suite boasts a spa-like bath with a separate shower, jetted tub, separate vanities, and a walk-in closet. Elegant formal dining room or additional living room. Large secondary bedrooms and bath. The fourth bedroom can easily be used as a comfortable office or home gym! The private backyard with a covered patio is perfect for relaxing at the end of a long day! Don\'t miss your opportunity to move in and make this your own! 3D tour available online!' ,`Acres` = '0.175' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CANYON LAKES AT CARDIFF RANCH SEC 5, BLOCK 1, LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7622' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'KEIKO DAVIDSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMPKINS HIGH SCHOOL' ,`SchoolMiddle` = 'TAYS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Lakes At Cardiff Ranch' ,`TaxAmount` = '8230' ,`TaxRate` = '2.7545' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804976' WHERE `Matrix_Unique_ID` = '212757271' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T07:46:09.473' ,`MLSNumber` = '87413658' ,`ListAgentFullName` = 'Shoujian Huang' ,`ListOfficeName` = 'Forever Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.699326' ,`Longitude` = '-95.496128' ,`PhotoCount` = '24' ,`PostalCode` = '77074' ,`RoomCount` = '6' ,`ListPrice` = '269900.00' ,`Status` = 'Active' ,`StreetName` = 'Rowan' ,`StreetNumber` = '6417' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1226' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Completely remodeled beautiful one story brick home, 3 BR, 2 bath, and 1 car garage and 1 covered porch/car port. High quality waterproof SPC wood like flooring throughout the whole house, walls, ceiling and trim have been freshly painted, new lighting, new blinds. Brand new kitchen features open concept design, kitchen has granite countertops and custom white cabinets, stainless stove/oven, dishwasher etc. The primary bedroom offers en suite bathroom with new vanity and shower. Spacious secondary bedrooms & large second bath with high end design of custom cabinetry, frameless glass walk-in shower. Lots of natural light for the whole house. New A/C system, brand new plumbing. New garage floor, new walls and garage door. New concrete drive way led to covered porch/car port. NEVER FLOODED! Not even in the 500-Year Floodplains.' ,`Acres` = '0.1639' ,`Area` = '21' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sharpstown Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 8 SHARPSTOWN SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7140' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SUTTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHARPSTOWN HIGH SCHOOL' ,`SchoolMiddle` = 'LONG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Lockbox Right Side,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sharpstown Sec 01' ,`TaxAmount` = '3610' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804976' WHERE `Matrix_Unique_ID` = '212801578' --> 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','212821813','1664804976','212821813','2022-10-03T07:51:16.540','20322777','Blythe Palamara','Compass RE Texas, LLC','','','29.963255','-95.653547','45','77429','11','615000.00','Active','Secret Forest','12810','Court','Cypress','3','1','4','3455','Single-Family','Coveted 4 BEDROOM & 3.5 BATH home located in Cypress. Almost acre lot in quiet gated community. Dramatic foyer with a formal dining room to the right. Office on left with built-in shelves. Slate flooring throughout downstairs. Hugh Primary suite on 1st floor with sitting room and gas fireplace! En suite bathroom features soaking tub, separate shower + large walk-in closet. Lovely kitchen with Granite counters, center island with cooktop, double ovens + raised dishwasher. Bright and sunny living room with another fireplace. Circular staircase leads up to 3 bedrooms, with game room. Amazing backyard with plenty of trees. Freshly painted, Roof (2013), HVAC (2021), water heater (2018). No MUD tax. This is the home you have been waiting for.','0.8663','10','Trendmaker','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace,Wood Burning Fireplace','2','Cypress North','Central Gas','1','LT 19 BLK 1 SECRET FOREST COURT','Subdivision Lot,Wooded','37736','Appraisal District','','2200','0','','3','Double Oven','0','','','Electric Range','','Composition','13 - Cypress-Fairbanks','SAMPSON ELEMENTARY SCHOOL','CYPRESS WOODS HIGH SCHOOL','SPILLANE MIDDLE SCHOOL','Appointment Required,Controlled Access,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Secret Forest Court','9705','2.091','Septic Tank','1999','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T07:49:27.997' ,`MLSNumber` = '79257695' ,`ListAgentFullName` = 'Stacy Newton' ,`ListOfficeName` = 'Weichert,REALTORS-Murray Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.118654' ,`Longitude` = '-95.502014' ,`PhotoCount` = '32' ,`PostalCode` = '77389' ,`RoomCount` = '7' ,`ListPrice` = '364900.00' ,`Status` = 'Active' ,`StreetName` = 'Glenfield Spring' ,`StreetNumber` = '5422' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2249' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming one story home conveniently located. Upon walking up to this home you are welcomed to an inviting front porch. When entering the home you will have a private office/study off of the entry hall. The kitchen with a large walk in pantry and tons of cabinet space is open to the dining room and family room. The back yard backs up to a greenbelt space which offers added privacy so you can sit on the covered back patio and relax. The primary suite has a room connected to it with closet space and a window that could easily be used as a private office, nursery, workout space - the possibilities are endless. Both secondary rooms are down their own hallway for privacy. The home also offers a central vacuum system throughout. Call today to schedule a private showing.' ,`Acres` = '0.1544' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 1 HAMPTON CREEK SEC 2 AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6725' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '925' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'FRENCH ELEMENTARY SCHOOL (KLEIN)' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HOFIUS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hampton Crk Sec 2' ,`TaxAmount` = '8939' ,`TaxRate` = '3.304' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804976' WHERE `Matrix_Unique_ID` = '212880832' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T07:02:06.720' ,`MLSNumber` = '70554378' ,`ListAgentFullName` = 'Darlyn Gomez' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.215123' ,`Longitude` = '-95.419592' ,`PhotoCount` = '35' ,`PostalCode` = '77385' ,`RoomCount` = '9' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Pacific Loon' ,`StreetNumber` = '2139' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2364' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '***Welcome home to 2139 Pacific Loon Ln! This gorgeous 2-story home features 2,364 sqft with 4 bedrooms, 2.5 bathrooms, incredible updates throughout! You\'ll love the perfect entertainer\'s layout with an open concept between the living room and kitchen. There are an abundance of features including beautiful tile floors, modern finishes, granite countertops, stainless steel appliances, spacious master suite, kitchen with ample storage space, COVERED PATIO, a relaxing backyard paradise you don\'t want to miss, and so much more! This home is located in the community of Montgomery Creek Ranch with amenities including a swimming pool, playground, recreation area, and is zoned Conroe ISD. The community has nearby restaurants and shopping as well as The Woodlands, I-45, and the Grand Pkwy (99) for an easy commute.' ,`Acres` = '0.1154' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S720819 - MONTGOMERY CREEK RANCH 19, BLOCK 2, LOT 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5027' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Montgomery Creek Ranch 19' ,`TaxAmount` = '6281' ,`TaxRate` = '2.6088' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804976' WHERE `Matrix_Unique_ID` = '212964730' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T07:35:01.880' ,`MLSNumber` = '22655709' ,`ListAgentFullName` = 'Mia Cardenas' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.556807' ,`Longitude` = '-95.238820' ,`PhotoCount` = '43' ,`PostalCode` = '77581' ,`RoomCount` = '12' ,`ListPrice` = '357000.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Cone' ,`StreetNumber` = '2704' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2249' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home nestled in the quiet, wooded community of Pine Shadows with 3 bedrooms and 2.5 baths. Large windows allow natural light to fill the home and highlight the spaciousness of each room. Step into the grand living room featuring cathedral ceilings and a stately brick fireplace. An open kitchen with granite counters and stainless appliances connects to the breakfast area. The formal dining room is located just off the front entry. A generously sized primary suite has cathedral ceilings and huge windows that overlook the private backyard full of beautiful trees. The primary bath offers double sinks with vanity, an oversized shower and 2 walk-in closets. Secondary bedrooms located upstairs are spacious. Upstairs also offers a large living area, study and full bath. A large gameroom was added downstairs, along with a half bath. Pine Shadows community is NOT managed by an HOA and no MUD tax! LOW tax rate! The home is an estate and being sold AS IS. Move in ready!!!' ,`Acres` = '0.2101' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PINE SHADOWS (PEARLAND), BLOCK 2, LOT 10' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '9152' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'SHADYCREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH EAST' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pine Shadows Pearland' ,`TaxAmount` = '7232' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804976' WHERE `Matrix_Unique_ID` = '212965054' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T07:33:12.697' ,`MLSNumber` = '82883512' ,`ListAgentFullName` = 'Daniel DiPetta' ,`ListOfficeName` = 'Bayou City Realty, LLC' ,`SellingAgentFullName` = 'Randy Anderson' ,`SellingOfficeName` = 'Keller Williams Premier RealtyKaty' ,`Latitude` = '29.927107' ,`Longitude` = '-95.575398' ,`PhotoCount` = '21' ,`PostalCode` = '77064' ,`RoomCount` = '4' ,`ListPrice` = '249999.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Lazy Meadows' ,`StreetNumber` = '10903' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1915' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated house in a mature neighborhood awaits you! New roof. New modern interior paint throughout! New modern flooring throughout the house. Updated kitchen with quartz counter tops and subway tile backsplash. Updated bathrooms with quartz counter tops and tile flooring. Spacious backyard perfect for those gatherings!' ,`Acres` = '0.1313' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Willowbrook South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TR 4 BLK 4 S 21 FT LT 8 & N 31 FT LT 9 HARVEST BEND SEC 3 R/' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5720' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '407' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'FRANCONE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'CAMPBELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harvest Bend Sec 03 R/P' ,`TaxAmount` = '4616' ,`TaxRate` = '2.5587' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804977' WHERE `Matrix_Unique_ID` = '212974434' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T07:36:52.107' ,`MLSNumber` = '82256427' ,`ListAgentFullName` = 'JD Adamson' ,`ListOfficeName` = 'Douglas Elliman Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.814492' ,`Longitude` = '-95.427659' ,`PhotoCount` = '24' ,`PostalCode` = '77018' ,`RoomCount` = '6' ,`ListPrice` = '398750.00' ,`Status` = 'Active' ,`StreetName` = 'Wilde Rock' ,`StreetNumber` = '1502' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1128' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Renovated charming 1-story brick home nestled in highly sought-after Shepherd Forest community; zoned to Oak Forest Elementary! This 2/2/1 was transformed into the beautiful home we see today in 2010. The down-to-the-studs renovation includes new plumbing, an additional bathroom, French doors to the patio, new roof, new windows, exterior paint, custom cabinets, honed granite countertops, ss appliances. New refrigerator (2021), wine bar, gas range, and updated lighting. Recent improvements include a new garage door, toilets, and air ducts (2021). Custom window treatments, sizeable main suite with dual closets, and renovated bathrooms. Original hardwood floors were refinished in (2018). The fully fenced backyard is the perfect backdrop for large-scale entertaining! Newly installed incredible screened porch (~298 SQFT) with fan and TV (included). This gorgeous home is conveniently located and move-in ready. Call today for a tour. HOME HAS NEVER FLOODED!' ,`Acres` = '0.159' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 344 BLK 19 SHEPHERD FOREST' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6944' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GARDEN OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Shepherd Forest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804977' WHERE `Matrix_Unique_ID` = '212981222' --> 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','212994839','1664804977','212994839','2022-10-03T07:12:36.020','41914549','Lindsay Landin','CB&A, Realtors','','','30.282396','-95.550695','49','77316','10','495000.00','Active','Claret Cup','154','Lane','Montgomery','2','0','2','2278','Single-Family','Welcome and make yourself at home! This lovely home is situation on an established street, in the cul de sac & on a PREMIUM OVERSIZED lot! The Avondale floorplan features a bright, open entry w/ high ceilings that extend past the study & formal dining. This home has light tile throughout main entrance & dining area, & eng. wood in living area. Many windows keeping it bright in the upgraded sunroom addition. Kitchen opens up to the living area overlooking the fireplace & breakfast area. Primary bedroom has a large walk-in closet, ensuite bathroom w/ shower & double vanity. Enjoy the UPGRADED extended & covered patio for outdoor entertaining & let your imagination go wild w/ the oversized backyard.\r\n\r\n55+ Community w/ large pool, pickel ball, bocce ball & access to a fabulous club house w/ many events throughout the year. You also have access to tennis courts, pools, dog parks, the Palm Clubhouse among other amenities of Woodforest. Come be apart of the Woodforest Community!','','39','Taylor Morrison','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Conroe Southwest','Central Gas','1','S265900 - BONTERRA AT WOODFOREST 01, BLOCK 2, LOT 25','Cul-De-Sac,In Golf Course Community,Subdivision Lot','11089','Appraisal District','','2850','0','','2','Electric Oven,Single Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','STEWART ELEMENTARY SCHOOL (CONROE)','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Bonterra At Woodforest 01','10194','2.6888','Water District','2015','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T07:50:18.307' ,`MLSNumber` = '43889597' ,`ListAgentFullName` = 'John Pham' ,`ListOfficeName` = 'RE/MAX Alliance' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.080556' ,`Longitude` = '-95.640757' ,`PhotoCount` = '10' ,`PostalCode` = '77377' ,`RoomCount` = '3' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Mary Jane' ,`StreetNumber` = '14407' ,`StreetSuffix` = 'Lane' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1232' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1+ acre with 2 mobile homes. Minutes from Tomball Parkway' ,`Acres` = '1.2473' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 15 R/S TRS 3 4 11 & 13 ABST 375 J M HOOPER' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '54332' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'ROSEHILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'J M Hooper' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Well' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804977' WHERE `Matrix_Unique_ID` = '212999444' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T07:58:37.203' ,`MLSNumber` = '22308548' ,`ListAgentFullName` = 'Ana Amezcua' ,`ListOfficeName` = 'Ross & Marshall Realty' ,`SellingAgentFullName` = 'Cindi Albers' ,`SellingOfficeName` = 'Cross Capital Realty' ,`Latitude` = '29.950513' ,`Longitude` = '-95.576222' ,`PhotoCount` = '25' ,`PostalCode` = '77070' ,`RoomCount` = '7' ,`ListPrice` = '325000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Grassland' ,`StreetNumber` = '10415' ,`StreetSuffix` = 'Circle' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2348' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning fully remodeled home in the quiet Woodedge Village subdivision. This beautiful home offers 4 Bedrooms 3 full bathrooms, detached 2-car garage with an EXTRA ROOM above the Garage that can be used as an apartment, home office, storage etc. \r\nBeautifully updated Kitchen with new granite countertops, new tile, new fixtures, new recessed lighting, and new stainless steel appliances! New HVAC unit, neutral paint, ceiling fans, carpet, tile & hardwood flooring throughout!\r\nExcellent Schools Cy-Fair ISD w/proximity to numerous parks, near FM-1960, Hwy 249, Hwy 290, & Beltway 8!' ,`Acres` = '0.2204' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Willowbrook South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 15 WOODEDGE VILLAGE SEC 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '525' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'DANISH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodedge Village Sec 02' ,`TaxAmount` = '5914' ,`TaxRate` = '2.8087' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804977' WHERE `Matrix_Unique_ID` = '213000348' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T06:46:06.117' ,`MLSNumber` = '68564258' ,`ListAgentFullName` = 'Suzanne McClere' ,`ListOfficeName` = 'Coldwell Banker TGRE' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.231593' ,`Longitude` = '-95.665428' ,`PhotoCount` = '47' ,`PostalCode` = '77354' ,`RoomCount` = '11' ,`ListPrice` = '572000.00' ,`Status` = 'Active' ,`StreetName` = 'Sharps' ,`StreetNumber` = '12530' ,`StreetSuffix` = 'Lane' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3572' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this spacious Dunn & Stone Builders brick and stone home in Mostyn Manor subdivision, located in Magnolia ISD. Upon entering the foyer, you will find the private study and formal dining room. The gourmet kitchen, with stainless steel appliances and abundant dark wood cabinetry, includes double ovens and a gas cooktop and is open to the living room. The butlers pantry is situated between the kitchen and dining room. The primary bedroom is located downstairs and includes an en-suite bath with separate tub and shower, complete with a generous walk in closet. Upstairs are 3 large bedrooms and two full baths, along with an added bonus room. This versatile space could be a media room, game room, craft room, exercise room or whatever is desired! Refrigerator/Washer/Dryer and 3 wooden barstools, at kitchen counter, convey with sale of home! Please verify schools and room measurements, as measurements are approximate.' ,`Acres` = '0.3767' ,`Area` = '15' ,`BuilderName` = 'Dunn & Stone' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S730804 - MOSTYN MANOR 04, BLOCK 4, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '16411' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mostyn Manor 04' ,`TaxAmount` = '' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804977' WHERE `Matrix_Unique_ID` = '213092941' --> 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','213120160','1664804978','213120160','2022-10-03T07:51:27.710','29578560','Neil Silverman','Bernstein Realty, Inc.','','','29.449171','-95.434768','49','77583','12','535000.00','Active','Emerald Pines','2706','Lane','Iowa Colony','3','1','4','3586','Single-Family','Beautiful Terrata Home built in 2019 that will not disappoint. Incredible home for entertaining! Open flowing concept filled w/natural light. This 4-bedroom, 3.5 bath home w/granite throughout, on a Cul-De-Sac, sits on a huge 17,193 sq foot lot (per Appraisal District). The first floor boasts a welcoming open floor plan w/ Primary down, 2 walk-in closets & double vanity sinks. Huge Living/Family room w/fireplace nicely appointed w/stone, open kitchen w/stainless steel appliances & stone backsplash, breakfast room, breakfast bar w/granite bull nose rounded corners giving ample extra seating, formal dining room & large walk-in pantry. Second floor includes 3 bedrooms, media room, study/office & 2 bathrooms, one with a full shower. Extra features, Tankless Water Heater, 3-Car Garage w/Epoxied Floor, Outdoor Kitchen for entertaining & beautifully landscaped. Huge lot will accommodate an expansive pool. Community amenities include a manned guard, rec facilities w/pool, trails, & tennis.','0.3947','5','Terrata','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Alvin North','Central Gas,Zoned','1','STERLING LAKES AT IOWA COLONY SEC 20 (A0289 HT&B) BLK 2 LOT','Subdivision Lot','17193','Appraisal District','','1200','0','','3','Convection Oven,Single Oven','0','','','Gas Cooktop','','Composition','3 - Alvin','SANCHEZ ELEMENTARY SCHOOL (ALVIN)','IOWA COLONY HIGH SCHOOL','CAFFEY JUNIOR HIGH SCHOOL','Appointment Required,Controlled Access,Lockbox Left Side,Supra Keybox','Appraisal District','2','Traditional','Sterling Lakes At Iowa Colony','14555','3.4099','Water District','2019','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T07:33:48.543' ,`MLSNumber` = '15539537' ,`ListAgentFullName` = 'Juria Taylor' ,`ListOfficeName` = 'Taylor Signature Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.024988' ,`Longitude` = '-95.385928' ,`PhotoCount` = '27' ,`PostalCode` = '77073' ,`RoomCount` = '4' ,`ListPrice` = '238500.00' ,`Status` = 'Active' ,`StreetName` = 'Jamals' ,`StreetNumber` = '21418' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1650' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home!!! To this beautiful, spacious, well maintained 4 bedroom, 2 bath, 2 car garage, 1 story home. This charming home has an open layout and is situated on a cul de sac street. Includes access to an area pool in the community. Just 15 minutes away for The Woodlands Mall! Grocery is near by, Mercer Botanic Gardens and Mercer Playground & Post Oak Picnic Pavilion just 6 minutes away.' ,`Acres` = '0.1085' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 51 BLK 3 WERRINGTON PARK SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4725' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '570' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'OGDEN ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'TEAGUE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Werrington Park Sec 3' ,`TaxAmount` = '3736' ,`TaxRate` = '2.9808' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804978' WHERE `Matrix_Unique_ID` = '213127688' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T07:24:32.880' ,`MLSNumber` = '76734990' ,`ListAgentFullName` = 'Salvador Caballero' ,`ListOfficeName` = 'ListWithFreedom.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.429407' ,`Longitude` = '-94.257149' ,`PhotoCount` = '6' ,`PostalCode` = '75972' ,`RoomCount` = '5' ,`ListPrice` = '329000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 1277' ,`StreetNumber` = '11185' ,`StreetSuffix` = '' ,`City` = 'San Augustine' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2324' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming country home on a hill. 15 acres, two ponds, a creek that borders the property, cross fencing, pecan and fig trees, a squeeze chute, small animal barn, a chicken house, a metal workshop this is an ideal home place. The 3 bedroom one bath home has a new HVAC 15 seer. Covered front and back porches to take in the scenery. The little house has bathroom, bedroom, living room/kitchen combo. 12 minutes from town and less than an hour from three major towns this is the perfect opportunity to live off the land and socially distance and style. Everything you need for a working farm and ranch.' ,`Acres` = '1' ,`Area` = '78' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'AB 43 A SPEAR & IMPROVEMENT' ,`LotDesciption` = 'Other' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '232 - Broaddus' ,`SchoolElementary` = 'BROADDUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BROADDUS HIGH SCHOOL' ,`SchoolMiddle` = 'BROADDUS HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'None' ,`TaxAmount` = '1059' ,`TaxRate` = '1.4992' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804978' WHERE `Matrix_Unique_ID` = '213147136' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T07:51:42.453' ,`MLSNumber` = '76886100' ,`ListAgentFullName` = 'Tiffany Nolan' ,`ListOfficeName` = 'Maddie Lowe Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.907775' ,`Longitude` = '-95.652401' ,`PhotoCount` = '34' ,`PostalCode` = '77095' ,`RoomCount` = '7' ,`ListPrice` = '200000.00' ,`Status` = 'Active' ,`StreetName` = 'Golden Sands' ,`StreetNumber` = '16162' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1116' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Patio home located in Copperfield Northmead Village with spacious backyard and side patio outdoor enjoyment. Mostly brick home with recent exterior paint. Windows are double paned and both sets of sliding doors have been replaced in last 10 years. Interior features include all tile flooring except in 2 bedrooms there is carpet, Wood burning fireplace with wood mantle, primary bathroom with walk in shower, primary bedroom with walk in closet and set of sliding patio doors for access to backyard patio, second set of sliding doors leads to side patio with extended pavers and more. Copperfield amenities including community pools, parks and trails. Close to area schools, shopping and freeways.' ,`Acres` = '0.101' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Mud,Probate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 40 COPPERFIELD NORTHMEAD VLG 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '565' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'FIEST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'LABAY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Copperfield Northmead Village' ,`TaxAmount` = '3642' ,`TaxRate` = '2.3216' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804978' WHERE `Matrix_Unique_ID` = '213158446' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T07:34:13.783' ,`MLSNumber` = '68930974' ,`ListAgentFullName` = 'Dawn Faust' ,`ListOfficeName` = 'Flat Fee Discount Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.114598' ,`Longitude` = '-95.703866' ,`PhotoCount` = '25' ,`PostalCode` = '77355' ,`RoomCount` = '10' ,`ListPrice` = '749900.00' ,`Status` = 'Active' ,`StreetName` = 'Mccall' ,`StreetNumber` = '15202' ,`StreetSuffix` = 'Park' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4160' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New roof 2020, new carpet, whole home water softener, central vacuum.' ,`Acres` = '1' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S694902 - MCCALL SOUND 02, BLOCK 2, LOT 1, ACRES 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '43560' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant,Leave Business Card' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mccall Sound 02' ,`TaxAmount` = '10518' ,`TaxRate` = '1.9215' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664804978' WHERE `Matrix_Unique_ID` = '213162945' --> Updated record success