Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T22:29:15.023' ,`MLSNumber` = '95748281' ,`ListAgentFullName` = 'Lisa Perez' ,`ListOfficeName` = 'Country Pride Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.201357' ,`Longitude` = '-96.269368' ,`PhotoCount` = '18' ,`PostalCode` = '77437' ,`RoomCount` = '2' ,`ListPrice` = '89000.00' ,`Status` = 'Active' ,`StreetName` = 'Main' ,`StreetNumber` = '511' ,`StreetSuffix` = 'Street' ,`City` = 'El Campo' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1046' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming 2 bed home sits on a huge corner lot with room for great entertaining or even build another home, workshop. This one is in a great location close to HEB, other shopping, dining and entertainment. With a little TLC this would be a great home to make your own or great investment opportunity but the beautiful hardwood floors are under the carpet in all rooms, carpet has been opened up for you to see, plumbing all updated in 2021 and electrical was updated a few years ago per seller. Call fast to schedule your private showing.' ,`Acres` = '0.1607' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating,Wall Heater' ,`HOAMandatory` = '0' ,`Legal` = 'LUNDY CENTRAL BLOCK 1 LOT 7' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '198 - El Campo' ,`SchoolElementary` = '' ,`SchoolHigh` = 'EL CAMPO HIGH SCHOOL' ,`SchoolMiddle` = 'EL CAMPO MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lundy Central' ,`TaxAmount` = '1566' ,`TaxRate` = '2.4815' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1939' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618320' WHERE `Matrix_Unique_ID` = '204869296' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T23:26:59.637' ,`MLSNumber` = '87074176' ,`ListAgentFullName` = 'Joyce Adamiak' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.584799' ,`Longitude` = '-95.041050' ,`PhotoCount` = '21' ,`PostalCode` = '77586' ,`RoomCount` = '9' ,`ListPrice` = '1649000.00' ,`Status` = 'Active' ,`StreetName` = 'Island' ,`StreetNumber` = '2910' ,`StreetSuffix` = 'Drive' ,`City` = 'Seabrook' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4059' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SEABROOK ISLAND WATERFRONT~ NEW CONSTRUCTION INSIDE THE GATE ~ HARBOUR CLASSIC CUSTOM HOME TO BE BUILT IN EXCLUSIVE NEIGHBORHOOD OF SEABROOK ISLAND ~ SEE ATTACHED RENDERING AND FLOOR PLAN ~ GREAT OPPORTUNITY TO OWN A HOME IN THIS ONE OF A KIND NEIGHBORHOOD ~' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'HARBOUR CLASSIC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lt 11 Blk 3, Seabrook Island Sec 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '10000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '740' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ED H WHITE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Seabrook Island' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664618321' WHERE `Matrix_Unique_ID` = '205465459' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T23:56:00.067' ,`MLSNumber` = '12670843' ,`ListAgentFullName` = 'Norma Smith' ,`ListOfficeName` = 'SES Real Estate Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.971453' ,`Longitude` = '-95.489476' ,`PhotoCount` = '12' ,`PostalCode` = '77541' ,`RoomCount` = '6' ,`ListPrice` = '180000.00' ,`Status` = 'Active' ,`StreetName` = 'Coker' ,`StreetNumber` = '102' ,`StreetSuffix` = 'Street' ,`City` = 'Jones Creek' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL MANUFACTURER HOME SITTING OVER HALF AN ACRE. HOME FEATURES 3 BEDROOM TWO BATH.\r\nOPEN FLOOR CONCEPT, KITCHEN ISLAND. CONER LOT. COME TAKE A LOOK!' ,`Acres` = '0.6051' ,`Area` = '5' ,`BuilderName` = 'CLAYTON HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Freeport' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'JONES CREEK TERRACE (A0020 S F AUSTIN DIV 17)(JONES CREEK),' ,`LotDesciption` = 'Corner' ,`LotSize` = '26358' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (BRAZOSPORT)' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jones Creek Terrace' ,`TaxAmount` = '496' ,`TaxRate` = '2.5078' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664618321' WHERE `Matrix_Unique_ID` = '205538681' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T22:29:49.983' ,`MLSNumber` = '17640270' ,`ListAgentFullName` = 'Laura Salazar' ,`ListOfficeName` = 'Winhill Advisors - Kirby' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.875454' ,`Longitude` = '-95.284316' ,`PhotoCount` = '41' ,`PostalCode` = '77016' ,`RoomCount` = '13' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Almont' ,`StreetNumber` = '7106' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3090' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this beautiful corner property located in Northwood Manor Subdivision nestled adjacent to Trotter Park! Built on two lots, nearly half an acre, this stunning home features 5 bedrooms, 3 full baths, a gorgeous & HUGE family room with vaulted ceiling that’s open to the dining, kitchen, wet bar and breakfast areas! Oh and you have to see the primary bath—adorn yourself in this very elegant & luxurious spa-like bathroom! AND if that’s not enough—this home ALSO has a LARGE additional room that can be used to your heart’s desires! Such as entertaining, a home office, hobby room, home daycare, salon or even pet grooming! There is also a huge storage building (23 x 18) in the back yard! Did not flood with Harvey. This unique property offers possibilities galore! Make your offer today!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 221, 222 BLK 6 NORTHWOOD MANOR SEC 8' ,`LotDesciption` = 'Corner,Greenbelt,Subdivision Lot' ,`LotSize` = '18984' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MARSHALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Lockbox Back,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Northwood Manor Sec 08' ,`TaxAmount` = '7035' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618321' WHERE `Matrix_Unique_ID` = '208295419' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T22:24:59.467' ,`MLSNumber` = '38537623' ,`ListAgentFullName` = 'Lisa Perez' ,`ListOfficeName` = 'Country Pride Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.777083' ,`Longitude` = '-96.167923' ,`PhotoCount` = '49' ,`PostalCode` = '77474' ,`RoomCount` = '3' ,`ListPrice` = '435000.00' ,`Status` = 'Active' ,`StreetName` = 'Westview' ,`StreetNumber` = '217' ,`StreetSuffix` = 'Drive' ,`City` = 'Sealy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2935' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This unique 3 bedrooms (two masters) 3 full bath home has beautiful high vaulted ceiling in living room, gorgeous wood look flooring. The updated kitchen has beautiful beveled edged granite countertops and tile backsplash, loads of cabinet space, breakfast bar as well as a nice pantry. The main master en-suite features a huge walk-in closet big enough to be another bedroom with a wall of shelving as well as hanging space, large vanity area, a soaker tub/shower combo and a full jacuzzi room all in the master suite! Bed 2 is a second master with a full size bath with stand up shower and ton of storage. The guest bath boasts a large vanity space, a huge soaker tub/shower combo and plenty of storage as well. The fully fenced backyard has a storage building that will stay and don\'t forget to check out the large covered back patio area, great for entertaining or just relaxing. Home is close to schools, shopping and app. 3 minutes from I-10. Call to schedule your showing fast!' ,`Acres` = '0.294' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WESTVIEW ADDN LOT 78' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '12807' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '109 - Sealy' ,`SchoolElementary` = 'SELMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEALY HIGH SCHOOL' ,`SchoolMiddle` = 'SEALY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westview Add' ,`TaxAmount` = '4450' ,`TaxRate` = '2.149' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618321' WHERE `Matrix_Unique_ID` = '209045292' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T22:07:05.263' ,`MLSNumber` = '37201889' ,`ListAgentFullName` = 'Kaila Yuille' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.802879' ,`Longitude` = '-95.421425' ,`PhotoCount` = '36' ,`PostalCode` = '77008' ,`RoomCount` = '7' ,`ListPrice` = '438000.00' ,`Status` = 'Active' ,`StreetName` = '19th' ,`StreetNumber` = '1225' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2164' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in this beautiful and spacious free standing 3 bed/3.5 bath home in a gated community in the Heart of Shady Acres! Open concept kitchen and living area with high ceilings, natural light and 8 foot doors throughout. Kitchen with large island and quality granite countertops, SS appliances and tile backsplash. Large primary bedroom and en suite with 2 closets, walk in shower and large soaking tub. Private backyard with green space for pets, added on patio perfect for outdoor dining and entertaining. Blocks away from several neighborhood friendly restaurants, patio/pet friendly bars, walking/biking trails and the Heights HEB!' ,`Acres` = '0.0439' ,`Area` = '9' ,`BuilderName` = 'Drake Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 1 LANDING AT NINETEENTH AMEND & EXTN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1911' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '495' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Landing at 19th' ,`TaxAmount` = '9215' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618321' WHERE `Matrix_Unique_ID` = '209301584' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T22:33:15.527' ,`MLSNumber` = '71940104' ,`ListAgentFullName` = 'Susan Buffamante' ,`ListOfficeName` = 'Fast Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.029592' ,`Longitude` = '-95.502240' ,`PhotoCount` = '50' ,`PostalCode` = '77379' ,`RoomCount` = '13' ,`ListPrice` = '559000.00' ,`Status` = 'Active' ,`StreetName` = 'Layton Meadows' ,`StreetNumber` = '5802' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3778' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Look no more! You found it! Your breathtaking custom-built paradise! Gorgeous house to make your amazing Dream home come true! Corner lot, Water Softener throughout with house. Beautifully landscape with a variety of plants specimens for your delate and sight recreation as you drive in. This huge yet cozy house offers more than just lots of space. This immaculate two-story home in Terranova West was designed to bring specific combinations of rocks, bricks, stucco, wood, to enhance the architecture that will keep you delating its unique beauty for many & many years! Lots of space and room for everything! Huge master and master bath, guest suite complete with its own full bath, formals, family room, a not only functional can accomodate 6 stools Breakfast bar, kitchen w/ granite countertops, 52\" cabinets, All New GE Stainless Steel Appliances, dishwasher double oven, gas cooktop, refrigerator, washer & dryer. Master Bath 2 Vanities, Home deep cleaned.\r\n Klein ISD! Qualified Buyers Only!' ,`Acres` = '0.1877' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 1 TERRAVISTA SEC 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '8177' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '880' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BENFER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'STRACK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Craftsman' ,`Subdivision` = 'Terravista Sec 01' ,`TaxAmount` = '9275' ,`TaxRate` = '2.7066' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1664618321' WHERE `Matrix_Unique_ID` = '209450558' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T23:40:41.687' ,`MLSNumber` = '50809446' ,`ListAgentFullName` = 'Shayna Andrews' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.789273' ,`Longitude` = '-95.462193' ,`PhotoCount` = '40' ,`PostalCode` = '77055' ,`RoomCount` = '8' ,`ListPrice` = '1150000.00' ,`Status` = 'Active' ,`StreetName` = 'Mosaico' ,`StreetNumber` = '1168' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3791' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Better than new construction and truly move-in-ready! Spectacular gated community at the end of a cul-de-sac right around the corner from The Awty International School and zoned to Memorial High School. Ravenna offers the best of the lock-and-leave lifestyle. Corner lot home has a multitude of windows on three sides providing abundant natural light. Rare guest parking on the street right in front of the home is an added bonus. First floor bedroom doubles as a home office and has its own separate entrance, perfect for working from home. Miele stainless steel appliances including a 48” built-in refrigerator/freezer, under counter wine chiller, and even a warming drawer. Window treatments include custom Ethan Allen drapery in Living Room and Hunter Douglas blinds in Bedrooms, Dining Room, Kitchen, and Game Room, and an elevator with access to all four floors. Designer light fixtures, chandeliers, and gorgeous stair runners complete the aesthetic of this stunning gem of a home.' ,`Acres` = '0.0501' ,`Area` = '24' ,`BuilderName` = '' ,`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,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 65 BLK 1 RAVENNA' ,`LotDesciption` = 'Patio Lot,Subdivision Lot' ,`LotSize` = '2184' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3447' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HOUSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '4' ,`Style` = 'Mediterranean,Traditional' ,`Subdivision` = 'Ravenna' ,`TaxAmount` = '21328' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618322' WHERE `Matrix_Unique_ID` = '209629862' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T22:34:03.510' ,`MLSNumber` = '20128833' ,`ListAgentFullName` = 'Mari Lasewicz' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.075569' ,`Longitude` = '-95.196430' ,`PhotoCount` = '24' ,`PostalCode` = '77339' ,`RoomCount` = '9' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Beaver Glen' ,`StreetNumber` = '3126' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2101' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Sorry no showings until Sunday October 2nd. Gorgeous 4 bedroom, 2 and 1/2 Bath. Master down Crown Molding throughout home. Hardwood floors, Surround sound wiring inside and out. Outdoor kitchen and Covered patio. Pool and Hot tub. One of the bedrooms is currently set up as a workout/yoga room and another bedroom has been converted into a soundproof movie room. So many extras. Must see.' ,`Acres` = '0.1708' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 10 ELM GROVE VILLAGE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7442' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '485' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'ELM GROVE ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Elm Grove Village Sec 02' ,`TaxAmount` = '5463' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618322' WHERE `Matrix_Unique_ID` = '210370413' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T22:30:06.377' ,`MLSNumber` = '55524811' ,`ListAgentFullName` = 'Rosa Martinez' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.650331' ,`Longitude` = '-95.240743' ,`PhotoCount` = '18' ,`PostalCode` = '77034' ,`RoomCount` = '7' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Globe' ,`StreetNumber` = '1131' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1594' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ready move-in completely remodeled call your Realtor today!' ,`Acres` = '0.1566' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 14 BLK 18 FREEWAY MANOR SEC 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6820' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'MATTHYS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SOUTH HOUSTON HIGH SCHOOL' ,`SchoolMiddle` = 'SOUTHHOUSTON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Freeway Manor Sec 02' ,`TaxAmount` = '3319' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1953' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618322' WHERE `Matrix_Unique_ID` = '210584303' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T22:10:53.753' ,`MLSNumber` = '67858930' ,`ListAgentFullName` = 'Priscilla Lopez-Garcia' ,`ListOfficeName` = 'Prime Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.792439' ,`Longitude` = '-95.434702' ,`PhotoCount` = '27' ,`PostalCode` = '77008' ,`RoomCount` = '7' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Timbergrove Heights' ,`StreetNumber` = '3331' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1985' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful freestanding home in the charming, cozy gated community of Timbergrove Heights. The second floor living area boasts soaring 12-ft ceilings, crown moulding, bluetooth surround sound, and epic 10-ft glass sliding trifold doors that open out from your living room to oversized balcony with gas/water hookup. The kitchen features SS Bosch appliances, prep-island, double trash-bin, and custom high quality soft close pull-out drawers. The spacious primary suite holds three walk in closets and leads into a 5 star spa- like bathroom. Equal distribution wifi installed on every level. Hardwood floors, 2- car garage, custom window shades included, upgraded fixtures included, fully wired smart home, washer/dryer included... truly a must see! Come be a part of the Heights boom! Home has gated front yard. Jaycee park is only a 5 min walk away w/ basketball/tennis courts, walking trails, playground.' ,`Acres` = '0.0347' ,`Area` = '9' ,`BuilderName` = 'InTown Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Timbergrove/Lazybrook' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 4 TIMBERGROVE HEIGHTS' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '1512' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,Lockbox Right Side,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,French,Traditional' ,`Subdivision` = 'Timbergrove Heights' ,`TaxAmount` = '10407' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618322' WHERE `Matrix_Unique_ID` = '210855589' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T22:59:13.607' ,`MLSNumber` = '81487300' ,`ListAgentFullName` = 'Danny Lazo' ,`ListOfficeName` = 'Lazo Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.153788' ,`Longitude` = '-95.470899' ,`PhotoCount` = '21' ,`PostalCode` = '77515' ,`RoomCount` = '6' ,`ListPrice` = '464900.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Forrest' ,`StreetNumber` = '201' ,`StreetSuffix` = 'Drive' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2560' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous home Fully renovated!!!! Splendid double doors entry that leads you into amazing home !!! Gourmet brand new kitchen with quartz countertops, upgraded modern cabinets, stainless steel appliances, freestanding oven and micro. New AC system. Huge Living room with high ceilings open to the kitchen, cam lights, gas log fireplace with wood mantel and built-ins cabinets. Large formal dining room with plenty of windows. New floors all through the house, include wood/vinyl flooring, porcelain and carpet for bedrooms. House sits in the middle of the most beautiful and quiet acreage of the area. Sprinkler system. Detached garage/shop area and well pump house adds approximate 800 sq ft. for storage. Full serviced generator package and 500 gal propane tank system. Come view this peaceful 3.13 acres home !!!! 10min from Lake Jackson.' ,`Acres` = '3.13' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'OAKWOOD CREEK ESTATES SEC 1 (A0129 C SMITH) LOT 36 ACRES 3.1' ,`LotDesciption` = 'Cleared,Greenbelt,Wooded' ,`LotSize` = '136343' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven,Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'WESTSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oakwood Creek Estates Sec 1' ,`TaxAmount` = '5180' ,`TaxRate` = '1.9464' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618322' WHERE `Matrix_Unique_ID` = '211286741' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T22:24:40.263' ,`MLSNumber` = '70276553' ,`ListAgentFullName` = 'Rosa Martinez' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.684567' ,`Longitude` = '-95.287429' ,`PhotoCount` = '17' ,`PostalCode` = '77087' ,`RoomCount` = '6' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Edna' ,`StreetNumber` = '7653' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '906' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.18' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 21 BLK 2 SANTA ROSA SEC 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7842' ,`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` = 'CORNELIUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HARTMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Rosa Sec 01' ,`TaxAmount` = '3074' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1944' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618322' WHERE `Matrix_Unique_ID` = '211392718' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T22:31:18.027' ,`MLSNumber` = '66366237' ,`ListAgentFullName` = 'Shirley Kopecky' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.800229' ,`Longitude` = '-95.465053' ,`PhotoCount` = '40' ,`PostalCode` = '77055' ,`RoomCount` = '12' ,`ListPrice` = '625000.00' ,`Status` = 'Active' ,`StreetName` = 'Teluco' ,`StreetNumber` = '6509' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2611' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come & See this lovely 3000 sq ft + property near I-10, Loop 610, & Hwy 290 & outside 100 & 500 yr flood plains! High lot value; Aug. 2015 appraisal = $606k when lot value = $200k (NOT $400k-$450k, like now/recently) & before MANY added improvements! Home is extensively updated & features real hardwood floors, crown molding + an oversized 2 car garage with an upscale apartment/quarters; home boasts a 2 story great room with a dramatic ceiling! Main bedroom has a large, real wood custom closet with built-ins & nearly pristine, never lived-on lux carpet! Two (of 4) bedrooms & bathrooms are downstairs! The large office/library can double as: wine or media room, 2nd eating area. Kitchen has gently used Viking gas range. 3 Recent HVAC units with sanitizing UV lights. See virtual tour of garage apt.; floor plans in MLS documents.\r\nGarage & garage apt. were constructed in 1999; home further enlarged in 2003.\r\nNew construction in subdivision = $1 Million+\r\nNo more showings until Sun. 10/02/22' ,`Acres` = '0.1865' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 23 WESTVIEW TERRACE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8125' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '10' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HOUSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Westview Terrace Sec 02' ,`TaxAmount` = '8956' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1949' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618323' WHERE `Matrix_Unique_ID` = '211498410' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T22:26:04.877' ,`MLSNumber` = '86076703' ,`ListAgentFullName` = 'Silvia Roberson' ,`ListOfficeName` = 'American Property Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.631070' ,`Longitude` = '-95.270514' ,`PhotoCount` = '25' ,`PostalCode` = '77075' ,`RoomCount` = '8' ,`ListPrice` = '390000.00' ,`Status` = 'Active' ,`StreetName` = 'BOTANY' ,`StreetNumber` = '8331' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2590' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Look at this charm! Beautiful in and out! Drive up to this New Construction Brick Home built June 2022.\r\nYou have to see this open concept layout. And walk into this beautiful spacious kitchen with custom made cabinets,\r\nhuge island all with beautiful quartz countertops. All stainless-steel appliances. Walk in pantry.\r\nOpens to dining room and living room for all your family gathering. Master shower with beautiful tiles and flooring.\r\nDouble sink for extra space, and a huge walk-in closet.\r\nUtility room inside for those cold days. All newly built wooded fence for a little privacy. Near Hobby Airport.\r\nThis 4-bedroom 3 full bathroom home is the one to call home!\r\nThis gem won\'t last. Schedule your showing today.' ,`Acres` = '0.1876' ,`Area` = '3' ,`BuilderName` = 'E&M LANDAVERDE\'S' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 37, BLOCK 61, HOUSTON\'S SKYSCRAPER SHADOWS SECTION 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8174' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DEANDA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'HOUSTON\'S SKYSCRAPER SHADOWS' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664618323' WHERE `Matrix_Unique_ID` = '211520214' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T23:14:07.647' ,`MLSNumber` = '22148175' ,`ListAgentFullName` = 'Orpha Palomares' ,`ListOfficeName` = 'Orpha Ruth Palomares Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.804755' ,`Longitude` = '-95.491329' ,`PhotoCount` = '20' ,`PostalCode` = '77055' ,`RoomCount` = '4' ,`ListPrice` = '349999.00' ,`Status` = 'Active' ,`StreetName` = 'Huge Oaks' ,`StreetNumber` = '1837' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1885' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1552' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 80 BLK 7 GLENVIEW SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6760' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'RIDGECREST ELEMENTARY SCHOOL (SPRING BRANCH)' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Glenview Sec 02' ,`TaxAmount` = '5742' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618323' WHERE `Matrix_Unique_ID` = '211764278' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T23:18:31.580' ,`MLSNumber` = '48492897' ,`ListAgentFullName` = 'Evelyn Black' ,`ListOfficeName` = 'Simien Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.516899' ,`Longitude` = '-95.016930' ,`PhotoCount` = '29' ,`PostalCode` = '77573' ,`RoomCount` = '11' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Hermosa Arroyo' ,`StreetNumber` = '4604' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2658' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning Taylor Morrison Home has it all! From Solar Panels, to beautiful landscaping and irrigation in the front and backyard, to a shaded, covered patio with a built-in grill, this home is a must see! It is located in the private, gated Verandas of Mar Bella in beautiful League City! It features gorgeous hard-wood flooring, granite counters, custom cabinets, 2 walk-in pantries, and 2 fireplaces! Perfect for entertaining or escape into your Master Retreat with its must see, elegant double-sided fireplace, highlighting a private Sun Room/Bonus Room! The Master Bath features a garden tub, separate walk-in shower, dual vanities, and a spacious custom walk-in closet! This amazing home is also equipped with two full sections of Solar Panels! Schedule your showing today! LA related to Seller. Room sizes to be verified by Buyer.' ,`Acres` = '0.1576' ,`Area` = '33' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MAR BELLA SEC 11 (2011) ABST 32, BLOCK 2, LOT 12, ACRES 0.16' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot' ,`LotSize` = '6863' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2165' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'SANDRA MOSSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,No Photos/No Videos,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mar Bella' ,`TaxAmount` = '10376' ,`TaxRate` = '2.7997' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618323' WHERE `Matrix_Unique_ID` = '211823386' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T23:08:18.383' ,`MLSNumber` = '49987368' ,`ListAgentFullName` = 'Rainy Rawls' ,`ListOfficeName` = 'Century 21 Realty Partners' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.946245' ,`Longitude` = '-95.143831' ,`PhotoCount` = '35' ,`PostalCode` = '77532' ,`RoomCount` = '8' ,`ListPrice` = '239000.00' ,`Status` = 'Active' ,`StreetName` = 'Canyon Cove' ,`StreetNumber` = '18406' ,`StreetSuffix` = 'Drive' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1613' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perfect home for a first-time buyer or Vacation home. This 3 bedroom, 2 bath Fully fenced backyard, storage shed, and covered screened in patio has plenty of back and side yard space! The interior plan offers a spacious family room w/ adjacent dining area, fireplace, western style kitchen w/ breakfast bar, utility in-home at garage entry, and a split bedroom plan with good-sized rooms. The location is quiet and relaxing and blocks away from the lake. \r\nCome and see a one of a kind home in Lake Shadows that has great access to Lake Houston. Close to FM 1960 with dining and shopping, IAH, and Sam Houston Toll. This is the home for you, don\'t loose the opportunity, come see it today!' ,`Acres` = '0.2571' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 6 LAKE SHADOWS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '50' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'NEWPORT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Shadows Sec 01' ,`TaxAmount` = '4493' ,`TaxRate` = '2.6843' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618323' WHERE `Matrix_Unique_ID` = '211858810' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T22:25:17.063' ,`MLSNumber` = '32466168' ,`ListAgentFullName` = 'Diana Rodriguez' ,`ListOfficeName` = 'Ruth Longoria, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.619685' ,`Longitude` = '-95.274841' ,`PhotoCount` = '21' ,`PostalCode` = '77075' ,`RoomCount` = '7' ,`ListPrice` = '340000.00' ,`Status` = 'Active' ,`StreetName` = 'Swiftwater' ,`StreetNumber` = '8130' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = 'Diosdado' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 1 Block 1 Houston Skyscraper Shadow Partial Replat No. 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DEANDA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Houston Skyscrpaer Shadow' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618323' WHERE `Matrix_Unique_ID` = '211858990' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T22:23:04.963' ,`MLSNumber` = '17448893' ,`ListAgentFullName` = 'Zach Richmond' ,`ListOfficeName` = 'Richmond Realty Group' ,`SellingAgentFullName` = 'Nora Mellet' ,`SellingOfficeName` = 'RE/ImageProperties and Investm' ,`Latitude` = '30.006725' ,`Longitude` = '-95.760066' ,`PhotoCount` = '23' ,`PostalCode` = '77433' ,`RoomCount` = '11' ,`ListPrice` = '350000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Mulberry Field' ,`StreetNumber` = '21710' ,`StreetSuffix` = 'Circle' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2216' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful opportunity to own a beautifully updated, well-maintained one-story home located in desirable Fairfield Village that is just minutes from Salyards Middle School, Premium Outlet Mall, Grand Parkway, and fine shopping and dining! A large dining room with crown molding located right off the kitchen is perfect for entertaining. Kitchen has nice granite counter tops, gas range with abundant cabinetry & counter space. With a nice open concept there is seamless movement from the kitchen into the breakfast nook with ample natural light that flows into the living room with a gas fireplace that creates a cozy & inviting ambiance. Huge primary suite has dual vanities, soaking tub with separate walk-in frameless shower & a nice-size closet. Two secondary bedrooms are split from the master offering maximum privacy equipped with a full bath. Enjoy the oversized covered patio in the backyard with enough room for children & pets to run and play. MOTIVATED SELLER' ,`Acres` = '0.1666' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 1 FAIRFIELD VILLAGE SOUTH SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7255' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'SWENKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairfield Village South Sec 03' ,`TaxAmount` = '7349' ,`TaxRate` = '2.746' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618324' WHERE `Matrix_Unique_ID` = '211945068' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T23:39:44.573' ,`MLSNumber` = '58483014' ,`ListAgentFullName` = 'Scarlet Brents' ,`ListOfficeName` = 'Scarlet Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.403275' ,`Longitude` = '-95.052153' ,`PhotoCount` = '28' ,`PostalCode` = '77568' ,`RoomCount` = '10' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Narrow Cove' ,`StreetNumber` = '12721' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2731' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FORMER MODEL HOME with all the bells & whistles! Gorgeous kitchen features huge 10X6 island that\'s perfect for entertaining, stainless steel appliances, metal back splash with built in ports for lighting, and neat dog nook/playhouse under stairs! Kitchen opens to living/dining area with inviting fireplace for those cozy winter nights! Other features include nice study with glass french doors, spacious primary bedroom on first floor with ceiling detail and lighting for relaxing ambience, large primary bathroom with tub & separate shower with bench seat & big closet. Pretty rod iron rails lead to upstairs gameroom and 3 bedrooms, Jack & Jill suite, and 4th bedroom with its own bathroom. Exterior includes nicely landscaped front yard with covered patio in the front & covered back patio with surround sound along with rest of the home! Subdivision features the largest 12-acre crystal clear lagoon in Texas with a white-sand beach and beach boardwalk! Easy commute to Galveston or Houston!' ,`Acres` = '0.1401' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAGO MAR POD 7 SEC 1 (2017) ABST 11, BLOCK 2, LOT 10, ACRES' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6103' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1330' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Lago Mar Pod 7 Sec 1' ,`TaxAmount` = '12621' ,`TaxRate` = '3.5512' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618324' WHERE `Matrix_Unique_ID` = '212204318' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T22:05:29.603' ,`MLSNumber` = '55660412' ,`ListAgentFullName` = 'Angela Elliott' ,`ListOfficeName` = 'RE/MAX All Stars' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.936853' ,`Longitude` = '-95.699426' ,`PhotoCount` = '49' ,`PostalCode` = '77433' ,`RoomCount` = '13' ,`ListPrice` = '915000.00' ,`Status` = 'Active' ,`StreetName` = 'Timberlake Glen' ,`StreetNumber` = '19518' ,`StreetSuffix` = 'Trail' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4457' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Why buy new when you can own this immaculate home in sought after Towne Lake? This home has ALL of the BELLS & WHISTLES! Enter to beautiful wood floors with soaring ceilings complemented by a beautiful spiral staircase. Make memories in the family room that\'s offers 19 foot ceilings that opens to a large gourmet kitchen with an oversized island, to entertain all of your guest needs. There\'s also a second bedroom downstairs with en suite bath. Step into your backyard oasis through the sliding doors to a beautiful pool/spa & outdoor kitchen that meets all of your culinary desires. So many features, please refer to upgrade list. Community offers top rated onsite elementary & middle school, resort-style waterpark with lazy river, pools, private island, parks & play grounds, tennis courts, fitness centers, hike & bike trails, community garden and onsite restaurants & shopping. All of this along with monthly resident activities make Towne Lake\'s lifestyle like no other! Hwy 99, 290 & I-10' ,`Acres` = '0.2693' ,`Area` = '25' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 2 TOWNE LAKE SEC 35' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '11730' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1699' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'RENNELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Towne Lake Sec 35' ,`TaxAmount` = '19285' ,`TaxRate` = '3.471' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618324' WHERE `Matrix_Unique_ID` = '212224930' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T23:16:46.407' ,`MLSNumber` = '36173744' ,`ListAgentFullName` = 'Kathryn Robinson' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = 'Jasmine Gonzalez' ,`SellingOfficeName` = 'CB&A, Realtors' ,`Latitude` = '29.810440' ,`Longitude` = '-95.397182' ,`PhotoCount` = '42' ,`PostalCode` = '77008' ,`RoomCount` = '8' ,`ListPrice` = '670000.00' ,`Status` = 'Option Pending' ,`StreetName` = '26th' ,`StreetNumber` = '204' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2232' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'French Quarter patio home by Distinctive Living. This home has ornate iron double gallery\r\nporches done to accurate Creole design on a mature tree lined street. Antique hardwood flooring\r\nand Italian Marble throughout. Commercial-grade SS appliances. Kitchen has floor to 10 ceiling\r\ncabinetry open to large den. New Orleans imported Antique butcher block island top. The master\r\nsuite has coffered ceilings that includes two closets. Ornate wainscoting in the entrance of\r\nthe house. Beautiful builtins in the formal dining room & living room. Easily maintained pet\r\nturf in the backyard. Newly repainted porches, front exterior, and several of the bedrooms. Wood floors are newly refinished on the first floor as well!\r\nWalking distance to Johnny Goldbrick, Tenfold coffee, F45 Greater Heights, Relic general store,\r\nAngelas oven and so much more!' ,`Acres` = '0.0689' ,`Area` = '9' ,`BuilderName` = 'Distinctive Living' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 36 SUNSET HEIGHTS' ,`LotDesciption` = 'Cleared' ,`LotSize` = '3000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HELMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'French,Victorian' ,`Subdivision` = 'Sunset Heights Add' ,`TaxAmount` = '12267' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618324' WHERE `Matrix_Unique_ID` = '212238915' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T23:18:10.023' ,`MLSNumber` = '90346703' ,`ListAgentFullName` = 'Xiaoming Shao' ,`ListOfficeName` = '31 Realty' ,`SellingAgentFullName` = 'Norma Oliver' ,`SellingOfficeName` = 'C.R.Realty' ,`Latitude` = '29.828428' ,`Longitude` = '-95.805741' ,`PhotoCount` = '32' ,`PostalCode` = '77493' ,`RoomCount` = '3' ,`ListPrice` = '315000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Pavarotti' ,`StreetNumber` = '24930' ,`StreetSuffix` = 'Place' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2188' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2-story house with 3 Bedrooms and 2.5 Baths. Kitchen with Island open to Family Room, Formal Dining. Master bedroom is at downstairs and Game room is at upstairs. Separate Master Bath Tub and Shower. 2 “ faux wood blinds. Good school district at Katy ISD! Gas Range. Convenient location, easy access to highway, close to shopping and restaurants.' ,`Acres` = '0.1188' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 37 BLK 2 CAMILLO LAKES SEC 2' ,`LotDesciption` = 'Other' ,`LotSize` = '5175' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'LEONARD ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Camillo Lakes Sec 2' ,`TaxAmount` = '8051' ,`TaxRate` = '3.5333' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618324' WHERE `Matrix_Unique_ID` = '212240292' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T23:22:29.853' ,`MLSNumber` = '79039205' ,`ListAgentFullName` = 'Nick Corkill' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Bradley Page' ,`SellingOfficeName` = 'Whitaker Realty, LLC' ,`Latitude` = '29.528220' ,`Longitude` = '-95.192265' ,`PhotoCount` = '37' ,`PostalCode` = '77546' ,`RoomCount` = '8' ,`ListPrice` = '379000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Whittier' ,`StreetNumber` = '9' ,`StreetSuffix` = 'Drive' ,`City` = 'Friendswood' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2063' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Adorable 3/2.1/2+ workshop with sink, 1 story in the heart of Friendswood on .39 acre cul de sac street lot! This home is a charmer & won\'t last long! Roof 2016, AC 2022, some interior paint 2022*Freshly landscaped*Many updates throughout: Kitchen & baths*Covered front & back patios*Wow your guests the moment they walk in the door, formal dining/study to your right, grand living room to your left, with gas fireplace & windows overlooking the front yard*Bar area separating living room & breakfast room*Breakfast room flows into the kitchen & formal dining/study*Kitchen complete with apron sink, stunning countertops & cabinetry*Stainless steel appliances & window overlooking driveway & side yard*Primary suite complete with two closets, doors overlooking back patio & stunning primary bath*Primary bath complete with Texas-sized walk in shower, double sinks & natural lighting*2 large additional bedrooms & bathroom just off the living room*1/2 bath & laundry/mud room*No HOA, low taxes & FISD!' ,`Acres` = '0.3982' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 151 PAGE 5 LOT 58 QUAKERS LANDING' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '17347' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'WESTWOOD ELEMENTARY SCHOOL (FRIENDSWOOD)' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Quakers Landing' ,`TaxAmount` = '6086' ,`TaxRate` = '2.2832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618325' WHERE `Matrix_Unique_ID` = '212258620' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T22:06:00.850' ,`MLSNumber` = '52968898' ,`ListAgentFullName` = 'Jeremy Alvarado' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.722796' ,`Longitude` = '-95.585924' ,`PhotoCount` = '50' ,`PostalCode` = '77082' ,`RoomCount` = '12' ,`ListPrice` = '1175000.00' ,`Status` = 'Active' ,`StreetName` = 'Legend Manor' ,`StreetNumber` = '11807' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4571' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spectacular brick and stone home situated on the 11th fairway within the 24/7 guard-gated Royal Oaks Country Club community. The 2-story foyer commands attention before flowing into the formal living and dining. Gourmet kitchen with professional appliances and large island opens to the breakfast and family room with panoramic golf course views through tall windows. Serene primary suite spoiled with golf course views, spa-like ensuite and enormous walk-in closet with custom built-ins. Upstairs boast a game room featuring a wetbar stocked with wine cooler and ice-maker with access to balcony overlooking the golf course, and a flex room- makes for a perfect theatre/study or bedroom. This home has been elevated with freshly updated kitchen, new paint and carpet throughout. Outside welcomes you with a relaxing covered patio and plenty of green space for a custom pool while engulfing the amazing views of the 11th fairway.' ,`Acres` = '0.2466' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Westchase Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 2 ROYAL OAKS COUNTRY CLUB SEC 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10740' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3130' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'OUTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'O\'DONNELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Royal Oaks Country Club Sec 10' ,`TaxAmount` = '23451' ,`TaxRate` = '2.6086' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664618325' WHERE `Matrix_Unique_ID` = '212267294' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T22:14:05.100' ,`MLSNumber` = '30744560' ,`ListAgentFullName` = 'Samantha Plomer' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.691137' ,`Longitude` = '-95.831953' ,`PhotoCount` = '50' ,`PostalCode` = '77406' ,`RoomCount` = '11' ,`ListPrice` = '420000.00' ,`Status` = 'Active' ,`StreetName` = 'Christen Canyon' ,`StreetNumber` = '26214' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2525' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! This gorgeous 2-story brick home in Westheimer Lakes is located on a premium, waterfront, cul-de-sac lot. The oversized primary bedroom features dual walk-in closets, a spa inspired ensuite bath, and is privately located downstairs. A gourmet kitchen featuring 42\' white cabinets, stainless steel appliances, and large granite island is open to a very spacious living room with water views and lots of natural light through out. This open floor plan also has 2 car garage, large patio space, and tankless hot water heater. Downstairs has wood-like tile throughout and updated grey paint. Upstairs you\'ll find a large game room, full size bathroom with double sinks, and 3 additional bedrooms with walk-in closets. Home is zoned to highly rated schools with lots of neighborhood amenities. With a thoughtful floor plan and upgrades throughout this gem is not to be missed! Schedule your private showing today.' ,`Acres` = '0.1462' ,`Area` = '37' ,`BuilderName` = 'Plantation Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CANYON VILLAGE AT WESTHEIMER LAKES SEC 2, BLOCK 2, LOT 13' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '6367' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '815' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Village At Westheimer Lakes Sec 2' ,`TaxAmount` = '6547' ,`TaxRate` = '2.5248' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618325' WHERE `Matrix_Unique_ID` = '212280441' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T22:13:41.933' ,`MLSNumber` = '53405335' ,`ListAgentFullName` = 'Sonya Patterson' ,`ListOfficeName` = 'Connect Realty' ,`SellingAgentFullName` = 'Michael Seder' ,`SellingOfficeName` = 'RE/MAX The Woodlands & Spring' ,`Latitude` = '30.144129' ,`Longitude` = '-95.460126' ,`PhotoCount` = '3' ,`PostalCode` = '77380' ,`RoomCount` = '7' ,`ListPrice` = '575000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Crinkleroot' ,`StreetNumber` = '17' ,`StreetSuffix` = '' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3332' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home is a nestled on a quiet street located on 9th hole of The Tournament Course at the front of Woodlands. It\'s a golfer\'s dream. It is located on the middle of the 9th fairway. It has a view of the Clubhouse, pond located between 9 green and 1 tee with a spectacular evening view of the sunset. Easy access to I-45, shopping, restaurants and so much more. Home will be sold AS IS. Room sizes will need to be verified.' ,`Acres` = '0.2437' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL GROGANS ML 19, LOT 8' ,`LotDesciption` = 'On Golf Course' ,`LotSize` = '10615' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric 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,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Grogans Ml 19' ,`TaxAmount` = '10153' ,`TaxRate` = '2.0079' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618325' WHERE `Matrix_Unique_ID` = '212350880' --> 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','212363753','1664618325','212363753','2022-09-30T22:34:26.770','67194618','Kimberly Bush','CB&A, Realtors-Katy','','','29.747181','-95.786549','27','77494','9','427000.00','Active','Winding Run','2703','Lane','Katy','2','0','4','2319','Single-Family','Beautiful 1 story home on a corner, cul-de-sac lot. Wait until you see this backyard! Sparkling pool/spa, tons of pool decking for all of your outdoor entertaining, but also has plenty of yard for your fur babies! This spectacular home features 4 bedrooms (or 3 bedrooms plus an office), 2 full bathrooms and a large island kitchen with granite counters, stainless steel appliances and tons of cabinet space. Gorgeous wood flooring in the primary bedroom, dining room and secondary bedrooms. En-suite primary bathroom features separate vanities, each with their own sink, granite counters, freshly painted cabinets, decorative mirrors, linen closet and a large walk-in closet. Large 2 car garage with attached porte cochere helps protect your vehicles from the elements. Front yard has gorgeous mature trees to provide shade on those hot summer days. Call today to schedule a private viewing. This home won\'t last long!','0.2346','36','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Katy - Southwest','Central Gas','1','FALCON RANCH SEC 1, BLOCK 1, LOT 27','Corner,Cul-De-Sac,Subdivision Lot','10217','Appraisal District','','695','0','','2','Convection Oven,Electric Oven,Single Oven','1','In Ground','','Gas Cooktop','','Composition','30 - Katy','RYLANDER ELEMENTARY SCHOOL','CINCO RANCH HIGH SCHOOL','CINCO RANCH JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Falcon Ranch','8998','2.9495','Water District','2001','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T23:30:17.177' ,`MLSNumber` = '77674506' ,`ListAgentFullName` = 'Tina Manno' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = 'Krista DiPuma' ,`SellingOfficeName` = 'UTR TEXAS, REALTORS' ,`Latitude` = '29.475989' ,`Longitude` = '-95.090392' ,`PhotoCount` = '36' ,`PostalCode` = '77573' ,`RoomCount` = '7' ,`ListPrice` = '395000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Mesa Verde' ,`StreetNumber` = '2635' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2408' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**OFFER ACCEPTED**GET READY TO MOVE INTO THIS 1 STORY, 4 BEDROOM HOME ON A CUL-DE-SAC IN BEAUTIFUL VICTORY LAKES! THIS HOMES\' KITCHEN FEATURES GE PROFILE STAINLESS APPLIANCES WITH CONVECTION OVEN AND WALK-IN PANTRY. PLANTATION SHUTTERS THROUGHOUT HOME, CROWN MOLDING THROUGHOUT, AND AMBIENT LIGHTING IN FORMAL DINING AND LIVING ROOMS. EN-SUITE PRIMARY BATH WITH DUAL VANITIES, WALK-IN CLOSETS AND JETTED TUB. LARGE OPEN FAMILY ROOM WITH WINDOW VIEWS OF LAKE. ENJOY THE RELAXING VIEW FROM YOUR COVERED BACK PATIO. ROOM DIMENSIONS ARE APPROXIMATE, BUYER TO VERIFY ALL DIMENSIONS, HOA, SCHOOLS AND TAXES. DON\'T MISS THIS ONE!' ,`Acres` = '0.1964' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'VICTORY LAKES SEC 1 (2001), ABST 3 S F AUSTIN SUR, BLOCK 6,' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8554' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'RALPH PARR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'VICTORYLAKES INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Victory Lakes Sec 1 2001' ,`TaxAmount` = '6152' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618325' WHERE `Matrix_Unique_ID` = '212406146' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T22:22:22.750' ,`MLSNumber` = '90038645' ,`ListAgentFullName` = 'Ashley Marquez' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.295508' ,`Longitude` = '-94.802706' ,`PhotoCount` = '28' ,`PostalCode` = '77550' ,`RoomCount` = '11' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue L' ,`StreetNumber` = '3228' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3362' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 3228 Avenue L, situated on a magnificent corner lot with large shade trees. This beautiful brick, colonial style home is simply waiting for you to add your personal touches. With 4 generous sized bedrooms, 2.5 baths, formals, a den/library, sunroom and walk-in humidor this home has endless possibilities. Original hardwood floors have been preserved throughout both levels. AC/Furnace replaced in 2019, water heater in 2020. Centrally located and easy access to the Strand or Seawall. This could be a second home or investment property. Call to schedule your tour today!' ,`Acres` = '0.1982' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR W 83 FT OF LOTS 4 & 5 (4-2) BLK 92 G' ,`LotDesciption` = 'Corner' ,`LotSize` = '8632' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'No Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'Galveston Townsite' ,`TaxAmount` = '5182' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618326' WHERE `Matrix_Unique_ID` = '212421140' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T22:22:59.050' ,`MLSNumber` = '71191104' ,`ListAgentFullName` = 'Lisa Weeks' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = 'Adela Hernandez' ,`SellingOfficeName` = 'Texas United Realty' ,`Latitude` = '30.084070' ,`Longitude` = '-95.219610' ,`PhotoCount` = '33' ,`PostalCode` = '77365' ,`RoomCount` = '7' ,`ListPrice` = '245000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Maple' ,`StreetNumber` = '22971' ,`StreetSuffix` = 'Street' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1456' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful like new 4/2 split plan home with gutters and lots of upgrades on just under 1/2 acre. 7x 17 Front Porch, Back yard is completely fenced with large workshop with electricity, concrete pad and extra parking. Back of home has 11x39 porch, Heavy duty R panel roof. New flooring, recessed lighting, crown mldg, and paint throughout. Both bathrooms were remodeled in 2021, kitchen remodeled in 2022, new cabinets, granite counters, tile backsplash and breakfast bar. Wide open spaces with views of living, kitchen and dining area. Large primary bedroom with plenty of closet space. Primary bath has large walk in shower. Great location within minutes of Hwy 59, 99 Grand PKWY, schools and shopping. Come and see all the upgrades you wont be disappointed' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S926008 - TIMBERLANE ACRES 08, LOT 22-A, SERIAL BL2001953TXA' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'PORTER ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Timberlane Acres 08' ,`TaxAmount` = '1628' ,`TaxRate` = '2.5431' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618326' WHERE `Matrix_Unique_ID` = '212424021' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T23:07:42.987' ,`MLSNumber` = '67137716' ,`ListAgentFullName` = 'Rainy Rawls' ,`ListOfficeName` = 'Century 21 Realty Partners' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.950181' ,`Longitude` = '-95.725865' ,`PhotoCount` = '48' ,`PostalCode` = '77433' ,`RoomCount` = '11' ,`ListPrice` = '563000.00' ,`Status` = 'Active' ,`StreetName` = 'First Bend Drive' ,`StreetNumber` = '18319' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3452' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous home located in highly Acclaimed Bridgeland!! This 4 Bdrm, 3.5 Baths has a backyard oasis, loaded with upgrades! This home flows beautifully from the moment you walk in the door, you will see a beautiful built in saltwater fish tank, spacious living area with lots of windows bringing in lots of natural lighting, beautiful stone fireplace,a large kitchen loaded with lots of cabinetry,island featuring granite counters. Kitchen opens into Brkfst area & Living area w/ long bar, a Study/w French doors, built in computer station downstairs and dual stations upstairs. Primary bdrm has bay windows, ensuite bath and large closet space. Upstairs you will find a Large gameroom and Media room that comes fully equipped with projector, speakers and huge screen. The backyard oasis is perfect for entertaining, including oversized patio, New pool installed in 2021, plumbing for outdoor bthrm installed, and beautiful Pergola by the pool. This is the home you\'ve been waiting for!Come see today!' ,`Acres` = '0.153' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 2 FIRST BEND SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6663' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1255' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MCGOWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '12114' ,`TaxRate` = '3.4329' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618326' WHERE `Matrix_Unique_ID` = '212655332' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T23:19:46.930' ,`MLSNumber` = '64239367' ,`ListAgentFullName` = 'Jacqueline Dang' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.679934' ,`Longitude` = '-95.598865' ,`PhotoCount` = '18' ,`PostalCode` = '77099' ,`RoomCount` = '5' ,`ListPrice` = '310000.00' ,`Status` = 'Active' ,`StreetName` = 'MAGNOLIA CANYON' ,`StreetNumber` = '12534' ,`StreetSuffix` = 'Canyon' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2944' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NO FLOODING IN HURRICANE HARVEY!!! CORNER HOUSE WITH 5 OVERSIZED BEDROOMS AND 3.5 BATHS. MASTER BEDROOM, FORMAL LIVING ROOM DOWNSTAIRS WITH KITCHEN INCLUDING BREAKFAST BAR ON THE TILE FLOOR. SPACIOUS GAMEROOM UPSTAIRS BETWEEN THE 4 BEDROOMS WITH 2 FULL BATHS ON THE LAMINATE FLOOR. A SITTING AREA IN THE SECOND BATHROOM USED AS A VANITY IS CONVENIENT FOR THE SECOND AND THE THIRD BEDROOM .\r\n\r\nTHIS HOUSE IS FEW MINUTES TO SCHOOLS, RESTAURANTS AND SUPERMARKETS. EASY ACCESS TO BELTWAY 8, WEST PARK TOLLWAY AND FREEWAY 59.' ,`Acres` = '0.1447' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 2 REGENTS VILLAGE' ,`LotDesciption` = 'Corner' ,`LotSize` = '6301' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'ALEXANDER ELEMENTARY SCHOOL (ALIEF)' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'HOLUB MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'REGENTS VILLAGE' ,`TaxAmount` = '5232' ,`TaxRate` = '2.7537' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618326' WHERE `Matrix_Unique_ID` = '212661706' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T23:01:17.063' ,`MLSNumber` = '95519695' ,`ListAgentFullName` = 'Kathy Grey' ,`ListOfficeName` = 'Xterra Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.698736' ,`Longitude` = '-95.495271' ,`PhotoCount` = '30' ,`PostalCode` = '77074' ,`RoomCount` = '3' ,`ListPrice` = '194900.00' ,`Status` = 'Active' ,`StreetName` = 'Roos' ,`StreetNumber` = '6402' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1062' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovingly Maintained by same Owner for 50+ years, SINGLE STORY Mid-Century home. This cute and cozy single story packs so many spaces into it. 3 beds, one full bath plus a formal dining AND paneled TV room. Sharpstown is known for it\'s large lots. One car attached garage. The backyard contains a storage shed.' ,`Acres` = '0.1708' ,`Area` = '21' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sharpstown Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 30 BLK 8 SHARPSTOWN SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7440' ,`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` = 'SUTTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHARPSTOWN HIGH SCHOOL' ,`SchoolMiddle` = 'LONG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Sharpstown Sec 01' ,`TaxAmount` = '3535' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618326' WHERE `Matrix_Unique_ID` = '212717714' --> 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','212752992','1664618326','212752992','2022-09-30T23:33:06.950','68196928','Ryan Hajdik','Texas United Realty','','','29.833472','-95.794498','33','77493','3','349900.00','Active','Asher Hollow','24218','Lane','Katy','2','0','3','1720','Single-Family','Come see this Meritage Home- Caddo Floor plan. Open floor plan huge outdoor covered patio. The large back yard is plenty big enough for all your family get togethers. This kitchen is a dream for your family chief.NO carpet in this house at all! This house has a water softener in the garage and is an energy-efficient home.The common area is equipped with an oversize family room which sits right next to the kitchen and dining room. The huge island provides plenty of space for people to gather around. Upgraded granite in the kitchen and quartz will be in the bathrooms. There is an office that could be used as a study and the home is walking distance from the recreation area. Katy Pointe offers easy access to the Grand Parkway, Katy Freeway, and a convenient commute to major employers. Just half an hour from metro-Houston, just off of I-10 with nearby shopping, dining, and entertainment. Schools in the sought-after Katy ISD, and close to the area’s golf courses.','0.133','25','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','','','','Katy - Old Towne','Central Gas','1','LT 18 BLK 3 KATY POINTE SEC 1','Subdivision Lot','5793','Appraisal District','','590','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','30 - Katy','BETHKE ELEMENTARY SCHOOL','PAETOW HIGH SCHOOL','STOCKDICK JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','Katy Pointe Sec 1','8088','3.4768','Public Sewer,Public Water','2019','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212871750','1664618326','212871750','2022-09-30T22:42:37.960','76833749','Michelle Duty','Zarco Realty','','','29.804186','-95.762431','36','77449','4','259900.00','Active','Braken Carter','22519','Lane','Katy','2','0','3','1675','Single-Family','Freshly painted inside and out! No carpet, driftwood vinyl plank though out. Zoned to award winning Katy ISD schools, Great layout with primary suite separated from secondary rooms by gorgeous living space with wonderful vaulted ceilings, a wood burning fireplace, and plenty of natural light though out. Corner lot provides a very spacious backyard with a beautiful oak tree for shade with plenty of sunny spots perfect for your garden! PEX plumbing, roof less than 2 years old, new fence. Don’t miss this home! Make your appointment today.','0.1719','25','','','','','Mud,Sellers Disclosure','','','1','Katy - North','Central Electric','1','LT 25 BLK 1 WILLIAMSBURG COLONY SEC 1 R/P','Corner,Subdivision Lot','7490','Appraisal District','','400','0','','2','','0','','','','','Composition','30 - Katy','WINBORN ELEMENTARY SCHOOL','MORTON RANCH HIGH SCHOOL','MORTON RANCH JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Request Online Appointment,Supra Keybox','Appraisal District','1','Ranch,Traditional','Williamsburg Colony Sec 01 R/P','4507','2.4333','Public Sewer,Public Water,Water District','1979','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212952574','1664618327','212952574','2022-09-30T23:39:48.863','87840787','Robin Hines','United Real Estate','','','29.654776','-95.931839','1','77441','13','799000.00','Active','Westerdale','3707','Drive','Fulshear','2','3','3','4079','Single-Family','Welcome to one of the most breathtaking homes in coveted Weston Lakes! Over 4000 square feet, and situated on over an acre of beautiful landscaping, this is the home you\'ve been waiting for! Custom formals, elegant kitchen, spacious den, bedrooms with a Hollywood bath and a generous flex room grace the first floor. Upstairs is the alluring master bedroom, luxury bath and a theatre or game room for you to enjoy. The balcony off the master bedroom is waiting for your morning coffee or tea. Opulent living in gated Weston Lakes, Welcome Home!','1.094','30','','','Electric Dryer Connections,Gas Dryer Connections','','Estate,Mud,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','3','Fulshear/South Brookshire/Simonton','Central Gas','1','RIVERWOOD FOREST AT WESTON LAKES SEC 1, BLOCK 6, LOT 18, ACR','In Golf Course Community','47655','Appraisal District','','1200','0','','3','Convection Oven,Electric Oven','0','','','Electric Cooktop','','Composition','33 - Lamar Consolidated','MORGAN ELEMENTARY SCHOOL','FULSHEAR HIGH SCHOOL','ROBERTS/LEAMAN JUNIOR HIGH SCHOOL','Controlled Access,Lockbox Left Side','Appraisal District','2','Contemporary/Modern,Traditional','Riverwood Forest At Weston Lakes Sec 1','9614','1.7948','Other Water/Sewer','2005','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T23:34:41.673' ,`MLSNumber` = '8264235' ,`ListAgentFullName` = 'Ana Torres' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.667528' ,`Longitude` = '-95.596671' ,`PhotoCount` = '24' ,`PostalCode` = '77099' ,`RoomCount` = '13' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Huntington Park' ,`StreetNumber` = '12158' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2570' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Are you looking for a great home to call your own? Look no further! This Two-story Home is located in a quiet neighborhood. House is very Spacious, 2-Car Detached Garage, Great size yard, Beautiful POOL with New Equipment. HVAC SYSTEM, Electrical Panel, Tankless Water Heater ONLY 2 Years old! 5th Room can be used as a Man cave. Easy access Beltway 8, Highway 6 and US 59.' ,`Acres` = '0.2116' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Stafford Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 8 HUNTINGTON VILLAGE SEC 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '9219' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '178' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'KENNEDY ELEMENTARY SCHOOL (ALIEF)' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'HOLUB MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Huntington Village Sec 01' ,`TaxAmount` = '4846' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618327' WHERE `Matrix_Unique_ID` = '212956867' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T23:07:51.363' ,`MLSNumber` = '63578177' ,`ListAgentFullName` = 'Kelly Yates' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.232597' ,`Longitude` = '-95.668926' ,`PhotoCount` = '24' ,`PostalCode` = '77354' ,`RoomCount` = '8' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Hill' ,`StreetNumber` = '40275' ,`StreetSuffix` = 'Pass' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3446' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! This beautiful home is ready for your family gatherings, holiday parties or just a relaxing evening at home. The freshly painted main floor boasts of plenty of natural light, with a study, formal dining, & spacious kitchen that opens up to the main living area. The kitchen has an abundance of counter space/cabinets, stainless appliances & you\'ll love the oversized island. The master suite has a spacious bath w/ double vanity, soaker tub, walk-in shower and oversized walk-in closet. The upstairs features a bonus area that can easily be a second living area, a media room that\'s ready for movie night or watching the big game, & large bedrooms with exceptional walk-in closets...and don\'t forget the downstairs office can easily be converted to a 5th bedroom. This home has so much to offer & is priced below appraisal value. The seller is offering an opportunity for an ASSUMABLE LOAN which may allow you to lock in an interest rate of 3.125%! Schedule your private showing today!' ,`Acres` = '0.1531' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S733300 - MOSTYN SPRINGS SUBDIVISION 01, BLOCK 3, LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6667' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mostyn Spgs Sub 01' ,`TaxAmount` = '9623' ,`TaxRate` = '3.1087' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618327' WHERE `Matrix_Unique_ID` = '212961679' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T22:13:33.557' ,`MLSNumber` = '96409645' ,`ListAgentFullName` = 'Laura Parks' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.589322' ,`Longitude` = '-95.567466' ,`PhotoCount` = '34' ,`PostalCode` = '77459' ,`RoomCount` = '11' ,`ListPrice` = '449000.00' ,`Status` = 'Active' ,`StreetName` = 'Brightwood' ,`StreetNumber` = '4007' ,`StreetSuffix` = 'Street' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3325' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2 story, well maintained,one owner, 4 bedroom 2.5 baths on a cul-de-sac with attached garage. Large 2 story open foyer with office on one side and living room on the other. No carpet downstairs.Waterproof laminate and tile are throughout the 1st floor.Large addition on 1st floor with its own a/c unit can be a great 2nd study or second family room.Kitchen has granite counters,island cooktop,under cabinet lighting and cedar ceiling.Refrigerator is included.Large size utility room. Lots of built-in bookcase and crown molding throughout house. Upstairs carpet was just installed. Every bedroom has a walk-in closet and ceiling fan. Primary has 2 walk-in closets. Backyard has a fountain and patio for a great place to relax with plenty of grass space also. Cedar on all garage walls. Double paned windows along the back side of the house on 1st and 2nd floor. Roof is 2 years old.Water heater is 4 years old. Subdivision has tennis courts,pool,and beautiful path along lake with benches.' ,`Acres` = '0.1812' ,`Area` = '29' ,`BuilderName` = 'Perry' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKESHORE AT BRIGHTWATER SEC 1, BLOCK 1, LOT 25' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7892' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '815' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEXINGTON CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakeshore At Brightwater Sec 1' ,`TaxAmount` = '7901' ,`TaxRate` = '2.71' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618327' WHERE `Matrix_Unique_ID` = '212971660' --> 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','212979641','1664618327','212979641','2022-09-30T22:04:49.763','64195129','Dwight Vincent','Icon Realty Group, L.L.C.','','','30.009960','-95.151520','10','77346','7','299999.00','Active','Legend Oak','20027','Drive','Humble','2','1','4','2382','Single-Family','ASSET LIQUIDATION SALE - $30K+ BELOW MARKET VALUE - SOLD AS IS- JUST NEEDS A LIL\' TLC AND YOUR PERSONAL TOUCH TO MAKE THIS YOUR DREAM HOME - GREAT BONES - HUGE CORNER LOT BACKS UP TO THE GOLF COURSE / NO BACK NEIGHBORS- RECENT VINYL PLANK WOODFLOORS - RECENTLY REMODELED HUGE MASTER BATH - DUAL VANATIES- WET BAR- BRICK FIREPLACE- 22 KW GENERAC GENERATOR- 3 CAR GARAGE- CIRCLE DRIVE WAY- 5 MINUTES FROM THE LAKE - 15 MINUTES TO IAH- AND SO MUCH MORE.... INVESTORS & BARGAIN HUNTERS WELCOME!!!!... professional pics coming soon after asset liquidation sale','0.2583','1','','','','','Sellers Disclosure','1','Freestanding,Wood Burning Fireplace','1','Atascocita North','Central Gas','1','LT 20 BLK 9 PINEHURST OF ATASCOCITA SEC 7','In Golf Course Community,On Golf Course,Subdivision Lot','11250','Appraisal District','','695','0','','3','Freestanding Oven','0','','','Electric Cooktop,Electric Range','','Composition','29 - Humble','PINEFOREST ELEMENTARY SCHOOL','ATASCOCITA HIGH SCHOOL','ATASCOCITA MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Ranch,Traditional','Pinehurst Atascocita Sec 07','4316','2.216','Public Sewer,Public Water','1982','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T22:15:40.727' ,`MLSNumber` = '96028121' ,`ListAgentFullName` = 'Judy Foster' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.614908' ,`Longitude` = '-95.584204' ,`PhotoCount` = '35' ,`PostalCode` = '77478' ,`RoomCount` = '9' ,`ListPrice` = '490000.00' ,`Status` = 'Active' ,`StreetName` = 'Brunswick' ,`StreetNumber` = '814' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2406' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous and Fully Remodeled Ranch-style beauty located inside Sugar Creek Golf Community is Move-in ready for You! The Central Fireplace is the Focal Point of this Open concept floor plan with large windows and glass doors providing natural light and relaxing views of a private backyard. Gorgeous wood look tile floors throughout. The kitchen offers top of the line black stainless appliance package, center island with exquisite Quartize counter top and plenty of cabinets and counter space. Large breakfast area with floor-to-ceiling windows overlooking the backyard. 4 bedrooms! Replaced windows, front door, glass sliders, interior doors w/ hardware throughout as well as the Garage door! Newly re-wired electrical & new electric panel. Bathrooms fully remodeled with PEX piping, whole house insulation and Gutters, too! HVAC and Roof 2018. Fabulous Sugar Creek Amenities. Close to shopping and easy freeway access. Park and pool a block away. Top-ranked FBISD schools are a 5-minute walk.' ,`Acres` = '0.2094' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUGAR CREEK SEC 3, BLOCK 2, LOT 16' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '9120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '532' ,`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` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Sugar Creek Sec 3' ,`TaxAmount` = '5945' ,`TaxRate` = '2.0094' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618327' WHERE `Matrix_Unique_ID` = '212979806' --> 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','212982619','1664618327','212982619','2022-09-30T22:45:11.060','49060699','Ordetralynn Thompson','Get Realty','','','30.098924','-95.186817','21','77365','8','344000.00','Active','Arcola Landing','4412','Court','Porter','2','1','3','2340','Single-Family','Don\'t skip over this listing..\r\nThis emaculant, cozy 2 story home relaxes in a cul-de-sac with awesome curb appeal. There is a covered front porch and a back patio for reading a book, checking emails or having great conversation. \r\nThe 1st floor is home of the primary bedroom with an en suite bathroom, private toilet enclosure, dual sinks, walk in closet, separate bath and shower. \r\nIntroducing the second floor. This floor is home to 2 bedrooms and a game room for kids play and family bonding.\r\nLast but not least.. Complete with a gourmet kitchen, astonishing granite counter tops, adjoining breakfast nook, walk-in pantry and wood cabinetry, the kitchen is the stunning center piece of the home. There is also plenty of cabinet storage space and a full suite of energy-efficient appliances.','0.146258','40','Lennar','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','0','Porter/New Caney East','Central Gas','1','S349205 - Country Colony 05, BLOCK 1, Lot 24','Cul-De-Sac','6370','Appraisal District','','750','0','','2','Gas Oven','0','','','Gas Range','','Composition','39 - New Caney','PORTER ELEMENTARY SCHOOL (NEW CANEY)','NEW CANEY HIGH SCHOOL','NEW CANEY MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox','Appraisal District','2','Traditional','Country Colony','','3.25','Water District','2018','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212983597','1664618327','212983597','2022-09-30T22:15:57.123','75840803','Rae Lynn White','Coldwell Banker Realty','','','29.778962','-95.418956','24','77007','6','450000.00','Active','Larkin','5443','Street','Houston','3','1','3','1917','Single-Family','Contemporary corner unit home in immaculate gated community in Cottage Grove, located between Heights & Rice Military. Enjoy the community pool (a rare find) just a few steps from this 3-story home. High ceilings & crown molding throughout. The first floor features a door leading to back yard patio and an en-suite bedroom, great for guests or home office. Living, dining & kitchen areas are located on 2nd floor, w/ gleaming oak hardwoods & high ceilings. Living room has large windows on two sides, thanks to the home\'s corner location. Dining area is open to the living room & kitchen, and everything has been done in soothing shades of greige & white. The kitchen is a real standout in its style, size & functionality. Granite countertops & s/s appliances accent the plentiful cabinets. Other features include farmhouse sink, bkfst bar & walk-in pantry. On the 3rd floor, you\'ll find an impressive primary suite w/ lovely primary bath & closet, a third en-suite bedroom & laundry. Don\'t miss it!','0.0412','9','David Weekley','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Cottage Grove','Central Gas,Zoned','1','LT 56 BLK 1 LARKIN PLACE','Corner,Patio Lot','1795','Appraisal District','','2350','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','27 - Houston','MEMORIAL ELEMENTARY SCHOOL (HOUSTON)','WALTRIP HIGH SCHOOL','HOGG MIDDLE SCHOOL (HOUSTON)','Appointment Required,Supra Keybox','Appraisal District','3','Contemporary/Modern,Traditional','Cottage Grove','9089','2.3307','Public Sewer,Public Water','2015','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T22:01:52.703' ,`MLSNumber` = '34484811' ,`ListAgentFullName` = 'Tiffany Fuller' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = 'Yashica Bowens' ,`SellingOfficeName` = 'Keller Williams Woodlands' ,`Latitude` = '30.009921' ,`Longitude` = '-95.598302' ,`PhotoCount` = '30' ,`PostalCode` = '77377' ,`RoomCount` = '7' ,`ListPrice` = '374900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Brown' ,`StreetNumber` = '11515' ,`StreetSuffix` = 'Trail' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2260' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'It\'s a ONE STORY home in Lakewood Grove located within Tomball ISD, A+ rated school district. It has 3 bedrooms with the perk of an office that could be used as a playroom, additional sitting room, or an optional bedroom! Formal dining area for the win along with a spacious kitchen that hosts plenty of storage! Awesome natural light showcased, plush fresh landscaping, and a patio for those perfect quiet mornings on the back-porch enjoying the start to your day! Updates galore, especially in the retreat of a master bathroom from cabinets to counters! Master bedroom offers bay windows with a push out of additional space perfect for a secondary office, workout space or sitting area in the comfort of your bedroom. Features laminate wood floor in main areas, fresh paint in most of the home, and those finishing updated touches to appreciate the overall look of the home! It is all within walking distance to nearby trails, park, pond, and neighborhood pool.' ,`Acres` = '0.1848' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 32 BLK 4 LAKEWOOD GROVE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'LAKEWOOD ELEMENTARY SCHOOL (TOMBALL)' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'WILLOW WOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakewood Grove' ,`TaxAmount` = '6675' ,`TaxRate` = '2.4945' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618327' WHERE `Matrix_Unique_ID` = '212987327' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T22:18:46.880' ,`MLSNumber` = '89915249' ,`ListAgentFullName` = 'Teresita Enriquez' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.861242' ,`Longitude` = '-95.738272' ,`PhotoCount` = '32' ,`PostalCode` = '77449' ,`RoomCount` = '5' ,`ListPrice` = '322000.00' ,`Status` = 'Active' ,`StreetName` = 'Iris Holly' ,`StreetNumber` = '21003' ,`StreetSuffix` = 'Street' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1757' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 21003 Iris Holly Street located in the community of Jasmine Heights and zoned to Cypress-Fairbanks ISD! This lovely DR Horton home features 4 bedrooms, 2 full baths, and an attached 2 car garage. The stunning kitchen features dark stained cabinetry with light coutnertops, SS appliances and room for bar seating. Make memories with the family in the formal dining area. The family room boasts high ceilings and large windows allowing the natural light to shine through. End your days in the spacious primary suite. The primary bath includes a large walk-in shower, separate garden tub and walk-in closet. Don\'t forget to step out to the back patio for family gatherings and refresh in your own private pool. You don\'t want to miss all this gorgeous home has to offer! Check out the virtual tour and schedule your showing today!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 6 JASMINE HEIGHTS SEC 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HEMMENWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Jasmine Heights' ,`TaxAmount` = '6229' ,`TaxRate` = '2.831' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618328' WHERE `Matrix_Unique_ID` = '212989557' --> 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','212990416','1664618328','212990416','2022-09-30T23:06:47.200','21682869','Andrea Credit','Texas United Realty','','','29.555272','-95.290454','24','77584','12','425000.00','Active','Lost Maples','2817','Drive','Pearland','3','1','4','2985','Single-Family','Beautiful 4 bed 3 1/2 bath has a grand two story entry that leads to the formal dining room. Tile and laminate floors on the first floor. The kitchen features plety of cabinet and counter top space, breakfast bar and stainless steel appliance package. The spacious 1st story master retreat has room for a sitting area and the en-suite bath features dual vanities, walk-in shower and separate soaking bathtub. The 2nd floor is complete with a game room, 3 bedrooms and 2 full bathrooms. The backyard has new fence and is made for entertaining with nice size pool. Schedule your showing today.','0.1584','5','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Pearland','Heat Pump','1','PARKS AT WALNUT BEND SEC 2 (A0239 HT&BRR) , BLOCK 2, LOT 48','Cleared','6900','Appraisal District','','315','0','','2','Gas Oven','1','Gunite','','Gas Cooktop','','Composition','42 - Pearland','C J HARRIS ELEMENTARY SCHOOL','PEARLAND HIGH SCHOOL','PEARLAND JUNIOR HIGH EAST','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','2','Traditional','Parks At Walnut Bend Sec 1-2','10849','2.8851','Public Sewer,Public Water','2013','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T23:16:46.780' ,`MLSNumber` = '81026000' ,`ListAgentFullName` = 'Laura Miranda' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.816738' ,`Longitude` = '-95.380802' ,`PhotoCount` = '19' ,`PostalCode` = '77022' ,`RoomCount` = '3' ,`ListPrice` = '379000.00' ,`Status` = 'Active' ,`StreetName` = '33rd' ,`StreetNumber` = '1405' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1752' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Houston\'s exciting new up and coming neighborhood-vibrant Independence Heights. Connecting with 610 and 45, enjoy the convenience of close proximity to Downtown, The Galleria and North Houston. The home features so many details such as a built-in vanity, accent walls & lighting in the primary bedroom with a huge walk-in closet. The first floor is an open concept with a kitchen that will include a farmhouse sink, quartz countertops, European tile work and shaker cabinets. Throughout the home you will see stunning hardware to add to that modern look and feel. Parking convenience is provided by a spacious one-car garage with ample storage space and double-wide driveway. Inner Loop Developments shows impressive attention to your year-round comfort and energy efficiency by providing R18 & R38 insulation, split high efficiency HVAC system and Low E windows. All of this at a great price!' ,`Acres` = '0.0551' ,`Area` = '9' ,`BuilderName` = 'Inner Loop Developme' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 1 BELLAVISTA PAR R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BURRUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Bellavista Add' ,`TaxAmount` = '1410' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664618328' WHERE `Matrix_Unique_ID` = '213002481' --> 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','213017506','1664618328','213017506','2022-09-30T22:09:57.187','64228203','Kalen Isas','Jane Byrd Properties INTL.','','','29.894315','-95.459664','47','77088','5','305000.00','Active','Royal Rock','11206','Court','Houston','2','1','5','2245','Single-Family','Welcome home to this beauty with many features to appreciate! Sitting in a cul-de-sac, the home boasts an open concept, 5 bedrooms, 2.5 bathrooms, 2 car garage and upgrades such as a water softener system, new AC, and a sprinkler system for your convenience.\r\nSchedule your private showing TODAY!','0.1155','11','','','','','Mud,Sellers Disclosure','1','','','Northwest Houston','Central Gas','1','LT 29 BLK 1 ROYAL CREST','Cul-De-Sac,Subdivision Lot','5031','Appraisal District','','378','0','','2','Gas Oven','0','','','Gas Range','','Composition','1 - Aldine','HILL ELEMENTARY SCHOOL (ALDINE)','EISENHOWER HIGH SCHOOL','GARCIA MIDDLE SCHOOL','Request Online Appointment,Vacant/Unoccupied','Appraisal District','2','Traditional','Royal Crest','5549','2.6153','Public Sewer,Public Water,Water District','2013','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213023743','1664618328','213023743','2022-09-30T22:00:02.833','21224116','Lindy Chappell','Keller Williams Realty - Memorial','','','29.497061','-95.815641','32','77471','10','310000.00','Active','Brightridge','4307','Court','Rosenberg','3','0','4','2346','Single-Family','Gorgeous, Welcoming, & Move-In Ready! Spacious, immaculate, & very well cared for home has a fantastic floor plan for today\'s lifestyles! 4 bedrooms, with the primary & 2 secondary bedrooms upstairs, & 1 bedroom + ensuite full bath downstairs - perfect for visiting parents or as an ideal home office. Downstairs, you\'ll adore the beautiful kitchen, open to the large living room, plus sunny breakfast room & formal dining. Upstairs, there\'s a huge game room / 2nd living area. The primary bedroom is a true retreat, with plenty of room for a sitting area + two walk in closets. Primary bath boasts double sinks, separate shower & relaxing soaking tub. The entire home is light & bright, with large double pane windows! Located on a cul de sac street, private fenced back yard. Briarwood Crossing is a terrific place, very walkable, with lake access, a Splash Pad for the kiddos, playground, Culver Elementary School, & coming soon, a neighborhood pool! Call your agent to see it soon!','0.1584','30','Long Lake, LTD.','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','0','Fort Bend South/Richmond','Central Gas','1','BRIARWOOD CROSSING SEC 1, BLOCK 1, LOT 44','Subdivision Lot','6900','Appraisal District','','645','0','','2','Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','33 - Lamar Consolidated','CULVER ELEMENTARY SCHOOL','RANDLE HIGH SCHOOL','WRIGHT JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied','Appraisal District','2','Traditional','Briarwood Crossing Sec 1','6213','3.2048','Water District','2014','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T22:17:17.337' ,`MLSNumber` = '40194367' ,`ListAgentFullName` = 'Rubeena Aggarwal' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.741621' ,`Longitude` = '-95.741482' ,`PhotoCount` = '50' ,`PostalCode` = '77450' ,`RoomCount` = '13' ,`ListPrice` = '455000.00' ,`Status` = 'Active' ,`StreetName` = 'Willow Fork' ,`StreetNumber` = '2827' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2938' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Superb location close to the Energy Corridor, Westpark Tollway & I-10! Across from Willow Fork Country Club! Charming, well maintained, updated home in a gated community! This home offers abundant windows for plenty of natural light, a well laid out floor plan with an open kitchen & family room featuring a fireplace. Some of the other features include mostly new light fixtures and fans, wood flooring in formal dining & living(can be used as study), kitchen with granite counters, modern backsplash, SS appliances, gas range, tile flooring, den with fireplace, updated powder room. Master bath with double sinks, jetted tub, separate shower, newer toilet. Fresh paint throughout the whole house and on the exterior. Roof 2022, dishwasher 2021, blinds 2021, water softener 2020. Covered patio, large backyard, sprinkler system, no back neighbors! Softener, refrigerator, washer, dryer included! Washer and dryer are 1 year old only. Never flooded. Low tax rate! Open House 10/1 12-2 PM' ,`Acres` = '' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 1 WILLOW PARK GREENS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6350' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '742' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'EXLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MCMEANS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Willow Park Greens' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618328' WHERE `Matrix_Unique_ID` = '213029095' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T22:21:08.777' ,`MLSNumber` = '96064466' ,`ListAgentFullName` = 'Ruhina Ahmed' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.572260' ,`Longitude` = '-95.644480' ,`PhotoCount` = '50' ,`PostalCode` = '77479' ,`RoomCount` = '12' ,`ListPrice` = '975000.00' ,`Status` = 'Active' ,`StreetName` = 'Burclare' ,`StreetNumber` = '4734' ,`StreetSuffix` = 'Court' ,`City` = 'Sugar Land' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4028' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Luxury at its finest. Gorgeous 5 Bedroom, 4.5 baths home situated on a huge lot in the quiet, comforting neighborhood of Telfair. The home is designed to awe when entering. The first floor has a lofty entrance, formal dining, kitchen with granite countertops that opens to the dining room, a high ceiling living area. Two bedroom downstairs, a guest bedroom suite, and a lovely private master bedroom. Upstairs offers not only a game room but also a media room and three secondary bedrooms. Brace yourself to be swooned by this well-maintained house with all the space to satisfy your needs plus more in this neighborhood that is centrally located. With close access to highways and excellent schools, this home is awaiting you and your family! Build a pool in the backyard. Watch the spectacular greenery from your balcony. Home didn\'t flood during Harvey. COME AND SEE THIS BEAUTY AND CALL IT YOUR DREAM HOME!!!' ,`Acres` = '0.2881' ,`Area` = '29' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Levee District,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TELFAIR SEC 24, BLOCK 1, LOT 10' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '12549' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'COLONY MEADOWS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FORT SETTLEMENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Telfair Sec 24' ,`TaxAmount` = '19312' ,`TaxRate` = '2.9544' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618328' WHERE `Matrix_Unique_ID` = '213031956' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T22:06:50.600' ,`MLSNumber` = '86814016' ,`ListAgentFullName` = 'Kimberly Smith' ,`ListOfficeName` = 'RE/MAX On The Water - Bolivar' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.518084' ,`Longitude` = '-94.474732' ,`PhotoCount` = '20' ,`PostalCode` = '77617' ,`RoomCount` = '4' ,`ListPrice` = '614000.00' ,`Status` = 'Active' ,`StreetName` = 'Audubon' ,`StreetNumber` = '2518' ,`StreetSuffix` = 'Avenue' ,`City` = 'Gilchrist' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1176' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Views! VIEWS! V.I.E.W.S. This fabulous three-level, hurricane-ready, 2020 construction home is your getaway beach escape! Located on Bolivar Peninsula in Gilchrist - the “quiet” “country” zone at the beach. And just a 10-minute drive to Crystal Beach stores and restaurants… and just a pleasant 20-minute ferry ride to the hustle and bustle of Galveston when you want it. It’s a private home that has never been rented. It has two bedrooms, two baths, a spacious open living area and kitchen, 360-degree covered and uncovered 3rd-level decks and porches, a fabulous covered 900 square feet 2nd-level entertainment and relaxation mezzanine, a 1st level shower, parking for 6+ cars, and an elevator/lift to all levels. It is fully furnished and ready for immediate move in. Unobstructed front views to the Gulf beach and unobstructed rear views to Galveston Bay, the Audubon Wildlife Reserve and the Inter-coastal Waterway. This IS your place at the beach!' ,`Acres` = '0.0773' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'HOA First Right of Refusal,Home Protection Plan,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Gilchrist' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'AUDUBON VILLAGE SEC 2 (2008) ABST 52, LOT 5, ACRES 0.077' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '3369' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '25 - High Island' ,`SchoolElementary` = 'HIGH ISLAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HIGH ISLAND HIGH SCHOOL' ,`SchoolMiddle` = 'HIGH ISLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Audubon Village Sec 2 2008' ,`TaxAmount` = '3675' ,`TaxRate` = '1.5543' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1664618328' WHERE `Matrix_Unique_ID` = '213047105' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T23:48:55.040' ,`MLSNumber` = '7328523' ,`ListAgentFullName` = 'Ryan Irvin' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.523240' ,`Longitude` = '-95.669156' ,`PhotoCount` = '39' ,`PostalCode` = '77469' ,`RoomCount` = '14' ,`ListPrice` = '844000.00' ,`Status` = 'Active' ,`StreetName` = 'Royal Crest' ,`StreetNumber` = '8919' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '5258' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 5258 Square Foot Trendmaker Home is the Largest Plan offered in Royal Lakes Estates. Coupled with the Intimate and Relaxing Waterfront Views, this Home Offers Both Beauty and Lasting Value. The Primary Bedroom with it\'s own Sitting Area and Gas Log Fireplace Overlooks One of the Royal Lakes. Both the First Floor Family Room and Breakfast Room, as well as the Upstairs Family Room Have a Breathtaking View of the Lake. All Bedrooms have Their Own Full Bath. Plus a Fifth Full Bath with Walk-In Closet and Lake View is at the Far End of the Second Floor Family Room and Game Area. A Simple Wall could Convert this Area to a Fifth Bedroom with it\'s own Bathroom. Open, Airy, and Ready for your Personal Choices in Flooring, this Home is a Blank Canvas. Foundation Work by Church Services has a Lifetime Transferrable Warranty. Design your Perfect Pool Overlooking the Lake. Personalize the 867 Square Foot Oversized Garage.' ,`Acres` = '0.5712' ,`Area` = '30' ,`BuilderName` = 'Trendmaker Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Fort Bend Southeast' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'ROYAL LAKE ESTATES SEC 1, BLOCK 1, LOT 9' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '24883' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1118' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'VELASQUEZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Royal Lake Estates Sec 1' ,`TaxAmount` = '8609' ,`TaxRate` = '1.6948' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618329' WHERE `Matrix_Unique_ID` = '213078642' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T22:15:27.653' ,`MLSNumber` = '92200130' ,`ListAgentFullName` = 'Gloria Chiu' ,`ListOfficeName` = 'The Real Estate Experts' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.546611' ,`Longitude` = '-95.489882' ,`PhotoCount` = '35' ,`PostalCode` = '77545' ,`RoomCount` = '11' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Egret Chase' ,`StreetNumber` = '2514' ,`StreetSuffix` = 'Court' ,`City` = 'Fresno' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2672' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home located on a corner lot on a cul-de-sac. Home features both formals, den, and game room. All bedrooms upstairs. \r\nNew laminate flooring from entry into formal living room, formal dining room and the family room.\r\nFresh paint. New carpets in upstairs.\r\nKitchen is upgraded with beautiful quartz countertops, New gas range, new dishwasher and new microwave oven.\r\nNew driveway.\r\nEasy access to Hwy 6 and Fort Bend Tollway. Convenient to schools, shopping, banking, and more.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Winfield Lakes Sec 8, BLOCK 4, Lot 22' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6874' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '575' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PARKS ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'HIGHTOWER HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'WINFIELD LAKES SEC 8' ,`TaxAmount` = '6344' ,`TaxRate` = '3.0229' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618329' WHERE `Matrix_Unique_ID` = '213078854' --> 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','213085577','1664618329','213085577','2022-09-30T22:13:43.433','14120305','Maria Erwin','Texas United Realty','','','29.930679','-95.563664','16','77064','6','265000.00','Active','Opatrny Meadows','11127','Lane','Houston','2','1','3','1634','Single-Family','Cute 2 Story home 3/2.5/2, all bedrooms upstairs. New carpet and freshly painted inside, Closed to Hwy 249, FM 1960, Beltway 8 and 290.','0.0844','10','','','Electric Dryer Connections,Washer Connections','','Owner/Agent,Sellers Disclosure','1','','','Willowbrook South','Central Electric','0','LT 5 BLK 2 OPATRNY MEADOWS','Subdivision Lot','3675','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Range','','Composition','13 - Cypress-Fairbanks','FRANCONE ELEMENTARY SCHOOL','CYPRESS RIDGE HIGH SCHOOL','CAMPBELL MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Opatrny Meadows','3828','2.5587','Water District','2005','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213109386','1664618329','213109386','2022-09-30T22:16:07.857','56680994','Greg Davis','Keller Williams Platinum','','','30.008889','-95.764855','33','77433','10','325000.00','Active','Raleighs Meadow','14815','Court','Cypress','2','0','3','1869','Single-Family','Welcome home to Raleighs Meadow Ct where you\'ll soon have your field of dreams!!! This beautiful 1-Story Lennar home is situated on a Cul-de-sac which is adjacent to central park in the coveted Fairfield master planned subdivision. From soccer fields, splash pad, playground, swimming pool and recent basketball court addition you\'ll love being so close to recreation. \r\n\r\nFrom the sprinkler system, to whole-home water softener & filtration system, covered back patio, open floor plan, spacious closets and gourmet kitchen... this home has it all! This one won\'t last long!!!','0.1427','35','','','','','Mud,Sellers Disclosure','','','','Cypress North','Central Gas','1','LT 10 BLK 2 FAIRFIELD VILLAGE SOUTH SEC 15','Cul-De-Sac,Greenbelt,Subdivision Lot','6214','Appraisal District','','1000','0','','2','','0','','','','','Composition','13 - Cypress-Fairbanks','SWENKE ELEMENTARY SCHOOL','BRIDGELAND HIGH SCHOOL','SALYARDS MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Fairfield Village South Sec 15','6707','2.631','Water District','2015','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T22:18:13.980' ,`MLSNumber` = '78550201' ,`ListAgentFullName` = 'George Diaz' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.153681' ,`Longitude` = '-95.425067' ,`PhotoCount` = '44' ,`PostalCode` = '77385' ,`RoomCount` = '9' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Darby' ,`StreetNumber` = '10487' ,`StreetSuffix` = 'Loop' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2229' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2 acre secluded and unrestricted lot, close to The Woodlands, with its own water well, charming updated and well maintained home, separate Guest Quarters which adds 763 square feet of living space, barn/workshop, 1000 square foot patio with fireplace, mature trees, and lots of additional space for entertaining, parking an RV or two, and much more.' ,`Acres` = '2' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'A0350 MONTG CO SCH LAND, TRACT 29, ACRES 2.000' ,`LotDesciption` = 'Cleared' ,`LotSize` = '87120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'HOUSER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'N/A' ,`TaxAmount` = '2375' ,`TaxRate` = '1.8487' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618329' WHERE `Matrix_Unique_ID` = '213121706' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T22:51:52.380' ,`MLSNumber` = '78629648' ,`ListAgentFullName` = 'Patience Smith' ,`ListOfficeName` = 'CR Elite Realty' ,`SellingAgentFullName` = 'Ricky Torres' ,`SellingOfficeName` = 'Keller Williams Realty - Memorial' ,`Latitude` = '29.636791' ,`Longitude` = '-95.379385' ,`PhotoCount` = '31' ,`PostalCode` = '77051' ,`RoomCount` = '5' ,`ListPrice` = '209000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Poe' ,`StreetNumber` = '3015' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1100' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! This beautiful 1-story home will be sure to capture your attention! Affordably priced, and beautifully remodeled, this 3-bedroom 2 bath starter home is waiting for the perfect family to add their personal touch. This jewel features 2\" faux wood blinds & luxurious vinyl flooring throughout, recessed lighting, and ceiling fans. This like-new home has a new roof, new electrical, new hot water heater, new cabinets, and new granite counters. Need appliances? Home includes Stainless steel Refrigerator, stove, microwave and dishwasher. Oversized back yard perfect for outdoor gatherings with mature shade trees. Come visit and fall in love with your dream home. This home is available for immediate move in! Great location with easy access to 288, 610, Beltway 8, Downtown, TX Medical Center, NRG Stadium, & Hobby Airport. Schedule your appointment today! No HOA, No MUD, Not in Flood Zone' ,`Acres` = '0.1263' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'W 35 FT OF LT 20 & E 15 FT OF LT 21 BLK 19 SUGAR VALLEY' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'REYNOLDS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sugar Valley' ,`TaxAmount` = '2078' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618329' WHERE `Matrix_Unique_ID` = '213131148' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T23:01:19.933' ,`MLSNumber` = '80399688' ,`ListAgentFullName` = 'Bassam Janem' ,`ListOfficeName` = 'Houston Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.835129' ,`Longitude` = '-95.705655' ,`PhotoCount` = '47' ,`PostalCode` = '77449' ,`RoomCount` = '12' ,`ListPrice` = '414999.00' ,`Status` = 'Active' ,`StreetName` = 'Cypress Harbor' ,`StreetNumber` = '19202' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3276' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Never flooded completely rebuilt, 225k in upgrades , contemporary/modern style home 5BDR/4BTH, two primary BDRS, open concept and offers the latest and hottest 2022 trends. Every buyer dream to have it all and now you can, custom built home offers an amazing design, quality craftsmanship, completely reimagined and most importantly worries free for years to come. New roof, 2 new High efficiency HVAC, new air ducts, new insulation, new plumbing re-piped all water line with \"PEX\", new wiring electrical including panel, all new plumbing & electrical fixtures, custom kitchen with tons of storage, quartz CT, high end SS appliances, butlers pantry, wet bar, Laminate flooring & wood like tile, custom closets, fancy Custom bathrooms, custom fireplace, ceiling fan in every BR, LED lighting, new windows & blinds, new siding, all new landscaping, fresh interior & exterior paint, custom interior & exterior features, built in floating shelves, LG garage , enormous covered patio & huge lot' ,`Acres` = '0.2629' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 47 BLK 6 CYPRESS MEADOW SEC 1' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '11450' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'M ROBINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (CY-FAIR)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Cypress Meadow Sec 01' ,`TaxAmount` = '1985' ,`TaxRate` = '2.796' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618329' WHERE `Matrix_Unique_ID` = '213157426' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T22:08:37.597' ,`MLSNumber` = '93996796' ,`ListAgentFullName` = 'Angela Chiang' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.003693' ,`Longitude` = '-95.642060' ,`PhotoCount` = '33' ,`PostalCode` = '77429' ,`RoomCount` = '14' ,`ListPrice` = '825000.00' ,`Status` = 'Active' ,`StreetName` = 'Nathan Ridge' ,`StreetNumber` = '13830' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4925' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Desirable cul-de-sac custom home in Rock Creek with 5 bedrooms, 5/1 baths plus media room (adds approx. 285 sqft to the 4925 sqft), office, game room, pool and 3 car garage. Sought after layout with a primary AND guest suite on the first floor. Gorgeous chandeliers, dramatic high ceilings with intricate tray ceiling detail are sure to wow guests. Covered patio with cool decking overlooks the heated pool with waterfalls and hot tub spa- a true backyard oasis. Updates in the past two years includes: new chandeliers, LED lighting, interior paint, carpet, built in speakers, double washers and dryers, custom dog washing station and built in kennels, resurfaced pool with polished PebbleTec and new pool parts, dishwasher, landscape lighting, double sided fence and so much more. The coveted Rock Creek community includes many amenities: trails, fitness center, pool, splash pad, tennis, basketball and pickleball courts—perfect for those seeking an active, social and healthy lifestyle.' ,`Acres` = '0.2835' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 1 ROCK CREEK SEC 11' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '12350' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'BLACK ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Rock Creek' ,`TaxAmount` = '18712' ,`TaxRate` = '2.82' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618330' WHERE `Matrix_Unique_ID` = '213159968' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T23:33:54.920' ,`MLSNumber` = '50040521' ,`ListAgentFullName` = 'Yonai Robeison' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.394617' ,`Longitude` = '-95.006322' ,`PhotoCount` = '8' ,`PostalCode` = '77591' ,`RoomCount` = '4' ,`ListPrice` = '134999.00' ,`Status` = 'Active' ,`StreetName` = 'Natchez Dr' ,`StreetNumber` = '1217' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1173' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1217 N Natchez Texas City Tx 77591' ,`Acres` = '0.138' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 189 PAGE 1 LOT 19 WESTLAND RIDGE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6010' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'SIMMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westland Ridge Sec 1' ,`TaxAmount` = '1733' ,`TaxRate` = '2.582' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664618330' WHERE `Matrix_Unique_ID` = '213160784' --> 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','213173672','1664618330','213173672','2022-09-30T23:29:01.207','65109795','Evan Ballew','JLA Realty','','','30.355104','-95.373447','42','77303','4','395000.00','Active','Silver Back','9254','Trail','Conroe','2','0','3','1942','Single-Family','Welcome to this absolutely beautiful 3 bedroom, 2 bath, 1 story home with upgrades GALORE including designer oversize tile flooring, granite counters, and updated lighting and plumbing fixtures. A butlers pantry separates the formal dining room and living space with elegant custom cabinets and under cabinet lighting. The kitchen is open to the breakfast eating area and iiving space boasting elevated ceilings and a wood burning fireplace. The master bedroom is light and bright and leads to a HUGE master ensuite with double sinks, a soaking tub, separate shower and a large master closet that connects to the laundry room for easy access. Both guest suites have elevated ceilings with ceiling fans and large closets. Enjoy the backyard in the park-like setting with a covered back patio overlooking a beautifully manicured backyard with plenty of trees for privacy... plenty of room for a pool or workshop!','1.0009','19','','','Electric Dryer Connections,Washer Connections','','Exclusions,Sellers Disclosure','1','Wood Burning Fireplace','1','Conroe Northeast','Central Electric','1','S400602 - DEER TRAIL TWO 02, BLOCK 3, LOT 20','Subdivision Lot','43601','Appraisal District','','285','0','','3','Electric Oven','0','','','Electric Range','','Composition','11 - Conroe','PATTERSON ELEMENTARY SCHOOL (CONROE)','CONROE HIGH SCHOOL','STOCKTON JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Deer Trail Two 02','4025','1.8488','Aerobic,Public Water','2015','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213182794','1664618330','213182794','2022-09-30T22:15:00.277','95364384','Erica Post','CENTURY 21 Western Realty','','','29.831498','-95.450581','40','77018','4','499000.00','Active','Nina Lee','2111','Lane','Houston','2','0','4','2365','Single-Family','Welcome to this beautifully updated home in the desirable Oak Forest! Head to toe renovation including a 503 sqft addition! There is a large covered porch in the front. Enter into an open concept floorplan. The island kitchen has quartz countertops, custom cabinetry, gas stove and oven with beautiful accent tile, large pantry and breakfast area. The primary suite has a big walk-in closet, bedroom overlooking the back yard. The primary bathroom has dual sinks, new cabinetry, quartz countertops, oversized walk-in shower and soaking tub. The secondary bathroom also has two sinks with new cabinetry, quartz countertops and separate vanities. The utility is close to all of the bedrooms for convenience. The extra room could be another bedroom, office or nursery. Large backyard with patio. Everything in this house is NEW! New plumbing, electrical and electrical box, HVAC (unit & ducts), roof, double paned windows & water heater. Foundation work comes with transferrable warranty! NEVER FLOODED!','0.1738','9','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Oak Forest East Area','Central Gas','0','LT 8 BLK 3 OAK FOREST SEC 14','Subdivision Lot','7569','Appraisal District','','','0','','0','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','STEVENS ELEMENTARY SCHOOL','WALTRIP HIGH SCHOOL','BLACK MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Ranch','Oak Forest Sec 14','7587','2.3307','Public Sewer,Public Water','1953','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213183120','1664618330','213183120','2022-09-30T22:09:31.510','29617790','Cindy Dodd','Century 21 Realty Partners','','','30.356202','-95.737350','17','77316','6','240000.00','Active','Horseshoe','23760','Bend','Montgomery','2','0','3','1608','Single-Family','Welcome to your new home in the cute community of Tri-Lake Estates. If you want that country feel but want to be a part of a community, this is it. This community offers 3 small lakes, pavilion for picnics and a fishing pier. Your home offers 3 bedrooms, living area, kitchen dining combo, 2 full baths, utility room, 2 car attached garage and fenced backyard. This cute home does need some TLC but is a nice home.','0.2835','39','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Montgomery County Northwest','Central Electric','1','TRI LAKE ESTATE 02, LOT 47','Subdivision Lot','12350','Appraisal District','','75','0','','2','Electric Oven','0','','','Electric Cooktop,Electric Range','','Composition','37 - Montgomery','MONTGOMERY ELEMENTARY SCHOOL (MONTGOMERY)','MONTGOMERY HIGH SCHOOL','MONTGOMERY JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Tri Lake Estate 02','4219','1.8242','Septic Tank','2009','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213187141','1664618330','213187141','2022-09-30T22:00:11.150','64821633','Blanca Benavidez','The Monarch Team, LLC','','','29.633136','-95.273104','41','77075','4','574999.00','Active','Jet Pilot','8223','Street','Houston','2','0','4','2768','Single-Family','Welcome to 8223 JET PILOT STREET! A personally designed beautiful home of 4 bedroom, 2 full bath.\r\nHome is situated in highly demanded subdivision of Airport Gardens and features a chic kitchen with granite countertops, stainless steel appliances, tasteful flooring throughout, and a backyard covered patio! The interior finishes and quality materials are exceptional, you don\'t want to miss the opportunity to call it HOME. \r\nSchedule a showing today!','0.5395','3','','','','','Sellers Disclosure','0','Gas Connections,Gaslog Fireplace','1','Hobby Area','Central Gas','0','LT 19 BLK 9 AIRPORT GARDENS','Cleared','23500','Appraisal District','','','0','','2','','0','','','Gas Cooktop','','Composition','27 - Houston','DEANDA ELEMENTARY SCHOOL','STERLING HIGH SCHOOL (HOUSTON)','THOMAS MIDDLE SCHOOL','Accompany,Appointment Required','Appraisal District','1','Mediterranean','Airport Gardens','12314','2.3307','Public Sewer,Public Water','2015','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213187770','1664618330','213187770','2022-09-30T22:58:43.730','57924290','Edgardo Martinez','Lucky Money Real Estate','','','30.060846','-95.363882','44','77373','9','337500.00','Active','Forest Hurst','5023','Drive','Spring','2','1','4','3068','Single-Family','Your search ends here! Beautiful 2 story house in Spring! Formal dining room has chair railing & upgraded light fixture. Open floor plan, includes formal dining room, Media Room, HUGE Game room, and Study. Kitchen has 42” cabinets, SS appliances, breakfast bar. Great family room with gas log fireplace. Large master bedroom down w/walk-in closet, dual sinks, garden tub & separate shower. 5th bedroom optional as study. Secondary bedrooms have large closets & large second full bath. Double Pane windows & Tech Shield. Conveniently located near Hardy Toll Rd, Grand Parkway, I-45, I-59, and George Bush international Airport.','0.1205','12','','','','','Exclusions,Mud,Sellers Disclosure','','Gaslog Fireplace','1','Spring East','Central Gas','1','LT 30 BLK 4 FOREST POINT AT CYPRESSWOOD','Subdivision Lot','5250','Appraisal District','','350','0','','2','','1','Above Ground','','','','Composition','48 - Spring','CHET BURCHETT ELEMENTARY SCHOOL','SPRING HIGH SCHOOL','DUEITT MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Contemporary/Modern,Traditional','Forest Point/Cypresswood','6870','2.8117','Water District','2014','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213187948','1664618330','213187948','2022-09-30T22:51:22.897','3084631','Elizabeth Pittman','RE/MAX The Woodlands & Spring','','','30.173550','-95.593499','25','77354','8','575000.00','Active','Hearthshire','114','Circle','The Woodlands','3','1','4','3123','Single-Family','ATTENTION INVESTORS! ABSOLUTELY STUNNING! - THIS IS IT! - BREATHTAKING M/I HOME W/ DESIRABLE ELIZABETH FLOORPLAN! - THIS HOME HAS IT ALL - WOOD FLOORS, GRANITE KITCHEN W/ LARGE ISLAND, ALL SS APPLIANCES, WASHER, DRYER, REFRIGERATOR INCLUDED, SOARING CEILINGS, OPEN & ENTERTAINING FLOORPLAN, GAMEROOM UP, STUDY W/ FRENCH DOORS, PLANTATION SHUTTERS, FORMAL DINING, HUGE MASTER CLOSET CONNECTS TO LAUNDRY ROOM W/ SINK, NO REAR NEIGHBORS - CLOSE TO PARKS, SCHOOLS, SHOPPING & RESTAURANTS! - THIS HOME IS A MUST SEE! - PLEASE DO NOT DISTURB THE TENANTS - APPOINTMENT REQUIRED!','0.1612','15','M/I HOMES','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure,Tenant Occupied','1','Gas Connections','1','The Woodlands','Central Gas','0','S969999 - WDLNDS VIL STERLING RIDGE 99, BLOCK 1, LOT 28','Greenbelt,Subdivision Lot,Wooded','7020','Appraisal District','','','0','','2','Convection Oven','0','','','Gas Cooktop','','Composition','36 - Magnolia','CEDRIC C. SMITH ELEMENTARY SCHOOL','MAGNOLIA HIGH SCHOOL','BEAR BRANCH JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','2','Traditional','Wdlnds Village Sterling Ridge 99','','','Public Sewer,Public Water,Water District','2013','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213188063','1664618330','213188063','2022-09-30T22:52:02.350','28574020','Elizabeth Pittman','RE/MAX The Woodlands & Spring','','','30.173146','-95.593239','28','77354','9','711000.00','Active','Hearthshire','126','Circle','The Woodlands','3','1','4','3250','Single-Family','ATTENTION INVESTORS! - ABSOLUTELY STUNNING! - THIS HOME HAS IT ALL! GORGEOUS M/I BUILDER HOME WITH SPARKLING POOL & WATERFALL! ENTERTAINING & OPEN FLOORPLAN - KITCHEN W/ GRANITE, HUGE ISLAND, GAS COOKTOP, ALL STAINLESS APPLIANCES, COPPER SINK, WASHER, DRYER, FRIDGE STAY!, STUDY W/ FRENCH DOORS, GAME ROOM, MEDIA ROOM, FORMAL DINING, SOARING CEILINGS & LOTS OF NATURAL LIGHT, TILE, OVERSIZE GARAGE, SPRINKLER SYSTEM! - HUGE COVERED PATIO & NO REAR NEIGHBORS!! - VERY PRIVATE! - PLEASE DO NOT DISTURB THE TENANTS - APPOINTMENT REQUIRED!','0.1707','15','M/I HOMES','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','Gas Connections','1','The Woodlands','Central Gas','0','S969999 - WDLNDS VIL STERLING RIDGE 99, BLOCK 1, LOT 31','Greenbelt,Subdivision Lot,Wooded','7436','Appraisal District','','','0','','2','Single Oven','1','Gunite,In Ground','','Gas Cooktop','','Composition','36 - Magnolia','CEDRIC C. SMITH ELEMENTARY SCHOOL','MAGNOLIA HIGH SCHOOL','BEAR BRANCH JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','2','Traditional','Wdlnds Village Sterling Ridge 99','','','Water District','2013','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213188429','1664618330','213188429','2022-09-30T23:30:01.373','78989908','Dao Vo','Intercontinental Properties','','','30.228092','-95.242473','0','77357','6','250000.00','Active','Paddock Point','15038','Lane','New Caney','2','0','3','','Single-Family','','0.1383','40','','','','','Mud,No Disclosures','','','','Cleveland Area','Central Gas','1','S573303 - HARRINGTON TRAILS 03, BLOCK 1, LOT 29','Subdivision Lot','6025','Survey','','750','0','','2','','0','','','','','Composition','47 - Splendora','TIMBER LAKES ELEMENTARY SCHOOL','SPLENDORA HIGH SCHOOL','SPLENDORA JUNIOR HIGH','Supra Keybox','','1','Traditional','Harrington Trails 03','663','2.0783','Water District','2021','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213188580','1664618330','213188580','2022-09-30T23:48:47.173','38913168','Tommy Bowen','JLA Realty','','','30.300799','-95.361616','16','77306','0','199000.00','Active','Candy Oak','10459','Lane','Conroe','0','0','0','906','Single-Family','LET YOUR IMAGINATION FLOW with this beautiful tract full of large oaks and and abundance of young pine trees. A home that is uninhabitable is currently present and on a slab. Clear the existing structure and start over with a fresh slate. Also, there is a large barn that is still a solid structure. A personal well exists in a shed that has fallen down around the well system. Towards the back of the property is a small pond. Clean this property up to make a beautiful 3.76 acre homesite. Property is sold as is. Conditions of the well and septic is unknown at this time, however is present. Call today for any interests.','3.767','19','','','','','Sellers Disclosure','','','1','Conroe Southeast','No Heating','0','A0188 - DAVIS JOHN A, TRACT 4, 5, BLOCK 11 PT, ACRES 3.767','Wooded','164091','Appraisal District','','','0','','0','','0','','','','','Composition','11 - Conroe','PATTERSON ELEMENTARY SCHOOL (CONROE)','CONROE HIGH SCHOOL','STOCKTON JUNIOR HIGH SCHOOL','No Appointment Required,Vacant/Unoccupied','Appraisal District','1','Traditional','N/A','1410','1.8488','Septic Tank','1978','Appraisal District'); --> New record created successfully