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-08-08T17:53:57.440' ,`MLSNumber` = '73839233' ,`ListAgentFullName` = 'George Gallagher' ,`ListOfficeName` = 'Westwood Shores Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.932664' ,`Longitude` = '-95.339030' ,`PhotoCount` = '29' ,`PostalCode` = '75862' ,`RoomCount` = '3' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'FM 356' ,`StreetNumber` = '17' ,`StreetSuffix` = '' ,`City` = 'Trinity' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1922' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous New Home Construction! Located in the Lovely Westwood Shores Community! This New Home Includes 3 Bedrooms, 2 & 1/2 Bathrooms, High Ceilings, Wood Burning Fireplace in Livingroom, Spacious Kitchen with Island, 2 Walk-In Closets, 1 Located in the Master Bedroom and the other in the Master Bath, Granite Countertops in the Kitchen and Bathrooms, Tile Flooring throughout the Home, Marble Tub/Shower Combo in Guest Bath, Marble Walk-In Shower and Separate Soaking Tub in the Master Bath. Covered Back Porch and Beautiful Views to go Along with It! Not to Mention that there are 9 Interior Fishing lakes, 24HR Manned Access Gate, 18 Hole Golf Course, Country Club with 19th Hole Bar&Grill, Fitness Center, Pool, Tennis Court, Marina/Country Store, Access to Campground and So Much More!!!! Please Call For More Information!' ,`Acres` = '0.4151' ,`Area` = '42' ,`BuilderName` = 'A G Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SPRING LAKE ESTATES, BLOCK 1 LOT 3' ,`LotDesciption` = 'In Golf Course Community,Water View' ,`LotSize` = '18081' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2244' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (TRINITY)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westwood Shores' ,`TaxAmount` = '' ,`TaxRate` = '2.5863' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663695976' WHERE `Matrix_Unique_ID` = '203848490' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T16:24:05.103' ,`MLSNumber` = '32331742' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.834259' ,`Longitude` = '-95.724969' ,`PhotoCount` = '8' ,`PostalCode` = '77449' ,`RoomCount` = '10' ,`ListPrice` = '445315.00' ,`Status` = 'Active' ,`StreetName` = 'Gohan' ,`StreetNumber` = '20634' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1917' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. You don’t want to miss this gorgeous Postwood Home in Westfield Ranch! Nestled on a corner lot, this 3-sided brick home boasts a premium elevation, tile flooring, crown molding, faux wood blinds, full gutters, a sprinkler system, and a covered patio. Master new recipes in the island kitchen, fully equipped with granite countertops, a tile backsplash, stainless steel appliances, 42” upper cabinets, and pendant lighting. Community amenities include a playground, splash pad, and sports field. Located off Fry Road and the Grand Parkway, residents have quick access to a variety of popular restaurants and shopping centers, including the Katy Mills Mall. Students attend schools in the highly acclaimed Cypress-Fairbanks ISD. Don’t wait – call now for more information!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Postwood Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 14 Block 3' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'M ROBINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (CY-FAIR)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westfield Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.32' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663695976' WHERE `Matrix_Unique_ID` = '207149397' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T16:42:48.720' ,`MLSNumber` = '15840106' ,`ListAgentFullName` = 'Trisha Hope' ,`ListOfficeName` = 'Logos Investment Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.289990' ,`Longitude` = '-94.798072' ,`PhotoCount` = '48' ,`PostalCode` = '77550' ,`RoomCount` = '12' ,`ListPrice` = '839000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue P' ,`StreetNumber` = '3018' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2728' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Historic charm with all the conveniences of a new home. This house was reconstructed from the studs in with energy efficient subflooring with foam insulation including all exteriors walls and attic, windstorm rated windows throughout, all framing up to windstorm code, replaced underground electrical and HVAC systems, updated plumbing and a sprinkler system all work properly permitted. Huge island kitchen with soft close drawers, 2 master bedrooms one downstairs, one upstairs, 3 additional large bedrooms and an upstairs media/gameroom. The laundry room can accommodate 2 sets of full size washers and dryers, 13\' high ceilings upstairs 10\' downstairs with beautiful 8\' doors throughout, handcrafted baseboards and trim work makes this home feel historic with all the benefits of new construction. Enjoy the back deck, lawn and off street gated parking. This home is truly special come see for yourself!' ,`Acres` = '0.118' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOT 12 SW BLK 64 GALVESTON OUTLOTS' ,`LotDesciption` = 'Other' ,`LotSize` = '5140' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Craftsman' ,`Subdivision` = 'Galveston Outlots' ,`TaxAmount` = '5744' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1890' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663695976' WHERE `Matrix_Unique_ID` = '207785259' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T16:23:15.887' ,`MLSNumber` = '15748372' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.834259' ,`Longitude` = '-95.724969' ,`PhotoCount` = '14' ,`PostalCode` = '77449' ,`RoomCount` = '9' ,`ListPrice` = '380415.00' ,`Status` = 'Active' ,`StreetName` = 'Medrano' ,`StreetNumber` = '4539' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1416' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. You don’t want to miss this stunning Lake Ridge Builders home in Westfield Ranch. Nestled on a corner lot, this 3-sided brick home boasts tile flooring, faux wood blinds, a sprinkler system, and a rear patio. Whip up meals in the island kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, and 42” upper cabinets. The spa-like primary suite features dual vanities, a 36” tub, and a separate shower. Community amenities include a playground, splash pad, and sports field. Located off Fry Road and the Grand Parkway, residents have quick access to a variety of popular restaurants and shopping centers, including the Katy Mills Mall. Students attend schools in the highly acclaimed Cypress-Fairbanks ISD. Don’t wait – call now for more information!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 17 Block 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'M ROBINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (CY-FAIR)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westfield Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.32' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663695976' WHERE `Matrix_Unique_ID` = '208156517' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T16:06:24.193' ,`MLSNumber` = '5517161' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.529958' ,`Longitude` = '-95.467374' ,`PhotoCount` = '16' ,`PostalCode` = '77545' ,`RoomCount` = '6' ,`ListPrice` = '334900.00' ,`Status` = 'Active' ,`StreetName` = 'Hawthorne Glen' ,`StreetNumber` = '3926' ,`StreetSuffix` = 'Court' ,`City` = 'Fresno' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2407' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1559' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ESTATES OF TEAL RUN SEC 5, BLOCK 1, LOT 6' ,`LotDesciption` = 'Other' ,`LotSize` = '6792' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'GOODMAN ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'HIGHTOWER HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Estates Of Teal Run Sec 5' ,`TaxAmount` = '4977' ,`TaxRate` = '2.4829' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695977' WHERE `Matrix_Unique_ID` = '208448495' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T16:29:18.823' ,`MLSNumber` = '11016845' ,`ListAgentFullName` = 'Amy Bernstein' ,`ListOfficeName` = 'Bernstein Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.686585' ,`Longitude` = '-95.470882' ,`PhotoCount` = '50' ,`PostalCode` = '77096' ,`RoomCount` = '11' ,`ListPrice` = '1749000.00' ,`Status` = 'Active' ,`StreetName` = 'Indigo' ,`StreetNumber` = '5150' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '5528' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning new construction Mediterranean home by Granit Builders offers a striking elevation with reclaimed Chicago bricks. The open first floor includes a stunning dining room w/ reclaimed Chicago brick wall, huge windows overlooking the front porch & a well appointed wine room. Grand living room features prime white oak hardwood floors, venetian plaster surround gaslog fireplace, reclaimed wood mantle & is open to the impressive chef\'s kitchen featuring 2 islands, 2 Thermador ovens, 6 burner gas range, pot filler, 2 sinks, & 2 large walk in pantries. Expansive primary suite features spa inspired bath w/ soaking tub, walk in shower, massive closet, wet bar & even a private laundry room. Upstairs are 3 bedrooms all w/ luxurious ensuite baths, game/media room w/ access to wrap around balcony, a wet bar & built in desk. Luxurious finishes throughout w/ Quartzite & granite counters, reclaimed wood beams & even a prewired elevator shaft. Covered patio with wet bar overlooks large backyard!' ,`Acres` = '0.2943' ,`Area` = '20' ,`BuilderName` = 'Granit Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Meyerland Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 16 MEYERLAND SEC 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '12820' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '557' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean,Spanish' ,`Subdivision` = 'Meyerland' ,`TaxAmount` = '20193' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663695977' WHERE `Matrix_Unique_ID` = '208661527' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T16:14:41.180' ,`MLSNumber` = '27599552' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.548346' ,`Longitude` = '-95.340944' ,`PhotoCount` = '16' ,`PostalCode` = '77584' ,`RoomCount` = '7' ,`ListPrice` = '334900.00' ,`Status` = 'Active' ,`StreetName` = 'Pecan Grove' ,`StreetNumber` = '4918' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2320' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1629' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SOUTHWYCK, BLOCK 7, LOT 14 SEC 1-REPLAT, A0242 HT&BRR' ,`LotDesciption` = 'Other' ,`LotSize` = '7096' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'SILVERLAKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'BERRY MILLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Southwyck' ,`TaxAmount` = '5958' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695977' WHERE `Matrix_Unique_ID` = '208978349' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T16:17:44.897' ,`MLSNumber` = '85017476' ,`ListAgentFullName` = 'Kristin McAlister' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.822037' ,`Longitude` = '-95.440102' ,`PhotoCount` = '32' ,`PostalCode` = '77018' ,`RoomCount` = '3' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'Ebony' ,`StreetNumber` = '1615' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1018' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! Located in the desirable Oak Forest area- shopping, dining, entertainment and outdoor activities are in walking distance! This layout is perfect for entertaining and will not disappoint. The backyard space is truly an oasis featuring a fire pit area and deck with covered pergola overlooking the lush, manicured landscaping. The backyard truly is a showpiece! This immaculately cared for home boasts a ton of updates! Some of which include: PEX re-pipe, recent roof replacement with radiant roof barrier and gutter upgrade, siding replacement and painting, electrical upgrade/update, sprinkler installation, garage Elfa organization system, front window replacement, water heater replacement and more. Additionally, inside, the original floors have been refinished, cabinets have been painted, SS appliances upgraded (washer and dryer included), and Elfa system in master bedroom. This home truly is a must see- schedule your tour today!' ,`Acres` = '0.1653' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 34 BLK 47 OAK FOREST SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'STEVENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Forest Sec 06' ,`TaxAmount` = '8531' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695977' WHERE `Matrix_Unique_ID` = '209342800' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T16:21:33.117' ,`MLSNumber` = '471824' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.836221' ,`Longitude` = '-95.727779' ,`PhotoCount` = '42' ,`PostalCode` = '77449' ,`RoomCount` = '13' ,`ListPrice` = '438780.00' ,`Status` = 'Active' ,`StreetName` = 'Medrano' ,`StreetNumber` = '4514' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2620' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This house is under construction. You don’t want to miss this incredible Lake Ridge Builders home in Westfield Ranch. This 4-sided brick home boasts a premium elevation, tile flooring, crown molding, faux wood blinds, a direct vent fireplace, dual vanities in the primary suite, and a covered patio. Master new recipes in the kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, and 42” upper cabinets. Community amenities include a playground, splash pad, and sports field. Located off Fry Road and the Grand Parkway, residents have quick access to a variety of popular restaurants and shopping centers, including the Katy Mills Mall. Students attend nearby schools in the highly acclaimed Cypress-Fairbanks ISD. Don’t wait – call today for more information!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'M ROBINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (CY-FAIR)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westfield Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.32' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663695977' WHERE `Matrix_Unique_ID` = '209390525' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T17:45:12.873' ,`MLSNumber` = '14968164' ,`ListAgentFullName` = 'Lucia Clark' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.320097' ,`Longitude` = '-95.334005' ,`PhotoCount` = '24' ,`PostalCode` = '77306' ,`RoomCount` = '10' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Schank' ,`StreetNumber` = '15401' ,`StreetSuffix` = 'Road' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2070' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME HOME! 15401 Schank Rd. This well-maintained single story 3 bedroom, 2.5 bath home is ready for move-in! The open floorplan and natural light make this home feel spacious and comfortable. The kitchen features granite countertops, stainless steel appliances, and walk-in pantry. The home\'s location is in close proximity to shopping and restaurants and allows for a quick commute. Take a look at this beautiful home today.' ,`Acres` = '0.265' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S515700 - FOREST TRACE NORTH 01, BLOCK 2, LOT 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11543' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'CREIGHTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Forest Trace North' ,`TaxAmount` = '3497' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695977' WHERE `Matrix_Unique_ID` = '209399701' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T17:52:52.170' ,`MLSNumber` = '84843809' ,`ListAgentFullName` = 'Megan Ennis' ,`ListOfficeName` = 'Monarch Real Estate & Ranch' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.118345' ,`Longitude` = '-94.894253' ,`PhotoCount` = '26' ,`PostalCode` = '77535' ,`RoomCount` = '4' ,`ListPrice` = '399990.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 6507' ,`StreetNumber` = '168' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2409' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 168 County Road 6507! This home sits on a 2.4 acre lot and offers a spacious 2,409 sq/ft of living space with 4 bedrooms, 2.5 bathrooms, sits on a quiet street with beautiful open spaces, brick exterior, and enclosed 25x50ft workshop or additional storage! You\'ll love all the incredible features this home has to offer, including a spacious living room with cozy fireplace and vaulted ceilings, wood cabinets, covered back patio, tall trees throughout the property, and so much more! Updates include new PEX plumbing and A/C units in 2021 and 2016. Winter Valley is minutes from 321 and 1008 - in an excellent location! Schedule your private showing today!' ,`Acres` = '2.4' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WINTER VALLEY, LOT 299 300, ACRES 2.4' ,`LotDesciption` = 'Cleared' ,`LotSize` = '104544' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (DAYTON)' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Winter Valley' ,`TaxAmount` = '4643' ,`TaxRate` = '1.7512' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695977' WHERE `Matrix_Unique_ID` = '209833287' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T16:21:52.990' ,`MLSNumber` = '60964935' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.833847' ,`Longitude` = '-95.725955' ,`PhotoCount` = '12' ,`PostalCode` = '77449' ,`RoomCount` = '11' ,`ListPrice` = '427515.00' ,`Status` = 'Active' ,`StreetName` = 'Medrano' ,`StreetNumber` = '4503' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1869' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. Enjoy every moment spent in this charming Lake Ridge Builders home in Westfield Ranch. Situated on a spacious corner lot, this 3-sided brick home boasts a stone front, no back neighbors, tile flooring, full gutters, a sprinkler system, and a covered patio. Create new recipes in the island kitchen, equipped with granite countertops, stainless steel appliances, and 42” upper cabinets. The serene primary suite features dual vanities, a 42” tub, and a separate shower. Community amenities include a playground, splash pad, and sports field. Located off Fry Road and the Grand Parkway, residents have quick access to a variety of popular restaurants and shopping centers, including the Katy Mills Mall. Students attend nearby schools in the highly acclaimed Cypress-Fairbanks ISD. Don’t wait – call today for more information!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 8 Block 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'M ROBINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (CY-FAIR)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westfield Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.32' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663695978' WHERE `Matrix_Unique_ID` = '210088097' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T16:20:27.053' ,`MLSNumber` = '29782870' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.833847' ,`Longitude` = '-95.725955' ,`PhotoCount` = '13' ,`PostalCode` = '77449' ,`RoomCount` = '10' ,`ListPrice` = '417090.00' ,`Status` = 'Active' ,`StreetName` = 'Hronas' ,`StreetNumber` = '4402' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1776' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. Live comfortably in this incredible Lake Ridge Builders home in Westfield Ranch. Situated on a cul-de-sac lot, this 3-sided brick home boasts a stone front, no back neighbors, tile flooring, full gutters, a sprinkler system, and a covered patio. Master new recipes in the kitchen, equipped with granite countertops, stainless steel appliances, and 42” upper cabinets. Complete with dual vanities, a 42” tub, and a separate shower, the primary suite is ideal for unwinding. Community amenities include a playground, splash pad, and sports field. Located off Fry Road and the Grand Parkway, residents have quick access to a variety of popular restaurants and shopping centers, including the Katy Mills Mall. Students attend nearby schools in the highly acclaimed Cypress-Fairbanks ISD. Don’t wait – call today for more information!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7 Block 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'M ROBINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (CY-FAIR)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westfield Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.32' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663695978' WHERE `Matrix_Unique_ID` = '210133389' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T17:13:22.837' ,`MLSNumber` = '60477917' ,`ListAgentFullName` = 'Erick Harbert' ,`ListOfficeName` = 'Realty Right' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.927910' ,`Longitude` = '-95.576657' ,`PhotoCount` = '50' ,`PostalCode` = '77064' ,`RoomCount` = '4' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Autumn Harvest' ,`StreetNumber` = '10511' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1560' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your beautiful 1 Story Home. You will fall in love with this 4 bedroom 2 bath home. The open floor plan makes this an ideal setting for gathering with family and friends. The dining room is open to the living room. The charming kitchen has a window sink, pantry, and plenty of counter space. The living room has a beautiful fireplace, a bonus to the living space is the patio door which can extend your entertaining space even further as you step out unto the patio and spacious backyard. 3 bedrooms and a full bathroom are found in their own wing of the home. The secluded primary suite is well kept off of the living space with plenty of natural light. The ensuite bath has a large vanity with double sinks and a deep, soaker tub. The back yard boast a nice patio ready for family, pets, bbq and entertaining. This home is a must see.' ,`Acres` = '0.163' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Willowbrook South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 2 HARVEST BEND SEC 3' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '411' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'FRANCONE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'CAMPBELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harvest Bend Sec' ,`TaxAmount` = '4363' ,`TaxRate` = '2.5587' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695978' WHERE `Matrix_Unique_ID` = '210455911' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T16:20:08.630' ,`MLSNumber` = '25478362' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.833847' ,`Longitude` = '-95.725955' ,`PhotoCount` = '12' ,`PostalCode` = '77449' ,`RoomCount` = '11' ,`ListPrice` = '435855.00' ,`Status` = 'Active' ,`StreetName` = 'Hronas' ,`StreetNumber` = '4503' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1869' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. Create unforgettable moments in this lovely Lake Ridge Builders Home in Westfield Ranch. Resting on a corner lot, this 3-sided brick home boasts a stone front, tile flooring, full gutters, a sprinkler system, and a covered patio. Whip up meals for guests in the island kitchen, equipped with granite countertops, stainless steel appliances, and 42” upper cabinets. Complete with dual vanities, a 42” tub, and a separate shower, the primary suite is perfect for relaxation. Community amenities include a playground, splash pad, and sports field. Located off Fry Road and the Grand Parkway, residents have quick access to a variety of popular restaurants and shopping centers, including the Katy Mills Mall. Students attend nearby schools in the highly acclaimed Cypress-Fairbanks ISD. Don’t wait – call today for more information!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 31 Block 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'M ROBINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (CY-FAIR)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westfield Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.32' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663695978' WHERE `Matrix_Unique_ID` = '210636227' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T17:57:16.613' ,`MLSNumber` = '38469324' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.836221' ,`Longitude` = '-95.727779' ,`PhotoCount` = '8' ,`PostalCode` = '77449' ,`RoomCount` = '16' ,`ListPrice` = '508850.00' ,`Status` = 'Active' ,`StreetName` = 'Enrique' ,`StreetNumber` = '20607' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3232' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. Seek comfort in this incredible Postwood Home in Westfield Ranch. This 4-sided brick home boasts tile flooring, full gutters, a sprinkler system, open ceilings in the entryway, curved staircase, wrought iron spindles, faux wood blinds, cast stone fireplace, guest suite, study with French doors, and a covered patio. Create new recipes in the kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, and 42” upper cabinets. Community amenities include a playground, splash pad, and sports field. Located off Fry Road and the Grand Parkway, residents have quick access to a variety of popular restaurants and shopping centers, including the Katy Mills Mall. Students attend nearby schools in the highly acclaimed Cypress-Fairbanks ISD. Don’t wait – call today for more information!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Postwood Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'M ROBINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (CY-FAIR)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westfield Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.32' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663695978' WHERE `Matrix_Unique_ID` = '210639315' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T16:22:23.393' ,`MLSNumber` = '89697857' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.834259' ,`Longitude` = '-95.724969' ,`PhotoCount` = '15' ,`PostalCode` = '77449' ,`RoomCount` = '9' ,`ListPrice` = '401060.00' ,`Status` = 'Active' ,`StreetName` = 'Medrano' ,`StreetNumber` = '4510' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1416' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. Fall in love with this stunning Lake Ridge Builders Home in Westfield Ranch. Nestled on a spacious corner lot, this 3-sided brick home boasts a stone front, tile flooring, full gutters, a sprinkler system, and a covered patio. Prepare incredible feasts in the island kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, and 42” upper cabinets. Unwind in the tranquil primary suite, featuring dual vanities, a 42” tub, and a separate shower. Community amenities include a playground, splash pad, and sports field. Located off Fry Road and the Grand Parkway, residents have quick access to a variety of popular restaurants and shopping centers, including the Katy Mills Mall. Students attend nearby schools in the highly acclaimed Cypress-Fairbanks ISD. Don’t wait – call today for more information!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1 Block 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'M ROBINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (CY-FAIR)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westfield Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.32' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663695978' WHERE `Matrix_Unique_ID` = '210642199' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T17:54:31.213' ,`MLSNumber` = '13028254' ,`ListAgentFullName` = 'Michael Flores' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.468847' ,`Longitude` = '-95.563069' ,`PhotoCount` = '35' ,`PostalCode` = '77318' ,`RoomCount` = '6' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Paradise Point' ,`StreetNumber` = '15743' ,`StreetSuffix` = 'Drive' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you\'ve been looking to escape the fast pace of city life...look no further! This 3 bedroom, 2 bathroom home sitting on almost an acre has plenty of room to spread out for those who appreciate the quiet, privacy & open sky of the country. Kitchen has been recently remodeled; featuring induction cooktop with vent hood, double ovens, granite countertops, sleek stainless appliances & tile backsplash. Generous sized living room has plenty of space for your oversized couches. Sizeable primary bedroom features en suite bathroom with dual vanity, large soaking tub & separate shower. Two spacious secondary bedrooms & full bathroom with shower/tub combo. Screened front porch and large back deck with 50\' dog run. Property features possible income producing opportunity with 4 RV hookups & septic for each. Recent tree trimming, roof, paint, deck refinish, 50\' carport & much more. Approximately 5 miles from I-45 & 2 BLOCKS to LAKE CONROE for GREAT fishing & boating! No HOA, No Deed Restrictions!' ,`Acres` = '0.824' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PARADISE RIDGE, BLOCK 3, LOT 1' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '35893' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'PARMLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Paradise Ridge' ,`TaxAmount` = '1162' ,`TaxRate` = '1.8448' ,`WaterSewer` = 'Public Sewer,Septic Tank,Well' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695978' WHERE `Matrix_Unique_ID` = '210825378' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T16:21:09.763' ,`MLSNumber` = '62747428' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.833847' ,`Longitude` = '-95.725955' ,`PhotoCount` = '12' ,`PostalCode` = '77449' ,`RoomCount` = '11' ,`ListPrice` = '398140.00' ,`Status` = 'Active' ,`StreetName` = 'Medrano' ,`StreetNumber` = '4626' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1869' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. Enjoy every moment spent in this lovely Lake Ridge Builders home in Westfield Ranch. Nestled on a spacious lot, this 3-sided brick home boasts tile flooring, full gutters, and a sprinkler system. Try a new recipe in the kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, and 42” upper cabinets. The spa-like primary suite features dual vanities, a 42” tub, and a separate shower. Community amenities include a playground, splash pad, and sports field. Located off Fry Road and the Grand Parkway, residents have quick access to a variety of popular restaurants and shopping centers, including the Katy Mills Mall. Students attend nearby schools in the highly acclaimed Cypress-Fairbanks ISD. Don’t wait – call today for more information!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 16 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'M ROBINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (CY-FAIR)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westfield Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.32' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663695979' WHERE `Matrix_Unique_ID` = '210830171' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T16:16:12.140' ,`MLSNumber` = '72705108' ,`ListAgentFullName` = 'Stephanie Cardoso' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.159370' ,`Longitude` = '-95.085014' ,`PhotoCount` = '20' ,`PostalCode` = '77327' ,`RoomCount` = '4' ,`ListPrice` = '215990.00' ,`Status` = 'Active' ,`StreetName` = 'Road 5102 B' ,`StreetNumber` = '80' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1155' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to The Cottage Plan by Casas Houston! This Gorgeous home sits on 0.16 of an acre in a low tax rate area with HOA. This open floor plan has 9-foot ceilings, recessed lights, luxury resilient flooring, rounded sheetrock corners. Your inviting open concept kitchen features 42\'\' floor cabinets and 36\'\' upper cabinets, granite countertops with backsplash and satin nickel hardware throughout, crown molding, Frigidaire Stainless on Black appliance package, under cabinet lighting and more. Stop by the model home or call for more information!' ,`Acres` = '' ,`Area` = '52' ,`BuilderName` = 'Casas Houston' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6447, BLK 50, Santa Fe Section 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe' ,`TaxAmount` = '' ,`TaxRate` = '1.98' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663695979' WHERE `Matrix_Unique_ID` = '210923602' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T17:20:16.427' ,`MLSNumber` = '53316749' ,`ListAgentFullName` = 'Penne Mayer' ,`ListOfficeName` = 'Coldwell Banker Southern Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.072573' ,`Longitude` = '-94.181236' ,`PhotoCount` = '47' ,`PostalCode` = '77707' ,`RoomCount` = '8' ,`ListPrice` = '245000.00' ,`Status` = 'Active' ,`StreetName` = 'Coburn' ,`StreetNumber` = '7610' ,`StreetSuffix` = 'Drive' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1860' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SITTING PRETTY On OVER HALF ACRE IN THE CITY! Beautiful Elegant Updated Home, Immaculately Maintained Sitting on Large Tree Shaded Lot Over .55 Acre. Country Feel & Appeal with City Convenience. Quality High End Updates Include Freshly Poured Sidewalk & Driveway that is GIGANTIC. You Will Love the Extra Parking & Backyard Access. Great Kitchen with Gorgeous Custom Cabinet Rich Built-ins in Living Area are Wonderfully Designed. Fabulous Luxury Wood Vinyl Plank Flooring, Exquisite Fixtures Throughout. Incredible Primary Bath Transformed 2018/2022 with Huge Walk-in Shower. You\'ll Love the High-End Updates, Tile & Wood floors throughout. Magnificent Designer Colors, Craftsmanship & Selections. Fantastic Open Floor Plan with Two Sets of Large 8\' Doors Overlooking Picturesque Back Patio & Private Paradise. No History of Flooding. This One is a Treasure Complete with Workshop off the Garage Plus Carport for Boat or Additional Parking. Home Sweet Home Has Arrived! Perfectly Pristine!' ,`Acres` = '0.551' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'FOREST PARK L6 B6' ,`LotDesciption` = 'Cleared' ,`LotSize` = '24000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'AMELIA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'VINCENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Forrest Park' ,`TaxAmount` = '3638' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695979' WHERE `Matrix_Unique_ID` = '211113408' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T17:43:50.353' ,`MLSNumber` = '32604680' ,`ListAgentFullName` = 'Angela Kennedy' ,`ListOfficeName` = 'Keller Williams Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.252931' ,`Longitude` = '-95.972902' ,`PhotoCount` = '43' ,`PostalCode` = '75833' ,`RoomCount` = '7' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Idlewilde' ,`StreetNumber` = '273' ,`StreetSuffix` = '' ,`City` = 'Centerville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1408' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WOW! Beautiful 2016 custom brick home in like new condition in Centerville! The first thing you\'ll notice as you pull up to this home is the gorgeous landscaping, covered front porch & nice concrete driveway. Enjoy the open and spacious feel of the well-lit living room, kitchen & breakfast room with 9\' ceilings, stylish laminate floors, and a neutral color palette. The kitchen includes finishes you\'ll also appreciate, incl. granite countertops, stained cabinetry, tile backsplash, & a large breakfast bar island with storage underneath. A spacious primary bedroom with en suite bath has dual sinks, private water closet & a walk-in closet. On the other side of this split floor plan are two more ample sized bedrooms and guest bath. The utility room features cabinetry matching the kitchen, a drip dry area and room for a small freezer. A back deck overlooks the large privacy fenced backyard complete with a 12x16 storage building with electricity & workbenches installed. Truly move-in ready!' ,`Acres` = '0.3306' ,`Area` = '63' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Centerville/Leona Area' ,`HeatSystem` = 'Central Electric,Wall Heater' ,`HOAMandatory` = '0' ,`Legal` = 'HIDDEN ACRES / CENTERVILLE CITY BLK 2 LT 2 .3306 AC AB 510 F' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14401' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '155 - Centerville (Leon)' ,`SchoolElementary` = 'CENTERVILLE ELEMENTARY SCHOOL (CENTERVILLE-LEON)' ,`SchoolHigh` = 'CENTERVILLE JUNIOR-SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'CENTERVILLE JUNIOR-SENIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hidden Acres' ,`TaxAmount` = '3430' ,`TaxRate` = '2.0943' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695979' WHERE `Matrix_Unique_ID` = '211175326' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T17:37:11.820' ,`MLSNumber` = '41491940' ,`ListAgentFullName` = 'Rachael Parker' ,`ListOfficeName` = 'Lake Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.194115' ,`Longitude` = '-94.067402' ,`PhotoCount` = '26' ,`PostalCode` = '75930' ,`RoomCount` = '2' ,`ListPrice` = '109000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 439e' ,`StreetNumber` = '784' ,`StreetSuffix` = '' ,`City` = 'Bronson' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '896' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Waterview Gem in Parkway II with views of the lake on 2 sides of the property! Home is being sold completely furnished so bring your clothes and toothbrush and start living the lake life! Only a short distance to boat launch and community access to the lake, so no worries about loading your boat everyday. The covered front porch is the perfect place to enjoy your morning coffee while looking out over the lake. Large carport to park your boat and toys! With just under an acre of land there is plenty of room to add any buildings that you may need. Schedule your appointment today!' ,`Acres` = '' ,`Area` = '78' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'LT 99 PARKWAY II SEC 2 & IMPROVEMENT' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '144 - Brookeland' ,`SchoolElementary` = 'BROOKELAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BROOKELAND HIGH SCHOOL' ,`SchoolMiddle` = 'BROOKELAND HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Parkway II Sub Sec 2' ,`TaxAmount` = '190' ,`TaxRate` = '1.3093' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '0' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695979' WHERE `Matrix_Unique_ID` = '211189607' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T17:59:03.470' ,`MLSNumber` = '37870168' ,`ListAgentFullName` = 'Charles Schrader' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.151545' ,`Longitude` = '-94.736532' ,`PhotoCount` = '29' ,`PostalCode` = '77575' ,`RoomCount` = '8' ,`ListPrice` = '339500.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 2010' ,`StreetNumber` = '198' ,`StreetSuffix` = '' ,`City` = 'Hardin' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1936' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this show stopper. Completely remodeled home in 2019. 3 Bedroom 2 bathroom home just under 2,000 total sf located in Hardin, Tx. In 2019 home had new flooring, new master bathroom, kitchen island, an inground gunite pool, and a pool house complete with a bathroom. Did I mention that the home sits on just over 2 acres which is fenced and cross fenced. Outside there is a pole barn, covered RV Storage, and a shop with utilities. So much opportunity with this gem. Call today for a showing. Pictures will be updated soon.' ,`Acres` = '2.13' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Liberty County East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '000222 M A HARDIN, TRACT 15, ACRES 1.5' ,`LotDesciption` = 'Cleared' ,`LotSize` = '92656' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '107 - Hardin' ,`SchoolElementary` = 'HARDIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARDIN HIGH SCHOOL' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Lockbox Front,No Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'M A Hardin' ,`TaxAmount` = '3284' ,`TaxRate` = '2.2551' ,`WaterSewer` = 'Public Sewer,Public Water,Well' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695979' WHERE `Matrix_Unique_ID` = '211192418' --> Updated record success