Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T22:51:29.580' ,`MLSNumber` = '43927599' ,`ListAgentFullName` = 'Krystal Bradford' ,`ListOfficeName` = 'Krystal Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.144791' ,`Longitude` = '-95.043987' ,`PhotoCount` = '34' ,`PostalCode` = '77554' ,`RoomCount` = '8' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Reeves' ,`StreetNumber` = '4010' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1182' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cute Beach Cottage....Desirable Sea Isle home offers a style that brings together cozy & casual elements to reflect an easy-going way of coastal life. Large open kitchen with ample counter & cabinet space. Living & dining has good space & fireplace with raised hearth. Downstairs offers 290 sq. ft. of air conditioned bonus space... could be bedroom, game room or multipurpose room! Other features include luxury wood laminate floors, covered decks to enjoy the beautiful sunrise & sunsets & hear the waves, huge tandem sized garage, tons of space, washer & dryer as well as a half bath. New AC 7-25-22. Doublewide drive offers great space for ample parking. Park a boat or RV Large backyard, outdoor shower & more! Sea Isle offers: pool, boat ramp, fishing pier, sports courts, Clay Walkers West End restaurants, Marina store & playground. New Beachside Bar & Grill at neighborhood entrance. Higher elevated than other surrounded homes & downstairs has NEVER flooded.' ,`Acres` = '0.1377' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Special Addendum' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 19 LOT 657 SEA ISLE' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '236' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Lockbox Left Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sea Isle Orig' ,`TaxAmount` = '5775' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1666677672' WHERE `Matrix_Unique_ID` = '207124275' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T22:21:40.187' ,`MLSNumber` = '30436140' ,`ListAgentFullName` = 'Jennie Green-Prats' ,`ListOfficeName` = '1st Choice Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.061238' ,`Longitude` = '-95.625193' ,`PhotoCount` = '7' ,`PostalCode` = '77422' ,`RoomCount` = '4' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 347' ,`StreetNumber` = '3690 and 3698' ,`StreetSuffix` = '' ,`City` = 'Brazoria' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1280' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 tracts of land outside of Brazoria on CR 347. There is a 4 acre tract and a 8 acre tract. Each tract has its own aerobic septic system. They share a water well and a driveway. There is a mobile home on the 8a acre lot that is currently occupied. The land is cleared around the mobile home. The rest is native timber and undergrowth.\r\nThere was a mobile home on the 4 acre tract, but it was heavily damaged during Harvey. The other home was damaged during Harvey, but has been raised and remodeled.' ,`Acres` = '4.044' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0020 S F AUSTIN TRACT 13N6 (DIV 9) ACRES 4.044 and A0020 S' ,`LotDesciption` = 'Wooded' ,`LotSize` = '176157' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Photos/No Videos' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'S F Austin' ,`TaxAmount` = '1152' ,`TaxRate` = '1.6567' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666677672' WHERE `Matrix_Unique_ID` = '207194707' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T22:19:30.397' ,`MLSNumber` = '85443912' ,`ListAgentFullName` = 'Lori Barnett' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.942850' ,`Longitude` = '-95.724496' ,`PhotoCount` = '31' ,`PostalCode` = '77433' ,`RoomCount` = '8' ,`ListPrice` = '430000.00' ,`Status` = 'Active' ,`StreetName` = 'Paynes Creek' ,`StreetNumber` = '16814' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2404' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME to this 1-story craftsman-style David Weekley home located in the highly desirable Lakeland Heights subdivision of Bridgeland! High ceilings throughout with an open concept main living space. Primary suite is located at the front of the home with a water view! Kitchen has granite countertops, a large island, and lots of cabinets for storage! There is a home office/study, a multi-purpose area/space between the 2nd and 3rd bedrooms, and a large laundry room. This home has solar panels and an EV charger in the garage. There’s an amenity center with a new gym, tennis courts, a pool and water slides as well as parks, restaurants, and shops all within walking distance. Schedule your showing today!' ,`Acres` = '0.1463' ,`Area` = '25' ,`BuilderName` = 'David Weekley' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas,Solar Assisted' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 1 LAKELAND HEIGHTS SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6375' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1305' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WELLS ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Lakeland Heights Sec 03' ,`TaxAmount` = '10299' ,`TaxRate` = '3.4329' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666677672' WHERE `Matrix_Unique_ID` = '209282487' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T22:49:32.800' ,`MLSNumber` = '28441117' ,`ListAgentFullName` = 'Vania Yagelski' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.820695' ,`Longitude` = '-95.733832' ,`PhotoCount` = '38' ,`PostalCode` = '77449' ,`RoomCount` = '8' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Rainshore' ,`StreetNumber` = '3503' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2330' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the beautiful house with high ceiling, gourmet kitchen with granite countertops, kitchen island and stainless steel appliances. The first floor has tile and extensive engineered wood floor, and includes the formal living/dining area, open concept kitchen into the large family room, utility room and 1/2 bath. The second floor includes 3 bedrooms and 2 full baths, plus a small flex room that can be used as a study or nursery. Refrigerator, washer and dryer are included. The garage currently has a insulated divider wall that is currently being used as an extra bedroom, or the wall can be removed to be converted back to 2 car garage. The back yard is completely fenced with a covered patio for your enjoyment. No back yard neighbors! House has never flooded!! Schedule your private showing today!!' ,`Acres` = '0.1136' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 4 RAINTREE VILLAGE SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4950' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '396' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'FRANZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MORTON RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'MCDONALD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Raintree Village Sec 6' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666677673' WHERE `Matrix_Unique_ID` = '210739436' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T22:22:43.943' ,`MLSNumber` = '41936140' ,`ListAgentFullName` = 'Esther Garcia' ,`ListOfficeName` = 'Keller Williams Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.767074' ,`Longitude` = '-94.953498' ,`PhotoCount` = '38' ,`PostalCode` = '77351' ,`RoomCount` = '5' ,`ListPrice` = '409900.00' ,`Status` = 'Active' ,`StreetName` = 'Johnson' ,`StreetNumber` = '145' ,`StreetSuffix` = 'Drive' ,`City` = 'Livingston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2150' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Completed New Construction in a great location close to town and Lake Livingston! Very close to sought after FM 350 North, and easy access to Hwy 190 and I-69 (59). Gorgeous custom cabinetry, upgrades, and built-ins throughout! Huge kitchen island! Granite countertops and beautiful backsplash! Built-in microwave and built-in oven included! Stunning walk-in tile showers. High ceiling and dormers provide natural light in living room. Open concept kitchen, dining room, and living room, great for entertaining. Amazing walk-in panty with plenty of storage. Mud/Utility room has storage galore! Study/Home office could be 5th bedroom. No HOA and no MUD tax. Close to restaurants and shopping!' ,`Acres` = '0.54' ,`Area` = '44' ,`BuilderName` = 'NA' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'OAK HILL LOT 2' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '23522' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Hill' ,`TaxAmount` = '192' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1666677673' WHERE `Matrix_Unique_ID` = '211068339' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T22:17:24.460' ,`MLSNumber` = '94919141' ,`ListAgentFullName` = 'Monty Singh' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.766455' ,`Longitude` = '-95.340957' ,`PhotoCount` = '24' ,`PostalCode` = '77020' ,`RoomCount` = '6' ,`ListPrice` = '489990.00' ,`Status` = 'Active' ,`StreetName` = 'Cline' ,`StreetNumber` = '2838' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1828' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NOW SELLING!! NEW CONSTRUCTION Gated Community in the hottest, fastest growing part of Houston - East Downtown!! Amazing views of the downtown skyline! Stunning 3 bed 3.5 Bath homes with private backyards centrally located inner city. ONE BLOCK from the upcoming, East River shipping/residential project, brought to you by the same developers of City Centre - but a planned 4 times the size! Literally 1 mile from Downtown, and minute away from Minute Maid Park, Toyota Center, and Discovery Green. Modern Open concept floorplan, Living and Kitchen area on the 2nd floor, massive kitchen island with shaker cabinets and elegant quartz counter-tops, living area opens up to a spacious exterior balcony. Beautiful finishes and fine craftsmanship adorn each floor. 9in High End Luxury Vinyl Wood planks, Stainless steel appliances, fine hardware, high ceilings on all levels make this community a one of a kind. Selection Sheet of all Finishes available upon request. Schedule your Private-Tour today!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'RDZ Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Schwartz Gardens BLK 1 LOT 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1558' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRUCE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Views At East River' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666677673' WHERE `Matrix_Unique_ID` = '211455364' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T22:16:54.960' ,`MLSNumber` = '59178024' ,`ListAgentFullName` = 'Monty Singh' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.766157' ,`Longitude` = '-95.340914' ,`PhotoCount` = '24' ,`PostalCode` = '77020' ,`RoomCount` = '6' ,`ListPrice` = '499990.00' ,`Status` = 'Active' ,`StreetName` = 'Cline' ,`StreetNumber` = '2842' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1828' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NOW SELLING!! NEW CONSTRUCTION Gated Community in the hottest, fastest growing part of Houston - East Downtown!! Amazing views of the downtown skyline! Stunning 3 bed 3.5 Bath homes with private backyards centrally located inner city. ONE BLOCK from the upcoming, East River shipping/residential project, brought to you by the same developers of City Centre - but a planned 4 times the size! Literally 1 mile from Downtown, and minute away from Minute Maid Park, Toyota Center, and Discovery Green. Modern Open concept floorplan, Living and Kitchen area on the 2nd floor, massive kitchen island with shaker cabinets and elegant quartz counter-tops, living area opens up to a spacious exterior balcony. Beautiful finishes and fine craftsmanship adorn each floor. 9in High End Luxury Vinyl Wood planks, Stainless steel appliances, fine hardware, high ceilings on all levels make this community a one of a kind. Selection Sheet of all Finishes available upon request. Schedule your Private-Tour today!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'RDZ Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Schwartz Gardens BLK 1 LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1408' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRUCE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Views At East River' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666677673' WHERE `Matrix_Unique_ID` = '211455859' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T22:17:47.890' ,`MLSNumber` = '95264301' ,`ListAgentFullName` = 'Monty Singh' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.766204' ,`Longitude` = '-95.340780' ,`PhotoCount` = '24' ,`PostalCode` = '77020' ,`RoomCount` = '6' ,`ListPrice` = '479990.00' ,`Status` = 'Active' ,`StreetName` = 'Cline' ,`StreetNumber` = '2850' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1850' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NOW SELLING!! NEW CONSTRUCTION Gated Community in the hottest, fastest growing part of Houston - East Downtown!! Amazing views of the downtown skyline! Stunning 3 bed 3.5 Bath homes with private backyards centrally located inner city. ONE BLOCK from the upcoming, East River shipping/residential project, brought to you by the same developers of City Centre - but a planned 4 times the size! Literally 1 mile from Downtown, and minutes away from Minute Maid Park, Toyota Center, and Discovery Green. Modern Open concept floorplan, Living and Kitchen area on the 2nd floor, massive kitchen island with shaker cabinets and elegant quartz counter-tops, living area opens up to a spacious exterior balcony. Beautiful finishes and fine craftsmanship adorn each floor. 9in High End Luxury Vinyl Wood planks, Stainless steel appliances, fine hardware, high ceilings on all levels make this community a one of a kind. Selection Sheet of all Finishes available upon request. Schedule your Private-Tour today!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'RDZ Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Schwartz Gardens BLK 1 LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1408' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRUCE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Views At East River' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666677673' WHERE `Matrix_Unique_ID` = '211456248' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T22:15:46.053' ,`MLSNumber` = '48072559' ,`ListAgentFullName` = 'Monty Singh' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.766043' ,`Longitude` = '-95.340791' ,`PhotoCount` = '24' ,`PostalCode` = '77020' ,`RoomCount` = '6' ,`ListPrice` = '499990.00' ,`Status` = 'Active' ,`StreetName` = 'Cline' ,`StreetNumber` = '2846' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1866' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NOW SELLING!! NEW CONSTRUCTION Gated Community in the hottest, fastest growing part of Houston - East Downtown!! Amazing views of the downtown skyline! Stunning 3 bed 3.5 Bath homes with private backyards centrally located inner city. ONE BLOCK from the upcoming, East River shipping/residential project, brought to you by the same developers of City Centre - but a planned 4 times the size! Literally 1 mile from Downtown, and minute away from Minute Maid Park, Toyota Center, and Discovery Green. Modern Open concept floorplan, Living and Kitchen area on the 2nd floor, massive kitchen island with shaker cabinets and elegant quartz counter-tops, living area opens up to a spacious exterior balcony. Beautiful finishes and fine craftsmanship adorn each floor. 9in High End Luxury Vinyl Wood planks, Stainless steel appliances, fine hardware, high ceilings on all levels make this community a one of a kind. Selection Sheet of all Finishes available upon request. Schedule your Private-Tour today!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'RDZ Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Schwartz Gardens BLK 1 LOT 6' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '1658' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRUCE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Views At East River' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666677674' WHERE `Matrix_Unique_ID` = '211456655' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T22:55:04.593' ,`MLSNumber` = '11883809' ,`ListAgentFullName` = 'Yuri Ibarra' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.585048' ,`Longitude` = '-95.104638' ,`PhotoCount` = '46' ,`PostalCode` = '77059' ,`RoomCount` = '5' ,`ListPrice` = '674999.00' ,`Status` = 'Active' ,`StreetName` = 'Brook Forest' ,`StreetNumber` = '16514' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4502' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for privacy? Located on a cul-de-sac, no back neighbors and access to the bayou this home delivers! With plenty of updates which include sprinkler system, new driveway, renovated pool & lavish landscaping. Featuring 5 bedrooms, 5 baths, theater room & a glowing fireplace. 2 family rooms with a wall of windows that stretch from the floor to the soaring ceilings. The kitchen will inspire the inner chef in you with high end appliances, quartz island & windows allowing tranquil views of the back yard. Large on suite primary bedroom features huge walk-in closets, a lavish en-suite spa bath, a walk-in shower, his/her vanity. Bedrooms upstairs grant access to the oversized balcony that overlooks the heated outdoor pool. This property also includes a garage apartment with total living area of 1,670sqft which features 2-bedroom,1 bath w/walking closets. Conveniently located near an array of shopping, dining options, and zoned to the outstanding CCISD schools. Come see your new home!' ,`Acres` = '0.3857' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 90 BROOK FOREST SEC 1 R/P' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '16800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '480' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ARMAND BAYOU ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Brook Forest Sec 01 Corr Pla' ,`TaxAmount` = '18855' ,`TaxRate` = '2.5769' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666677674' WHERE `Matrix_Unique_ID` = '211495387' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T22:01:08.783' ,`MLSNumber` = '66366237' ,`ListAgentFullName` = 'Shirley Kopecky' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.800229' ,`Longitude` = '-95.465053' ,`PhotoCount` = '40' ,`PostalCode` = '77055' ,`RoomCount` = '12' ,`ListPrice` = '620000.00' ,`Status` = 'Active' ,`StreetName` = 'Teluco' ,`StreetNumber` = '6509' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2611' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Priced to Sell!! Come & see this lovely 3000 sq ft+ property near I-10, Loop 610, & Hwy 290 & outside the 100 & 500 yr flood plains! High lot value - $400k-$450 recently; Aug. 2015 appraisal = $606k when lot value = $200k, unlike now & before MANY more improvements! Home has extensive additions & updates & boasts a 2 story greatroom with a dramatic ceiling, extensive real hardwood floors, crown molding + oversized 2 car garage with upscale apartment/quarters & 3 Recent HVAC units with sanitizing UV lights! Main bedroom has a large custom closet; 2 (of 4) bedrooms & bathrooms in main house are downstairs! The large office/library can double as: wine or media room, 2nd eating area; kitchen includes a gently used Viking gas range. Floor plans uploaded.\r\nPoints buy-down negotiable, depending upon offer. Garage apt.rental currently allowed by Civic Assn. \r\nThere\'s NOTHING like this with 5 bedrooms & bathrooms home, so close in with a full size lot. Much recent and new construction in area.' ,`Acres` = '0.1865' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 23 WESTVIEW TERRACE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8125' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '10' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HOUSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Westview Terrace Sec 02' ,`TaxAmount` = '8956' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1949' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666677674' WHERE `Matrix_Unique_ID` = '211498410' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T23:43:37.813' ,`MLSNumber` = '79296747' ,`ListAgentFullName` = 'Rodrigo Hernandez' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.847650' ,`Longitude` = '-95.805082' ,`PhotoCount` = '24' ,`PostalCode` = '77493' ,`RoomCount` = '8' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Rue Dela Croix' ,`StreetNumber` = '4926' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2529' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 2-story Beazer home nestled on a lot with NO REAR NEIGHBORS in the community of Kings Crossing! A covered front porch, pretty landscaping and trees offer great curb appeal! Open the door to gorgeous wood look tile flooring that flows down the hall into the main living spaces! Tucked behind French doors is a private study, ideal for a home office! A light and bright, open floor plan is ideal for entertaining! A HUGE island offers additional seating and storage! Warm 42\" cabinets adorned w/granite countertops, stainless appliances, and water softener system for kitchen finishes out the space! Serene primary suite offers peace and quiet, along w/en-suite bath w/dual sink vanity, granite countertops & enlarged steam shower w/bench seat! Upstairs boasts an airy game room, 3 secondary bedrooms & full bath! Step outside onto a covered patio overlooking the backyard space w/NO REAR NEIGHBORS! Great KATY Schools!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'BEAZER' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 1 KING CROSSING SEC 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5490' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '880' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BETHKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'King Crossing' ,`TaxAmount` = '8692' ,`TaxRate` = '3.4768' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666677674' WHERE `Matrix_Unique_ID` = '211612630' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T22:24:13.267' ,`MLSNumber` = '13601507' ,`ListAgentFullName` = 'Hai Le' ,`ListOfficeName` = 'Houston Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.941920' ,`Longitude` = '-95.360072' ,`PhotoCount` = '26' ,`PostalCode` = '77032' ,`RoomCount` = '4' ,`ListPrice` = '219000.00' ,`Status` = 'Active' ,`StreetName` = 'Whittier' ,`StreetNumber` = '2106' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1335' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fully remodel with new granite countertops in kitchen, bathroom. New painted cabinets. New fresh paint New carpet, new garage door. This house is on one of the largest lot in neighbor. \r\nThere bedrooms are all on second floor. Large family room on first floor. This house was never flooded through out all big hurricanes as its lots is one of the highest in neighborhood.' ,`Acres` = '0.1037' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 110 BLK 11 GREENBRIAR COLONY T/H' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot' ,`LotSize` = '4515' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '227' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CALVERT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'TEAGUE MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Greenbriar Colony T/H' ,`TaxAmount` = '2972' ,`TaxRate` = '2.5707' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666677674' WHERE `Matrix_Unique_ID` = '211709363' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T22:39:43.050' ,`MLSNumber` = '92626331' ,`ListAgentFullName` = 'Kristy Stone' ,`ListOfficeName` = 'C.R.Realty' ,`SellingAgentFullName` = 'Eneyda Diaz' ,`SellingOfficeName` = 'JLA Realty' ,`Latitude` = '29.794955' ,`Longitude` = '-95.841936' ,`PhotoCount` = '50' ,`PostalCode` = '77493' ,`RoomCount` = '9' ,`ListPrice` = '769999.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Champion' ,`StreetNumber` = '6923' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Tired of those long drives to the deer lease, wait until you see the majestic beauties in the backyard! Morning, noon and night you have your very own Safari to enjoy outdoors. Don\'t want to haul everything for baseball practice, no worries, its already set up in your backyard. Wake up feeling like you need to hit the greens? Check out the perfectly manicured tees. How about a relaxing evening making laps in the pool. If all that is in your backyard, why would you need to leave? The interior is just as amazing! Triple sliding patio doors, cathedral ceilings, high-end Chefs kitchen, enormous walk-in pantry, and more! Yes, it does have the oversized 3 car garage you are looking for as well. Hurry before this one is gone!' ,`Acres` = '0.4052' ,`Area` = '25' ,`BuilderName` = 'SHEA HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S422366 CANE ISLAND SECTION 6 BLK 4 LOT 12' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt' ,`LotSize` = '17652' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Cane Island' ,`TaxAmount` = '16320' ,`TaxRate` = '3.4077' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666677675' WHERE `Matrix_Unique_ID` = '212232148' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T22:55:07.387' ,`MLSNumber` = '19071315' ,`ListAgentFullName` = 'Edgardo Martinez' ,`ListOfficeName` = 'Lucky Money Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.415367' ,`Longitude` = '-95.087470' ,`PhotoCount` = '50' ,`PostalCode` = '77510' ,`RoomCount` = '10' ,`ListPrice` = '695000.00' ,`Status` = 'Active' ,`StreetName` = 'Young' ,`StreetNumber` = '12322' ,`StreetSuffix` = 'Circle' ,`City` = 'Santa Fe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3457' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A stunning custom home on over a half-acre(NO HOA) offers charm and elegance. High ceilings captivate\r\nas large entryways lead from room to room. Formal dining room with wood flooring rests near\r\nthe front. It opens to a spacious family room with tall windows overlooking the backyard. A\r\ncomfortable living room with wood-burning fireplace is steps away, adjacent to a classic\r\nkitchen. It features granite countertops, custom cabinetry, and stainless-steel appliances. Delight in a 1st-floor primary suite under a tiered ceiling. It includes a\r\nsitting area near a bay window overlooking the pool & covered patio. Primary bath\r\nboasts separate vanity areas, a frameless shower, & jetted tub. The 2nd floor reveals a\r\ngame room or office, a guest room with a separate bathroom, 2 additional bedrooms\r\nsharing a bath. 5ton A/C replaced in March! Home includes refrigerator, w/d, Craftsman Lawn Tractor, RV parking, & a 50x25 workshop, plumbing-ready, for additional storage. Upgraded well w/softener.' ,`Acres` = '0.5404' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 1 M AUSTIN SUR LOT 21 & E PT OF LOT 20 & W PT OF LOT 22' ,`LotDesciption` = 'Other' ,`LotSize` = '23541' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'WILLIAM F BARNETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Young Estates' ,`TaxAmount` = '9618' ,`TaxRate` = '2.3536' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666677675' WHERE `Matrix_Unique_ID` = '212300721' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T23:38:15.290' ,`MLSNumber` = '32422587' ,`ListAgentFullName` = 'Susan Stahley' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.074432' ,`Longitude` = '-95.565014' ,`PhotoCount` = '34' ,`PostalCode` = '77375' ,`RoomCount` = '10' ,`ListPrice` = '529000.00' ,`Status` = 'Active' ,`StreetName` = 'Castlehead' ,`StreetNumber` = '9322' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3905' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous Village Builders Home on Oversized Lot. Recently Remodeled and Ready for Move In. New High End Carpet. New Paint. New Oven, Dishwasher and Microwave. New Lighting in Entry, Formal Dining, Kitchen & Bathrooms. Wood Floors in Family Room, Master Bedroom, Master Closet and Office. Updated Shower, Flooring and Granite in Master Bath. Tile Flooring in Kitchen, Family Room, and Formal Dining. Granite in All Secondary Bathrooms. Double Sink in Secondary Bath. Huge Game Room. Large Bedrooms and Great Closets. Fabulous Kitchen with Large Island, Breakfast Bar and a Planning Desk. Fantastic Backyard with Tons of Room For Kids to Play and Plenty of Room for a Pool. Only a Short Walk Right Around the Corner to Neighborhood Park with Swings, Pool, Tennis Courts, Walking Trails and Catch Release Ponds. Zoned to Highly Sought after Klein ISD with Easy Access to Grand Parkway (99), Shopping, Dining & Entertainment. This is a MUST SEE!' ,`Acres` = '0.2298' ,`Area` = '14' ,`BuilderName` = 'Village Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 3 INVERNESS ESTATES SEC 2' ,`LotDesciption` = 'Wooded' ,`LotSize` = '10012' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MAHAFFEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'KRIMMEL INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Inverness Estates Sec 02' ,`TaxAmount` = '9900' ,`TaxRate` = '3.0565' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666677675' WHERE `Matrix_Unique_ID` = '212376164' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T22:35:35.120' ,`MLSNumber` = '58237804' ,`ListAgentFullName` = 'Christine Lahori' ,`ListOfficeName` = 'Krueger Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.227100' ,`Longitude` = '-95.566205' ,`PhotoCount` = '30' ,`PostalCode` = '77354' ,`RoomCount` = '10' ,`ListPrice` = '560000.00' ,`Status` = 'Active' ,`StreetName` = 'Weisinger' ,`StreetNumber` = '503' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3395' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to this beautiful well kept 4/5 bedrooms, 3.5 baths nestled on an almost 1/2 acre lot in the desired Westwood community! Rustic modern country feel with gorgeous stained concrete flooring throughout the first floor for easy maintenance. Gorgeous kitchen cabinets with granite countertops, and a nice size island for a quick meal. Open floor plan in kitchen, family and dining rooms with windows overlooking the backyard and great for entertaining or just family time. Spacious master bedroom and bathroom with huge walk in closet. Covered patio with ceiling fan overlooking backyard! Upstairs you will find a huge game room, media room, a flex room or office and an additional bedroom. Other features include crown molding, & granite in all bathrooms. Easy access to I-45, The Woodlands, and Lake Conroe. Great Magnolia schools. Low taxes and HOA, several pools, playground, and tennis Courts. Come see this gem, you won\'t be disappointed.' ,`Acres` = '0.4591' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WESTWOOD 03, BLOCK 1, LOT 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '20000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'TOM R. ELLISOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westwood 03' ,`TaxAmount` = '8169' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666677675' WHERE `Matrix_Unique_ID` = '212397742' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T22:37:42.070' ,`MLSNumber` = '48229944' ,`ListAgentFullName` = 'Tiffany LaRose' ,`ListOfficeName` = 'The LaRose Kaileh Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.739852' ,`Longitude` = '-95.445783' ,`PhotoCount` = '38' ,`PostalCode` = '77027' ,`RoomCount` = '10' ,`ListPrice` = '3495000.00' ,`Status` = 'Active' ,`StreetName` = 'Essex' ,`StreetNumber` = '4006' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Another Carol Isaak Barden project: House 21. The House of Many Palms, situated in the prestigious Highland Village subdivision, has been influenced by the glamorous luxury of West Palm Beach. Situated on a 7,700 square foot lot, the gated 5 bedroom, 4 1/2 bath home, has a spacious kitchen and vast entertaining area, a north-facing tropical garden, and is designed for indoor and outdoor living. Amenities include a soaring 24-foot entrance, an elevator shaft, and massive amounts of storage. The house has many large walls having been designed with art collectors in mind. Scott Strasser, designer, gave the house transformational rooms infused with natural light. Developer Carol Isaak Barden avoided cold, austere spaces in favor of luxurious finishes and lighting.' ,`Acres` = '0.1768' ,`Area` = '16' ,`BuilderName` = 'Carol Isaak Barden' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Highland Village/Midlane' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 54 BLK 5 HIGHLAND VILLAGE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SCHOOL AT ST GEORGE PLACE' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Highland Village' ,`TaxAmount` = '16690' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666677675' WHERE `Matrix_Unique_ID` = '212514924' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T22:38:10.290' ,`MLSNumber` = '83362604' ,`ListAgentFullName` = 'Diana Rodriguez' ,`ListOfficeName` = 'Ruth Longoria, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.594874' ,`Longitude` = '-95.482891' ,`PhotoCount` = '10' ,`PostalCode` = '77489' ,`RoomCount` = '6' ,`ListPrice` = '244900.00' ,`Status` = 'Active' ,`StreetName` = 'Cardono' ,`StreetNumber` = '15915' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1508' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1653' ,`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 7, LOT 17' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7201' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`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` = 'Traditional' ,`Subdivision` = 'Briargate Sec 3' ,`TaxAmount` = '3539' ,`TaxRate` = '2.2137' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666677676' WHERE `Matrix_Unique_ID` = '212817148' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T23:44:49.807' ,`MLSNumber` = '50787201' ,`ListAgentFullName` = 'Ashley DeCastro' ,`ListOfficeName` = 'City Insight Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.709513' ,`Longitude` = '-95.734302' ,`PhotoCount` = '39' ,`PostalCode` = '77450' ,`RoomCount` = '9' ,`ListPrice` = '362000.00' ,`Status` = 'Active' ,`StreetName` = 'Gabrielle Canyon' ,`StreetNumber` = '6326' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2434' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MANNED AND GATED COMMUNITY. Welcome to this beautiful one-story Royce Home, zoned to top-rated Katy ISD schools, located on a cul-de-sac street. This home has been loved and cared for by its current owners. Ready for a new owner to call it their home! Spacious open floor plan with 3 bedrooms, 2.5 bathrooms and additional space for an office. Large master suite. Tile flooring in hallway entry, kitchen, and bathrooms. Upgraded to laminate wood flooring in all bedrooms 2017. Updated modern lighting throughout. Granite countertops, tiled backsplash, and an island with extra storage underneath. All kitchen appliances stay. New A/C and water heater installed 2019. Water filtration and sprinkler system. Easy access to Westpark Tollway & Grand Parkway. Call today!' ,`Acres` = '0.1452' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CANYON GATE CINCO RANCH SEC 2, BLOCK 3, LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6325' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1260' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CREECH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'BECK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Gate Cinco Ranch Sec 2' ,`TaxAmount` = '6997' ,`TaxRate` = '2.6862' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666677676' WHERE `Matrix_Unique_ID` = '212836786' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T23:42:48.643' ,`MLSNumber` = '80831728' ,`ListAgentFullName` = 'Sue Ellen Rangel' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.368664' ,`Longitude` = '-95.597692' ,`PhotoCount` = '43' ,`PostalCode` = '77356' ,`RoomCount` = '8' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Park' ,`StreetNumber` = '117' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2261' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to tranquil living in your beautiful new home in the lake front resort community of April Sound. Your home sits on a large peaceful lot with lots of trees and a large covered front porch right across from a nature reserve. Your home is a 4 bedroom 2.5 bath with a private study/home office. The owners retreat is on the first floor with updated en suite. The bright sunny kitchen breakfast/dining combo features newer appliances and granite counter tops. A/C and water heater replaced 2019. \r\nApril Sound is a gated community with 24 hour security. Close to all the restaurants and attractions on Lake Conroe. Once you are home you can take advantage of the many amenities your new community has to offer. April Sound Country Club has dining and many events where you can get out and meet your new neighbors. Your new community also offers 27 holes of golf (membership required), tennis, swimming pools, pickle ball, fitness center, boat lauches and so much more. Room sizes are approximate.' ,`Acres` = '0.224' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Reports Available,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'APRIL SOUND 04, BLOCK 4, LOT 48' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '9756' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '234' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Controlled Access,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'April Sound 04' ,`TaxAmount` = '5093' ,`TaxRate` = '2.2625' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666677676' WHERE `Matrix_Unique_ID` = '212961565' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T22:02:19.887' ,`MLSNumber` = '35084477' ,`ListAgentFullName` = 'Stanley Mani' ,`ListOfficeName` = 'MIH REALTY, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.699345' ,`Longitude` = '-95.720080' ,`PhotoCount` = '50' ,`PostalCode` = '77407' ,`RoomCount` = '11' ,`ListPrice` = '420000.00' ,`Status` = 'Active' ,`StreetName` = 'Belford Park' ,`StreetNumber` = '7107' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2949' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous, Well-Maintained and Updated 4 bed 3.5 Bath David Weekley Home tucked away in the beautiful \"Grand Mission\" Master-Planned community! As you take a step inside you are greeted by the foyer flanked by the study/office, and formal dining. Notice the updated wood tile-like flooring as you make your way through the first floor into the living area with built shelving, a brick-face fireplace, recessed lighting, and premium shutters. The kitchen comes with marble countertops, a buffet addition for extra cabinet and counter space, stainless steel appliances, updated cabinets/hardware/lighting/fixtures, and more! The primary bedroom has also been updated with new flooring, new entry door to the bedroom and primary bath, large walking closet with custom shelving and drawers! Primary bath equipped with soaking tub, stand-alone shower with bench, double sinks. Upstairs includes the spacious 3 secondary bedrooms, jack and bath, game room, and an additional 3rd full bath. A MUST SEE TODAY!' ,`Acres` = '0.1993' ,`Area` = '37' ,`BuilderName` = 'David Weekley' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND MISSION SEC 4, BLOCK 1, LOT 13' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '8682' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '965' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Mission' ,`TaxAmount` = '6214' ,`TaxRate` = '2.5097' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666677676' WHERE `Matrix_Unique_ID` = '213022231' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T23:59:18.703' ,`MLSNumber` = '62900616' ,`ListAgentFullName` = 'Sandra McNeil' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.700295' ,`Longitude` = '-95.848204' ,`PhotoCount` = '31' ,`PostalCode` = '77441' ,`RoomCount` = '8' ,`ListPrice` = '410000.00' ,`Status` = 'Active' ,`StreetName` = 'Cottage Stream' ,`StreetNumber` = '27138' ,`StreetSuffix` = 'Lane' ,`City` = 'Fulshear' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2282' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CHARMING 1 story home in Fulshear zoned to KatyISD. Cross Creek Ranch amenities include swimming pools, fitness center, hiking trails inside a naturally sculpted subdivision. Centrally located near shopping, dining and entertainment in the highly desirable city of Fulshear. Easy access to Westpark Toll Road. This home features 4 bedrooms and a study for those working remotely, 3 car garage, a large walk in closet in the primary suite, and a welcoming/spacious foyer. Enjoy the evenings on the covered patio with family and friends. No neighbors in the back and on one side is a small park that lends a wooded feel to the property. Large granite island in the kitchen easily fits bar stools for casual dining. Game room features a built-in desk and bookcase. Today is the day to start your new life in Cross Creek Ranch - schedule your private tour and make this gem yours!' ,`Acres` = '0.2477' ,`Area` = '36' ,`BuilderName` = 'Plantation Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CREEKSIDE AT CROSS CREEK RANCH SEC 8, BLOCK 1, LOT 28' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10788' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'JAMES E RANDOLPH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Creekside At Cross Creek Ranch Sec 8' ,`TaxAmount` = '7895' ,`TaxRate` = '3.1575' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666677677' WHERE `Matrix_Unique_ID` = '213098826' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T23:57:30.097' ,`MLSNumber` = '10751552' ,`ListAgentFullName` = 'Steve Hardcastle' ,`ListOfficeName` = 'RE/MAX Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.851714' ,`Longitude` = '-95.592926' ,`PhotoCount` = '50' ,`PostalCode` = '77041' ,`RoomCount` = '11' ,`ListPrice` = '799900.00' ,`Status` = 'Active' ,`StreetName` = 'Santa Fe Springs Ct' ,`StreetNumber` = '12203' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '4423' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 4/4/3 D R Horton Custom Series home on a big waterfront lot at the end of a culdesac! The back yard has a beautiful custom heated pool,large spa,fountains,waterfall,big covered patio,custom brick cabana,iron fence,a big detached 3 car garage and a gated driveway. Surrounded by water for privacy and serene views. Impressive 2 story foyer with grand curved staircase,spacious formal living and dining rooms,den with walk-in wet bar that was originaly the fifth bedroom down(could also be used as a study). Grand 2 story family room with heavy crown molding,fireplace and a built-ins. Granite island kitchen,open to a breakfast room and the family room. Large primary suite with siiting area and lavish bathroom. Big gameroom up with wet bar and access to a large tiled balcony. Two staircases,lots of extra storage areas throughout the home. New roof 2020,1 AC and 2 water heaters have been replaced. Never flooded.' ,`Acres` = '0.2951' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 29 BLK 1 LAKES ON ELDRIDGE NORTH SEC 1' ,`LotDesciption` = 'Cul-De-Sac,Water View,Waterfront' ,`LotSize` = '12855' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1860' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'KIRK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes On Eldridge North' ,`TaxAmount` = '12969' ,`TaxRate` = '2.431' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666677677' WHERE `Matrix_Unique_ID` = '213122442' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T23:14:15.300' ,`MLSNumber` = '53726202' ,`ListAgentFullName` = 'Lunguang Wat' ,`ListOfficeName` = 'RealtyOne Plus, LLC' ,`SellingAgentFullName` = 'Lisseth DeLeon' ,`SellingOfficeName` = 'RE/MAX Grand' ,`Latitude` = '29.496589' ,`Longitude` = '-95.776054' ,`PhotoCount` = '30' ,`PostalCode` = '77469' ,`RoomCount` = '8' ,`ListPrice` = '329000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Snowbell' ,`StreetNumber` = '6514' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2631' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come view this gorgeous freshly updated/upgraded 5-bedroom home built in 2015! Situated in large corner lot of cul-de-sac, great floor plan, kitchen open to large family room, primary suite downstairs and game room upstairs! Fresh paint throughout, new hardwood looking vinyl plank in family/dining, new carpet & cushion in bedrooms, new chandelier and vanity lights, new ceiling fan, new mirror frames in bathrooms! Kitchen features granite counter tops, breakfast bar and over-the-range microwave! Primary suite w/ large walk-in close, his & her sinks, separate shower and garden tub! Guest bathroom upstairs w/ vanity area and double sinks! Brazos Town Center and Sugar Land Town Center are nearby, very convenient to shop and commute! Low tax rate and HOA fee!' ,`Acres` = '0.1764' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SUNRISE MEADOW SEC 6, BLOCK 1, LOT 6' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7682' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '330' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MEYER ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunrise Meadow' ,`TaxAmount` = '6592' ,`TaxRate` = '2.8148' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666677677' WHERE `Matrix_Unique_ID` = '213133137' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T23:12:22.183' ,`MLSNumber` = '47146760' ,`ListAgentFullName` = 'Ansley Stewart' ,`ListOfficeName` = 'KSP' ,`SellingAgentFullName` = 'Darnell Cleary' ,`SellingOfficeName` = 'Keller Williams Realty -SW' ,`Latitude` = '29.639570' ,`Longitude` = '-95.379446' ,`PhotoCount` = '25' ,`PostalCode` = '77051' ,`RoomCount` = '3' ,`ListPrice` = '199999.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Groton' ,`StreetNumber` = '3010' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2486' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! This thoughtfully updated 3 bedroom boasts a massive addition giving you one of the larger floorplans in the area. Open Concept living with updated granite countertops add a modern take on this Traditional Brick property. Recent refreshed paint, stove, and HVAC ensures years of comfort and enjoyment. Enjoy plenty of parking with the additional circle drive! No flooding, per seller.' ,`Acres` = '0.1389' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 15 SUGAR VALLEY' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'REYNOLDS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Request Online Appointment,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Sugar Valley' ,`TaxAmount` = '3659' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666677677' WHERE `Matrix_Unique_ID` = '213195610' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T23:00:42.313' ,`MLSNumber` = '13635362' ,`ListAgentFullName` = 'Tonya Kiliddjian' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = 'Jack Allen' ,`SellingOfficeName` = 'Allen Sims Real Estate' ,`Latitude` = '30.166995' ,`Longitude` = '-95.298218' ,`PhotoCount` = '32' ,`PostalCode` = '77357' ,`RoomCount` = '4' ,`ListPrice` = '247000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Woodpecker' ,`StreetNumber` = '18137' ,`StreetSuffix` = 'Trail' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1477' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New! New! New! Smart-home in unbelievable location!\" Fantastic Newer Construction Home that has it all! Charming one story with designer details at every corner! Wonderful open floor plan! Spacious kitchen and living spaces! Other features include landscape package, full sprinkler system, granite in kitchen and EVPlank flooring in entry, kitchen and wet areas. The large master bathroom offers double sinks , separate tub and shower and a massive walk-in closet. The kitchen offers stainless appliances, spacious pantry. FRIDGE, WASHER AND DRYER included with the sale. Never run out of hot water with the homes energy efficient tankless water heater! Enjoy and relax rain or shine on your amazing covered patio. Porters Mill is a lovely community located 2 miles north from The Grand Parkway off FM1314 and Gene Campbell Rd.' ,`Acres` = '0.1373' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S812700 - PORTERS MILL 01, BLOCK 1, LOT 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5980' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'ROBERT CRIPPEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Porters Mill 01' ,`TaxAmount` = '5420' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1666677677' WHERE `Matrix_Unique_ID` = '213257944' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T23:34:16.160' ,`MLSNumber` = '82482617' ,`ListAgentFullName` = 'Margaret Vinson' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = 'Margaret Tsanais' ,`SellingOfficeName` = 'RE/MAX Metro' ,`Latitude` = '29.709081' ,`Longitude` = '-95.422867' ,`PhotoCount` = '27' ,`PostalCode` = '77005' ,`RoomCount` = '9' ,`ListPrice` = '999900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Brompton' ,`StreetNumber` = '6601' ,`StreetSuffix` = 'Road' ,`City` = 'West University Place' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3504' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'For those who seek an amazing lifestyle – Timeless, warm and inviting home with many recent updates & enhancements, located in a premium West U location with Whitt Johnson Park (playground, picnic, basketball & more) across the street. The home features UPDATED KITCHEN with Quartz countertops (2021). The Primary Suite offers an UPDATED BATH, 3 closets & balcony (2022). The downstairs open floor plan, connecting Living Room, Dining Room, Kitchen, Family Room & Breakfast Room, is ideal for daily enjoyment & entertainment. The flexible floor plan presents plenty of options for your quiet home office(s) & offers one BEDROOM DOWN. All bedrooms have a bathroom and tons of closet space. Updated WINDOWS, PEX pipes + recent carpet, tankless water heater, fence & more. A desirable lifestyle awaits with convenient commute to TMC, Downtown, Uptown and Greenway Plaza and close proximity to West U finest amenities and Rice Village for shopping and dining. See features for more detail.' ,`Acres` = '0.1148' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 DAVIS' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Davis' ,`TaxAmount` = '18120' ,`TaxRate` = '2.0584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666677678' WHERE `Matrix_Unique_ID` = '213280143' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T23:23:29.297' ,`MLSNumber` = '42133464' ,`ListAgentFullName` = 'Melissa Lacy' ,`ListOfficeName` = 'Keller Williams Hou Preferred' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.543550' ,`Longitude` = '-95.216380' ,`PhotoCount` = '17' ,`PostalCode` = '77546' ,`RoomCount` = '4' ,`ListPrice` = '339000.00' ,`Status` = 'Active' ,`StreetName` = 'Winding' ,`StreetNumber` = '211' ,`StreetSuffix` = 'Road' ,`City` = 'Friendswood' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1888' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Four bedroom, two bath beautifully updated home in FISD. Granite countertops, laminate flooring, and new paint. Oversized backyard with deck that is the perfect spot to enjoy family time. All outdoor accessories including TV are staying with the home. Schedule your showing today and don\'t miss this amazing space to make memories.' ,`Acres` = '0.1931' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 20 PAGE 4 E 66 FT OF LOT 25 BLK 2 VILLAGE GREEN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8410' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'WESTWOOD ELEMENTARY SCHOOL (FRIENDSWOOD)' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Village Green' ,`TaxAmount` = '4883' ,`TaxRate` = '2.2832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666677678' WHERE `Matrix_Unique_ID` = '213303791' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T22:35:16.820' ,`MLSNumber` = '20731245' ,`ListAgentFullName` = 'Ariana Lopez' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.846734' ,`Longitude` = '-95.792068' ,`PhotoCount` = '23' ,`PostalCode` = '77493' ,`RoomCount` = '9' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Brewcastle' ,`StreetNumber` = '5003' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2473' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing 4 bedrooms, 3.1 baths two story home located on a large corner lot in King Crossing, Katy. Upon entering is a space originally design as an office/study space which current home owners have decide to use as their formal dining area. The kitchen features stainless steel appliances, designer backsplash, recessed lighting, great size island with a set of pendants, followed by a large living area. This property features beautiful ceramic wood tile all through the first floor. \r\n\r\nThe primary suite is located on the first floor offering a very generous size soaking tub along with a standing shower, dual sink vanity and walk in closet. Large game room to be found on the second floor as well as secondary bedrooms. \r\n\r\nMinutes from 99 grand parkway and interstate 10, Legacy stadium, Water parks, grocery stores, Katy mills mall and high acclaimed Katy ISD school district.' ,`Acres` = '0.1476' ,`Area` = '25' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 4 KING CROSSING SEC 11' ,`LotDesciption` = 'Corner' ,`LotSize` = '6430' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BETHKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Photos/No Videos,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'King Xing Sec 11' ,`TaxAmount` = '9142' ,`TaxRate` = '3.4768' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666677678' WHERE `Matrix_Unique_ID` = '213350801' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T22:57:04.260' ,`MLSNumber` = '22490665' ,`ListAgentFullName` = 'Patricia Dajani' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.748610' ,`Longitude` = '-95.403093' ,`PhotoCount` = '36' ,`PostalCode` = '77019' ,`RoomCount` = '13' ,`ListPrice` = '1899000.00' ,`Status` = 'Active' ,`StreetName` = 'Park' ,`StreetNumber` = '1914' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4058' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gotham Development brings you the \'\'Modern Tudor\'\' in the heart of the River Oaks Shopping Center! A dynamite floor plan with exceptional finishes by \"Allie Wood Design Studio\" Features Include: 7 Inch wire brushed white oak floors throughout (Except Wet Areas), Beamed Ceilings, Expansive Foyer, Floating Staircase, Incredible Millwork, Formal Dining Room with Wet-Bar, First Floor Library, Family Room with a Cathedral Ceiling, Incredible Master Suite with \'\'Spa Like\'\' Master Bath & Large Wardrobe. Game Room on the Second Floor, along with all 4 Bedrooms. Covered Two Story Loggia with an outdoor Kitchen. Large Yard with Room for a Pool! Elevator Capable! Pool in the rendering is not included with the price of the home. Home is framed and ready for showings. There is still time to make selections! Estimated Completion Date Dec. 2022/Jan. 2023.' ,`Acres` = '0.1079' ,`Area` = '16' ,`BuilderName` = 'Gotham Development' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'River Oaks Shopping Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 10 BLK 30 HYDE PARK MAIN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WOODROW WILSON MONTESSORI' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Hyde Park Main' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666677678' WHERE `Matrix_Unique_ID` = '213389126' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T23:20:28.993' ,`MLSNumber` = '85366627' ,`ListAgentFullName` = 'Doris Snipp' ,`ListOfficeName` = 'Savvy Property Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.954319' ,`Longitude` = '-95.165321' ,`PhotoCount` = '33' ,`PostalCode` = '77044' ,`RoomCount` = '10' ,`ListPrice` = '530000.00' ,`Status` = 'Active' ,`StreetName` = 'Elm Shores' ,`StreetNumber` = '13610' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3564' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Pristine all brick 2 bedroom down home backing to Lake Houston. True open concept with gathering room, soaring ceilings. Door opens to 2 story foyer and instant view of the lake. Plantation shutters throughout home. Master has bay window, sitting area. The family room has TV connection over the fireplace. The flex room/study upfront would pop with a sliding barn door. The nursery off the master can be changed to the builder option of 2 bedrooms down. Simple closing of current entrance and opening the bedroom at the front of home. Drywalling the current entrance and enclosing designated closet. Upstairs features a spacious game room leading out onto a covered balcony.. Also Computer study room. The backyard has extended covered patio, lake front ( no boat access). Boat access lake launch at Duessen Park. Garage is 3 car with 5 foot wide extension. Generator Transfer switch plug 30A powers 10 critical circuits powered by your generator. Open house 8/20 & 8/21 2-5 pm our 1st show date.' ,`Acres` = '0.1928' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,HOA First Right of Refusal,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 1 LAKESHORE SEC 1' ,`LotDesciption` = 'Cul-De-Sac,Water View,Waterfront' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '940' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'LAKESHORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakeshore Sec 01' ,`TaxAmount` = '10886' ,`TaxRate` = '2.863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666677678' WHERE `Matrix_Unique_ID` = '213408889' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T23:28:58.717' ,`MLSNumber` = '44214602' ,`ListAgentFullName` = 'Deanna Clark' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.176855' ,`Longitude` = '-95.546912' ,`PhotoCount` = '45' ,`PostalCode` = '77382' ,`RoomCount` = '11' ,`ListPrice` = '1550000.00' ,`Status` = 'Active' ,`StreetName` = 'Sentinel Point' ,`StreetNumber` = '190' ,`StreetSuffix` = 'Court' ,`City` = 'The Woodlands' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4792' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Like pages out of a magazine, this gorgeous 5 bedroom custom home with sparkling pool/spa is tucked into an almost 1/2 acre cul-de-sac lot in coveted Cascade Canyon. The yard has plenty of space to play! Completely remodeled -final finishing touches in 2021, custom features, built-ins & designer upgrades at every turn, the feeling of classic elegance meets you in every room. Large windows throughout allow stunning views of the backyard paradise. Meticulously maintained! Roof 2021! Generator! Unparalleled finishes: custom stained wood floors in the living areas, classic trim - cased openings, archways, and more. Stunning kitchen with classic white cabinets, quartz counters & island, Wolf Range & Thermador refrigerator; butler\'s pantry w/ wine refrigerator. Upgrades include elegant light fixtures throughout, bathrooms inside the home are stunning with marble or granite counters, framed mirrors, marble tile accents, recent designer carpet & tile flooring! Come see the home of your dreams!' ,`Acres` = '0.4849' ,`Area` = '15' ,`BuilderName` = 'Eaglebrook' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S971521 - WDLNDS VIL INDIAN SPRG 21, BLOCK 1, LOT 9' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot,Wooded' ,`LotSize` = '21124' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'TOUGH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Indian Sprg 21' ,`TaxAmount` = '18804' ,`TaxRate` = '2.1319' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666677679' WHERE `Matrix_Unique_ID` = '213506981' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T23:03:00.530' ,`MLSNumber` = '63191908' ,`ListAgentFullName` = 'Gina Jaeschke' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.159456' ,`Longitude` = '-95.776315' ,`PhotoCount` = '48' ,`PostalCode` = '77355' ,`RoomCount` = '12' ,`ListPrice` = '1200000.00' ,`Status` = 'Active' ,`StreetName` = 'Sapphire' ,`StreetNumber` = '20603' ,`StreetSuffix` = 'Circle' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3193' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Indigo Lake Estates has picturesque acreage homesites with custom homes. This highly sought after community boasts a private 160 acre lake perfect for your favorite water sports & fishing! This property offers a fully fenced, 5 acre corner lot with mature trees, horse & agriculture property, fully stocked pond & water well. The wrought iron remote gate & circle driveway will welcome you to this 3193 sq foot home with 5 bedrooms & 3.5 baths. Gather with family & friends in the cozy living room & entertain them in your inviting kitchen with custom flat-top hibachi grill. The outdoor living space & covered patio is great for outdoor entertaining, while the kids enjoy the game room upstairs. The 3500 sq foot thermal barrier insulated metal building is perfect for warehouse, storing an RV, Boat or tractor, or could be a huge garage for the car enthusiast, complete with office work space, 2 bathrooms & a shower! It can even be finished out to provide garage apartment for extra living space!' ,`Acres` = '5' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'INDIGO LAKE ESTATES 01, BLOCK 3, LOT 43' ,`LotDesciption` = 'Corner,Wooded' ,`LotSize` = '217800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1090' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Double Oven,Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'NICHOLS SAWMILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Craftsman,Traditional' ,`Subdivision` = 'Indigo Lake Estates' ,`TaxAmount` = '9535' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Septic Tank,Water District,Well' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666677679' WHERE `Matrix_Unique_ID` = '213544077' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T22:59:36.357' ,`MLSNumber` = '91924842' ,`ListAgentFullName` = 'Vera Mitrofanova' ,`ListOfficeName` = 'VAM Real Estate Solutions' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.760756' ,`Longitude` = '-95.763894' ,`PhotoCount` = '39' ,`PostalCode` = '77450' ,`RoomCount` = '9' ,`ListPrice` = '380000.00' ,`Status` = 'Active' ,`StreetName` = 'Lamplight Trail' ,`StreetNumber` = '1427' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2378' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Hidden gem of Cinco Ranch! Beautiful spacious corner house with high vaulted ceiling with tons of natural light, formal living room with fireplace to cozy up during cold days, huge den with dining area. 4 bedrooms, the 4th bedroom can be used as an office, if need be. Freshly painted throughout all house. Only the primary bedroom has recently installed carpet, the rest of the house has hard flooring. The primary bathroom has shower, tub and double sinks. The kitchen has a plethora of cabinets and storage. Bathrooms and breakfast area have recent light fixtures. The side street does not go through. Perfect for extra parking or extra play areas for kids. A good sized backyard is ready for family gatherings and barbeque. Enjoy recreation amenities including multiple parks, tennis courts, swimming pools of Cinco Ranch. Welcome Home!!!' ,`Acres` = '0.1765' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLK 4 CINCO RANCH MEADOW PLACE SEC 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7688' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1115' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'FIELDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'BECK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cinco Ranch Meadow Place Sec 0' ,`TaxAmount` = '6983' ,`TaxRate` = '2.6083' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666677679' WHERE `Matrix_Unique_ID` = '213578923' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T22:18:15.390' ,`MLSNumber` = '51287664' ,`ListAgentFullName` = 'Rosalinda Swartz' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.050733' ,`Longitude` = '-95.384707' ,`PhotoCount` = '21' ,`PostalCode` = '77373' ,`RoomCount` = '6' ,`ListPrice` = '188000.00' ,`Status` = 'Active' ,`StreetName` = 'Tree House' ,`StreetNumber` = '23347' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1025' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is it! Move-in ready single-story home LOADED w/ upgrades in the popular Cypress Trails community offering a gated pool, & quick access to I-45, Grand Parkway and Hardy. This home\'s curb appeal begins w/ the oversize corner lot, & a cozy covered front porch. The upgrades to this home include new: water heater, exterior sliding door, garage door/door opener, sheetrock, trim, doors, blinds, ceiling fans light fixtures, & 2 new toilets. Once inside you are welcomed by an open-concept layout featuring high ceilings, neutral paint tones, laminate flooring, & plenty of natural light. The spacious living room offers a brick fireplace & leads into the dining area & the updated kitchen w/ a new stove, ample cabinet storage, & a pantry. A large primary bedroom w/ sliding door access to the backyard, 1 well-sized secondary bedroom with newly built closet, & a full bath completes this home. Don\'t forget to check out the NEWLY decked backyard that\'s perfect for entertaining.' ,`Acres` = '0.0685' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TR 31A BLK 8 CYPRESS TRAILS OF TIMBERLANE 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '2986' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '330' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'GLORIA MARSHALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Trails Timberlane' ,`TaxAmount` = '3534' ,`TaxRate` = '3.0268' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666677679' WHERE `Matrix_Unique_ID` = '213594808' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T23:00:08.697' ,`MLSNumber` = '36272747' ,`ListAgentFullName` = 'Diane Boyd' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`SellingAgentFullName` = 'Lily Jang' ,`SellingOfficeName` = 'Keller Williams Realty - Memorial' ,`Latitude` = '30.179607' ,`Longitude` = '-95.522467' ,`PhotoCount` = '50' ,`PostalCode` = '77381' ,`RoomCount` = '14' ,`ListPrice` = '489900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Hidden View' ,`StreetNumber` = '50' ,`StreetSuffix` = 'Circle' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2612' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning one-of-a-kind home located in the prime and highly sought after Cochrans Crossing and boast the amenities you have been looking for.This beautiful 4 Bed 2 ½ Bath home is situated on a private corner lot overlooking a tranquil stocked neighborhood fishing lake. Home features a grand and open floor plan with private home office, upgraded tile wood like floors, granite counters, freshly painted cabinetry throughout, stainless appliances, walk in closets throughout, Double Pane Windows, sprinkler system plus so much more! You will enjoy cozying up with family and friends by the stunningly upgraded gas log fireplace situated in the spacious family room. Primary features beautiful custom built-ins as well as a bonus loft sitting area. Primary bath offers two walk-in closets, relaxing soaking tub and double vanities. Secondary bedrooms are very generously sized. The grand sized back patio is perfect for entertaining. Steps away from neighborhood park! Zone to Galatas Elementary!' ,`Acres` = '0.1765' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL COCHRANS CR 17, BLOCK 1, LOT 1' ,`LotDesciption` = 'Corner,In Golf Course Community,Subdivision Lot,Water View,Wooded' ,`LotSize` = '7688' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GALATAS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Cochrans Cr' ,`TaxAmount` = '6682' ,`TaxRate` = '2.1319' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666677679' WHERE `Matrix_Unique_ID` = '213657253' --> 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','213664702','1666677680','213664702','2022-10-24T22:26:47.470','37034430','Dee Dee Guggenheim Howes','Compass RE Texas, LLC','','','29.749819','-95.413174','14','77019','12','1892000.00','Active','Stanmore','2203','Drive','Houston','3','0','3','2640','Single-Family','Don\'t miss this outstanding opportunity to acquire a fantastic future lot or remodel opportunity in coveted River Oaks on the Stanmore Courtyards. The two-story dwelling features expansive living and dining rooms, a large kitchen with breakfast room, & three bedrooms, including a guest suite with full bath on the first floor. Charming details and light filled windows run throughout this 3 BD/3 BA home. The just under 10,000’ lot has mature trees & features amazing frontage to Stanmore Drive on the courtyards. Enjoy easy access to great shopping, River Oaks Country Club and close proximity to Memorial Park, and The Galleria. Zoned for top-rated Houston ISD schools, including River Oaks Elementary.','0.2282','16','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Exclusions,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace,Mock Fireplace,Wood Burning Fireplace','2','River Oaks Area','Central Electric,Central Gas,Zoned','1','LT 18 & TR 17 BLK 42 RIVER OAKS SEC 1','Subdivision Lot','9942','Appraisal District','','2357','0','','2','Single Oven','0','','','Electric Cooktop','','Composition','27 - Houston','RIVER OAKS ELEMENTARY SCHOOL (HOUSTON)','LAMAR HIGH SCHOOL (HOUSTON)','LANIER MIDDLE SCHOOL','Accompany,Appointment Required','Appraisal District','2','Traditional','River Oaks','31580','2.3307','Public Sewer,Public Water','1936','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T23:35:02.007' ,`MLSNumber` = '38790165' ,`ListAgentFullName` = 'Gabrielle Davis' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.116826' ,`Longitude` = '-95.517375' ,`PhotoCount` = '36' ,`PostalCode` = '77389' ,`RoomCount` = '9' ,`ListPrice` = '467000.00' ,`Status` = 'Active' ,`StreetName` = 'Northcrest' ,`StreetNumber` = '24614' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2890' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'STUNNING/UPDATED home in desirable Northampton Estates minutes to Willow Creek Golf Club & Wild Stallion Vineyard. Home has high ceilings & abundance of windows allowing tons of natural light in. Living room incl floor to ceiling fireplace for chilly nights, accent ceiling beams, wet bar & access to beautiful patio with pergola. Great for entertaining! Kitchen has KitchenAid appliances including a wall oven & 6 burner gas range, leathered quartz countertops, breakfast bar, large island & walk in pantry with custom shelves. You will love this kitchen! Adjacent breakfast area has lovely built in window seat. Large primary bedroom has spa like bathroom. Recent updates incl interior/exterior paint, gutters, windows, A/C incl duct work, roof, furnace, light fixtures, outdoor patio & pergola. Add touches to large yard to create your backyard oasis. Conveniently located to parks, paths, schools, Hwy 99, shopping & The Woodlands! Extra amenities incl tennis, fitness ctr, 2 pools for small fee.' ,`Acres` = '0.254' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 2 NORTHHAMPTON ESTATES PH 1' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '11064' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '385' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'NORTHAMPTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HILDEBRANDT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Northhampton Estates Ph 01' ,`TaxAmount` = '8285' ,`TaxRate` = '2.664' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666677680' WHERE `Matrix_Unique_ID` = '213743804' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T22:07:41.400' ,`MLSNumber` = '58281468' ,`ListAgentFullName` = 'Janis Adams' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.061243' ,`Longitude` = '-95.170623' ,`PhotoCount` = '1' ,`PostalCode` = '77345' ,`RoomCount` = '11' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Fair' ,`StreetNumber` = '5106' ,`StreetSuffix` = 'Drive' ,`City` = 'Kingwood' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3640' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Showstopping 5/3.5 custom home located on 17,812 sqft cul-de-sac lot. There are upgrades/updates galore. The gourmet kitchen has top of the line appliances, pot filler, five burner gas cooktop & recessed lighting. The open family room has a wall of windows overlooking the fabulous backyard. The primary suite is spectacular, spa like bathroom remodel incl. huge walk-in shower w/multiple heads, custom cabinetry and granite countertops. Upstairs the gameroom has a wet bar and the 5th bedroom is being used as a MEDIA room. Secondary baths all updated with glass shower doors. Your backyard paradise awaits & no expense has been spared, pool/spa have been competely remodeled w/replaced piping, equipment and robot. The stamped concrete patio encompasses a huge fire pit which leads on to the gazebo (gasline installed)& still there is room for the kids and pets to play. 90% of fence has been replaced, Roof (2022), HVAC (2018), gutter installed (2015) Windows and exterior doors (2018).' ,`Acres` = '0.4089' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 50 BLK 4 SAND CREEK VILLAGE SEC 3 R/P' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot,Wooded' ,`LotSize` = '17812' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '455' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'DEERWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'RIVERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sand Creek Village' ,`TaxAmount` = '9560' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666677680' WHERE `Matrix_Unique_ID` = '213760056' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T22:27:12.680' ,`MLSNumber` = '55690712' ,`ListAgentFullName` = 'Donn Clark' ,`ListOfficeName` = 'R. Alexa Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.326582' ,`Longitude` = '-95.297591' ,`PhotoCount` = '5' ,`PostalCode` = '77306' ,`RoomCount` = '3' ,`ListPrice` = '174900.00' ,`Status` = 'Active' ,`StreetName` = 'Old Highway 105 E' ,`StreetNumber` = '17642' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1456' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great 3/2 on large lot located in Ponderosa Pines. Home has been totally refurbished including new appliances. New carpet and faux wood flooring.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S810300 - PONDEROSA PINES 01, BLOCK 4, LOT 7, SERIAL BL20019' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '380' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'CREIGHTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,No Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Ponderosa Pines 01' ,`TaxAmount` = '1282' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666677680' WHERE `Matrix_Unique_ID` = '213775673' --> 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','213835001','1666677680','213835001','2022-10-24T23:24:13.803','51472505','Allison Denman','Realty ONE Group Iconic','','','30.111215','-95.398869','18','77386','9','237000.00','Active','Waltham','29202','Street','Spring','2','0','3','1762','Single-Family','Perfect house to make your home. It is ready for you to add your personal touch. Formal dining room at the front of the house. Extra room could be used as an office or playroom or even a 4th bedroom. Corner gas fireplace in the den. Walk-in closet in primary bedroom. Double sinks, soaking tub and separate shower in primary bath. Gated dog run. Washer and dryer included. New garage door opener (2022), AC replaced in 2019, Roof replaced in 2017, Camera system included (hard-wired in) including doorbell camera, Fingerprint reader for front door.','0.1446','15','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Wood Burning Fireplace','1','Spring Northeast','Central Gas','1','FOX RUN 04, BLOCK 23, LOT 26','Subdivision Lot','6300','Appraisal District','','315','0','','2','Gas Oven','0','','','Gas Range','','Composition','11 - Conroe','FORD ELEMENTARY SCHOOL (CONROE)','GRAND OAKS HIGH SCHOOL','YORK JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Fox Run 04','5128','2.8187','Public Sewer,Public Water','1993','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T22:14:37.710' ,`MLSNumber` = '77211638' ,`ListAgentFullName` = 'Ginny Jackson' ,`ListOfficeName` = 'New Leaf Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.710511' ,`Longitude` = '-95.432329' ,`PhotoCount` = '30' ,`PostalCode` = '77005' ,`RoomCount` = '12' ,`ListPrice` = '2150000.00' ,`Status` = 'Active' ,`StreetName` = 'Mercer' ,`StreetNumber` = '6512' ,`StreetSuffix` = 'Street' ,`City` = 'West University Place' ,`BathsFull` = '6' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4558' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful light filled home featuring front and back covered porches in West U! 4 bedrooms, 6 full baths plus oversized third floor game room with additional space that could be a fifth bedroom. Full kitchen renovation in 2016 and features fine cabinetry, under counter and accent lighting and top of the line appliances. Handsome paneled study with french doors. Spacious master suite with reading lights and coffered ceilings. Recessed lighting and switches/outlets updated, surround sound speakers. Back yard is complete with turf and an incredible covered outdoor kitchen/living space with outdoor speakers. Each bedroom has a private bath. Elevator capable to third floor! Convenient to West U elementary, Rice Village and the medical center.' ,`Acres` = '0.1492' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 5A BLK 35 WEST UNIVERSITY PLACE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'West University Place Sec 01' ,`TaxAmount` = '33464' ,`TaxRate` = '2.0584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666677680' WHERE `Matrix_Unique_ID` = '213864330' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T23:11:40.220' ,`MLSNumber` = '90408886' ,`ListAgentFullName` = 'Fatima Haq' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.582950' ,`Longitude` = '-95.638934' ,`PhotoCount` = '50' ,`PostalCode` = '77479' ,`RoomCount` = '11' ,`ListPrice` = '614999.00' ,`Status` = 'Active' ,`StreetName` = 'Caladium' ,`StreetNumber` = '4803' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3406' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This TASTEFULLY REMODELLED NewMark Home sits in the heart of Sugarland. If you want a feel of a new construction home but in a well established neighborhood then look no further. Recently revamped w/ New Wooden Floors, New Carpet, Fresh Paint both interior & exterior so you can just grab your bags and enjoy living. Great open floor plan w/ windows galore. There is not a dull moment in this house as the sun shines brightly throughout the home. Elegant Formal Dining area to enjoy happy meals & Spacious Study/Office for quite working environment. Chef style Island Kitchen w/ ample Pantry space. Lots of Cabinets & storage. Huge Primary retreat w/ spa like bath with oversized Closet. Gameroom Upstairs with generous sized 4 bedrooms w/ walk in closets. Concrete oversized Patio , Sprinklers on a Huge LOT SIZE of 11,000 sqft w/lots of opportunity for future entertainment. 2 car Garage w/ epoxy & cabinets. No back Neighbors. Close to Freeway, Walking to Kroger, Eateries etc. TOP RATED Schools.' ,`Acres` = '0.2548' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LEXINGTON MEADOWS SEC 1, BLOCK 2, LOT 6' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '11098' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '790' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'COLONY MEADOWS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FORT SETTLEMENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lexington Meadows Sec 1' ,`TaxAmount` = '9247' ,`TaxRate` = '2.1584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666677681' WHERE `Matrix_Unique_ID` = '213867025' --> 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','213902998','1666677681','213902998','2022-10-24T23:32:50.780','16026419','John Rodriguez','Realty Associates','','','29.912849','-95.077987','0','77532','10','330000.00','Active','Oporto','523','Path','Crosby','2','1','4','2434','Single-Family','Welcome to your next home! This beautiful property has all you could need! This home features 4 bedrooms, 2.5 bathrooms with a Gameroom.UPGRADED flooring, Granite countertops, backsplash, HUGE closets. Be sure to check out the great amenities Newport offers includes access to San Jacinto river and Lake Houston with boat ramps, pools, splash pad, tennis courts, a golf course, walking and biking trails, multiple parks through the community, a workout facility, multiple lakes, and even a horse stable.','0.1175','1','','','Electric Dryer Connections','','Mud,Sellers Disclosure','1','','0','Crosby Area','Central Electric','1','LT 6 BLK 2 NEWPORT SEC 9','Subdivision Lot','5118','Appraisal District','','55','0','','2','Electric Oven','0','','','Electric Range','','Composition','12 - Crosby','CROSBY ELEMENTARY SCHOOL (CROSBY)','CROSBY HIGH SCHOOL','CROSBY MIDDLE SCHOOL (CROSBY)','Accompany,Appointment Required','Appraisal District','2','Traditional','Newport','6461','2.7105','Water District','2018','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','213903948','1666677681','213903948','2022-10-24T22:51:14.090','57709637','Ced Thomas','Legacy Homes & Properties, LLC','','','29.673991','-95.368600','12','77051','6','249900.00','Active','Colonial','8133','Lane','Houston','2','0','3','1524','Single-Family','Come enjoy this beautiful modern home minutes away from I-610 and the Medical Center! There is ceramic tile in all of the wet areas and wood flooring throughout the remainder. Granite countertops in the kitchen guest bathroom and master bathroom. French doors lead into the master bathroom, which comes with a separate tub and shower with dual sinks and his and hers closets! Include in the home is 2\' faux wood blinds, stainless steel microwave, gas range, dishwasher and refrigerator.','0.1148','3','','','Electric Dryer Connections,Washer Connections','','No Disclosures,Probate','','','','Medical Center South','Central Gas','0','LT 8 BLK 73 SUNNYSIDE PLACE','Corner,Subdivision Lot','5000','Appraisal District','','','0','','2','Freestanding Oven','0','','','Freestanding Range','','Composition','27 - Houston','YOUNG ELEMENTARY SCHOOL (HOUSTON)','WORTHING HIGH SCHOOL','ATTUCKS MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Sunnyside Place','4849','2.3307','Public Sewer,Public Water','2017','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T23:55:50.243' ,`MLSNumber` = '28871157' ,`ListAgentFullName` = 'Kevin Johnson' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.527126' ,`Longitude` = '-95.733701' ,`PhotoCount` = '37' ,`PostalCode` = '77469' ,`RoomCount` = '3' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Clover Leaf' ,`StreetNumber` = '8110' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1815' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful updated home. This 1 story 3bed, 2 bath, home features an updated Kitchen with beautiful granite and backsplash. The open floor plan makes this home feel even larger than it is. Upon entering, you have 2 bedrooms and 1 bathroom up front. The heart of the home is the open Kitchen, breakfast, living room, and dining/flex space. In the back of the home you have the primary suite that features a large bedroom, a nice bathroom, and a good size closet. Out back you have a covered patio and plenty of space for a pool, play equipment, and fido.' ,`Acres` = '0.146' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RIVER RUN AT THE BRAZOS SEC 2, BLOCK 7, LOT 22' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6360' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'ARREDONDO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'River Run At The Brazos' ,`TaxAmount` = '4975' ,`TaxRate` = '2.7148' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666677681' WHERE `Matrix_Unique_ID` = '213914823' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T23:20:32.067' ,`MLSNumber` = '31606871' ,`ListAgentFullName` = 'Sandra Delmonico' ,`ListOfficeName` = 'Krisher-McKay, Inc., REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.768817' ,`Longitude` = '-94.952071' ,`PhotoCount` = '26' ,`PostalCode` = '77521' ,`RoomCount` = '10' ,`ListPrice` = '194900.00' ,`Status` = 'Active' ,`StreetName` = 'Mesquite' ,`StreetNumber` = '1105' ,`StreetSuffix` = 'Street' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1880' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Cute started home has some updates: Recent Roof, Tankless Hot Water System, Generator, Black Kitchen Appliances, Double Oven, Electrical Stove Top, and the Black Refrigerator included with the sale of the home.\r\nLarge Family room on the back of the house is great for family gatherings, in the family room it has a wood burning stove pipe burner. Large family room has plenty of windows to let in the natural sunlight into the room. Back yard is fenced and has a storage shed to keep tools. Kids can run and play in the back yard. Half of the Garage has been made into two room that can be used for craft room, study, game room or for extra storage.' ,`Acres` = '0.1793' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 BLK 2 CHAPARRAL VILLAGE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7810' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'CEDAR BAYOU J H' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Chaparral Village Sec 03' ,`TaxAmount` = '4984' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666677681' WHERE `Matrix_Unique_ID` = '213920750' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T23:10:38.353' ,`MLSNumber` = '11958750' ,`ListAgentFullName` = 'Hong Zhang' ,`ListOfficeName` = 'PRG, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.862342' ,`Longitude` = '-95.698192' ,`PhotoCount` = '10' ,`PostalCode` = '77449' ,`RoomCount` = '5' ,`ListPrice` = '238000.00' ,`Status` = 'Active' ,`StreetName` = 'Lyford' ,`StreetNumber` = '18839' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1440' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great Three bedroom with two full baths. 2-car attached garage. Nice floor plan, laminate floor, Fenced yard-Utility room is in the house. Katy Schools. Tenant occupied, month by month, sold as is but with good condition.' ,`Acres` = '0.0982' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 3 BRENWOOD VILLAGE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4278' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MCFEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (CY-FAIR)' ,`ShowInstructions` = 'Call Occupant' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Brenwood Village Sec 03' ,`TaxAmount` = '4358' ,`TaxRate` = '2.641' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666677681' WHERE `Matrix_Unique_ID` = '213976708' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T22:22:40.917' ,`MLSNumber` = '86965276' ,`ListAgentFullName` = 'Veronica Cisneros' ,`ListOfficeName` = 'Jane Byrd Properties INTL.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.951277' ,`Longitude` = '-95.569010' ,`PhotoCount` = '33' ,`PostalCode` = '77070' ,`RoomCount` = '7' ,`ListPrice` = '219900.00' ,`Status` = 'Active' ,`StreetName` = 'Farrell' ,`StreetNumber` = '9935' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1632' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss out on this 2 story 3 bedroom 2.5 bath in a highly sought after gated community. Located just minutes from Vintage Park where you can enjoy entertainment, dinning, and shopping. This home offers an open floor plan where you can enjoy a kitchen with stainless steel appliances and granite counter tops with a beautiful back splash. Enjoy plenty of natural lighting in this move in ready home with a deck that leads into the detached garage. Call for your private showing today.' ,`Acres` = '0.0997' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Willowbrook South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 32 BLK 2 PARKSIDE AT PERRY SEC 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '4344' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '695' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MATZKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkside/Perry Sec 02' ,`TaxAmount` = '4862' ,`TaxRate` = '2.7537' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666677681' WHERE `Matrix_Unique_ID` = '213981627' --> 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','213991054','1666677682','213991054','2022-10-24T23:45:34.550','42422105','Karen Espinoza','Walzel Properties','','','29.650330','-95.613926','16','77478','3','255000.00','Active','Summerfield','1926','Place','Sugar Land','2','0','2','1496','Single-Family','Lovely one story home, 2beds 2 baths and 2 car garage. Great starter home! This home features high ceilings, title floor throughout the house, walk-in closets, and a fireplace. Roof is 5 years old. 2 minutes from a major super store chain, 12 minutes to First Colony Mall, very close to plenty shops and restaurants.','0.1507','29','','','','','Sellers Disclosure','','','1','Sugar Land North','Central Gas','1','BARRINGTON PLACE SEC 3, BLOCK 3, LOT 47','Patio Lot,Subdivision Lot','6566','Appraisal District','','350','0','','2','','0','','','','','Composition','19 - Fort Bend','BARRINGTON PLACE ELEMENTARY SCHOOL','DULLES HIGH SCHOOL','DULLES MIDDLE SCHOOL','Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied','Appraisal District','1','Traditional','Barrington Place Sec 3','3495','2.0094','Public Water','1984','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T23:02:05.070' ,`MLSNumber` = '52635354' ,`ListAgentFullName` = 'Yohan Adhitama' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.612188' ,`Longitude` = '-95.616760' ,`PhotoCount` = '39' ,`PostalCode` = '77478' ,`RoomCount` = '9' ,`ListPrice` = '520000.00' ,`Status` = 'Active' ,`StreetName` = 'Mockingbird' ,`StreetNumber` = '1015' ,`StreetSuffix` = 'Way' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2650' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful two story house in Sugar Lakes subdivision that features 4 bedrooms, 3.5 bathrooms, & also private swimming pool for entertainment. Master bedroom is downstairs with large master bath. Gorgeous kitchen with granite countertops with an island and breakfast area. There is also access to Sugar Lakes community gated tennis court and an Olympic size swimming pool. Within minutes to Sugar Land City Center & First Colony Mall. Close to Hwy. 59, Hwy. 90, & Hwy. 6.' ,`Acres` = '0.1869' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sugar Land North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUGAR LAKES SEC 1, BLOCK 3, LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8141' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '898' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HIGHLANDS ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sugar Lakes Sec 1' ,`TaxAmount` = '7209' ,`TaxRate` = '2.0094' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666677682' WHERE `Matrix_Unique_ID` = '214005445' --> 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','214011467','1666677682','214011467','2022-10-24T22:26:25.553','91142042','Melanie Cook','Palmer Real Estate','','','30.816274','-95.252371','45','77320','8','149900.00','Active','Quail','26628','Court','Huntsville','2','0','3','1040','Single-Family','How about a super cute, even sassy, house close to Lake Livingston within the Waterwood subdivision? Check out this adorable house with a 400+ sq ft guest suite. The main house and converted garage share a fenced-in courtyard area with a mosaic sidewalk, concrete fountain, and screened-in porch. Brightly colored walls and splashes of rock and tile are artistically placed throughout the home, as colorful accents perfectly fitting for this eclectic house. Enjoy a peaceful evening in the sunroom, on the screened-in front porch, or in the courtyard area listening to the soothing sounds of the fountain. The top-of-the-line stainless LG refrigerator with water and ice in the door and microwave stay! AC replaced in 2020 and the breaker panel was replaced in 2022. See more descriptions in the photos for lots more info on this unique, one-of-a-kind home. Home is occupied so please allow enough time to notify occupants.','0.1156','64','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','0','','0','Lake Livingston Area','Central Electric','1','WATERWOOD - GREENTREE VILLAGE #11A, BLOCK 1, LOT PT OF 8 & P','Cleared,Cul-De-Sac,In Golf Course Community,Subdivision Lot','5036','Appraisal District','','750','0','','0','Electric Oven','0','','','Electric Range','','Composition','101 - Coldspring-Oakhurst Consolidated','JAMES STREET ELEMENTARY SCHOOL','COLDSPRING-OAKHURST HIGH SCHOOL','LINCOLN JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Request Online Appointment','Appraisal District','2','Contemporary/Modern','Waterwood Greentree Vill #11a','2580','2.3654','Public Sewer,Public Water,Water District','1977','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','214017790','1666677682','214017790','2022-10-24T22:22:15.863','65793884','Shane Terry','RE/MAX Northwest, REALTORS','','','29.825052','-95.442819','22','77018','6','572900.00','Active','Althea Lane','1709','','Houston','2','0','3','1781','Single-Family','Spectacular Home located in the Highly Desirable Oak Forest Community. Featuring an Impressive Backyard Oasis with Pool, Spa, Outdoor Kitchen, Private Courtyard and Outdoor Space for Entertaining! Ample Updates Inside with Pristine Hardwood Flooring, Stainless Steel Appliances, a New Gas Range and Oven, Updated Electrical and Light Fixtures, the Refrigerator is Included! You\'ll love the Updated Bathrooms and a Primary Suite with Access to the Pool Area. Surrounded by the Burgeoning Restaurants and Retail Scene Developing in this Area. Don\'t Miss this Fabulous Opportunity!!!!','0.1653','9','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Oak Forest East Area','Central Gas','0','LT 37 BLK 51 OAK FOREST SEC 6','Subdivision Lot','7200','Appraisal District','','','0','','2','Convection Oven,Electric Oven','1','Heated,In Ground','','Electric Cooktop,Gas Cooktop','','Tile','27 - Houston','STEVENS ELEMENTARY SCHOOL','WALTRIP HIGH SCHOOL','BLACK MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Oak Forest Sec 06','9689','2.3307','Public Sewer,Public Water','1949','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','214026694','1666677682','214026694','2022-10-24T23:20:26.497','12039985','Cellina Stokes','Crowne Realty','','','31.591089','-94.850565','50','75964','10','178500.00','Active','County Road 769','190','','Nacogdoches','2','0','3','1680','Single-Family','Enjoy peaceful country living in this recently updated 3BR/2BA Palm Harbor doublewide home w/ full length covered porch on almost an acre of fenced land in the desirable Douglass area, less than 1 mile from Lake Nacogdoches! Home offers a split floorplan, living room w/ wood burning fireplace & French doors to the covered back porch, dining area, breakfast area, kitchen w/ breakfast bar, buffet/cabinet area, study/computer nook & large walk-in pantry across from the in-door laundry room! Solid surface flooring throughout, ceiling fans in all bedrooms & living room. Recent updates include paint, master bedroom & closet flooring, light fixtures in master bathroom, flush mounted LED lighting in dining/breakfast/kitchen. Master bedroom has en-suite bathroom w/ double vanity sinks, soaking tub, separate shower & 13’ walk-in closet! 25x30 red iron metal shop on a slab w/ rollup door, shelving, electricity w/ 220 plugs & 2 lean-to\'s. 12x12 greenhouse on a slab w/ 2 sliding doors & windows.','0.866','77','Palm Harbor','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','','Central Electric','0','A-29 J L EWING P 21-2 28X60 PALM HARBOR MFG HOME PFS0609265','Other','37723','Survey','','','0','','1','Electric Oven,Single Oven','0','','','Electric Range,Freestanding Range','','Other','481 - Douglass','DOUGLASS SCHOOL','DOUGLASS SCHOOL','DOUGLASS SCHOOL','Accompany,Appointment Required,Lockbox Back,Vacant/Unoccupied','Seller','1','Traditional','J L EWING','936','1.5243','Septic Tank','1999','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','214027466','1666677682','214027466','2022-10-24T23:13:23.773','43529241','Marcy alBeirakdar','HomeSmart','','','29.468878','-95.103435','0','77539','13','349750.00','Active','Barrington Springs','3006','Lane','Dickinson','2','1','4','2452','Single-Family','Ready just for you! Beautiful open floor plan 4 Bedroom Anglia Built home with 2.5 bathrooms has a large game room upstairs along with all the secondary bedrooms and full bath room. All of the rooms are large 1 of the bedrooms is big enough to be used as an awesome home theater/media room. 2 car garage has extra storage space and attic decked for additional storage. Covered patio, pool sized back yard with no back neighbors. Perfect for outdoor activities and entertaining . Call to come and see it today!','0.1435','33','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','League City','Central Gas','1','BAY VIEW SEC 3 (2017) ABST 19, BLOCK 1, LOT 13, ACRES 0.1435','Cleared','6250','Appraisal District','','500','0','','2','Gas Oven','0','','','Freestanding Range,Gas Cooktop','','Composition','17 - Dickinson','BAY COLONY ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','DUNBAR MIDDLE SCHOOL (DICKINSON)','Appointment Required,Supra Keybox','Appraisal','2','Other Style','Bay View Sec 3','8619','2.8897','Public Sewer,Public Water','2016','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','214028693','1666677682','214028693','2022-10-24T22:08:42.330','13196352','Jackie Murray','Weichert,REALTORS-Murray Group','','','29.688741','-95.438337','49','77025','7','599500.00','Active','Linkview','3814','Drive','Houston','2','1','3','3089','Single-Family','Remarkable home features premium selections that are showcased in this beautifully appointed home.Exterior w/limestone rock & front porch on a well positioned double lot.Living room w/fireplace,recessed lighting & crown molding.Dining room open to the living room.Kitchen has been stylishly updated w/quartz counters,SS appliances,built in pantry,gas range & farm house sink.Charming second living space off of kitchen w/shiplap & wood beam ceiling.Oversized primary retreat w/gleaming hardwood floors!Primary bath w/walk-in shower,double sinks,separate vanity & huge closet.Generous size secondary bedrooms w/updated guest bath that features tub/shower.Covered patio overlooking the sparkling pool.Even with a pool there is plenty of yard on this oversized lot!2 car attached garage features bonus cabana! Great for additional storage. Large storage shed in backyard.Updates:foundation repaired w/lifetime warranty,new windows,fresh paint,new front porch,refinished hardwood floors & much more!','0.3581','17','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Knollwood/Woodside Area','Central Gas','0','LT 29 & TRS 28A & 30A BLK 2 LINKWOOD','Subdivision Lot','15600','Appraisal District','','','0','','2','Single Oven','1','Gunite,In Ground','','Gas Cooktop','','Composition','27 - Houston','LONGFELLOW ELEMENTARY SCHOOL (HOUSTON)','BELLAIRE HIGH SCHOOL','PERSHING MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Linkwood','16291','2.3307','Public Sewer,Public Water','1950','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','214028902','1666677682','214028902','2022-10-24T22:19:41.097','39823919','Vera Mitrofanova','VAM Real Estate Solutions','','','29.822221','-95.440710','39','77018','11','1374999.00','Active','Ebony','1626','Lane','Houston','4','1','5','4447','Single-Family','This immaculate house was built by GHBA award winning builder Ryland Homes is located in the heart of Oak Forest, right off of I-610. You will love the infusion of Craftsman style and elegant modern design. This house has everything you can think of, private office, formal dining, wine grotto, exquisite Chef\'s kitchen with a huge granite island that opens up to the living room with a soaring ceiling. Some of the features include custom made shutters, extended WIFI, wire for alarm/security system, surround system, tankless water heater, epoxy garage flooring, oak hardwood floors throughout whole first floor, HEPA filters, warming drawers in the kitchen, pot filler, large pantry, laundry room with sink, media room, game room with wet bar. Updated landscaping with kumquat and grapefruit trees. Beautiful pool to enjoy during hot Texas summer! The backyard has an outdoor kitchen, garden includes rosemary, dill, thyme, cucumbers, onions, peppers, parsley, etc. Call for your private showing!','0.168','9','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Exclusions,Sellers Disclosure','1','Gas Connections,Mock Fireplace','1','Oak Forest East Area','Central Gas','0','LT 20 BLK 48 OAK FOREST SEC 6','Patio Lot,Subdivision Lot','7320','Appraisal District','','','0','','2','Gas Oven','1','Enclosed','','Gas Cooktop,Gas Range','','Composition','27 - Houston','STEVENS ELEMENTARY SCHOOL','WALTRIP HIGH SCHOOL','BLACK MIDDLE SCHOOL','Accompany,Appointment Required,Supra Keybox','Appraisal District','2','Contemporary/Modern,Craftsman','Oak Forest Add Sec 06','20634','2.3307','Public Sewer,Public Water','2014','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214029333','1666677682','214029333','2022-10-24T23:02:58.017','63666749','Mohammed Jaber','eXp Realty, LLC','','','30.468380','-96.049741','25','77830','6','299000.00','Active','Scenic View','4731','Drive','Anderson','1','0','3','1080','Single-Family','Just a few miles outside of the quaint town of Anderson lies this beautiful 2.15 acre Lot with a Completely Renovated Beautiful Home. This Newly Remodeled home has 3 Beds, 1 Bath, and 1 Office. Family room, Kitchen with Breakfast area, laundry room, Master bedroom, Office, and Master Bath. Brand New Roof, Kitchen, Bathroom, and Floor and comes with Brand New appliances. Covered front porch and 17x14 Storage shed. Low taxes, No HOA fees, no restrictions. Great property for living in Anderson Texas. Anderson is a charming little town that is highly sought after because of its great Anderson and Navasota schools. Located in the rolling hills of Grimes County and in the sought-after Navasota OR Anderson ISD, The property features gorgeous long distant views of the countryside, a private road, and easy access to both Houston and College Station. The buyer has the option to buy all 7.95 acres as well','7.975','60','','','Electric Dryer Connections','','Sellers Disclosure','1','','','','Central Electric','0','SCENIC VIEW EST, LOT 4, ACRES 2.15','Cleared,Wooded','','Appraisal District','','','0','','0','Convection Oven,Electric Oven','0','','','Electric Range','','Composition','129 - Navasota','WEBB ELEMENTARY SCHOOL (NAVASOTA)','NAVASOTA HIGH SCHOOL','NAVASOTA JUNIOR HIGH','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','1','Other Style,Ranch','Scenic View Estate','2882','1.7749','Septic Tank,Well','1990','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','214029470','1666677682','214029470','2022-10-24T22:46:59.343','53596739','Juan Salcedo','ASIN Realty','','','18.853198','-99.158726','7','62550','4','625000.00','Active','Emiliano Zapata','26','Avenue','Cuernavaca','4','1','4','6243','Single-Family','A beautiful house ideal for those looking for a place to relax, enjoy nature, away from worldwide noise and pollution & enjoy the rest that we deserve every day. Inside a closed security and golf club development.','','','NA','','','','No Disclosures','0','','','','Central Gas','0','Emiliano Zapata 26','In Golf Course Community,Other','','','','','1','Never Lived In','3','','1','In Ground','','','','Slate','','','','','Appointment Required','Seller','3','Other Style','Golf Club San Gaspar','','','Other Water/Sewer','2019','Seller'); --> 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','214029677','1666677682','214029677','2022-10-24T23:22:18.753','73380147','Sandra Acord','eXp Realty, LLC','','','29.874629','-95.723440','26','77449','6','250000.00','Active','Highwind Bend','6930','Lane','Katy','2','1','3','1422','Single-Family','','0.1054','25','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections,Wood Burning Fireplace','1','Bear Creek South','Central Gas','1','LT 20 BLK 3 HIGHLAND CREEK RANCH SEC 3','Subdivision Lot','4593','Appraisal District','','450','0','','2','Gas Oven','0','','','Gas Cooktop,Gas Range','','Composition','13 - Cypress-Fairbanks','WALKER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','CYPRESS PARK HIGH SCHOOL','ROWE MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','2','Traditional','Highland Crk Ranch','4389','2.69','Water District','2004','Appraisal District'); --> New record created successfully