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-02T08:56:01.070' ,`MLSNumber` = '45850261' ,`ListAgentFullName` = 'Anne Vickery' ,`ListOfficeName` = 'Anne Vickery & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.291784' ,`Longitude` = '-95.147005' ,`PhotoCount` = '16' ,`PostalCode` = '77328' ,`RoomCount` = '4' ,`ListPrice` = '2111861.00' ,`Status` = 'Active' ,`StreetName` = 'Fostoria' ,`StreetNumber` = '10488' ,`StreetSuffix` = 'Road' ,`City` = 'Cleveland' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2001' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Excellent 13+ acre property in ideal location near Hwy 59 and Hwy 105 for residential, Industrial or Commercial development with lovely 3 Bedroom-2-bath home, detached office and large barn onsite. This land has access to the subdivision on the North boundary on CR-3795 (Auction Barn Rd).' ,`Acres` = '13.852' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric,Space Heater' ,`HOAMandatory` = '0' ,`Legal` = 'A0310 LAWRENCE M B, TRACT 36-F(11.442 AC IN MONT CO, 2.410 A' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '603393' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'GREENLEAF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'LAWRENCE M B' ,`TaxAmount` = '4310' ,`TaxRate` = '2.1029' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663705886' WHERE `Matrix_Unique_ID` = '202432901' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T09:20:32.370' ,`MLSNumber` = '58848977' ,`ListAgentFullName` = 'Kimberlea Peppercorn' ,`ListOfficeName` = 'Eastex Real Estate Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.790432' ,`Longitude` = '-95.176508' ,`PhotoCount` = '14' ,`PostalCode` = '77364' ,`RoomCount` = '3' ,`ListPrice` = '229000.00' ,`Status` = 'Active' ,`StreetName` = 'Leaning Oak' ,`StreetNumber` = '41' ,`StreetSuffix` = 'Drive' ,`City` = 'Point Blank' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1064' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand New Log Exterior Lake Getaway!! Construction completed Feb 2021. 100 x 100 lot log cabin with 8 x 10 storage building included. All furnishings will convey to buyer including refriderator.' ,`Acres` = '0.1148' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '1' ,`Legal` = 'HIDDEN OAKS, SEC J OF HVL, LOT 233, ACRES .1148' ,`LotDesciption` = 'Cleared,Greenbelt,Subdivision Lot' ,`LotSize` = '5001' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '36' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Hidden Oaks' ,`TaxAmount` = '122' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663705886' WHERE `Matrix_Unique_ID` = '206763072' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T08:20:33.680' ,`MLSNumber` = '61257522' ,`ListAgentFullName` = 'Bethania Sanchez' ,`ListOfficeName` = 'Keller Williams Hou Preferred' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.868397' ,`Longitude` = '-95.064317' ,`PhotoCount` = '20' ,`PostalCode` = '77532' ,`RoomCount` = '6' ,`ListPrice` = '800000.00' ,`Status` = 'Active' ,`StreetName` = 'Cypress' ,`StreetNumber` = '221' ,`StreetSuffix` = 'Avenue' ,`City` = 'Crosby' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '1068' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Calling all INVESTORS!!! These 6 separate home rentals and 1 duplex is a great cash-flowing opportunity with Great Rental History with all units fully occupied. Owner has run this business for over 20 years!!! Homes have new roofs and are well maintained. Each home has their own meters giving you the potential to subdivide. Located in an area that is developing and growing fast with shopping strips, highways, and New Home construction!! Just minutes away from 90 Crosby Fwy, a couple miles from The Historical Barrett Station, parks, local shops, and restaurants. (DO NOT DISTURB TENANTS) Make an offer.' ,`Acres` = '0.2984' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Wall Heater' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 67 & 68 ARCADIAN GARDENS SEC 4' ,`LotDesciption` = 'Other' ,`LotSize` = '13000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'DREW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Arcadian Gardens Sec 04' ,`TaxAmount` = '3090' ,`TaxRate` = '3.0343' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705886' WHERE `Matrix_Unique_ID` = '206849648' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T08:41:59.790' ,`MLSNumber` = '29717088' ,`ListAgentFullName` = 'Estella Dawson' ,`ListOfficeName` = 'RE/MAX Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.327158' ,`Longitude` = '-95.318440' ,`PhotoCount` = '44' ,`PostalCode` = '77303' ,`RoomCount` = '3' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Crockett Martin Estates' ,`StreetNumber` = '16247' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous new construction, on a large lot!! Come see this new listing with high ceilings that give it a large and open feel. The split bedroom plan offers extra privacy to the primary suite. Nice primary bath has a soothing spa feel to it. Lots of features including granite kitchen and a nice size island. The kitchen also comes with stainless appliances. Lovely wood look tile floors throughout and carpet in the bedrooms. Very nice size laundry room too! All this on a large lot with an attached garage! Close to the neighborhood pond with a great view! Hurry! Call your agent today!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'JCM Construction LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 12, Block 1 Section 1, Crockett Martin Estates' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'CREIGHTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Crockett Martin Estates' ,`TaxAmount` = '' ,`TaxRate` = '2.2817' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705886' WHERE `Matrix_Unique_ID` = '207069249' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T08:59:07.630' ,`MLSNumber` = '795494' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'KB Home Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.842644' ,`Longitude` = '-95.811419' ,`PhotoCount` = '7' ,`PostalCode` = '77493' ,`RoomCount` = '9' ,`ListPrice` = '364995.00' ,`Status` = 'Active' ,`StreetName` = 'Cartington' ,`StreetNumber` = '25403' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1909' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**home is under construction.**Enjoy living in this beautiful KB Home on a spacious lot in Katy Manor, boasting a brick front and stone veneer, vinyl plank flooring, and an open great room. Whip up meals for guests in the kitchen, equipped with Silestone countertops, stainless steel Energy Star® appliances, and 42-in. cabinets. The serene primary suite features extended dual vanities, a 42-in. Kohler Master Windward® tub, and a separate shower. Additional home features include faux wood blinds, full gutters, and a covered patio. Katy Manor boasts a splash pad, park, and playground. The community is located near I-10 and the Grand Parkway, giving residents easy access to the Energy Corridor. Enjoy dining, shopping, and entertainment at the nearby Katy Mills Mall and LaCenterra at Cinco Ranch. Zoned to the highly-acclaimed Katy ISD.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'KB Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '465' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Katy Manor' ,`TaxAmount` = '' ,`TaxRate` = '3.556' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705886' WHERE `Matrix_Unique_ID` = '207579949' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T08:33:47.167' ,`MLSNumber` = '97987101' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.528331' ,`Longitude` = '-95.394306' ,`PhotoCount` = '42' ,`PostalCode` = '77578' ,`RoomCount` = '10' ,`ListPrice` = '699799.00' ,`Status` = 'Active' ,`StreetName` = 'Sandy Cove' ,`StreetNumber` = '4430' ,`StreetSuffix` = 'Drive' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3050' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 97987101 - Built by Highland Homes - October completion! ~ Gorgeous 1 Story home, with an open floor plan. This modern home boasts of double doors with 8\' glass and metal front and a modern gray painted exterior. It features 4 bedrooms, 3 ½ baths, Extended Master Suite, Fireplace at Keeping Room, Powder ILO Closet/Storage making Full Bath Private, Wall of sliding glass doors at patio, Extended outdoor patio, Freestanding Tub in the Master and a 3 car-tandem garage.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'POMONA SEC 17 (A0540 ACH&B) BLK 1 LOT 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1190' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'POMONA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pomona 65s' ,`TaxAmount` = '' ,`TaxRate` = '3.659' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705886' WHERE `Matrix_Unique_ID` = '208029951' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T08:39:08.113' ,`MLSNumber` = '72319552' ,`ListAgentFullName` = 'Bethania Sanchez' ,`ListOfficeName` = 'Keller Williams Hou Preferred' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.683304' ,`Longitude` = '-95.175115' ,`PhotoCount` = '13' ,`PostalCode` = '77502' ,`RoomCount` = '8' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Wayne' ,`StreetNumber` = '2003' ,`StreetSuffix` = 'Street' ,`City` = 'Pasadena' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2188' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well maintain home. Very Spacious home with a spacious yard. Tile through out the home. New HVAC unit and conductors, New roof, New gas lines. New built heavy metal carport attached. Double wide garage, driveway.' ,`Acres` = '0.2089' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 38 SIMWAY PLACE SEC 2 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'MAE SMYTHE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SAM RAYBURN HIGH SCHOOL' ,`SchoolMiddle` = 'SOUTHMORE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Simway Place Sec 02 R/P' ,`TaxAmount` = '4194' ,`TaxRate` = '2.6514' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705887' WHERE `Matrix_Unique_ID` = '208341330' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T09:09:16.350' ,`MLSNumber` = '34185037' ,`ListAgentFullName` = 'Kati Hall' ,`ListOfficeName` = 'RE/MAX On The Water - Bolivar' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.472624' ,`Longitude` = '-94.592249' ,`PhotoCount` = '24' ,`PostalCode` = '77650' ,`RoomCount` = '3' ,`ListPrice` = '623600.00' ,`Status` = 'Active' ,`StreetName` = 'Gateway' ,`StreetNumber` = '939' ,`StreetSuffix` = '' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1559' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION home just minutes from the Beach! Home will offer vaulted ceiling in the living room area and open to the kitchen. Upstairs you will find the Primary bedroom with private balcony! Enjoy the sound of the waves and the beautiful views while sipping your morning coffee. This property is the perfect location! Close to Restaurant\'s and Shopping. Call today this one won\'t last long! \r\nPhotos are not of the current home but of similar homes completed.' ,`Acres` = '0.1033' ,`Area` = '33' ,`BuilderName` = 'Prestige' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 65 B FRANKS SUR LOT 26 BLK 7 GATEWAY' ,`LotDesciption` = 'Other' ,`LotSize` = '4500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Gateway' ,`TaxAmount` = '333' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705887' WHERE `Matrix_Unique_ID` = '208402184' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T08:22:04.550' ,`MLSNumber` = '6706088' ,`ListAgentFullName` = 'Terry Stanley' ,`ListOfficeName` = 'Texas Signature Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.595402' ,`Longitude` = '-95.485701' ,`PhotoCount` = '7' ,`PostalCode` = '77489' ,`RoomCount` = '4' ,`ListPrice` = '230000.00' ,`Status` = 'Active' ,`StreetName` = 'Ridgerock' ,`StreetNumber` = '15902' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1765' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss out on this income producing property! Large fenced yard. Open kitchen. Convenient to Fort Bend Tollway and Beltway 8.' ,`Acres` = '0.1641' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'BRIARGATE SEC 3, BLOCK 4, LOT 5' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BRIARGATE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLOWRIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'MCAULIFFE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Briargate Sec 3' ,`TaxAmount` = '3577' ,`TaxRate` = '2.2137' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705887' WHERE `Matrix_Unique_ID` = '208425935' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T09:34:43.590' ,`MLSNumber` = '2433646' ,`ListAgentFullName` = 'Meagan Minter' ,`ListOfficeName` = 'RE/MAX American Dream' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.190807' ,`Longitude` = '-95.409049' ,`PhotoCount` = '27' ,`PostalCode` = '77515' ,`RoomCount` = '4' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'Cay' ,`StreetNumber` = '11' ,`StreetSuffix` = 'Court' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2954' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come check out this Original Owner/builder home on a quiet, established Cul-de-sac located just minutes from all Angleton amenities! The home features oversized rooms throughout the home starting with a large family room as you walk into the front door. You also will be able to entertain and cook to your hearts desire in the kitchen that is centered around a gorgerous kitchen island. Not accounted for in the square feet listed is a bonus room that may be used as a game room, playroom, or as it is now as a 4th bedroom that adds around 415 sq ft of living space.\r\nThere are entrances to the backyard through the living room, primary bedroom and bonus room that will take you to your new oasis. The screened in pool brings you over 3,000 sq ft of no mosquito entertaining and relaxing space!!' ,`Acres` = '0.2624' ,`Area` = '5' ,`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` = 'Angleton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'NORTH CAY (ANGLETON) LOT 11 SEC II' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11430' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Enclosed,Gunite,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'CENTRAL ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'North Cay Angleton' ,`TaxAmount` = '6636' ,`TaxRate` = '2.6102' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705887' WHERE `Matrix_Unique_ID` = '208644825' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T09:49:24.887' ,`MLSNumber` = '21585987' ,`ListAgentFullName` = 'Edward McClintick' ,`ListOfficeName` = 'Joseph Walter Realty, LLC' ,`SellingAgentFullName` = 'Edward McClintick' ,`SellingOfficeName` = 'Joseph Walter Realty, LLC' ,`Latitude` = '29.371023' ,`Longitude` = '-94.981563' ,`PhotoCount` = '6' ,`PostalCode` = '77568' ,`RoomCount` = '4' ,`ListPrice` = '127250.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Jackson' ,`StreetNumber` = '2518' ,`StreetSuffix` = 'Street' ,`City` = 'La Marque' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '962' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perfect investor opportunity in a prime location. All the majors items are in great working order (AC, roof, electrical and plumbing). \r\nCute 3 bedroom, 1 bath single family home. The home has a 1 car garage that can add a 4th bedroom and bathroom to bring up the value significantly.' ,`Acres` = '0.1471' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Marque' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 150 J D MOORE SUR LOT 35 TORRY SUB EXTN' ,`LotDesciption` = 'Other' ,`LotSize` = '6406' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'WESTLAWN ELEMENTARY SCHOOL (LA MARQUE)' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Torry Ext' ,`TaxAmount` = '2548' ,`TaxRate` = '2.6428' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705887' WHERE `Matrix_Unique_ID` = '208928109' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T09:14:36.567' ,`MLSNumber` = '66777792' ,`ListAgentFullName` = 'Kimberly Roe' ,`ListOfficeName` = 'KAR Realty Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.748484' ,`Longitude` = '-95.609226' ,`PhotoCount` = '23' ,`PostalCode` = '77077' ,`RoomCount` = '9' ,`ListPrice` = '385000.00' ,`Status` = 'Active' ,`StreetName` = 'Westhorpe' ,`StreetNumber` = '12707' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2039' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is located on a highly desirable street on a cul-de-sac lot in the Ashford West neighborhood. A formal dining room, updated kitchen and generously sized family room are ready for gatherings. The kitchen boasts granite counters, travertine backsplash SS appliances, double ovens and built in microwave. The spacious family room has vaulted ceilings with wood beams, a wood burning fireplace and a custom built-in entertainment center. The primary ensuite features a walk-in shower, double sink vanity. framed mirrors and closet. Three other secondary bedrooms and a full bath complete this home. The backyard has a large extended flagstone patio with walkways and a hot tub pergola. Conveniently located near Memorial and the Energy Corridor. Walking distance to schools.' ,`Acres` = '0.2225' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 8 ASHFORD WEST SEC 2' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '9694' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DAILY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ashford West' ,`TaxAmount` = '6572' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705887' WHERE `Matrix_Unique_ID` = '208998284' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T08:32:52.837' ,`MLSNumber` = '24246138' ,`ListAgentFullName` = 'Rania Mounir' ,`ListOfficeName` = 'Mission Real Estate Group' ,`SellingAgentFullName` = 'Rania Mounir' ,`SellingOfficeName` = 'Mission Real Estate Group' ,`Latitude` = '29.998994' ,`Longitude` = '-95.617815' ,`PhotoCount` = '47' ,`PostalCode` = '77429' ,`RoomCount` = '7' ,`ListPrice` = '370000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Wincrest Ct' ,`StreetNumber` = '12918' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2940' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Remodeled home in Lakewood Forest with a great outdoor area including a pool, spa and covered patio. Large den with fireplace, hardwood floors, updated kitchen with granite counter tops, spacious upstairs master bedroom, bath with a separate tub, shower and granite counter tops. Great school area and 0.3 mile from a shopping plaza. It is all what you need to have in one place. This is a must see!' ,`Acres` = '0.2238' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 30 BLK 3 LAKEWOOD FOREST SEC 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '670' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HAMILTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakewood Forest Sec 10' ,`TaxAmount` = '6093' ,`TaxRate` = '2.5217' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705887' WHERE `Matrix_Unique_ID` = '209702712' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T09:02:03.000' ,`MLSNumber` = '65959246' ,`ListAgentFullName` = 'Randy Hodde' ,`ListOfficeName` = 'Hodde Real Estate Company' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.146551' ,`Longitude` = '-96.366363' ,`PhotoCount` = '16' ,`PostalCode` = '77833' ,`RoomCount` = '8' ,`ListPrice` = '443900.00' ,`Status` = 'Active' ,`StreetName` = 'Chase' ,`StreetNumber` = '2702' ,`StreetSuffix` = 'Street' ,`City` = 'Brenham' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2461' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fabulous home located in a well-established neighborhood on a beautiful corner lot just minutes from everything that Brenham has to offer!! Home is traditional in style and features a wonderful split floor plan that offers ±2461 SF. There are three bedrooms, three baths, office/fourth bedroom, formal dining room, spacious living area with fireplace, kitchen/breakfast room with lots of natural light and 2 car side-entry garage. The home has been updated over the past several years including granite countertops in kitchen, wood look tile flooring in all rooms except bathrooms, new roof (2016), new A/C (2019) and exterior painted (2020) Outside is a great covered back porch/ patio with fireplace and lots of room for entertaining. Come take a look.... you will love what you see!!' ,`Acres` = '0.2837' ,`Area` = '58' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'SPRINGWOOD S/D SEC I, LOT 12' ,`LotDesciption` = 'Corner' ,`LotSize` = '12360' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '137 - Brenham' ,`SchoolElementary` = 'BISD DRAW' ,`SchoolHigh` = 'BRENHAM HIGH SCHOOL' ,`SchoolMiddle` = 'BRENHAM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Springwood Sec I' ,`TaxAmount` = '6281' ,`TaxRate` = '2.0369' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705887' WHERE `Matrix_Unique_ID` = '209876946' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T09:49:29.643' ,`MLSNumber` = '10840049' ,`ListAgentFullName` = 'Andrea Joseph' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.764144' ,`Longitude` = '-95.467982' ,`PhotoCount` = '49' ,`PostalCode` = '77056' ,`RoomCount` = '9' ,`ListPrice` = '2694900.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Forest' ,`StreetNumber` = '5203' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '5088' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully situated on an 16,000+ square foot corner lot in Bayou Bend / Tanglewood, you\'ll discover this gorgeous modern farm house inspired residence featuring 4 bedrooms, 5 baths and an enormous yard with a beautiful covered porch and lush lawn. Hardwood floors, high ceilings, weathered brick wine room. The casual elegance of the family room features a large fireplace and an abundance of light. Granite kitchen, Butler\'s Pantry + delightful breakfast room. Main floor primary bedroom offers space for a king-size bed cozy fire place and exquisite ensuite bathroom. Office or home gym space adjacent to the primary bed. The 4th bedroom is ideal for a teenager, visiting relative or live -in nanny. Game room or secondary living space upstairs. Unfinished suite above the garage is plumbed and ready you to make it your own. Outstanding public and private schools. Minutes to Galleria, Whole Foods, and easy access to I-610. Please click the film reel above the listing pic for virtual tour!' ,`Acres` = '0.3857' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Tanglewood Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 1 BAYOU GLEN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '16800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bayou Glen' ,`TaxAmount` = '61832' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705888' WHERE `Matrix_Unique_ID` = '209898213' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T09:32:07.467' ,`MLSNumber` = '18603166' ,`ListAgentFullName` = 'Gary Bisha' ,`ListOfficeName` = 'My Castle Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.949039' ,`Longitude` = '-95.721394' ,`PhotoCount` = '25' ,`PostalCode` = '77433' ,`RoomCount` = '12' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Williams Elm' ,`StreetNumber` = '18147' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3764' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Updated, with private pool that backs to greenbelt and NO back neighbors. Meticulously maintained and Move-in Ready!. NO Carpet! Recently updated flooring and cabinets. Flooring specific for high traffic and pool. Mature trees and professionally landscaped yard with sprinkler system. New, modern paint throughout, The functional layout has 5 bedrooms, 3.5 baths, dedicated study, formal dining, media and game rooms. Huge separated bedroom and bath upstairs perfect for generational living. Smart double ovens in kitchen make entertaining a breeze while the formal dining, breakfast room and breakfast bar offer many options for seating. The salt water pool is situated off the expansive covered patio. Pool fence allows owners to safely enjoy the pool and yard. Whole home water filtration system. Conveniently located in award winning Bridgeland minutes from Grand Parkway, US 290 and zoned to excellent schools.' ,`Acres` = '0.1801' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 1 FIRST BEND SEC 5' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '7845' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1197' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Salt Water' ,`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` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland First Bend Sec 05' ,`TaxAmount` = '12181' ,`TaxRate` = '3.4329' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705888' WHERE `Matrix_Unique_ID` = '210240882' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T09:09:51.090' ,`MLSNumber` = '79729162' ,`ListAgentFullName` = 'Nikola Knezevic' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.984619' ,`Longitude` = '-95.145358' ,`PhotoCount` = '28' ,`PostalCode` = '77346' ,`RoomCount` = '5' ,`ListPrice` = '429900.00' ,`Status` = 'Active' ,`StreetName` = 'Mariner' ,`StreetNumber` = '18410' ,`StreetSuffix` = 'Place' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4276' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! DYNAMITE 5 Bedroom, 3.5 bath Home just minutes away from Lake Houston…Spacious bedrooms…Large Family Room with fireplace...Updated open kitchen with granite counters and NEW Stainless-steel appliances…Breakfast Area and separate Formal dining room for family gatherings…Primary bedroom features a standing shower and Separate soaking tub…Beautiful Victorian style terrace upstairs…NEW Carpet throughout…Great community amenities, 4 minutes away from Golf Course and Community Pool…DO NOT MISS OUT!' ,`Acres` = '0.2094' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Owner/Agent,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 48 CHAMPIONS VILLAGE WALDEN ON LAKE HOUSTON PH 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'MAPLEBROOK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Walden On Lake Houston Ph 05' ,`TaxAmount` = '8406' ,`TaxRate` = '2.5885' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705888' WHERE `Matrix_Unique_ID` = '210273525' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T09:00:19.637' ,`MLSNumber` = '51768137' ,`ListAgentFullName` = 'Christine Nguyen' ,`ListOfficeName` = '5th Stream Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.595368' ,`Longitude` = '-95.524103' ,`PhotoCount` = '25' ,`PostalCode` = '77489' ,`RoomCount` = '3' ,`ListPrice` = '339900.00' ,`Status` = 'Active' ,`StreetName` = 'Gentle Bend' ,`StreetNumber` = '1362' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1960' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction! 10 year structural warranty for major structural components, details attached. A rare find in Hunter Glen subdivision. Beautiful house with 3 bedrooms, 2 full bathrooms, an office with closet which can turn into a 4th bedroom if desired, a spacious great room, and a very nice kitchen. Attractive hall way, with bright natural sunlight and beautifully painted with elegant neutral color. Wonderful convenience floor plan. All bedrooms with ceiling fans, and walk-in closets. Recessed lights installed in most areas of the house. Kitchen with granite countertops, mosais backsplash, wood cabinets in white color with soft closing, a kitchen island with seating area and a good size pantry. Master bedroom with high ceiling,looking out to a big backyard with no neighbor at the back. Master bath has 2 separate vanities, with granite countertops, double space shower with glass door. Tiles installed in all wet areas, and luxurious vinyl planks for the rest of the house. And more.' ,`Acres` = '0.2228' ,`Area` = '38' ,`BuilderName` = 'La Perouse Construct' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'HUNTERS GLEN SEC 3, BLOCK 1, LOT 14' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9703' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '329' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HUNTERS GLEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MARSHALL HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'MISSOURI CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hunters Glen Sec 3' ,`TaxAmount` = '743' ,`TaxRate` = '2.693' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705888' WHERE `Matrix_Unique_ID` = '210316686' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T08:55:45.797' ,`MLSNumber` = '20427362' ,`ListAgentFullName` = 'Michelle Whitecotton' ,`ListOfficeName` = 'Markham Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.660308' ,`Longitude` = '-95.535408' ,`PhotoCount` = '22' ,`PostalCode` = '77340' ,`RoomCount` = '7' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Durham' ,`StreetNumber` = '1612' ,`StreetSuffix` = '' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1899' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Light, bright, and open concept home on a corner lot in a quiet area. White wrought iron fenced back yard complete with covered porch, deck, flag pole and outdoor natural gas connection for grill! High ceilings, crown molding in entry, living and master. Atrium doors to deck, gas fireplace in den that opens to kitchen and breakfast area. Wonderful master bath w/whirlpool tub, separate shower, separate sink, different height vanities and closets with built ins.' ,`Acres` = '' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'West Lake Shores Sec 3 Blk 5 Lot 1 & 2' ,`LotDesciption` = 'Corner,In Golf Course Community,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '198' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'ESTELLA STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Elkins Lake' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705888' WHERE `Matrix_Unique_ID` = '210724934' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T09:31:23.287' ,`MLSNumber` = '39808213' ,`ListAgentFullName` = 'Diane Cutaia' ,`ListOfficeName` = 'Elite Texas Properties' ,`SellingAgentFullName` = 'Carlos Garcia II' ,`SellingOfficeName` = 'Carlos Garcia Realty' ,`Latitude` = '30.001671' ,`Longitude` = '-95.592058' ,`PhotoCount` = '35' ,`PostalCode` = '77377' ,`RoomCount` = '7' ,`ListPrice` = '299000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Oxenford' ,`StreetNumber` = '15602' ,`StreetSuffix` = '' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1916' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Handsome Contemporary on a huge (13000+ft. lot) in quiet, tree lined Canterbury Forest. Just minutes to shopping, medical, tollway, etc. You will fall in love with the high ceiling, fireplace, wood floors, and spacious downstairs primary bedroom with ensuite bath. The updated kitchen has beautiful millwork, lighting and new appliances. A secondary bedroom upstairs was 2 rooms combined and it is huge! You will want to stay outside on the expansive custom covered patio with outdoor kitchen, bar (barstools included), hard wired wireless access point, fireplace, and porch swing (included). Ask agent for extensive list of updates! Great Tomball Schools, and low tax rate. Washer, dryer, and refrigerator included with acceptable offer!' ,`Acres` = '' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 31 Block 6' ,`LotDesciption` = 'Wooded' ,`LotSize` = '13250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '155' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'LAKEWOOD ELEMENTARY SCHOOL (TOMBALL)' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'WILLOW WOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Canterbury Forest' ,`TaxAmount` = '5441' ,`TaxRate` = '2.49' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705888' WHERE `Matrix_Unique_ID` = '210995772' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T09:22:31.940' ,`MLSNumber` = '76030863' ,`ListAgentFullName` = 'John McIntyre' ,`ListOfficeName` = 'Century 21 Olympian Galleria' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.658209' ,`Longitude` = '-95.344133' ,`PhotoCount` = '27' ,`PostalCode` = '77033' ,`RoomCount` = '7' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Noel St' ,`StreetNumber` = '9209' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2299' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNDER CONSTRUCTION CUSTOM HOME! You need to see the exquisite details of the high ceilings, wood beams, custom pantry and closets & all the extra features that you cannot find with other builders in this area. Beautiful 2 Story home with 4 bedrooms 3 1/2 bathrooms in front of a park. Open concept floor plan with wood flooring throughout the house. The kitchen features quartz countertops and a huge kitchen island with a sink, stainless steel appliances and spacious custom pantry. The second floor has all the bedrooms and a game room. The primary bedroom features a separate shower and garden tub, double sinks and a large custom walk-in closet and it is located to one side for privacy. The second and third bedrooms share a bathroom and the 4th bedroom/guest room has its own bathroom. This home also includes a front porch and covered patio with a large backyard and electric gate for security. The house comes pre-wired for alarm system. Close to the Medical Center; easy access to 610 - 288.' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = 'Villas La Hacienda' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 HACIENDA AT NOEL' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6200' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WOODSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'HACIENDA AT NOEL' ,`TaxAmount` = '543' ,`TaxRate` = '2.4216' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705888' WHERE `Matrix_Unique_ID` = '211225212' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T08:59:38.407' ,`MLSNumber` = '57951838' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Keller Williams Platinum' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.950495' ,`Longitude` = '-94.704077' ,`PhotoCount` = '49' ,`PostalCode` = '77575' ,`RoomCount` = '8' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Private Road 1145' ,`StreetNumber` = '126' ,`StreetSuffix` = '' ,`City` = 'Liberty' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Get a taste of the beautiful Texas countryside in this stunning 4-bedroom, 2.5-bathroom home in Jos Dunman, boasting beamed ceilings, wood flooring, a detached 4-car garage, gas log fireplace, storage area, and an open great room. Entertain guests in the expansive backyard, complete with a covered patio, outdoor kitchen, workshop, and above-ground pool. The beautiful island kitchen is equipped with granite countertops, a gas cooktop, and a breakfast bar. The spa-like primary suite features a walk-in closet and a shower. Conveniently located off U.S 90, I-10, and State Highway 146, residents are mere steps from the town’s main dining and shopping. Explore the endless miles of trails and nature parks surrounding the Trinity River, including the Trinity River National Wildlife Refuge. Zoned to Liberty ISD.' ,`Acres` = '1.541' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Liberty' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '000032 JOS DUNMAN, TRACT 229 243, ACRES 1.541' ,`LotDesciption` = 'Wooded' ,`LotSize` = '67126' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '73 - Liberty' ,`SchoolElementary` = 'LIBERTY ELEMENTARY SCHOOL (LIBERTY)' ,`SchoolHigh` = 'LIBERTY HIGH SCHOOL (LIBERTY)' ,`SchoolMiddle` = 'LIBERTY MIDDLE SCHOOL (LIBERTY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jos Dunman' ,`TaxAmount` = '3957' ,`TaxRate` = '1.9555' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705889' WHERE `Matrix_Unique_ID` = '211242987' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T08:21:18.793' ,`MLSNumber` = '16316084' ,`ListAgentFullName` = 'Nancy Stow' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.722718' ,`Longitude` = '-95.570918' ,`PhotoCount` = '24' ,`PostalCode` = '77042' ,`RoomCount` = '9' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Royce Palms' ,`StreetNumber` = '11231' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1995' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Paradise in Royal Palms - a wonderful community of 90 homes! Situated on a 5000+ sf lot, this lovely well-maintained home built in 2003 is a find! Lush tree-lined professionally landscaped backyard has plenty of room for a pool and play! Granite chef\'s kitchen features updated Samsung SS appliances and Bosch dishwasher (refrigerator remains). Open family room to dining and breakfast area - a fabulous flow for entertaining! Light and bright, you\'ll love the 2-story entry that opens to the sizeable gameroom upstairs + 3-bedrooms. Easy-clean ceramic tile neutral flooring, berber carpet upstairs, plantation shutters & crown molding. Roof replaced in 2019. New hot water heater (Aug 2022). Front door refinished in July 2022. Kinetico water softening system and under kitchen sink water filter system. Ceiling fans throughout. Backyard trees include: Palm, Fig, Mimosa, Japanese Blueberry and Loquat. Good size garage and additional driveway parking! You don\'t want to miss!' ,`Acres` = '0.1194' ,`Area` = '31' ,`BuilderName` = 'Royce' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Westchase Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 30 BLK 1 ROYAL PALMS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5199' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '798' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'OUTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'O\'DONNELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Royal Palms' ,`TaxAmount` = '6548' ,`TaxRate` = '2.5311' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705889' WHERE `Matrix_Unique_ID` = '211393149' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T09:47:16.157' ,`MLSNumber` = '68008317' ,`ListAgentFullName` = 'Youngil Seo' ,`ListOfficeName` = 'CMK Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.719312' ,`Longitude` = '-95.797515' ,`PhotoCount` = '29' ,`PostalCode` = '77494' ,`RoomCount` = '9' ,`ListPrice` = '519000.00' ,`Status` = 'Active' ,`StreetName` = 'Everhart Manor' ,`StreetNumber` = '5311' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2871' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely Home in Seven Meadows. RECENTLY UPDATED with Kitchen (2021), Quartz countertop, Wall Mounted Range Hood& Pot Filler, New SS Appliances open to Family Room with High Ceilings & Crown Molding. New Roof (2019) & New Water Heater (2020), New Paint (2021)\r\nThis home offers 2 Master Bedrooms, One Downstairs & One Upstairs. Great backyard with Covered Patio & Pavestone Walkway. Great Location and Exemplary School. DON\'T MISS THIS HOME!' ,`Acres` = '0.1754' ,`Area` = '36' ,`BuilderName` = 'Meritage' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEVEN MEADOWS SEC 14, BLOCK 2, LOT 20' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7642' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'HOLLAND ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'SEVEN LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'BECKENDORFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Seven Meadows Sec 14' ,`TaxAmount` = '7836' ,`TaxRate` = '2.3145' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705889' WHERE `Matrix_Unique_ID` = '211476327' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T08:43:01.903' ,`MLSNumber` = '3657765' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.518503' ,`Longitude` = '-95.784257' ,`PhotoCount` = '6' ,`PostalCode` = '77471' ,`RoomCount` = '8' ,`ListPrice` = '414240.00' ,`Status` = 'Active' ,`StreetName` = 'Richglen' ,`StreetNumber` = '3628' ,`StreetSuffix` = 'Court' ,`City` = 'Rosenberg' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2731' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Fairway Collection \"Melrose\" Plan with Elevation \"E\" in Sendero! This new single-story home delivers modern comfort with a low-maintenance design. Down the foyer is a quiet study well-suited as an office, followed by a spacious open layout situated among the kitchen, dining room and family room. Direct access to the covered patio allows seamless for indoor-outdoor living. In a private corner is the owner’s suite with an adjoining bathroom and oversized walk-in closet, while at the front are three secondary bedrooms. A two-car garage completes the home. *HOME ESTIMATED TO BE COMPLETE, JANUARY, 2022*' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0005 BLK 001 LOT 002' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '756' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MEYER ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sendero' ,`TaxAmount` = '' ,`TaxRate` = '3.09' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705889' WHERE `Matrix_Unique_ID` = '211510557' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T08:43:44.110' ,`MLSNumber` = '18267729' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.518503' ,`Longitude` = '-95.784257' ,`PhotoCount` = '6' ,`PostalCode` = '77471' ,`RoomCount` = '7' ,`ListPrice` = '405540.00' ,`Status` = 'Active' ,`StreetName` = 'Richglen' ,`StreetNumber` = '3615' ,`StreetSuffix` = 'Court' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2517' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Fairway Collection \"Glenbrook\" Plan with Elevation \"D\" in Sendero! This new single-story home provides modern comfort and convenience. Down the foyer is a quiet study ideal for office work, followed by a spacious open-concept family room that merges into the well-equipped kitchen and airy dining room to deliver seamless everyday living. A large covered patio offers enviable outdoor fun and relaxation. In a privately situated corner is the owner’s suite with an attached bathroom and oversized walk-in closet, while at the front of the home are two secondary bedrooms. *HOME ESTIMATED TO BE COMPLETE, JANUARY, 2023*' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0005 BLK 001 LOT 012' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '756' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MEYER ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sendero' ,`TaxAmount` = '' ,`TaxRate` = '3.09' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705889' WHERE `Matrix_Unique_ID` = '211514131' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T08:25:54.787' ,`MLSNumber` = '22923409' ,`ListAgentFullName` = 'Emilio Zaporteza' ,`ListOfficeName` = 'Vez Realty, LLC' ,`SellingAgentFullName` = 'Iman Kanan' ,`SellingOfficeName` = 'RE/MAX Signature' ,`Latitude` = '29.501862' ,`Longitude` = '-95.395121' ,`PhotoCount` = '34' ,`PostalCode` = '77578' ,`RoomCount` = '13' ,`ListPrice` = '428900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Terra Bella' ,`StreetNumber` = '57' ,`StreetSuffix` = 'Drive' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3483' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fabulous lake front home with stunning views inside and out. Incredible open floor plan with 2-story family room and study/den. Beautifully appointed kitchen and breakfast area with Giallo Napoli granite countertops & stainless steel appliances. Very clean. Gorgeous fireplace in family room. Over-sized master bedroom retreat. Master bath with shower, soaking tub, and dual sinks. Very large upstairs game room which has its own wet bar! Also featuring a separate media room with sunken floor, perfect for all your entertainment needs. All secondary bedrooms are very spacious with 10-foot-tall ceilings and nice bathrooms to match. Enjoy sitting on the balcony overlooking the lake or simply walk down to the lake. Covered back patio and front porch.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RODEO PALMS, PALM LAKES (A0299 & A0459)(MANVEL) BLK 2 LOT 18' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '6599' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'DON JETER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Rodeo Palms, Palm Lakes' ,`TaxAmount` = '10509' ,`TaxRate` = '3.6694' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705889' WHERE `Matrix_Unique_ID` = '211534808' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T08:47:49.890' ,`MLSNumber` = '59102079' ,`ListAgentFullName` = 'Joseph Adams' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = 'Steven Little' ,`SellingOfficeName` = 'Little Realty' ,`Latitude` = '30.017307' ,`Longitude` = '-95.298752' ,`PhotoCount` = '6' ,`PostalCode` = '77338' ,`RoomCount` = '8' ,`ListPrice` = '204900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Opalwood' ,`StreetNumber` = '8318' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1926' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HOME SWEET HOME ...Charming open floor plan in seasoned community with lots of trees!!! Large Family Room open to Large Kitchen & Breakfast Room! Formal Dining & Living or Study...Master open to backyard with large trees to keep the home cool with shade!!! LOTS OF UPDATES! New 2019 flooring throughout home! New inside paint 2019, NEW AC and water heater 2019!!! WHOLE HOUSE GENERATOR 2019!!!!!!.. A MUST SEE!!! Schedule your showing today!' ,`Acres` = '0.1446' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 36 BLK 4 KENSWICK SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '254' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'JONES ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kenswick Sec 05' ,`TaxAmount` = '4648' ,`TaxRate` = '2.7433' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705889' WHERE `Matrix_Unique_ID` = '211578821' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T08:44:21.610' ,`MLSNumber` = '5569616' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.518499' ,`Longitude` = '-95.784274' ,`PhotoCount` = '7' ,`PostalCode` = '77471' ,`RoomCount` = '11' ,`ListPrice` = '487440.00' ,`Status` = 'Active' ,`StreetName` = 'Richglen' ,`StreetNumber` = '3612' ,`StreetSuffix` = 'Court' ,`City` = 'Rosenberg' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3126' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Fairway Collection Next Gen \"Oak Hill III\" Plan with Elevation \"F\" in Sendero! The versatile two-story Oak Hill III Next Gen® floor plan by Lennar features a HOME OFFICE SUITE with a built-in coffee bar, a private front entrance, and a single bay garage. The main home features an island kitchen with a walk-in pantry, an open dining room and family room, a relaxing covered rear patio, and a walk-in utility room. The first floor primary bedroom features an en suite bathroom with dual sinks, stand-up shower, private toilet enclosure, and a spacious walk-in closet. The second floor features three additional bedrooms, two full bathrooms, and a spacious game room. *HOME ESTIMATED TO BE COMPLETE, JANUARY, 2023*' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0005 BLK 001 LOT 006' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '756' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MEYER ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sendero' ,`TaxAmount` = '' ,`TaxRate` = '3.09' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705890' WHERE `Matrix_Unique_ID` = '211584237' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T09:08:12.500' ,`MLSNumber` = '80320485' ,`ListAgentFullName` = 'Casey Copley' ,`ListOfficeName` = 'Live Oak Real Estate Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.389902' ,`Longitude` = '-94.216257' ,`PhotoCount` = '31' ,`PostalCode` = '77656' ,`RoomCount` = '8' ,`ListPrice` = '324900.00' ,`Status` = 'Active' ,`StreetName` = 'Country Club' ,`StreetNumber` = '6037' ,`StreetSuffix` = 'Road' ,`City` = 'Silsbee' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2404' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Do you wanna live on the golf course but want to stay in Silsbee, TX. We\'ve got it! Directly across from the 7th green you can see this Beauty. Home has four bed rooms with three full baths. Dedicated Gaming/Study area. Large garage will hold full size SUV and 3/4 ton truck with storage room to spare. Separate Garage door for the golf cart. Fenced in backyard for the large dogs. Back deck has been recently updated with new boards. Tons of room for you to enjoy, both inside and out!' ,`Acres` = '0.527' ,`Area` = '49' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'AB 6 H BINNS P# 6-158-A I# 2018-87916 08/23/2018' ,`LotDesciption` = 'Cleared' ,`LotSize` = '22956' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '252 - Silsbee' ,`SchoolElementary` = 'SILSBEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SILSBEE HIGH SCHOOL' ,`SchoolMiddle` = 'EDWARDS-JOHNSON MEMORIAL MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Out of town' ,`TaxAmount` = '3365' ,`TaxRate` = '1.9097' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705890' WHERE `Matrix_Unique_ID` = '211620611' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T08:45:05.083' ,`MLSNumber` = '62247043' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.518559' ,`Longitude` = '-95.783973' ,`PhotoCount` = '6' ,`PostalCode` = '77471' ,`RoomCount` = '8' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Rushing Brook' ,`StreetNumber` = '5328' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1922' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Wildflower Collection \"Brenham II\" Plan with Elevation \"A\" in Sendero! This spacious, single-story home features a large family room, a kitchen with a center island and an adjoining breakfast space that overlooks a covered patio. The owner’s suite enjoys bay windows and a private entry that leads to a second walk-in closet and a laundry room. *HOME ESTIMATED TO BE COMPLETE, OCTOBER, 2022*' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0004 BLK 001 LOT 026' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '756' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MEYER ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sendero' ,`TaxAmount` = '' ,`TaxRate` = '3.09' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705890' WHERE `Matrix_Unique_ID` = '211635456' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T08:59:20.437' ,`MLSNumber` = '88109526' ,`ListAgentFullName` = 'Dawei Ke' ,`ListOfficeName` = 'Glad Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.895789' ,`Longitude` = '-95.477227' ,`PhotoCount` = '34' ,`PostalCode` = '77088' ,`RoomCount` = '7' ,`ListPrice` = '247000.00' ,`Status` = 'Active' ,`StreetName` = 'Fairview Forest' ,`StreetNumber` = '5723' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2070' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Sweet home with 3 bedroom and 2 bathroom, good opportunity for investment. A huge game room easy convent to bedroom with great floor plan. Great and quiet neighborhood. Perfect location and close by school!! LOW TAX and HOA. COME TO LOOK AT YOUR NEW HOME!!!' ,`Acres` = '0.1687' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 27 BLK 2 017*I5645955-006-002-027 INWOOD NORTH SEC 6' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7350' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'NITSCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'KLEIN INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Split Level' ,`Subdivision` = 'Inwood North Sec 06' ,`TaxAmount` = '4370' ,`TaxRate` = '2.6485' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705890' WHERE `Matrix_Unique_ID` = '211731035' --> 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','211863151','1663705890','211863151','2022-09-02T09:40:07.380','70966662','Donna Story','Keller Williams Advntge Realty','','','30.766792','-95.510087','26','77320','6','260000.00','Active','Emery Oak','155','Way','Huntsville','2','0','3','1607','Single-Family','This beautiful home is located in the desirable subdivision of Sterling Ridge and is ready for you to make it your own! You will love the bright open-concept floor plan, high ceilings, and large windows. The kitchen offers a breakfast bar, stainless steel appliances, and granite countertops. The split bedroom floor plan arrangement has an oversized primary suite with an ensuite bathroom that has a soaking tub, dual sinks, and a walk-in shower. The small workspace/desk is secluded and perfect for homework or even a home office area. The backyard is fenced and has a patio which is perfect for entertaining family, friends, children, and 4-legged family members.','0.1389','43','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Huntsville Area','Central Gas','1','STERLING RIDGE SEC-2, BLOCK 2, LOT 4','Subdivision Lot','6050','Appraisal District','','370','0','','2','Gas Oven','0','','','Gas Cooktop,Gas Range','','Composition','64 - Huntsville','HUNTSVILLE ELEMENTARY SCHOOL','HUNTSVILLE HIGH SCHOOL','MANCE PARK MIDDLE SCHOOL','Appointment Required,Request Online Appointment,Supra Keybox','Appraisal District','1','Contemporary/Modern,Traditional','Sterling Ridge','3569','1.6534','Public Sewer,Public Water','2019','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T08:56:58.057' ,`MLSNumber` = '39302437' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.381804' ,`Longitude` = '-95.026999' ,`PhotoCount` = '11' ,`PostalCode` = '77568' ,`RoomCount` = '7' ,`ListPrice` = '269990.00' ,`Status` = 'Active' ,`StreetName` = 'Delany Cove' ,`StreetNumber` = '740' ,`StreetSuffix` = 'Court' ,`City` = 'La Marque' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Watermill Collection \"Agora\" Plan with Elevation \"B\" in Delany Cove! This single-story home is great with three bedrooms tucked into a corner at the front of the home and an owner’s suite in back. Down the hall is the open living area, which provides a place to relax and spend time together with a modern kitchen, family room and dining room. *HOME ESTIMATED TO BE COMPLETE, JANUARY, 2023*' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'La Marque' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0014 BLK 001 LOT 015' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '26 - Hitchcock' ,`SchoolElementary` = 'HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HITCHCOCK HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (HITCHCOCK)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Delany Cove' ,`TaxAmount` = '' ,`TaxRate` = '3.2' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705890' WHERE `Matrix_Unique_ID` = '211869888' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T08:56:16.547' ,`MLSNumber` = '81747542' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.381804' ,`Longitude` = '-95.026999' ,`PhotoCount` = '12' ,`PostalCode` = '77568' ,`RoomCount` = '8' ,`ListPrice` = '288990.00' ,`Status` = 'Active' ,`StreetName` = 'Delany Cove' ,`StreetNumber` = '728' ,`StreetSuffix` = 'Court' ,`City` = 'La Marque' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1947' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Watermill Collection Willowford Plan with Elevation \"A\" in Delany Cove! This two-story home has a classic layout that offers space and privacy. The owner’s suite is on the first floor along with the open concept living area, which features a kitchen, family room and dining area. Upstairs are three bedrooms and a loft, which can be used as a game room or additional living space for kids. *HOME ESTIMATED TO BE COMPLETE, JANUARY, 2023*' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'La Marque' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0014 BLK 001 LOT 018' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '26 - Hitchcock' ,`SchoolElementary` = 'HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HITCHCOCK HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (HITCHCOCK)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Delany Cove' ,`TaxAmount` = '' ,`TaxRate` = '3.2' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705890' WHERE `Matrix_Unique_ID` = '211870380' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T09:21:01.103' ,`MLSNumber` = '10414913' ,`ListAgentFullName` = 'Maynor Vega' ,`ListOfficeName` = 'Pivot Up Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.817702' ,`Longitude` = '-95.386340' ,`PhotoCount` = '43' ,`PostalCode` = '77022' ,`RoomCount` = '3' ,`ListPrice` = '499999.00' ,`Status` = 'Active' ,`StreetName` = 'Europa Street' ,`StreetNumber` = '3422' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this lovely 2-story BRAND NEW construction. This is your chance to be the first person to live in this meticulously designed home. \r\n\r\nIt is full of luxurious amenities. Kitchen includes quartz countertops, a mosaic tile backsplash & custom shelving. Features include a pot filler, slide-in natural range, wall mounted range hood, farmhouse kitchen sink, stainless-steel appliances & pantry.\r\n\r\nThe gorgeous living room includes a bar with dual-zone cooler, and electric fireplace decorated by a unique white wave tile design. Upstairs are solid white oak steps leading to classy bedrooms and spa-like bathrooms. The luxury bathrooms feature frameless glass door on both showers. The master bathroom is a true treat, including Italian tile, a free-standing tub, rain shower head, wall-mounted vanity and LED mirrors. Home is prewired for all cable services, plus a ring doorbell. \r\n\r\nCome shine bright in the heart of Houston, close to The Heights, 610, I-45, & minutes away from Downtown.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'MEVS Bldg & Const' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 24 BLK 12' ,`LotDesciption` = 'Cleared' ,`LotSize` = '3000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BURRUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'LINCOLN HEIGHTS' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705891' WHERE `Matrix_Unique_ID` = '211892900' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T09:01:02.600' ,`MLSNumber` = '14475217' ,`ListAgentFullName` = 'Scott Miller' ,`ListOfficeName` = 'RE/MAX Signature Galleria' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.460694' ,`Longitude` = '-95.543997' ,`PhotoCount` = '24' ,`PostalCode` = '77318' ,`RoomCount` = '10' ,`ListPrice` = '229900.00' ,`Status` = 'Active' ,`StreetName` = 'Old Creek' ,`StreetNumber` = '8882' ,`StreetSuffix` = 'Street' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2432' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WOW !!!YOU HAVE TO SEE THIS...Huge ,Beautifully remodeled Mobile Home . 4 beds with 2 full baths. 2400 square feet. HUGE family Room with a Fireplace. Large Living Room open to the kitchen. Large, Massive back Porch over looking the Canal. The home is on an oversized lot sitting on a canal. New AC , New Vinyl Plank flooring, paint , New vanities and New Refrigerator/ Freezer. Metal Roof. . Close to the boat ramp leading to Lake Conroe. 2 oversized living areas. The master has a soaker tub with a separate shower and NEW vanity with double sinks. You will not find a nicer mobile home' ,`Acres` = '0.1928' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WALNUT COVE 01, BLOCK 21, LOT 21-24, MH LABEL # PFS0769469' ,`LotDesciption` = 'Water View' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '54' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'PARMLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Walnut Cove 01' ,`TaxAmount` = '1936' ,`TaxRate` = '1.8448' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663705891' WHERE `Matrix_Unique_ID` = '211899015' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T09:58:25.467' ,`MLSNumber` = '19380179' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = 'Chasity Bufford' ,`SellingOfficeName` = 'The Lakes Group' ,`Latitude` = '29.680822' ,`Longitude` = '-95.902411' ,`PhotoCount` = '11' ,`PostalCode` = '77441' ,`RoomCount` = '11' ,`ListPrice` = '728826.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Oakview' ,`StreetNumber` = '30611' ,`StreetSuffix` = 'Court' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '4214' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Move-in Ready! Located on a huge oversized 14,010 sqft end of cul-de-sac lot, this brick exterior 4,214 sqft ROYAL is one of our most popular floor plans. Featuring double front door, 20ft ceilings, and curved staircase as you walk in, this home boasts 4 bedrooms, 3 full bathrooms, 2 half baths (one up, one down), study, game room, media room with speakers, project & 100ft LED screen, sitting room, and a full 3-car garage. The formal dining room with wine nook and study are off the gallery entrance, and the open-concept kitchen, breakfast room with a window seat, and great room overlook the fireplace and double french doors to the covered patio and backyard. The owner\'s retreat on the main floor is both private and luxurious, with enviable separate walk-in closets and a spacious ensuite that includes dual vanities. The bedrooms on the upper floor each have a large walk-in closet and easy access to the game and media rooms, and bonus sitting room overlooks the great room downstairs.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 34, Block 2, Section 5' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '14010' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fulbrook at Fulshear Creek' ,`TaxAmount` = '' ,`TaxRate` = '2.99' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705891' WHERE `Matrix_Unique_ID` = '211928961' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T09:49:56.927' ,`MLSNumber` = '39306157' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.146795' ,`Longitude` = '-95.678390' ,`PhotoCount` = '11' ,`PostalCode` = '77362' ,`RoomCount` = '12' ,`ListPrice` = '658940.00' ,`Status` = 'Active' ,`StreetName` = 'Walnut Park' ,`StreetNumber` = '814' ,`StreetSuffix` = 'Lane' ,`City` = 'Pinehurst' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3972' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW!! Village Builders Wentworth \'\'New Haven II\'\' Design, Elevation \'\'J\'\' in Woodtrace! 2-Story Home, 5 Bedrooms, 2 Down/4.5 Baths/3 Car Garage. Elegant Entry Foyer, Handsome Study, Formal Dining Room & Breakfast Room. Upstairs Game Room! Gourmet Island Kitchen has 42\" Cabinets, Sparkling Countertops & Great Appliance Pkg! Family Room has a Beautiful Tile Surround Fireplace w/ Maple Mantel. Gorgeous, Resilient Flooring throughout Main Areas. Tile in Full Baths and in Utility Room. Master Suite has Tub, Separate Shower & Large Walk-in Closet. Long,\r\nEXTENDED Covered Rear Patio; Energy Efficient 16 SEER HVAC System & MORE!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Village Builders' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0012 BLK 002 LOT 015' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodtrace' ,`TaxAmount` = '' ,`TaxRate` = '3.4309' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705891' WHERE `Matrix_Unique_ID` = '211938927' --> 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','212038080','1663705891','212038080','2022-09-02T09:25:10.390','66355828','Crystal Mooney','316 Realty Group','','','29.687641','-95.107429','43','77536','7','459900.00','Active','Yellowstone','1606','Drive','Deer Park','2','1','4','3285','Single-Family','Welcome Home! This beautifully maintained 3,285 square feet home features 4 bedrooms/ 2 1/2 baths on an oversized lot in the heart of Deer Park! The primary suite is on the first floor with his/her vanities, a garden tub, separate shower, and a large walk in closet. The downstairs features a large living room with vaulted ceilings, formal dining room, a study/sitting room, a large kitchen with granite counters, breakfast area, and plenty of cabinets for storage. The upstairs features an oversized game room, 3 bedrooms, and a secondary bathroom. The backyard has a large covered patio, a 32 x 12 storage shed and a Generac generator! Some of the updates include: roof in 2017, AC in 2016 and the other one in 2021, dishwasher in 2022, bamboo floors in 2015, and hot water heater in 2020. This home won\'t last long. Schedule your showing today!','0.2731','6','','','Washer Connections','','Sellers Disclosure','1','Gas Connections,Gaslog Fireplace,Wood Burning Fireplace','1','Deer Park','Central Gas','0','LT 39 BLK 6 PARK PLACE SEC 6 R/P','Subdivision Lot','11898','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','16 - Deer Park','DEER PARK ELEMENTARY SCHOOL','DEER PARK HIGH SCHOOL','DEER PARK JUNIOR HIGH SCHOOL','Supra Keybox','Appraisal District','2','Traditional','Park Place Sec 06 R P','10166','2.8239','Public Sewer,Public Water','2002','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','212038951','1663705891','212038951','2022-09-02T09:28:01.550','54132133','Tonya Pressley','Prime Realty Group','','','29.551125','-95.345187','32','77584','6','299999.00','Active','Pecan Grove','2515','Court','Pearland','2','0','3','1668','Single-Family','MOVE IN READY!!! This beautiful home features 3 bedrooms, 2 baths, 2 car garage, a large backyard, shed for extra storage. Lots of upgrade\'s New HVAC Aug 2022, New Roof Aug 2022, All New flooring throughout the home, Fresh Paint, both bathrooms showers have been updated. Refrigerator, Dishwasher and Stove are staying with the home. Call me to schedule your private showing today!','0.2273','5','','','','','Sellers Disclosure','1','Gas Connections','1','Pearland','Central Gas','1','SOUTHWYCK, BLOCK 1, LOT 20 SEC 1-REPLAT, A0242 HT&BRR','Cul-De-Sac','9901','Appraisal District','','350','0','','2','','0','','','Gas Range','','Composition','42 - Pearland','SILVERLAKE ELEMENTARY SCHOOL','GLENDA DAWSON HIGH SCHOOL','BERRY MILLER JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','1','Contemporary/Modern','Southwyck','4977','2.5552','Public Sewer,Public Water','1987','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','212070999','1663705891','212070999','2022-09-02T08:37:31.883','20372516','Phillip Cameron','Cameron Real Estate','','','30.358962','-95.076226','13','77327','5','77000.00','Active','Ross','1728','Avenue','Cleveland','1','0','2','912','Single-Family','Great investment opportunity or Handyman Special! Nice large yard consists of 4 city lots (0.68+ acre). Public water available. 2 bedroom,1 bath home on property needs TLC. Quick access to Hwy 59/69 corridor.','0.688','52','','','','','Estate','0','','','Cleveland Area','Space Heater','0','HOLTS, SEC 1, BLK 5, LOTS 3,4,19,20, ACRES 0.6888','Cleared','30004','Appraisal District','','','0','','0','','0','','','','','Aluminum','100 - Cleveland','NORTHSIDE ELEMENTARY SCHOOL (CLEVELAND)','CLEVELAND HIGH SCHOOL','CLEVELAND MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Holts, Sec 1','','2.5563','Public Water,Septic Tank','1947','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','212075713','1663705891','212075713','2022-09-02T09:55:54.540','11518360','Jared Turner','LennarVillageBldr-JaredTurner','','','29.805790','-95.837319','7','77493','12','624640.00','Active','Sterling Springs','6615','Lane','Katy','4','0','5','3916','Single-Family','NEW! Lennar Texas Reserve \"Galena\" Plan with Elevation \"C\" in Falls at Green Meadows! The spacious two-story Galena plan by Lennar features a welcoming front porch and entry foyer that leads to a handsome study. An inviting casual dining room opens to the generous island kitchen and adjoining breakfast room. The kitchen features a discreetly located large, walk-in pantry and utility room. The large open family room offers access to the covered rear patio as well as a first floor game room. The first floor owner\'s suite features dual sinks, separate shower and corner tub, a private toilet enclosure, and a large walk-in master closet. Two additional secondary bedrooms, a full bath, and a large loft space are located on the second floor. Virtual tour is a representation of the floor plan and not the actual home. **ESTIMATED COMPLETION JANUARY 2023**','','25','Lennar Homes','','','','Other Disclosures','','','','Katy - Old Towne','Central Gas','1','SEC 0007 BLK 004 LOT 002','Subdivision Lot','','','','1100','1','Never Lived In','3','','0','','','','','Composition','30 - Katy','KATY ELEMENTARY SCHOOL','KATY HIGH SCHOOL','KATY JUNIOR HIGH SCHOOL','Appointment Required','Builder','2','Traditional','Falls at Green Meadows','','','Water District','2022','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','212098502','1663705891','212098502','2022-09-02T08:03:13.297','6046862','Ashlee Johnston','Realty ONE Group, Experience','','','30.202226','-95.421091','8','77385','4','399900.00','Active','White Birch','17044','Lane','Conroe','2','1','4','1994','Single-Family','10\' ceilings in kitchen/Living, beautiful open concept. Spacious kitchen with 42\" upper cabinets with large island, granite tops. Bedrooms with huge walk-in closet. Great lighting and all LED! Samsung Stainless Steel appliance package including easy clean top range with electric oven, 3 rack dishwasher, and microwave. 1 year warranty on appliances from Samsung. Ask agent about preferred lender benefits.','0.5246','15','Starter Homes of TX','','Electric Dryer Connections','','No Disclosures','1','','','Spring Northeast','Central Electric','0','S403001 - DOGWOOD FOREST, LOT 95, ACRES 0.5246','Subdivision Lot','22850','Appraisal District','','','1','To Be Built/Under Construction','2','Electric Oven','0','','','Freestanding Range','','Composition','11 - Conroe','SUCHMA ELEMENTARY SCHOOL','OAK RIDGE HIGH SCHOOL','IRONS JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card','Builder','2','Traditional','Dogwood Forest','587','1.8488','Septic Tank,Well','2022','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','212106126','1663705891','212106126','2022-09-02T09:08:31.687','31243889','Rene Sorola','Keller Williams Metropolitan','','','29.282211','-94.813747','31','77551','7','550000.00','Active','Avenue R','4504','','Galveston','3','0','4','2402','Single-Family','Beautiful Island home only 6 Blocks from the Seawall! Open Your Own Bed & Breakfast! Just a short stroll to put your toes in the sand and walk along the beach! Recently updated with all new Plumbing, Laminate flooring, and Foam in the attic and all under the home. Oversized screened back porch with solar screen roof. Fully fenced private backyard with plenty of space adding a pool or entertaining. 2,300 sq. ft. Garage/Workshop. 10x12 guest bedroom with a 3/4 bath, fridge, microwave and TV. Property has so much potential, can be used for Nightly, Weekly or Monthly Rental. Outside A/C Units replaced in 2016 & 2017. Inside units replaced in 2012. Don’t wait, call today to schedule your showing!','0.1771','33','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Midtown - Galveston','Central Gas','0','ABST 628 M B MENARD SUR LOT 9 & E 1/2 OF LOT 10 SE BLK 106 G','Cleared,Subdivision Lot','7716','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Range','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required,Leave Business Card','Appraisal District','2','Traditional','Galveston Outlots','6324','2.0662','Public Sewer,Public Water','1908','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','212113332','1663705891','212113332','2022-09-02T08:50:17.847','72942279','Daisy Lopez','Move Up America','','','29.840853','-95.858726','25','77493','4','317340.00','Active','Malibu Shore','944','Lane','Katy','2','0','3','1518','Single-Family','','','26','Chesmar Homes','','','','No Disclosures','1','','0','Katy - Old Towne','Central Gas,Zoned','1','Lot:60 Block:1 Section:9','Subdivision Lot','','','','1200','1','To Be Built/Under Construction','2','Electric Oven','0','','','Gas Range','','Composition','30 - Katy','ROBERTSON ELEMENTARY SCHOOL (KATY)','KATY HIGH SCHOOL','HASKETT JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,No Appointment Required','Builder','1','Traditional','Sunterra','','3.53','Public Sewer,Public Water,Water District','2022','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','212116236','1663705891','212116236','2022-09-02T09:59:40.563','52699991','Teri Walter','K. Hovnanian of Houston II, LL','','','29.202356','-95.406725','14','77515','10','324080.00','Active','Sun Dial','1715','Drive','Angleton','2','0','3','1660','Single-Family','This Fairbanks home design features 3 bedrooms, 2 baths and 2 car garage. Convenient home office tucked off foyer. Beautiful maple cabinets and quartz countertops with low bar top in kitchen. Huge walk-in closet in owner\'s suite. Double sinks, separate tub and shower in owner\'s bath. Covered patio in backyard, perfect for entertaining. This home is a must see, so schedule your appointment today to find out if this home is the best option for you and your family. \r\nWindrose Green in Angleton offers easy access to Hwy 288 and Hwy 35. Students will have access to a trail which will lead them to Angleton High School. Planned amenities include a neighborhood park with playground and splashpad plus walking trails. Offered by: K. Hovnanian of Houston II, L.L.C.','','5','K.Hovnanian','','Gas Dryer Connections,Washer Connections','','Mud','1','','0','Angleton','Central Gas','1','24/3/1','Cleared,Subdivision Lot','6122','Survey','','750','1','To Be Built/Under Construction','2','Gas Oven,Single Oven','0','','','Gas Range','','Composition','5 - Angleton','RANCHO ISABELLA ELEMENTARY SCHOOL','ANGLETON HIGH SCHOOL','ANGLETON MIDDLE SCHOOL','Accompany,Appointment Required','Builder','1','Traditional','Windrose Green','','3.527','Water District','2022','Builder'); --> New record created successfully