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-11-02T23:33:01.397' ,`MLSNumber` = '48999530' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.146633' ,`Longitude` = '-95.678417' ,`PhotoCount` = '7' ,`PostalCode` = '77362' ,`RoomCount` = '10' ,`ListPrice` = '415000.00' ,`Status` = 'Active' ,`StreetName` = 'Knollbridge Point' ,`StreetNumber` = '1310' ,`StreetSuffix` = 'Lane' ,`City` = 'Pinehurst' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3008' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW!! Gorgeous Village Builders Icon Collection \'\'Princeton\" Design with Elevation \'\'B\'\'. This two-story residence is a Next Gen® home design that is perfect for those who need space, with an attached suite that features its own kitchenette, living room, bedroom, bathroom and private entrance. In the main home is an open living area with a back patio and an owner’s suite. Upstairs are two-bedroom suites and a versatile game room loft.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Village Builders' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0014 BLK 001 LOT 012' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodtrace' ,`TaxAmount` = '' ,`TaxRate` = '3.2528' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667484954' WHERE `Matrix_Unique_ID` = '208343434' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T23:56:14.050' ,`MLSNumber` = '31412492' ,`ListAgentFullName` = 'Teresa Hill McCray' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.821114' ,`Longitude` = '-95.118145' ,`PhotoCount` = '8' ,`PostalCode` = '77360' ,`RoomCount` = '3' ,`ListPrice` = '62500.00' ,`Status` = 'Active' ,`StreetName` = 'Holly' ,`StreetNumber` = '286' ,`StreetSuffix` = 'Drive' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Property is located in Onalaska. Dimensions will need to be verified. This home is currently occupied, PLEASE DO NOT DISTURB THE TENANT. The property is included in a portfolio listing. Home is being sold \"As Is\". \r\nPer Seller, Mobile Home is 16 x 75. Year of home to be verified.' ,`Acres` = '0.3373' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'CANYON PARK SECTION 2 LOT 414' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14692' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Canyon Park Sec 2' ,`TaxAmount` = '88' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1667484954' WHERE `Matrix_Unique_ID` = '208575671' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T23:45:39.970' ,`MLSNumber` = '44082244' ,`ListAgentFullName` = 'Teresa Hill McCray' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.823580' ,`Longitude` = '-95.113915' ,`PhotoCount` = '26' ,`PostalCode` = '77360' ,`RoomCount` = '3' ,`ListPrice` = '62600.00' ,`Status` = 'Active' ,`StreetName` = 'Live Oak' ,`StreetNumber` = '202' ,`StreetSuffix` = 'Lane' ,`City` = 'Onalaska' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home is Occupied, please do not disturb tenants. Verify Dimensions. Home is on a corner lot. Washer and Dryer connections are located on the lower level.' ,`Acres` = '0.185' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Other Heating,Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'CANYON PARK SECTION 1 LOT 154' ,`LotDesciption` = 'Other' ,`LotSize` = '8060' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Canyon Park Sec 1' ,`TaxAmount` = '1437' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484955' WHERE `Matrix_Unique_ID` = '208576549' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T23:37:05.003' ,`MLSNumber` = '57381480' ,`ListAgentFullName` = 'Teresa Hill McCray' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.818198' ,`Longitude` = '-95.119246' ,`PhotoCount` = '6' ,`PostalCode` = '77360' ,`RoomCount` = '4' ,`ListPrice` = '79500.00' ,`Status` = 'Active' ,`StreetName` = 'Magnolia' ,`StreetNumber` = '165' ,`StreetSuffix` = 'Park' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1064' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Property is currently occupied by tenant. Please do not disturb tenant. All dimensions will need to be verified. Investment Opportunity.' ,`Acres` = '0.3581' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'CANYON PARK SECTION 2 LOT 251 & 252 SERIAL# AILA770772143537' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Canyon Park Sec 2' ,`TaxAmount` = '959' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484955' WHERE `Matrix_Unique_ID` = '208584017' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T22:39:12.963' ,`MLSNumber` = '31192449' ,`ListAgentFullName` = 'Michelle Riddle' ,`ListOfficeName` = 'Tricia Turner Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.734452' ,`Longitude` = '-95.745849' ,`PhotoCount` = '24' ,`PostalCode` = '77450' ,`RoomCount` = '8' ,`ListPrice` = '390000.00' ,`Status` = 'Active' ,`StreetName` = 'San Vicente' ,`StreetNumber` = '3415' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2518' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful large one story home with several updates throughout. Kitchen just remodeled with new granite countertops and backsplash. The home boasts new paint, gorgeous gray laminate, top of the line carpet in bedrooms, and new tile in the bathrooms and kitchen. The master bedroom is massive, and the bathroom is a must see! The master closet has ample amount of space and has stunning cedar walls. The home has a wrap around deck on three sides with still plenty of yard space. It also has two storage units that come with the home, one of them with workbench, fan, lights, and outlets. The second larger unit could be used as a playhouse, storage, she-shed, whatever your imagination allows! The upgrades in this charming home will not dissapoint!' ,`Acres` = '0.155' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'KELLIWOOD LINKS SEC 1, BLOCK 2, LOT 21' ,`LotDesciption` = 'In Golf Course Community' ,`LotSize` = '6753' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'EXLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'BECK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kelliwood Links Sec 1' ,`TaxAmount` = '7452' ,`TaxRate` = '2.495' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484955' WHERE `Matrix_Unique_ID` = '208957382' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T22:32:54.077' ,`MLSNumber` = '12514546' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = 'Christine Nguyen' ,`SellingOfficeName` = 'AB Realty Corp' ,`Latitude` = '29.701848' ,`Longitude` = '-95.706490' ,`PhotoCount` = '30' ,`PostalCode` = '77407' ,`RoomCount` = '12' ,`ListPrice` = '338990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Halifax Harvest' ,`StreetNumber` = '6810' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1831' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New D. R. Horton Home under Construction - This Harris! Stunning Entry! This lovely home you are greeted with High Ceilings, extended hallway and Beautiful Carefree Vinyl Plank Wood Flooring throughout! Luxurious Carpeting in all bedrooms! Two Full Baths plus Half Bath! The Family Room features Walls of Windows projecting abundance of natural light inside! Your Casual Dining area flows gracefully into your Gourmet Kitchen which features Quartz Counters, lots of Tall Shaker Cabinets for storage space, Stainless Appliances, Large Eat-in & Working Island with Under-mount Stainless Sink & more! Private Owner\'s Suite features Luxurious bathroom Shower & Huge Walk-in Closet. Energy Efficient Home(HERS Rated),Tankless Water Heater & features the \"Smart Home Automation System\" where you are able to control your home from anywhere, Camera Doorbell, Lighting, Electric Deadbolt, Thermostat & so much more! NO FLOODING! Amenities include: Pool, Splash Pad & More! Just 20 minutes to The Galleria!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lakeview Retreat Lot: 18 /Block: 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Lakeview Retreat' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667484955' WHERE `Matrix_Unique_ID` = '209646887' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T22:33:55.367' ,`MLSNumber` = '84029026' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = 'Sandra Breeland' ,`SellingOfficeName` = 'REALM Real Estate Professional' ,`Latitude` = '29.702019' ,`Longitude` = '-95.706289' ,`PhotoCount` = '31' ,`PostalCode` = '77407' ,`RoomCount` = '10' ,`ListPrice` = '324990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Telford Hollow' ,`StreetNumber` = '7011' ,`StreetSuffix` = 'Trail' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1297' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Abbot Floor Plan by D.R. Horton! Completed & Move In Ready! Wonderful Covered Back Patio! Contemporary/Modern Chic Style Elevation with Synthetic Stucco & Brick! Grand Entering with High Ceilings & Gorgeous Upgraded Vinyl Wood Plank Flooring throughout! Family & Casual Dining Area is open to the Dramatic Gourmet Kitchen W/Tall Shaker Cabinets, Beautiful Quartz Counters, Tile Back-splash, Large Eat-in Working Island w/Under-mount Stainless Sink, Drinking Water Filtration System, & Stainless Appliances! Amazing Huge Family Room! The Private Owners Suite features a Luxurious Bathroom W/Double Sinks Vanity, Shaker Cabinets, \"Massive\" Seamless Glass Shower W/Tile Surroundings & Walk-in Closet! Guest Bedrooms private & tucked away! Energy Features: HERS Energy Rated, Tankless/On-Demand H2O Heater &\"Smart Home System which allows you to control the Skybell, Locks, Lighting, Thermostat, Wireless Security & control anywhere! NO FLOODING ! Amenities include: Pool, Splash Pad, Lakes & More!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lakeview Retreat Lot: 32 / Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Lakeview Retreat' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667484955' WHERE `Matrix_Unique_ID` = '209701476' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T22:41:47.513' ,`MLSNumber` = '76243718' ,`ListAgentFullName` = 'Ahmad Adam' ,`ListOfficeName` = 'Adam Group Realty, LLC' ,`SellingAgentFullName` = 'Joshua DeShong' ,`SellingOfficeName` = 'Myers The Home Buyers' ,`Latitude` = '29.682775' ,`Longitude` = '-95.694318' ,`PhotoCount` = '34' ,`PostalCode` = '77407' ,`RoomCount` = '8' ,`ListPrice` = '329000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Butterstone Ridge' ,`StreetNumber` = '8803' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2532' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Prepare to fall in love! This fantastic 2-story, open-concept floor plan features four beds, 2.5 baths, a spacious den, and a game room on an oversized corner lot with no back neighbors. The home has recently been updated with wood floors, crown molding, granite countertops in Master and Guest bathrooms, a frame-less Master shower, and Close walking distance to the neighborhood pool and park. Quick access to Hwy 99, West Park Tlwy, Grocery stores, shopping & entertainment.Close access to the New Target and At Home store. Recent James Patterson Elementary School is now Open.' ,`Acres` = '0.196' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MISSION SIERRA SEC 2, BLOCK 8, LOT 23' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8536' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'BOWIE MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mission Sierra Sec 2' ,`TaxAmount` = '5653' ,`TaxRate` = '2.4429' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484956' WHERE `Matrix_Unique_ID` = '210536786' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T22:29:26.583' ,`MLSNumber` = '63648556' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.773000' ,`Longitude` = '-94.682696' ,`PhotoCount` = '11' ,`PostalCode` = '77514' ,`RoomCount` = '12' ,`ListPrice` = '319990.00' ,`Status` = 'Active' ,`StreetName` = 'Big Spring' ,`StreetNumber` = '105' ,`StreetSuffix` = 'Drive' ,`City` = 'Anahuac' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1832' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New One Story- 4 Bedroom Home! The Justin Floor Plan by D.R. Horton! Under Construction! Amazing Subdivision surrounded by trees, Low Tax Rate, No Flooding! Minutes from the Bay & The Banks Of The Trinity River for all your Outdoor Fun! Huge Lot! Dramatic entry W/High Ceilings, extended hallway & Beautiful Vinyl Wood like Floors throughout! Luxurious Carpeting in all bedrooms! Family Area features Walls of Windows projecting abundance of natural light inside! Casual Dining area flows gracefully into your Gourmet Kitchen which features Granite Counters, Tall Shaker Cabinets, Tile Backsplash, Stainless Appliances, Large Eat-in & Working Island w/Under-mount Stainless Sink! Private Owner\'s Suite W/Luxurious Bathroom, Granite Counters, Massive Shower & Huge Walk-in Closet. Energy Efficient Home(HERS Rated),Tankless Water Heater & features the \"Smart Home Automation System\" where you are able to control your home from anywhere, Camera Doorbell, Lighting, Electric Deadbolt, Thermostat & more' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'D. R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Cypress Point: lot 2 /Block 1' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '9557' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '4 - Anahuac' ,`SchoolElementary` = 'ANAHUAC ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANAHUAC HIGH SCHOOL' ,`SchoolMiddle` = 'ANAHUAC MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Cypress Point' ,`TaxAmount` = '' ,`TaxRate` = '2.66016' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667484956' WHERE `Matrix_Unique_ID` = '210609368' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T22:28:45.837' ,`MLSNumber` = '18236929' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.773000' ,`Longitude` = '-94.682696' ,`PhotoCount` = '16' ,`PostalCode` = '77514' ,`RoomCount` = '11' ,`ListPrice` = '317990.00' ,`Status` = 'Active' ,`StreetName` = 'Big Sandy' ,`StreetNumber` = '137' ,`StreetSuffix` = 'Lane' ,`City` = 'Anahuac' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1796' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning New D. R. Horton One Story Ranch Home Under Construction! The Cali Plan! Upgraded Brick Elevation on a Huge Lot! Large Covered Patio! Grand Entry with High Ceilings! Amazing Carefree Vinyl Like Wood Floors throughout! The Outstanding Family Area has a Wall of Windows looking out to your Patio, High Ceilings all that flows into the Gourmet Kitchen & Casual Dining Area! Gourmet Kitchen has Beautiful Tall Cabinets, Tile Backsplash, Stainless Steel Appliances, Huge Eat In Working Station Island, Gorgeous Granite Counters, Undermount Sink, Walk In Pantry & More! Primary Suite tucked away from all Guest Bedrooms Features High Ceilings, Plush Carpet, Luxurious Bathroom with His & Her Private Sink Vanity, Granite Countertops, Soaker Tub, Seamless Glass Shower, Huge Walk In Closet! Two Guest Bedrooms tucked away & Full Bathroom W/Granite Countertops & More! Low Tax Rate! No Flooding! Close to the Bay, & along the banks of the Trinity River for all your Outdoor Water Fun & More!' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'D. R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Cypress Point: lot 9 /Block 2' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '15360' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '4 - Anahuac' ,`SchoolElementary` = 'ANAHUAC ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANAHUAC HIGH SCHOOL' ,`SchoolMiddle` = 'ANAHUAC MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Cypress Point' ,`TaxAmount` = '' ,`TaxRate` = '2.6' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667484956' WHERE `Matrix_Unique_ID` = '210706269' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T22:26:34.830' ,`MLSNumber` = '45945124' ,`ListAgentFullName` = 'Christopher Sambursky' ,`ListOfficeName` = 'Realty Solutions' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.996205' ,`Longitude` = '-95.796435' ,`PhotoCount` = '31' ,`PostalCode` = '77447' ,`RoomCount` = '5' ,`ListPrice` = '349999.00' ,`Status` = 'Active' ,`StreetName` = 'Steven Springs' ,`StreetNumber` = '32007' ,`StreetSuffix` = 'Drive' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2727' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this gorgeous Castlerock home. Great curb appeal. Huge kitchen with a big island and formal dining. A very nice sized primary bedroom located downstairs with 3 bedrooms upstairs. The primary has a garden tub with a nice shower. It has a big game room and media room. A big backyard with a covered patio and no back neighbors!. Also has 16 Seer AC, energy efficient windows, and radiant barrier roof decking. Located close to Grand Parkway/99 and 290. No flooding!' ,`Acres` = '0.1749' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 59 BLK 1 STONE CREEK RANCH SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7620' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stone Crk Ranch Sec 3' ,`TaxAmount` = '8969' ,`TaxRate` = '3.1924' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1667484956' WHERE `Matrix_Unique_ID` = '211040226' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T22:36:16.763' ,`MLSNumber` = '12522287' ,`ListAgentFullName` = 'Tracy Ostrofsky-King' ,`ListOfficeName` = 'Century 21 Top Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.688950' ,`Longitude` = '-95.767341' ,`PhotoCount` = '30' ,`PostalCode` = '77407' ,`RoomCount` = '6' ,`ListPrice` = '310000.00' ,`Status` = 'Active' ,`StreetName` = 'Misty Morning' ,`StreetNumber` = '6803' ,`StreetSuffix` = 'Trace' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1858' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Truly exceptional, this open floor plan features a charming, light and uplifting interior and contains a generously sized living area and formal dining room. Fall in love with this recently updated kitchen, equipped with granite countertops and a spacious pantry. Enjoy the enormous backyard that comes complete with a large patio and plenty of space to add a custom pool. Ideally located in the sought after Meadows Of Parkway Lakes neighborhood, this one will go fast!' ,`Acres` = '0.2868' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MEADOWS OF PARKWAY LAKES SEC 1, BLOCK 1, LOT 22' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '12492' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '765' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUBENAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meadows Of Pkwy Lakes Sec 1' ,`TaxAmount` = '5682' ,`TaxRate` = '2.7615' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484956' WHERE `Matrix_Unique_ID` = '211364110' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T23:32:26.970' ,`MLSNumber` = '94981757' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.146679' ,`Longitude` = '-95.678374' ,`PhotoCount` = '7' ,`PostalCode` = '77362' ,`RoomCount` = '8' ,`ListPrice` = '400000.00' ,`Status` = 'Active' ,`StreetName` = 'Knollbridge Point' ,`StreetNumber` = '1365' ,`StreetSuffix` = 'Lane' ,`City` = 'Pinehurst' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2875' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW!! Gorgeous Village Builders Icon Collection \'\'Beaufort\" Design with Elevation \'\'C\'\'. This two-story home has everything the modern needs to live a comfortable lifestyle. There are two bedrooms on the first floor, including the primary suite, plus an open living area with a covered patio in the back. Upstairs are two bedrooms and a versatile game room loft. Optional extended covered patio! *Home is located in the beautiful 65\' section.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Village Builders' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 14 BLK 002 LOT 001' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodtrace' ,`TaxAmount` = '' ,`TaxRate` = '3.3542' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667484957' WHERE `Matrix_Unique_ID` = '211535752' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T23:21:16.770' ,`MLSNumber` = '53924795' ,`ListAgentFullName` = 'Leonel Dubon' ,`ListOfficeName` = 'James B Chaplin' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.690150' ,`Longitude` = '-95.709548' ,`PhotoCount` = '28' ,`PostalCode` = '77407' ,`RoomCount` = '6' ,`ListPrice` = '351800.00' ,`Status` = 'Active' ,`StreetName` = 'Pinebrook Arbor Ct' ,`StreetNumber` = '8023' ,`StreetSuffix` = '' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1775' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Over $45k in upgrades that include solar panels, wired in Ring security cameras around the whole house, keyless entry, insulated garage attic + garage door, oversized mini split AC unit, 8kwh Tesla solar panels with 2 Tesla power walls that can generate the house in case of a power outage. As if these upgrades weren\'t enough, this charming home features 3 bedrooms, an office, and 2 baths in Grand Vista neighborhood. The open layout will allow you to navigate the spacious areas of the house with ease. The kitchen features granite countertops, pendant lighting in the breakfast bar and stainless steel gas stove+microwave+dishwasher. The home is complimented with a natural paint color and engineered hardwood flooring in every room. Primary bedroom features an en-suite bath with dual vanities, a shower with floor to ceiling tile and walk-in closet. Great location with close proximity to TX 99, Westpark Tollway and 1464.' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Grand Vista Sec 19, Block 2, Lot 47' ,`LotDesciption` = 'Other' ,`LotSize` = '5679' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Vista' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484957' WHERE `Matrix_Unique_ID` = '211740543' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T23:17:23.003' ,`MLSNumber` = '24567026' ,`ListAgentFullName` = 'Teresa Hill McCray' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.825204' ,`Longitude` = '-95.121822' ,`PhotoCount` = '9' ,`PostalCode` = '77360' ,`RoomCount` = '3' ,`ListPrice` = '59500.00' ,`Status` = 'Active' ,`StreetName` = 'Tree Harbor' ,`StreetNumber` = '110' ,`StreetSuffix` = 'Drive' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1216' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Text agent with request. All dimensions to be verified by client. Home recently vacated.' ,`Acres` = '0.1548' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'PINE HARBOR SECTION 2 BLK 12 LOT 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6745' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Pine Harbor' ,`TaxAmount` = '48' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '200' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484957' WHERE `Matrix_Unique_ID` = '212084678' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T23:19:06.760' ,`MLSNumber` = '62544616' ,`ListAgentFullName` = 'Teresa Hill McCray' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.807967' ,`Longitude` = '-95.103537' ,`PhotoCount` = '14' ,`PostalCode` = '77360' ,`RoomCount` = '3' ,`ListPrice` = '59500.00' ,`Status` = 'Active' ,`StreetName` = 'Uvalde' ,`StreetNumber` = '131' ,`StreetSuffix` = '' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home is occupied. Do not disturb the tenants. Viewing requires 24 advance hour notice. All dimensions to be verified by client/buyer. Home is part of an Estate sell.' ,`Acres` = '0.1377' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TWIN HARBORS SECTION 1 BLK 1 LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Twin Harbors' ,`TaxAmount` = '169' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484957' WHERE `Matrix_Unique_ID` = '212084879' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T23:26:11.370' ,`MLSNumber` = '77168724' ,`ListAgentFullName` = 'Teresa Hill McCray' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.816122' ,`Longitude` = '-95.115787' ,`PhotoCount` = '7' ,`PostalCode` = '77360' ,`RoomCount` = '1' ,`ListPrice` = '92450.00' ,`Status` = 'Active' ,`StreetName` = 'Seminole' ,`StreetNumber` = '144' ,`StreetSuffix` = 'Circle' ,`City` = 'Onalaska' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '864' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Text agent with request. All dimensions to be verified by client. Large corner lot in subdivision.' ,`Acres` = '0.3806' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'CANYON PARK SECTION 4 LOT 351 & 352' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '16579' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Canyon Park' ,`TaxAmount` = '1351' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484958' WHERE `Matrix_Unique_ID` = '212087254' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T23:33:14.127' ,`MLSNumber` = '75967685' ,`ListAgentFullName` = 'Teresa Hill McCray' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.820513' ,`Longitude` = '-95.111971' ,`PhotoCount` = '41' ,`PostalCode` = '77360' ,`RoomCount` = '3' ,`ListPrice` = '55000.00' ,`Status` = 'Active' ,`StreetName` = 'Red Oak' ,`StreetNumber` = '149' ,`StreetSuffix` = '' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Text agent with request. All dimensions to be verified by client. Home is vacant. Located on a large lot.' ,`Acres` = '0.2316' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'CANYON PARK SECTION 2 LOT 182' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10088' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Canyon Park' ,`TaxAmount` = '166' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1667484958' WHERE `Matrix_Unique_ID` = '212087390' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T23:35:05.417' ,`MLSNumber` = '16211275' ,`ListAgentFullName` = 'Teresa Hill McCray' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.815836' ,`Longitude` = '-95.115095' ,`PhotoCount` = '6' ,`PostalCode` = '77360' ,`RoomCount` = '2' ,`ListPrice` = '57500.00' ,`Status` = 'Active' ,`StreetName` = 'Seminole' ,`StreetNumber` = '161' ,`StreetSuffix` = 'Circle' ,`City` = 'Onalaska' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '980' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Text agent with request. All dimensions to be verified by client. Home is currently occupied, do not disturb the tenants.' ,`Acres` = '0.1791' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'CANYON PARK SECTION 4 LOT 309 SERIAL# K2301837 HUD# TXS05467' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Canyon Park' ,`TaxAmount` = '389' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484958' WHERE `Matrix_Unique_ID` = '212087805' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T23:50:16.543' ,`MLSNumber` = '33704788' ,`ListAgentFullName` = 'Teresa Hill McCray' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.832412' ,`Longitude` = '-95.101162' ,`PhotoCount` = '11' ,`PostalCode` = '77360' ,`RoomCount` = '2' ,`ListPrice` = '43250.00' ,`Status` = 'Active' ,`StreetName` = 'Walnut' ,`StreetNumber` = '243' ,`StreetSuffix` = '' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home is part of an Estate sell. All dimensions should be verified. Home is occupied, do not disturb the tenants.' ,`Acres` = '0.1515' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'YAUPON COVE MOBILE HOME SECTION 1 LOT 43' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Yaupon Cove Mobile Home' ,`TaxAmount` = '92' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1667484958' WHERE `Matrix_Unique_ID` = '212088276' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T23:52:29.743' ,`MLSNumber` = '36524709' ,`ListAgentFullName` = 'Teresa Hill McCray' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.819064' ,`Longitude` = '-95.117488' ,`PhotoCount` = '33' ,`PostalCode` = '77360' ,`RoomCount` = '2' ,`ListPrice` = '42500.00' ,`Status` = 'Active' ,`StreetName` = 'Pecan' ,`StreetNumber` = '270' ,`StreetSuffix` = '' ,`City` = 'Onalaska' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '952' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Text agent with request. All dimensions to be verified by client. Home is part of an estate.' ,`Acres` = '0.3581' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'CANYON PARK SECTION 2 LOT 328 & 329 SERIAL# A508 HUD# TXS057' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Canyon Park' ,`TaxAmount` = '371' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484958' WHERE `Matrix_Unique_ID` = '212088778' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T23:58:06.457' ,`MLSNumber` = '63687400' ,`ListAgentFullName` = 'Teresa Hill McCray' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.821214' ,`Longitude` = '-95.112358' ,`PhotoCount` = '8' ,`PostalCode` = '77360' ,`RoomCount` = '3' ,`ListPrice` = '55000.00' ,`Status` = 'Active' ,`StreetName` = 'Canyon' ,`StreetNumber` = '301' ,`StreetSuffix` = 'Drive' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '784' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Text agent with request. All dimensions to be verified by client. Home is currently occupied, do not disturb the tenants.' ,`Acres` = '0.2107' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'CANYON PARK SECTION 2 LOT 162 SERIAL# 1380662172 HUD# TEX004' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9180' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Canyon Park' ,`TaxAmount` = '319' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484959' WHERE `Matrix_Unique_ID` = '212088885' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T23:31:26.080' ,`MLSNumber` = '44293096' ,`ListAgentFullName` = 'Teresa Hill McCray' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.843012' ,`Longitude` = '-95.170936' ,`PhotoCount` = '7' ,`PostalCode` = '77360' ,`RoomCount` = '3' ,`ListPrice` = '62500.00' ,`Status` = 'Active' ,`StreetName` = 'Garden Villas' ,`StreetNumber` = '145' ,`StreetSuffix` = 'Drive' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '4 Large Lots. Property is Occupied. Do not disturb the tenants. All dimensions should be verified. Home and lots are part of an Estate Sell. \"Other\" on property information as the source for the square footage of the property is ALL 4 lots combined.' ,`Acres` = '0.2493' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'GARDEN VILLAS LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10858' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Other' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Garden Villas' ,`TaxAmount` = '28' ,`TaxRate` = '1.7215' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1667484959' WHERE `Matrix_Unique_ID` = '212099852' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T23:43:33.517' ,`MLSNumber` = '89925462' ,`ListAgentFullName` = 'Teresa Hill McCray' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.842775' ,`Longitude` = '-95.170364' ,`PhotoCount` = '13' ,`PostalCode` = '77360' ,`RoomCount` = '1' ,`ListPrice` = '37500.00' ,`Status` = 'Active' ,`StreetName` = 'Garden Villas' ,`StreetNumber` = '176' ,`StreetSuffix` = 'Drive' ,`City` = 'Onalaska' ,`BathsFull` = '0' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home on property is not hooked up,, it conveys with the property. Price is based on the lot value. Utilities are available. All dimensions to be verified by client/buyer. Seller is and Estate.' ,`Acres` = '0.1915' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'GARDEN VILLAS LOT 35' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8340' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Garden Villas' ,`TaxAmount` = '22' ,`TaxRate` = '1.7215' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1667484959' WHERE `Matrix_Unique_ID` = '212099953' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T23:51:35.607' ,`MLSNumber` = '43683651' ,`ListAgentFullName` = 'Tina Slocum-Davis' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.523590' ,`Longitude` = '-95.053142' ,`PhotoCount` = '34' ,`PostalCode` = '77573' ,`RoomCount` = '9' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Pallins' ,`StreetNumber` = '121' ,`StreetSuffix` = 'Way' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2198' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Grand Family Home located in the highly desired section of Meadow Bend! This property offers an open, spacious living, breakfast, kitchen area. The Kitchen features upgraded cabinetry with under mount lighting, custom tile work & backsplash, granite counter surface, & breakfast bar. The original 1/2 bathroom on 1st level is now a Full bathroom with walk-n shower, & handicap features. Adjacent to the bathroom is a bonus room perfect if you work remotely & need a large office space, Or easily modified as a 5th bedroom for quests/mother-n-law suite. Interior painted 8/2022, newer A/C system less than 2 yrs, LG wash/dry all in one appliance is included! Property sits on a cul-de-sac street w minimum traffic, the storage shed behind the detached garage is included. On the back patio a Swim Spa is offered...fantastic for training, exercise, or therapy! There are so many possibilities with this property! Exemplary CCISD schools, & a short walk to the community park & pool. Schedule your tour!' ,`Acres` = '0.1617' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 18 PAGE 6 LOT 11 BLK 3 MEADOW BEND SEC 6 PHASE II REPLA' ,`LotDesciption` = 'Cleared,Cul-De-Sac' ,`LotSize` = '7044' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'HYDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'LEAGUECITY INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial,Other Style,Traditional' ,`Subdivision` = 'Meadow Bend' ,`TaxAmount` = '5199' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484959' WHERE `Matrix_Unique_ID` = '212103071' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T23:36:30.013' ,`MLSNumber` = '3815558' ,`ListAgentFullName` = 'Kourtney Walker' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.015055' ,`Longitude` = '-95.745200' ,`PhotoCount` = '32' ,`PostalCode` = '77433' ,`RoomCount` = '8' ,`ListPrice` = '367500.00' ,`Status` = 'Active' ,`StreetName` = 'Fiesta Rose' ,`StreetNumber` = '16603' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1984' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful one-story home settled on a double cul-de-sac street. 4-bedroom 2-and-a-half-bathroom split plan home with no carpet. A very well-maintained home on a corner lot with many amazing features. As you enter the home, you are welcomed by a formal dining area. The open floor plan features a kitchen that opens to the living area. There is an abundance of windows and gas fireplace. The primary bedroom is privately located off the living area. The primary bathroom has a tub and separate shower. The three secondary bedrooms are spacious. There is a Jack and Jill bathroom to accommodate the secondary bedrooms. The backyard is fully fenced and features a covered patio. Fairfield is a master planned community located conveniently off the Grand Parkway. The amenities include: parks, pools, athletic fields, basketball courts, pavilions and more. Welcome Home.' ,`Acres` = '0.2027' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 30 BLK 2 FAIRFIELD VILLAGE NORTH SEC 11' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8830' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1015' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'SWENKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Fairfield Village North' ,`TaxAmount` = '' ,`TaxRate` = '2.611' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484959' WHERE `Matrix_Unique_ID` = '212196872' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T23:33:32.113' ,`MLSNumber` = '2494663' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.146764' ,`Longitude` = '-95.678386' ,`PhotoCount` = '7' ,`PostalCode` = '77362' ,`RoomCount` = '10' ,`ListPrice` = '430000.00' ,`Status` = 'Active' ,`StreetName` = 'Knollbridge Point' ,`StreetNumber` = '1381' ,`StreetSuffix` = 'Lane' ,`City` = 'Pinehurst' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3008' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW!! Gorgeous Village Builders Icon Collection \'\'Princeton\" Design with Elevation \'\'A\'\'. This two-story residence is a Next Gen® home design that is perfect for those who need space, with an attached suite that features its own kitchenette, living room, bedroom, bathroom and private entrance. In the main home is an open living area with a back patio and an owner’s suite. Upstairs are two-bedroom suites and a versatile game room loft.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Village Builders' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0014 BLK 002 LOT 005' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodtrace' ,`TaxAmount` = '' ,`TaxRate` = '3.2528' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667484960' WHERE `Matrix_Unique_ID` = '212249590' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T23:07:01.117' ,`MLSNumber` = '37275388' ,`ListAgentFullName` = 'Sergio Franco' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.559384' ,`Longitude` = '-95.405524' ,`PhotoCount` = '50' ,`PostalCode` = '77584' ,`RoomCount` = '10' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Shady Sands Place' ,`StreetNumber` = '11911' ,`StreetSuffix` = '' ,`City` = 'Pearland' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4335' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 2 story corner home in the hearth of the desirable Shadow Creek area with easy access to 288 and Hwy 6. This formal Coventry model home features an outdoor kitchen, media room, 3-car garage, 2nd floor balcony, hardwood floors, surround system and much more. Shadow Creek lakes and trails around the neighborhood make this home ideal for outdoor adventures and entertainment. Contact us for a private showing today!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SHADOW CREEK RANCH SF17(PEARLAND), BLOCK 2, LOT 26' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '10720' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'BROTHERS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHADOW CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MCNAIR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadow Creek Ranch Sf1-Sf2-Sf3' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484960' WHERE `Matrix_Unique_ID` = '212418725' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T23:35:12.513' ,`MLSNumber` = '884873' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.146844' ,`Longitude` = '-95.678280' ,`PhotoCount` = '7' ,`PostalCode` = '77362' ,`RoomCount` = '10' ,`ListPrice` = '525000.00' ,`Status` = 'Active' ,`StreetName` = 'Lakemont Bend' ,`StreetNumber` = '1076' ,`StreetSuffix` = 'Lane' ,`City` = 'Pinehurst' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3376' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Awesome NEW Village Builders Wentworth Series, \'\'Rocklin\" Design with Elevation \"C\'\', located in Stunning Woodtrace! This Magnificent 1.5 home has 4 bedrooms, 3.5 baths and a 3 Car Garage w/ Storage space, also, a welcoming front porch with a Handsome Study off of the foyer, an Open concept layout with a really Large Family Room and a Gorgeous Formal Dining Room. Gourmet Island Kitchen has 42\" Cabinets & Great Appliance Pkg! Luxury Master Suite has a Shower, Separate Tub, and Huge W/I Closet with direct access to the laundry room. A Covered back patio is just waiting for you. This home has so much to offer, you will not want to miss it!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Village Builders' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Sect 13, BLOCK 3, Lot 14' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodtrace' ,`TaxAmount` = '' ,`TaxRate` = '3.2528' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667484960' WHERE `Matrix_Unique_ID` = '212708519' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T23:15:41.747' ,`MLSNumber` = '48841794' ,`ListAgentFullName` = 'Colette Anthony' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = 'Michael Nguyen' ,`SellingOfficeName` = 'R. Alexa Group LLC' ,`Latitude` = '29.928280' ,`Longitude` = '-95.612243' ,`PhotoCount` = '29' ,`PostalCode` = '77065' ,`RoomCount` = '5' ,`ListPrice` = '385000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Azalea Creek' ,`StreetNumber` = '12811' ,`StreetSuffix` = 'Trail' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2694' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to 12811 Azalea Creek Trl located in Wortham Park. This spacious residence has everything you need in your new home and tons of updates: Recent Roof (2017), New Plumbing (2020), New Electrical (2020), New Pool Equipment (2020), Fully Renovated Custom Kitchen and Spa-Like Primary Bath (2020), Gated Driveway, and High-End Stainless Steel Appliances (2020). This home features a formal dining / flex space off the main entry, an office, open living and kitchen, primary bedroom and bathroom, and a ½ bath all on the main 1st level and 3-bedrooms, a gameroom / loft and full bathroom and the 2nd level. Retreat to the spacious backyard for some relaxation or a dip in your private pool. As a resident of the Wortham community enjoy walking trails, the community pool and tennis court, and easy access to 290 and HWY 6; home also zoned to top rated Cypress-Fairbanks Independent School District. Booked your private showing today!' ,`Acres` = '0.1853' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 4 WORTHAM PARK SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8072' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '625' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ADAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'ARNOLD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wortham Park' ,`TaxAmount` = '7366' ,`TaxRate` = '2.341' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484960' WHERE `Matrix_Unique_ID` = '212974336' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T23:14:48.037' ,`MLSNumber` = '4022439' ,`ListAgentFullName` = 'Rodney Thorin' ,`ListOfficeName` = 'RE/MAX Northwest, REALTORS' ,`SellingAgentFullName` = 'Cathy Harper' ,`SellingOfficeName` = 'Compass RE Texas, LLC' ,`Latitude` = '29.741239' ,`Longitude` = '-95.556870' ,`PhotoCount` = '36' ,`PostalCode` = '77042' ,`RoomCount` = '13' ,`ListPrice` = '590000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Briar River' ,`StreetNumber` = '10327' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3268' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful property has been transformed and is ready for a new owner to love. Open floorplan with a large Living Room/Den featuring gaslog fireplace, custom built-ins, sound system, and a tucked away Home Study. Formal Dining opens to an expansive Kitchen with large island, bar seating, and TONS of storage. Wolf gas range, farmer\'s sink, quartz countertops, under cabinet lighting, and soft-close drawers make this Kitchen a chef\'s dream! Also downstairs is a FULL Bath with shower. Upstairs are four generous Bedrooms - Master Suite with remodeled Bath and large WIC, two large secondary Bedrooms, both with WIC, and a 4th Bedroom that could be a Media or Game Room that opens to a large 2nd floor Deck overlooking the Backyard. Garage is a 3-stall tandem with 3rd space currently used as a Weight Room featuring sliding doors to the back Patio. Recent roof, HVAC, paint, bathrooms. Beautiful low-maintenance landscaping on a quiet street. Don\'t miss this gem of a house in Brairgrove Park.' ,`Acres` = '0.1315' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Briargrove Park/Walnutbend' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 6 BRIAR COURT' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '5730' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '685' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WALNUT BEND ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Right Side,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Briar Court' ,`TaxAmount` = '11515' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484961' WHERE `Matrix_Unique_ID` = '213099087' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T22:55:10.467' ,`MLSNumber` = '65109795' ,`ListAgentFullName` = 'Evan Ballew' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = 'Kaylee Dean' ,`SellingOfficeName` = 'Fathom Realty' ,`Latitude` = '30.355104' ,`Longitude` = '-95.373447' ,`PhotoCount` = '42' ,`PostalCode` = '77303' ,`RoomCount` = '4' ,`ListPrice` = '395000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Silver Back' ,`StreetNumber` = '9254' ,`StreetSuffix` = 'Trail' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1942' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this absolutely beautiful 3 bedroom, 2 bath, 1 story home with upgrades GALORE including designer oversize tile flooring, granite counters, and updated lighting and plumbing fixtures. A butlers pantry separates the formal dining room and living space with elegant custom cabinets and under cabinet lighting. The kitchen is open to the breakfast eating area and iiving space boasting elevated ceilings and a wood burning fireplace. The master bedroom is light and bright and leads to a HUGE master ensuite with double sinks, a soaking tub, separate shower and a large master closet that connects to the laundry room for easy access. Both guest suites have elevated ceilings with ceiling fans and large closets. Enjoy the backyard in the park-like setting with a covered back patio overlooking a beautifully manicured backyard with plenty of trees for privacy... plenty of room for a pool or workshop!' ,`Acres` = '1.0009' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S400602 - DEER TRAIL TWO 02, BLOCK 3, LOT 20' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '43601' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '285' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Deer Trail Two 02' ,`TaxAmount` = '4025' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484961' WHERE `Matrix_Unique_ID` = '213173672' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T23:43:07.070' ,`MLSNumber` = '74667747' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.518503' ,`Longitude` = '-95.784257' ,`PhotoCount` = '6' ,`PostalCode` = '77471' ,`RoomCount` = '8' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Springview' ,`StreetNumber` = '3619' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1990' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Fairway Collection \"Blackstone\" Plan with Elevation \"F\" in Sendero! The beautiful one-story Blackstone plan by Lennar features an inviting front porch and entry foyer, a dining room, an island kitchen with walk-in pantry and breakfast room that offers access to a relaxing covered rear patio, a generous open family room and a walk-in utility room. The master bedroom features an en suite master bathroom with dual sinks, stand-up shower, private toilet enclosure, and access to a large master closet. *HOME ESTIMATED TO BE COMPLETE, DECEMBER, 2022*' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0003 BLK 001 LOT 031' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '756' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MEYER ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sendero' ,`TaxAmount` = '' ,`TaxRate` = '3.09' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667484961' WHERE `Matrix_Unique_ID` = '213257973' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T22:07:40.190' ,`MLSNumber` = '4377873' ,`ListAgentFullName` = 'Suzanne Estrada' ,`ListOfficeName` = 'Leopold & Strahan Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.468085' ,`Longitude` = '-94.598010' ,`PhotoCount` = '26' ,`PostalCode` = '77650' ,`RoomCount` = '6' ,`ListPrice` = '1080000.00' ,`Status` = 'Active' ,`StreetName` = 'Tradewind' ,`StreetNumber` = '2789' ,`StreetSuffix` = 'Lane' ,`City` = 'Crystal Beach' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2024' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '4 bed/3.5 bath home with breathtaking unobstructed views of the beach. NO HOA! Take in the warm ocean breeze from the expansive balcony overlooking the waves or venture out for an easy stroll on the sand steps away from your front door. Open concept kitchen includes marble countertops with subway tile backsplash, an island with breakfast bar, picture frame cabinets & stainless appliances. Modern fixtures & recessed lighting. The living room provides a comfortable space to relax - warm tones, crown molding and views of the beach. 3 spacious guestrooms, one with a built in trundle, perfect as a mother-in-law suite & a Jack-n-Jill bath. Upstairs the 4th bedroom is tucked away with a private balcony overlooking the beach. Outdoor entertainment space with a bar area and an enclosed outdoor shower. The beach is your front yard. MAKE AN OFFER TODAY!' ,`Acres` = '0.1148' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 65 B FRANKS SUR LOT 13 BLK 8 TIDELANDS ADDN' ,`LotDesciption` = 'Water View' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven,Single 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` = 'Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Tidelands' ,`TaxAmount` = '10480' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484961' WHERE `Matrix_Unique_ID` = '213266265' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T23:30:31.967' ,`MLSNumber` = '28129507' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.043007' ,`Longitude` = '-95.796385' ,`PhotoCount` = '11' ,`PostalCode` = '77447' ,`RoomCount` = '7' ,`ListPrice` = '290990.00' ,`Status` = 'Active' ,`StreetName` = 'Gold Hollow' ,`StreetNumber` = '18510' ,`StreetSuffix` = 'Court' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1538' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Homes Gulf Coast Series, \"San Luis II\'\' Plan Elevation \'\'B\" in Becker Meadows! Exciting One Story with 4 Beds/2 Baths/2 Car Garage! Entry Foyer opens to Family Room! Fantastic Kitchen has 36\'\' Designer Cabinets, Sparkling Countertops, Breakfast/Dining Area and Great Appliance Pkg! Primary Bedroom has Bath with Separate Tub & Shower, Large Walk-in Closet! Lovely Luxury Hard Surface Floors; Walk-in Utility Room! Fully Sodded Yard and Landscape Pkg! Energy Efficient w/16 SEER HVAC System & MORE!' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0004 BLK 001 LOT 011' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'EVELYN TURLINGTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Becker Meadows' ,`TaxAmount` = '' ,`TaxRate` = '3.6' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667484961' WHERE `Matrix_Unique_ID` = '213278557' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T22:46:44.847' ,`MLSNumber` = '94457208' ,`ListAgentFullName` = 'Katherine Weatherford' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.887333' ,`Longitude` = '-95.530565' ,`PhotoCount` = '50' ,`PostalCode` = '77040' ,`RoomCount` = '4' ,`ListPrice` = '559000.00' ,`Status` = 'Active' ,`StreetName` = 'Scherzo' ,`StreetNumber` = '7903' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3414' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WOW! LAKEFRONT Beauty with oversized cul-de-sac lot opening to lake bordered by jogging trail, backyard w/ large yard, lake views, and also privacy provided with lush landscaping, sprinkler system, 3 car garage. Soaring ceilings greet you upon entering, 2 formals and 1/2 bath on main floor. Walls of windows in den provides for stunning lake views! Kitchen opens to den w/ granite counters, large island, gas cooktop & large pantry. Primary bedrm on main floor, primary bath- oversized whirlpool jetted tub, separate shower. Custom built-ins in spacious family room upstairs, & new interior paint throughout! Roof, HVAC, Water Heater all have been replaced within last 10 years! Gorgeous Lakes, Trails, Mature Trees, Pools, Pavilion, Parks, Tennis Court. Easy Access to Major Freeways, Schools Zoned to the Highly-Acclaimed Cypress-Fairbanks ISD. NO FLOOD!' ,`Acres` = '0.2526' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 3 WOODWIND LAKES SEC 2 AMENDED' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '11003' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '815' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'GLEASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JERSEY VILLAGE HIGH SCHOOL' ,`SchoolMiddle` = 'COOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodwind Lakes Sec 02 Amd' ,`TaxAmount` = '8472' ,`TaxRate` = '2.591' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484962' WHERE `Matrix_Unique_ID` = '213329584' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T22:41:37.030' ,`MLSNumber` = '48647807' ,`ListAgentFullName` = 'Ernestina Argueta' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.937019' ,`Longitude` = '-95.174531' ,`PhotoCount` = '47' ,`PostalCode` = '77044' ,`RoomCount` = '10' ,`ListPrice` = '529900.00' ,`Status` = 'Active' ,`StreetName` = 'Waterside View' ,`StreetNumber` = '14815' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3803' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BUILT BY TAYLOR MORRISON- Welcome to this beautiful hard to find home.\r\nThis stunning 2-story home in the highly acclaimed neighborhood of Stillwater in Lake Houston is a gated community backing up to Lake Houston, House located in a cul-de-sac street, Upon walking into the front door you will fall in love with the soaring ceilings that open up to this impressive home, the family room that offers a wall of windows opening up to the modern and extensive kitchen, Kitchen stove top including five burner, Kitchen cabinets including soft close, Butlers pantry with own wine refrigerator, The large primary bedroom located in the first floor creates a relaxing retreat, guest bedroom within own suite also located in the first floor, upstairs you will find 3 bedrooms plus a game and media room, plug connections located in the roof for easy christmas lights decoration, Did I mentioned the high efficiency HVAC,low E-windows and no back yard easement.' ,`Acres` = '0.1794' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 1 STILLWATER ON LAKE HOUSTON SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7816' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'CENTENNIAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stillwater/Lk Houston' ,`TaxAmount` = '13672' ,`TaxRate` = '3.4539' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1667484962' WHERE `Matrix_Unique_ID` = '213332152' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T23:01:27.017' ,`MLSNumber` = '34487833' ,`ListAgentFullName` = 'Jose Richenberger' ,`ListOfficeName` = 'Executive Texas Realty' ,`SellingAgentFullName` = 'Ariel Monsalve' ,`SellingOfficeName` = 'Las Lomas Realty Elite' ,`Latitude` = '30.040883' ,`Longitude` = '-95.348413' ,`PhotoCount` = '32' ,`PostalCode` = '77373' ,`RoomCount` = '11' ,`ListPrice` = '300000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Diane' ,`StreetNumber` = '22606' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1930' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 22606 Diane Drive! Nestled in the established neighborhood of Forest Lakes, on a tree lined street this property has been remodeled beautifully. Close to schools, shopping, dining and overall convenience this home has fresh paint, and new carpet throughout, the home features granite counter tops, wood burning fireplace, and sitting on just over 1/2 an acre it has plenty of space for you and your family! A circular drive way offers easy in / out access with a 2 car garage! Come see why this property is perfect, for you and your family!' ,`Acres` = '0.5025' ,`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` = '0' ,`Legal` = 'LT 5 FOREST LAKES SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '21890' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'ANDERSON ELEMENTARY SCHOOL (SPRING)' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Forest Lakes' ,`TaxAmount` = '4366' ,`TaxRate` = '2.1367' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484962' WHERE `Matrix_Unique_ID` = '213384982' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T22:55:20.607' ,`MLSNumber` = '20888227' ,`ListAgentFullName` = 'Jenny Avellaneda' ,`ListOfficeName` = 'Effective Real Estate, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.572230' ,`Longitude` = '-95.041973' ,`PhotoCount` = '37' ,`PostalCode` = '77586' ,`RoomCount` = '10' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Woodvine' ,`StreetNumber` = '430' ,`StreetSuffix` = 'Drive' ,`City` = 'El Lago' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2174' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this beautiful and spacious single family home located in the wonderful community of El Lago. This corner lot property has been recently painted, it has new windows, new front door, new interior doors and a huge remodeled garage. This beautiful property has big size 4 bedrooms and 2 baths, open living room with dining room, family room with wood/gas fireplace, very good size kitchen with a dining room and an additional sunroom/office with lots of windows. This beautiful house is a block away from the community center, that has a pool, gym and tennis courts, in addition, this house is located near NASA, Kemah Boardwalk, Clearlake Recreational Park and much more family friendly locations. Roof, AC/heating indoor plumbing and floor replaced in 2018, windows and main door replaced in 2021.Property interior completely painted and all interior doors replaced in 10/2022. Schedule your own private showing to make this house yours!' ,`Acres` = '0.2703' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 1O EL LAGO SEC 4 R/P' ,`LotDesciption` = 'Corner' ,`LotSize` = '11776' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ED H WHITE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant,Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'El Lago Sec 04 R/P' ,`TaxAmount` = '7175' ,`TaxRate` = '2.6666' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484962' WHERE `Matrix_Unique_ID` = '213441836' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T22:31:16.233' ,`MLSNumber` = '52270785' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.150656' ,`Longitude` = '-95.202948' ,`PhotoCount` = '23' ,`PostalCode` = '77357' ,`RoomCount` = '3' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Roberts' ,`StreetNumber` = '23767' ,`StreetSuffix` = 'Road' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1216' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'RESIDENTIAL OR COMMERCIAL OPPORTUNITY***\r\nThis is the perfect location for the next commercial development with FM 1485 frontage for maximum business exposure. This property is great for a new homeowner seeking a low tax rate and land that has NEVER FLOODED! The home features a bright open floorplan, spacious covered front porch, and a cozy screened in back porch. Unbeatable convenience to US 69 and plenty of mature trees for supreme shade and privacy.\r\nProperty is located in a MUD - you\'ll never have to worry about Septic or Well maintenance.\r\nSchedule a private tour today!' ,`Acres` = '0.9995' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WILDWOOD FOREST, LOT 9, ACRES 1.000' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '43538' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'TAVOLA ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wildwood Forest' ,`TaxAmount` = '922' ,`TaxRate` = '2.5981' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484962' WHERE `Matrix_Unique_ID` = '213498083' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T23:28:18.150' ,`MLSNumber` = '34677969' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.038253' ,`Longitude` = '-95.798872' ,`PhotoCount` = '6' ,`PostalCode` = '77447' ,`RoomCount` = '6' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Breckenridge Pass' ,`StreetNumber` = '24238' ,`StreetSuffix` = 'Lane' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1522' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Homes Watermill Series, \"Whitton\'\' Plan with Elevation \'\'B\" in Becker Trace! Conveniently laid out single story showcases an open-plan. This home has 3 bedroom, 2 Baths with 2 Car Garage with the secondary bedrooms situated off the foyer! Nice welcoming Front Porch and great Entry Foyer! Fantastic Kitchen has 36\'\' Designer Cabinets, Sparkling Countertops, Breakfast/Dining Area and Great Appliance Pkg! Master Bedroom has Master Bath w/ Tub & Shower Combo, Large Walk-in Closet! Walk-in Utility Room! Lovely Hard Surface Floors; Fully Sodded Yard and Landscape Pkg! Energy Efficient w/16 SEER HVAC System & MORE!' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0002 BLK 001 LOT 005' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'EVELYN TURLINGTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Becker Trace' ,`TaxAmount` = '' ,`TaxRate` = '3.56' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667484963' WHERE `Matrix_Unique_ID` = '213533343' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T22:42:25.890' ,`MLSNumber` = '97843402' ,`ListAgentFullName` = 'Shawn Saxton' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.940777' ,`Longitude` = '-95.200451' ,`PhotoCount` = '23' ,`PostalCode` = '77346' ,`RoomCount` = '10' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Starry Summer' ,`StreetNumber` = '12435' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2074' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful like new home built by Saratoga in 2019! Upon entering the foyer this Elise plan offers a spacious formal dining room that can dual as a living area as well! The kitchen is a chef\'s DREAM that features granite countertops, stainless steel appliances, and a large walk in pantry. The kitchen also has an island and breakfast seating area that overlooks the spacious family room which makes it perfect for entertaining! This home also offers a flex/study room and covered back patio for your enjoyment! The exceptionally spacious primary bedroom features a luxury en-suite bath with a spacious walk in closet, double sinks, separate shower and a soaking tub! This home is zoned to the award winning Humble ISD and is close to lots of shopping and major highways! The only thing this home is missing is you! Look no further! Welcome Home! Buyer to verify all info.' ,`Acres` = '0.1332' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'HOA First Right of Refusal,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 1 SUNSET RIDGE SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5802' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'RIDGE CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunset Ridge' ,`TaxAmount` = '7435' ,`TaxRate` = '3.0673' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484963' WHERE `Matrix_Unique_ID` = '213544242' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T22:27:22.190' ,`MLSNumber` = '94548894' ,`ListAgentFullName` = 'Jessica Clements' ,`ListOfficeName` = 'Monarch Real Estate & Ranch' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.838381' ,`Longitude` = '-95.782186' ,`PhotoCount` = '30' ,`PostalCode` = '77493' ,`RoomCount` = '4' ,`ListPrice` = '440000.00' ,`Status` = 'Active' ,`StreetName` = 'Brenta Mountain' ,`StreetNumber` = '4414' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2763' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! This one story home is located in Ventana Lakes and sits on a cul-de-sac street with NO BACK NEIGHBORS! Come see all it has to offer including wood floors throughout all main living areas, pool, home office, and whole house filtration system! The backyard invites you to stay with the extended covered patio and built in deck! Ventana Lakes is conveniently located near 99 with easy access to shopping, dining, and all zoned to KATY ISD!' ,`Acres` = '0.2038' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 1 VENTANA LAKES SEC 11' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8876' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BETHKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ventana Lakes' ,`TaxAmount` = '9271' ,`TaxRate` = '3.2768' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484963' WHERE `Matrix_Unique_ID` = '213546394' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T22:02:52.437' ,`MLSNumber` = '6475624' ,`ListAgentFullName` = 'Ivan Ruiz' ,`ListOfficeName` = 'Keller Williams SoutheastTexas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.089120' ,`Longitude` = '-94.175115' ,`PhotoCount` = '32' ,`PostalCode` = '77706' ,`RoomCount` = '7' ,`ListPrice` = '205000.00' ,`Status` = 'Active' ,`StreetName` = 'Coronado' ,`StreetNumber` = '1270' ,`StreetSuffix` = 'Circle' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1476' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cul-de-sac Living in the West End of Beaumont. This cute little charmer will sweep you off your feet. The home had dining room turned into a functional room or office space ,Offers a large den with brick wall feature, eat in kitchen, with plenty of counter space & tile floors. The bedrooms are all spacious , clean carpets, and master bathroom has a nice stand alone shower & tasteful vanity space. The home is located in a great location with little traffic. The backyard is oversized and has room for a pool, play scape and more, a new storage room was installed recently. The covered patio allows for great evening gatherings and all year round out door fun. \r\nCome take a tour and discover that this property truly feels like home!' ,`Acres` = '0.2096' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SHERATON WOODS L17 B4' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '9130' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'CURTIS ELEMENTARY SCHOOL (BEAUMONT)' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sheraton Woods' ,`TaxAmount` = '4107' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484963' WHERE `Matrix_Unique_ID` = '213562133' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T22:51:09.700' ,`MLSNumber` = '12169062' ,`ListAgentFullName` = 'Collette King' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.887794' ,`Longitude` = '-95.698528' ,`PhotoCount` = '38' ,`PostalCode` = '77433' ,`RoomCount` = '6' ,`ListPrice` = '239900.00' ,`Status` = 'Active' ,`StreetName` = 'Painted Desert' ,`StreetNumber` = '7615' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1390' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled in the quiet community of Yaupon Ranch, this charming home sits on a private lot with no neighbors across the street. This cozy home features an open living room and a large master suite with a walk-in closet. The open kitchen is perfect for entertaining and is equipped with a breakfast bar and gas range. Tile floors throughout except for carpeting in bedrooms. Two-inch blinds on all the windows. Oversized backyard. Two car garage with an automatic garage door opener. Amenities include a pool, park and basketball court. Located in the highly acclaimed Cy-Fair ISD. Not far from some of the best dining and shopping. Located centrally between Hwy 290 and I-10. Opportunities like these don’t come around often.' ,`Acres` = '0.1189' ,`Area` = '25' ,`BuilderName` = 'Trophy Homes' ,`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' ,`HOAMandatory` = '1' ,`Legal` = 'LT 31 BLK 3 YAUPON RANCH SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5180' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '477' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'JOWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'HOPPER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Yaupon Ranch' ,`TaxAmount` = '4939' ,`TaxRate` = '3.041' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484964' WHERE `Matrix_Unique_ID` = '213594249' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T23:37:29.807' ,`MLSNumber` = '18685105' ,`ListAgentFullName` = 'Graeme Miller' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.011860' ,`Longitude` = '-95.534702' ,`PhotoCount` = '50' ,`PostalCode` = '77379' ,`RoomCount` = '16' ,`ListPrice` = '1250000.00' ,`Status` = 'Active' ,`StreetName` = 'Cougar Falls' ,`StreetNumber` = '16618' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '6242' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exceptional Custom Home located in the elegant Falls at Champion Forest. Thoughtfully designed interior ideal for entertaining has been kept up-to-date w traditional design elements. Iron front doors open to charming living room w sweeping views of backyard oasis. Kitchen features Granite countertops, Wolf appliances & Sub-Zero Refrig, Designer Cabinets w Accent Lighting, Double Ovens, Over-sized Pantry. Seamless flow into Dining Room w Butler\'s Pantry & Wet Bar. Primary bedroom includes sitting area, his/her walk-in closets. En-suite bathroom w separate Vanities, Jetted Tub, re-modeled Shower. Private Study just off BR w built-in cabinet shelves. Resort style Backyard includes PebbleTec Pool/Spa, Kitchen w Wood Ceiling, Fireplace, Mosquito Misting system, Landscape lighting, Putting Green. Many more refined features: Whole home water filtration system, 40-yr Designer Roof Shingles, 4 car garage, 38kw Home Gen, Upgraded AC units, Premium Floors, Tankless W Heaters, Plantation Shutters.' ,`Acres` = '0.5575' ,`Area` = '13' ,`BuilderName` = 'St James Custom Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 27 BLK 1 FALLS AT CHAMPION FOREST SEC 1' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '24283' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2325' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BRILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Falls At Champion Forest' ,`TaxAmount` = '18749' ,`TaxRate` = '2.4866' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484964' WHERE `Matrix_Unique_ID` = '213645997' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T23:22:00.387' ,`MLSNumber` = '83525008' ,`ListAgentFullName` = 'Susan Smith' ,`ListOfficeName` = 'Bayou City Brokers' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.061500' ,`Longitude` = '-95.216591' ,`PhotoCount` = '33' ,`PostalCode` = '77339' ,`RoomCount` = '6' ,`ListPrice` = '229000.00' ,`Status` = 'Active' ,`StreetName` = 'River Village Drive' ,`StreetNumber` = '2143' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1512' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great affordable opportunity in Top rated schools...Convenient location to nearby HWY 59 , Beltway 8, IAH airport , HWY 99 to The Woodlands . Ready for move in- short walk via Greenbelt access next door to Elementary school-Middle School and\r\n K-Park HS.\r\nQuiet neighborhood , mature trees -very nice area...NO FLOODING ...Original owners have taken very good care of property and house. New electrical service panel installed Aug 2022. Microwave and stove new Aug 2022.\r\nFreshly painted throughout ( even garage ), New carpet upstairs-staircase installed in Aug 2022.\r\nNo carpet downstairs. Oversized yard -very quiet street...' ,`Acres` = '0.1758' ,`Area` = '32' ,`BuilderName` = 'Ryland' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 45 WOODLAND HILLS VILLAGE SEC 7' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot,Wooded' ,`LotSize` = '7656' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'WOODLAND HILLS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'Woodland Hills Village' ,`TaxAmount` = '3804' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484964' WHERE `Matrix_Unique_ID` = '213719647' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T22:37:05.437' ,`MLSNumber` = '4987174' ,`ListAgentFullName` = 'Harper Lawson' ,`ListOfficeName` = 'MOD Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.466744' ,`Longitude` = '-95.467583' ,`PhotoCount` = '34' ,`PostalCode` = '77583' ,`RoomCount` = '6' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Oakleaf Meadow' ,`StreetNumber` = '8030' ,`StreetSuffix` = 'Court' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2611' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Beauty Has An Open Floor Plan With A Stunning Family Room With Soaring Ceilings, & Tons Of Windows To Bring In The Natural Light! This Home Is In Pristine Condition! The Gorgeous Kitchen Is For The Chef In The Family Which Includes: Custom Espresso Cabinets, Granite Countertops, Subway Backsplash, Butler’s Pantry & Massive Kitchen Island! The Formal Dining Room Can Easily Fit Eight! A Spacious Private Primary Suite Downstairs With A HUGE Walk-In Closet! Primary Bathroom Retreat With Double Vanities & Over-Sized Glass Walk-In Shower! SIZABLE Secondary Bedrooms & Game Room Upstairs! The Backyard Has A Covered Patio and outside kitchen That Is Perfect For Entertaining Family And Friends! Bonus Features: Tankless Water Heater, Blinds, And Large Utility Room! Amenities Include: Covered Picnic Area, Playground, Splash Pad And Walking Trails! Easy Access To Freeways! No Flooding!' ,`Acres` = '0.1492' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SOUTHERN COLONY SEC 4A, BLOCK 5, LOT 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Southern Colony Sec 4a' ,`TaxAmount` = '7814' ,`TaxRate` = '3.1329' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484964' WHERE `Matrix_Unique_ID` = '213795185' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T23:42:27.583' ,`MLSNumber` = '93811411' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.520258' ,`Longitude` = '-95.786419' ,`PhotoCount` = '6' ,`PostalCode` = '77471' ,`RoomCount` = '9' ,`ListPrice` = '380000.00' ,`Status` = 'Active' ,`StreetName` = 'Richglen' ,`StreetNumber` = '3623' ,`StreetSuffix` = 'Court' ,`City` = 'Rosenberg' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2548' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Fairway Collection \"Cantaron\" Plan with Elevation \"D\" in Sendero! The largest single-story home at Fairway with a two-bay garage and storage space. The gourmet kitchen overlooks the living space and covered patio. There is plenty of flexibility for family living with three secondary bedrooms and a study, and the owner’s suite with an en-suite bathroom is tucked away for privacy. *HOME ESTIMATED TO BE COMPLETE, JANUARY, 2023*' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0005 BLK 001 LOT 014' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '756' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MEYER ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sendero' ,`TaxAmount` = '' ,`TaxRate` = '3.09' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667484964' WHERE `Matrix_Unique_ID` = '213806589' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T22:17:20.707' ,`MLSNumber` = '17605268' ,`ListAgentFullName` = 'Kelly Zwern' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.661987' ,`Longitude` = '-95.731896' ,`PhotoCount` = '30' ,`PostalCode` = '77407' ,`RoomCount` = '10' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Lake Catherine' ,`StreetNumber` = '4810' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2404' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stylish and comfortable home invites you to settle into its spacious rooms while you enjoy the cozy, peaceful atmosphere. Stainless steel appliances, granite countertops, white herringbone patterned tile backsplash, plenty of counter space, and a gas stove is a chef\'s dream kitchen! The tranquil east facing back porch nestled by mature shade trees is perfect for happy hour. You will notice the elegant lighting throughout the house as well as gorgeous windows which cheerfully fill the home with sunlight. The downstairs primary suite has a lovely sitting area by the windows. Unlimited possibilites for the large gameroom upstairs. Half-bath on first floor just off the foyer is a beneficial feature of this well thought out home. What a bonus to live on a quiet cul-de-sac with a manacured yard, porch swing and a playground at the end of the block! Conveniently located within half a mile from Kroger w/ quick access to 99. Enjoy Waterside Estates pool, tennis court and park.' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WATERSIDE VILLAGE SEC 1, BLOCK 1, LOT 26' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '5393' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '649' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'OAKLAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'BOWIE MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Waterside Village' ,`TaxAmount` = '5246' ,`TaxRate` = '2.2929' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484965' WHERE `Matrix_Unique_ID` = '213816663' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T23:40:16.283' ,`MLSNumber` = '64695994' ,`ListAgentFullName` = 'Sonal Shah' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.862243' ,`Longitude` = '-95.717439' ,`PhotoCount` = '47' ,`PostalCode` = '77449' ,`RoomCount` = '3' ,`ListPrice` = '249990.00' ,`Status` = 'Active' ,`StreetName` = 'Hon' ,`StreetNumber` = '19743' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1413' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Truly exceptional, the open floor plan features a warm, welcoming interior and boasts well-proportioned rooms and a flow-through living area. You have what you need in this gorgeous kitchen that has been newly upgraded and includes stainless-steel appliances, electric oven, granite countertops, manufactured stone backsplash, wooden cabinetry, built-in pantry, built-in microwave and gas stove. The spacious master bedroom is made for relaxation and includes a bright and cheerful bathroom and a walk-in closet. Relax in the beautifully maintained suburban getaway that features patio dining space. A wonderful space for fun. Set on a quiet street in a sought-after Bear Creek Meadows neighborhood. The easy-to-maintain lot offers plenty of room to play. Appreciate the benefits of a well-organized double car attached garage. A rare opportunity. We love this home. You will too. Call today.' ,`Acres` = '0.1331' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 2 BEAR CREEK MEADOWS SEC 3' ,`LotDesciption` = 'Patio Lot,Subdivision Lot' ,`LotSize` = '5799' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '445' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Slate' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HEMMENWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Bear Crk Mdws Sec 03' ,`TaxAmount` = '4581' ,`TaxRate` = '2.671' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484965' WHERE `Matrix_Unique_ID` = '213832410' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T22:52:43.797' ,`MLSNumber` = '91082520' ,`ListAgentFullName` = 'Collette King' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.380852' ,`Longitude` = '-95.303012' ,`PhotoCount` = '50' ,`PostalCode` = '77303' ,`RoomCount` = '7' ,`ListPrice` = '459000.00' ,`Status` = 'Active' ,`StreetName` = 'Deer Pines' ,`StreetNumber` = '16089' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2225' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Over an acre of blissful living! Step inside this beautiful large one-story w/ 3 oversized bedrooms, & a study. Open kitchen to dining & living room. Walls of windows & an abundance of sunlight greet you from every angle. Looking out into your acreage backyard w/ ample trees & shade (think multiple hammocks) & a workshop or separate parking! Workshop is complete w/ electricity! The large screened-in porch offers so much versatility. Enjoy beautiful mornings & evenings without mosquitos. Huge master bedroom with a roomy master bath including his and her sinks, separate tub and shower, and a wonderful walk-in closet. You’ll love the storage in this home! Never worry about losing power because your full-house generator will be the envy of your neighbors! Full gutters with leaf guards will keep the cleaning at bay. This home is just the perfect place to call home with its amenities and space! Come let the kids roam and play! No neighbors across the street either. It’s just perfect!' ,`Acres` = '1.1376' ,`Area` = '19' ,`BuilderName` = 'First America Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Gas,Propane' ,`HOAMandatory` = '1' ,`Legal` = 'S400100 - DEER PINES 01, BLOCK 1, LOT 16' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '49553' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Deer Pines' ,`TaxAmount` = '6864' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484965' WHERE `Matrix_Unique_ID` = '213845194' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T23:11:37.560' ,`MLSNumber` = '10239910' ,`ListAgentFullName` = 'Celina Gomez' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.739809' ,`Longitude` = '-95.256480' ,`PhotoCount` = '9' ,`PostalCode` = '77029' ,`RoomCount` = '8' ,`ListPrice` = '249000.00' ,`Status` = 'Active' ,`StreetName` = 'De Haven' ,`StreetNumber` = '311' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1650' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Contruction! Beautiful new home for sale featuring 3 bedrooms and 2 1/2 bathrooms, an open concept floor plan with recessed lighting and many more modern amenities throughout. Great Dining Room/Living Room Combination. This property is in close proximity to Port Houston and 20 minutes from Downtown Houston.' ,`Acres` = '0.1148' ,`Area` = '2' ,`BuilderName` = 'M Guzman Constructio' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 5 & 6 BLK 23 FIDELITY' ,`LotDesciption` = 'Other' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'JACINTO CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GALENA PARK HIGH SCHOOL' ,`SchoolMiddle` = 'GALENA PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Fidelity' ,`TaxAmount` = '429' ,`TaxRate` = '2.7702' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667484965' WHERE `Matrix_Unique_ID` = '213859932' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T22:25:49.963' ,`MLSNumber` = '65720391' ,`ListAgentFullName` = 'Wesley Wilson' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = 'Michael Glenny' ,`SellingOfficeName` = 'JPAR - The Sears Group' ,`Latitude` = '29.585902' ,`Longitude` = '-95.136884' ,`PhotoCount` = '32' ,`PostalCode` = '77062' ,`RoomCount` = '9' ,`ListPrice` = '325000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Chestnut Springs' ,`StreetNumber` = '1422' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1958' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this exquisitely reimagined 3 bed 2 bath single-story in Pineloch. This spectacular home has everything you want with updated finishes from floor to ceiling. You\'ll love the breathtaking wood-look luxury plank flooring throughout the common areas. You\'ll cook like a chef in the beautiful brand new kitchen with white shaker cabinets, pristine white quartz countertops with designer tile backsplash, and new stainless appliances. Entertain or relax in the oversized living space complete with cathedral ceiling and stylish tiled fireplace and custom mantle. Enjoy the quiet and privacy of the split plan with the primary retreat in the rear corner of the home. Relax in the oversized soaking tub or refresh in the luxurious glass shower. Find room for everything and everyone with two large secondary bedrooms on the other side and a well-equipped updated hall bath with dual sinks. New paint, lighting, flooring, and more rival new construction with ready to move-in appeal.' ,`Acres` = '0.1485' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 5 BAY GLEN SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6468' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'WARD ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'CLEARLAKE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay Glen' ,`TaxAmount` = '6037' ,`TaxRate` = '2.5769' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484966' WHERE `Matrix_Unique_ID` = '213869908' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T23:57:30.110' ,`MLSNumber` = '26744142' ,`ListAgentFullName` = 'Kourtney Walker' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = 'Brittany Acree' ,`SellingOfficeName` = 'Orchard Brokerage' ,`Latitude` = '29.995107' ,`Longitude` = '-95.635640' ,`PhotoCount` = '50' ,`PostalCode` = '77429' ,`RoomCount` = '9' ,`ListPrice` = '540000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Kavanaugh' ,`StreetNumber` = '13514' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3380' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A lovely 4/5-bedroom home located on a large corner lot in Longwood Village with a gorgeous backyard pool. The home is located across from a park, tennis courts and neighborhood recreation facility. The formal entry welcomes you into the home. The study is located at the front of the home with a large window that looks out onto your front yard. The formal dining room is open and connected to the kitchen by a butler\'s pantry and walk-in pantry. The spacious kitchen features a large island and extensive counter space. The kitchen opens to the family room and breakfast area. The family room has an abundance of windows that allow you to enjoy views of your backyard. One wing of the home features a full bathroom and two secondary bedrooms. The second wing of the home includes the extra room with built-ins, secondary bedroom and full bathroom. The primary bedroom is privately located at the rear of the home with more views of your immaculate backyard. Don\'t miss out on this amazing home.' ,`Acres` = '0.232' ,`Area` = '10' ,`BuilderName` = 'David Weekley' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 4 LONGWOOD VILLAGE SEC 19' ,`LotDesciption` = 'Corner,In Golf Course Community' ,`LotSize` = '10106' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HAMILTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Longwood' ,`TaxAmount` = '9714' ,`TaxRate` = '2.4837' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1667484966' WHERE `Matrix_Unique_ID` = '213872574' --> 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','213909652','1667484966','213909652','2022-11-02T22:50:03.230','13975870','Sue Ann Wilson','Bian Realty','','','29.811552','-95.533317','33','77080','8','399000.00','Active','Elmgate','2306','Drive','Houston','2','0','4','1859','Single-Family','This is a single-story home with 4 bedrooms, a formal dining area, and a family room. The bedrooms are separated from the common areas with a door and hallway. The family room is large and has a fireplace. The bedrooms are carpeted, wood in the great room and dining room, tile in the wet areas. The kitchen has a small breakfast bar and double ovens. The utility room is inside off one of the backdoors. The garage was designed by a handyman! The roof was replaced last year. Water heater is a few years old. Interior walls have fresh paint.','0.1768','24','','','Electric Dryer Connections,Washer Connections','','Other Disclosures,Owner/Agent,Sellers Disclosure','1','Gas Connections','1','Spring Branch','Central Gas','1','LT 10 BLK 21A SPRING SHADOWS SEC 11','Subdivision Lot','7700','Appraisal District','','336','0','','1','Double Oven','0','','','Electric Cooktop','','Composition','49 - Spring Branch','SPRING SHADOW ELEMENTARY SCHOOL','NORTHBROOK HIGH SCHOOL','SPRING WOODS MIDDLE SCHOOL','Leave Business Card,Lockbox Front,No Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Contemporary/Modern','Spring Shadows Sec 11','6623','2.4415','Public Water','1970','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T22:12:40.457' ,`MLSNumber` = '16465038' ,`ListAgentFullName` = 'Dondtray Thomas' ,`ListOfficeName` = 'Home Journey Realtors, LLC' ,`SellingAgentFullName` = 'Dondtray Thomas' ,`SellingOfficeName` = 'Home Journey Realtors, LLC' ,`Latitude` = '29.938743' ,`Longitude` = '-95.173655' ,`PhotoCount` = '50' ,`PostalCode` = '77044' ,`RoomCount` = '12' ,`ListPrice` = '499000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Waterside View' ,`StreetNumber` = '14918' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4051' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 5-bedroom and 4.5 bath stucco and brick home built by Taylor Morrison in a gated community located on Lake Houston! Master, Guest Suite, and Home Office/Study are on the first floor. Three Bedrooms are upstairs, along with a Media Room and Game Room. All Bedrooms have walk-in closets! The home features a spacious kitchen with upgraded granite countertops, a large island open to the family/living area to host family and friends, high ceilings, 8 ft. doors, a formal dining, a bay window in the breakfast area, butler\'s pantry, upgraded tile, carpet and ceiling fans. This stunning home also has custom Plantation Shutters in the office/study, dining room and side-light of front entry. The guest suite on the first floor has a custom wall feature. Did I forget to mention that the media room upstairs also has a projector, surround sound and large movie screen in order to enjoy late night movies with the family! Also, this home includes a back yard storage shed.' ,`Acres` = '0.1644' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 STILLWATER ON LAKE HOUSTON SEC 4' ,`LotDesciption` = 'Other' ,`LotSize` = '7161' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'CENTENNIAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stillwater/Lk Houston Sec 4' ,`TaxAmount` = '12797' ,`TaxRate` = '3.4539' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484966' WHERE `Matrix_Unique_ID` = '213969611' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T22:08:43.150' ,`MLSNumber` = '72954227' ,`ListAgentFullName` = 'Jenna D\'Amico' ,`ListOfficeName` = 'Coldwell Banker RealtyREALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.014536' ,`Longitude` = '-95.761651' ,`PhotoCount` = '40' ,`PostalCode` = '77433' ,`RoomCount` = '11' ,`ListPrice` = '725000.00' ,`Status` = 'Active' ,`StreetName` = 'Yellow Daisy' ,`StreetNumber` = '16514' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4294' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning backyard and view! This cul-de-sac charmer has a massive elegant covered back porch with built in speakers, kitchen including a beer tap, & don\'t forget about that lake view! This 4 bdrm, 4.5 bath home has the master suite & another other en-suite bedroom down as well. Enjoy a private study as well as a formal dining room with built in butlers pantry to include a multi bottle wine rack. The kitchen is MASSIVE! An abundant amount of granite counter and rich wood cabinet space that includes a gas cooktop, double ovens, fridge, & decorative stone backsplash. Central living space has a gas log fireplace and nice built ins. First floor master suite is lucky enough to have the back wall full of windows that overlooks the backyard lake view, spacious bathroom with a closet to die for. Upstairs has a relaxing rear balcony overlooking the lake, two oversized bedrooms, two full baths, a fabulous game room with pool table & even a media rm that includes equipment!' ,`Acres` = '0.3055' ,`Area` = '35' ,`BuilderName` = 'Trendmaker' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 1 FAIRFIELD VILLAGE NORTH SEC 3' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Water View' ,`LotSize` = '13309' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1015' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'SWENKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairfield Village North' ,`TaxAmount` = '15684' ,`TaxRate` = '2.611' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484966' WHERE `Matrix_Unique_ID` = '214000989' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T22:22:00.613' ,`MLSNumber` = '32096077' ,`ListAgentFullName` = 'Marcia Kyanka' ,`ListOfficeName` = 'Berkshire Hathaway HomeServicePremier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.829013' ,`Longitude` = '-95.450188' ,`PhotoCount` = '50' ,`PostalCode` = '77018' ,`RoomCount` = '10' ,`ListPrice` = '1100000.00' ,`Status` = 'Active' ,`StreetName` = 'Cheshire' ,`StreetNumber` = '2115' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3716' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous like new home..rivals new construction in highly sought after Oak Forest. Open concept living w/ chef\'s delight kitchen w/ 48 in-range, 11ft Mont Blanc island, wine chiller, large pantry & soft close cabinetry perfect for entertaining. Formal dining, study, & spacious family room w/ gaslog fireplace complete the downstairs. Primary Retreat w/ spa like bath has massive marble shower, separate soaking tub & huge walk-in closet, 3 large secondary bedrooms w/ walk-in closets, spacious game room, covered balcony & laundry conveniently located upstairs. Stunning white oak hardwood floors throughout home, designer lighting & plumbing fixtures, tons of storage, & large windows offering an abundance of natural light. Wired for alarm system & surround sound. Epoxy garage floor finish, 2 tankless water heaters, upgraded Trane HVACs, irrigation system w/ french drains. Inviting outdoor space offers front & back porches & yard large enough for a pool. A Must See. Welcome Home!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 10 OAK FOREST SEC 14' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'STEVENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Craftsman' ,`Subdivision` = 'Oak Forest Sec 14' ,`TaxAmount` = '15755' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667484967' WHERE `Matrix_Unique_ID` = '214029785' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T23:13:31.893' ,`MLSNumber` = '86947177' ,`ListAgentFullName` = 'Gwendolyn Davis' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.135072' ,`Longitude` = '-95.818052' ,`PhotoCount` = '49' ,`PostalCode` = '77447' ,`RoomCount` = '8' ,`ListPrice` = '549900.00' ,`Status` = 'Active' ,`StreetName` = 'Forest' ,`StreetNumber` = '24875' ,`StreetSuffix` = 'Circle' ,`City` = 'Hockley' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2602' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic piece of country living. Over 1/2 acre with large home of 4/5 bedroom 3 bath with a full 3 car garage. Large double driveway for extra parking. Large kitchen with huge granite bar overlooking open family room and has double gas ovens. Upstairs has private quarters of bathroom, guest room and/or den / game room. Primary is large with en-suite bath has double sinks, shower, deep tub, and large walk in closet. High ceilings and crown molding. Outside has above ground pool, sprinkler system with a $50-60,000 30x40 Mueller Building. Double gates on right side. Inside the Mueller building is a man cave with 250 sq. ft of A/C space. Could be workshop, office, boat or RV storage. Private patio covered for entertaining. Fully wired for security system including outside camera. Hurry you don\'t want to miss this' ,`Acres` = '0.57' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Gas,Propane' ,`HOAMandatory` = '1' ,`Legal` = 'S561100 LAKESIDE ESTATES 1 LOT 36 ACRES .57' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '24829' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '252' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'EVELYN TURLINGTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakeside Estates 1' ,`TaxAmount` = '8144' ,`TaxRate` = '2.0243' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484967' WHERE `Matrix_Unique_ID` = '214065319' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T22:21:46.340' ,`MLSNumber` = '31532554' ,`ListAgentFullName` = 'Lunguang Wat' ,`ListOfficeName` = 'RealtyOne Plus, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.505106' ,`Longitude` = '-95.449769' ,`PhotoCount` = '17' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '177000.00' ,`Status` = 'Active' ,`StreetName` = 'Victoria' ,`StreetNumber` = '5414' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1584' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Handyman\'s special. Unrestricted location, no HOA or MUD tax, no water bill. This 3 bedrooms, 2 bathroom home on foundation of pier & beam has upgraded kitchen and bathrooms. Wood floor throughout except tile in wet areas, hardwood floor in family room. New well tank and AC thermostat. Furnish the house with appliances, fix the problems in drywall, some faucets etc and make it your dream home.' ,`Acres` = '0.1793' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ROSEDALE ADDN, BLOCK 4, LOT 17' ,`LotDesciption` = 'Other' ,`LotSize` = '7811' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rosedale Add' ,`TaxAmount` = '1750' ,`TaxRate` = '1.7629' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484967' WHERE `Matrix_Unique_ID` = '214070052' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T22:17:45.230' ,`MLSNumber` = '43738298' ,`ListAgentFullName` = 'Lisett Labarca' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.741278' ,`Longitude` = '-95.476929' ,`PhotoCount` = '32' ,`PostalCode` = '77056' ,`RoomCount` = '9' ,`ListPrice` = '624990.00' ,`Status` = 'Active' ,`StreetName` = 'Ella Lee' ,`StreetNumber` = '5667' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2203' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing opportunity in the heart of Houston! This lovely Briar croft home provides fantastic proximity to shopping centers, schools, hotels and major office centers. You will enjoy being minutes away from over 452 dining and entertainment establishments!. Remodelers dream! Home in original condition with roof replaced 2010, fence 2014, dishwasher 2015, A/C and heat (16 SEER), duct work 2016. Large on corner lot, generous room sizes, formal dining, formal living, den, hardwoods, great flexible floor plan, patio with brick pavers and pergola. Beautiful, original hardwood floors fill all the major spaces. Live in now and build later or remodel to suit. All per Seller. Location offers convenient access to 610, 59, Westpark Tollway, The Galleria and Uptown Park. Never flooded per Seller. LOCATION, LOCATION,LOCATION.' ,`Acres` = '0.2114' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Galleria' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'TR 1 BLK 4 BRIARCROFT' ,`LotDesciption` = 'Corner' ,`LotSize` = '9208' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '660' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Briarcroft' ,`TaxAmount` = '15220' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1953' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1667484967' WHERE `Matrix_Unique_ID` = '214105795' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T22:58:13.267' ,`MLSNumber` = '51396947' ,`ListAgentFullName` = 'Brandon Wilson' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = 'Oscar Martinez' ,`SellingOfficeName` = 'HomeSmart' ,`Latitude` = '29.531011' ,`Longitude` = '-95.166926' ,`PhotoCount` = '23' ,`PostalCode` = '77546' ,`RoomCount` = '3' ,`ListPrice` = '294995.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Pirates Gold' ,`StreetNumber` = '2722' ,`StreetSuffix` = 'Circle' ,`City` = 'Friendswood' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1780' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well maintained home by the original owners in the desirable Heritage Park area. This 3 bedroom 2 bath features a large family room, breakfast area. The master bathroom has separate shower and soaking tub with a dual vanity. In the backyard is a covered patio and deck built for an above ground pool perfect for entertaining!' ,`Acres` = '0.1531' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 50 BLK 3 HERITAGE PARK SEC 21' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6669' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '352' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'GREENE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'BROOKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Heritage Park Sec 21' ,`TaxAmount` = '5430' ,`TaxRate` = '2.166' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484967' WHERE `Matrix_Unique_ID` = '214107164' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T23:35:50.577' ,`MLSNumber` = '50534725' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.146373' ,`Longitude` = '-95.678460' ,`PhotoCount` = '8' ,`PostalCode` = '77362' ,`RoomCount` = '12' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Lakemont Bend' ,`StreetNumber` = '1064' ,`StreetSuffix` = 'Lane' ,`City` = 'Pinehurst' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3548' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW!! Gorgeous Village Builders Wentworth Series \'\'Whitaker\" Design, Elevation \'\'J\'\'. This new two-story home was designed with families in mind. The first floor features an open design among the Great Room, kitchen and nook, which opens out to an EXTENDED covered patio. A study and formal dining room are found off the foyer. The luxe primary suite and a secondary bedroom are restful retreats. Upstairs are a versatile bonus room and three secondary bedrooms, which all have walk-in closets.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Village Builders' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0013 BLK 003 LOT 011' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodtrace' ,`TaxAmount` = '' ,`TaxRate` = '3.4309' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667484968' WHERE `Matrix_Unique_ID` = '214127531' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T22:12:38.147' ,`MLSNumber` = '3490812' ,`ListAgentFullName` = 'Juli Morman' ,`ListOfficeName` = 'RE/MAX 5 Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.675032' ,`Longitude` = '-95.058469' ,`PhotoCount` = '44' ,`PostalCode` = '77571' ,`RoomCount` = '7' ,`ListPrice` = '415000.00' ,`Status` = 'Active' ,`StreetName` = 'H' ,`StreetNumber` = '11226' ,`StreetSuffix` = 'Street' ,`City` = 'La Porte' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2186' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this one story on over an acre and bring all your animals!!! Enter the home to an open concept, Living, breakfast and kitchen with a walk-in pantry! Tile is throughout the entire home so no carpet! The living room has gorgeous wood beams that accent the tall ceilings. This home features 4 bedrooms and 3 full bathrooms. One of the bedrooms and bathrooms has its own access from outside and also has all the stub outs ready for a kitchenet perfect for a guest or renter. All bathrooms have been updated. Utility room is inside. Roof was replaced 3 years ago! Call today for your private showing!' ,`Acres` = '1.0013' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 471D & 471D-1 LA PORTE OUTLOTS' ,`LotDesciption` = 'Other' ,`LotSize` = '43616' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'LOMAX ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LOMAX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'La Porte Outlots' ,`TaxAmount` = '7696' ,`TaxRate` = '2.7208' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484968' WHERE `Matrix_Unique_ID` = '214188741' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T23:26:32.307' ,`MLSNumber` = '46488403' ,`ListAgentFullName` = 'Karen Karapasha' ,`ListOfficeName` = 'Real Living Karapasha Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.713981' ,`Longitude` = '-95.836047' ,`PhotoCount` = '50' ,`PostalCode` = '77494' ,`RoomCount` = '11' ,`ListPrice` = '775000.00' ,`Status` = 'Active' ,`StreetName` = 'Cinco Falls' ,`StreetNumber` = '5107' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4390' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic home in highly desired Cinco Ranch. Beautiful curb appeal welcomes you to a covered porch with brick pavers. Upon entering you will notice the tall ceilings, pretty hardwood flooring and wall of windows overlooking the backyard. Kitchen with light cabinetry, island, granite and dual ovens. The spacious family room with fireplace is open to the kitchen and provides ample space for family gatherings and entertaining. Primary bedroom located on first floor. Wall of windows with views to the pool/spa and nicely landscaped yard. Primary bath with dual sinks, jetted tub and walk in shower. Dual closets with built in closet systems. Three spacious bedrooms upstairs. Jack and Jill bath serves two of the rooms, Third full bath is open for access to bedroom, media and game room. New carpet throughout. Yard with pool/spa/slide and outdoor kitchen. Space for your furry friends. Great schools and walking distance to playground, trails and amenities. This home will wow you.' ,`Acres` = '0.2254' ,`Area` = '36' ,`BuilderName` = 'Trendmaker' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CINCO RANCH SOUTHWEST SEC 46, BLOCK 3, LOT 36' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '9817' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'STANLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'SEVEN LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cinco Ranch' ,`TaxAmount` = '15928' ,`TaxRate` = '2.7695' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484968' WHERE `Matrix_Unique_ID` = '214191061' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T23:33:23.940' ,`MLSNumber` = '37214030' ,`ListAgentFullName` = 'Barbara Miller' ,`ListOfficeName` = 'Vista Real Estate' ,`SellingAgentFullName` = 'Barbara Miller' ,`SellingOfficeName` = 'Vista Real Estate' ,`Latitude` = '29.443687' ,`Longitude` = '-95.417376' ,`PhotoCount` = '43' ,`PostalCode` = '77583' ,`RoomCount` = '8' ,`ListPrice` = '419000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Carson' ,`StreetNumber` = '9631' ,`StreetSuffix` = '' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2891' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Sellers spared no expense when building this gorgeous 4 bedroom, 2.5 bathrooms home along with several upgrades including kitchen cabinets, tile plank flooring except in guest bedrooms, quartz counter tops, 8\' doors, lighting, speakers in & out & a very large covered patio w/fans. The beautiful kitchen is the heart of the home complete w/an oversized island & stainless steel appliances. The open concept allows the chef of the family to join in on conversations in the living & dining roomS. Imagine relaxing in the soaking tub in the primary bathroom. The extended, oversized outdoor patio offers a fun spot to hang out and watch the games. The backyard has plenty of room for your fur babies or kids to play. THE HOME HAS A VERY LARGE FLEXROOM & W/ AN ACCEPTABLE OFFER, THE SELLERS WILL HAVE A CLOSET PROFESSIONALLY BUILT IN THIS ROOM TO CONVERT AS THE 4TH BEDROOM BEFORE CLOSING, OR BUYERS CAN LEAVE THE FLEXROOM AS IS. Adventure Cove w/wave pool, tidal river & fitness center are coming soon' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Meridiana Sec 7 Blk 2 Lot 35' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9425' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484968' WHERE `Matrix_Unique_ID` = '214191552' --> 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','214192330','1667484968','214192330','2022-11-02T23:33:45.170','79579826','Celina Gomez','eXp Realty, LLC','','','29.739710','-95.256500','11','77029','11','249000.00','Active','De Haven','313','','Houston','2','1','3','1650','Single-Family','New Construction! Bautiful new home for sale featuring 3 Bedrooms and 2 1/2 baths, this is a modern property with an open floor plan that offers recessed lighting and many more modern amenities throughout. Great dining room/living combo. This property is in close proximity to Port of Houston and 20 minutes from Downtown Houston.','','2','M Guzman Constructio','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','North Channel','Central Gas','0','LTS 6 BLK 23 Fidelity','Other','','','','','1','Never Lived In','1','','0','','','Gas Range','','Composition','21 - Galena Park','JACINTO CITY ELEMENTARY SCHOOL','GALENA PARK HIGH SCHOOL','GALENA PARK MIDDLE SCHOOL','Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied','Builder','2','Contemporary/Modern','Fidelity','0','','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214210135','1667484969','214210135','2022-11-02T22:42:23.127','26797487','Ana De Los Reyes','Realty ONE Group, Experience','','','30.146644','-95.525793','50','77389','10','1115000.00','Active','Fremont Ridge','14','Loop','Spring','5','1','5','4568','Single-Family','Absolutely stunning home with soaring ceiling and open floor plan! Come preview the lovely home built by Partners In Building. Home as master and guest room down, spacious kitchen with beautiful granite counters and wood cabinetry. The high ceilings and wall of windows in the family area really make this area of the home the place to be! 3 bedrooms up along with the spacious media room with includes all audio and video equipment! Outdoor kitchen under a covered roof, beautiful pool with spa and waterfall, perfect place to entertain friends and family','','14','','','','','Mud,Sellers Disclosure','1','','1','The Woodlands','Central Electric','0','LT 21 BLK 1 THE WOODLANDS VLG OF CREEKSIDE PARK 23','Other','11570','Appraisal District','','','0','','3','Double Oven','1','Gunite,Heated','','','','Composition','53 - Tomball','CREEKSIDE FOREST ELEMENTARY SCHOOL','TOMBALL HIGH SCHOOL','CREEKSIDE PARK JUNIOR HIGH SCHOOL','Appointment Required,Call Occupant,Supra Keybox','Appraisal District','2','Traditional','The Woodlands Creekside Park 23','20444','2.6895','Water District','2011','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T23:30:33.590' ,`MLSNumber` = '8416091' ,`ListAgentFullName` = 'Jennifer Bean' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.827998' ,`Longitude` = '-95.427185' ,`PhotoCount` = '25' ,`PostalCode` = '77018' ,`RoomCount` = '6' ,`ListPrice` = '559500.00' ,`Status` = 'Active' ,`StreetName` = 'Gardenia' ,`StreetNumber` = '1070' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1594' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great Opportunity to own in Garden Oaks. This home is 3 bedroom and 2 full bathrooms on a 7,134 sq foot lot. There is a large 2 car garage, extended driveway, porte-cochere and driveway gate. This home has hardwood floors and tile. Kitchen is equipped with stainless steel appliances. The kitchen opens to the dining room and cozy den. Spacious primary bedroom and secondary bedrooms. Great backyard for grilling and entertaining.' ,`Acres` = '0.168' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Garden Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 18 BLK 53 GARDEN OAKS SEC 5' ,`LotDesciption` = 'Other' ,`LotSize` = '7320' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GARDEN OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Garden Oaks Sec 05' ,`TaxAmount` = '11128' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1947' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484969' WHERE `Matrix_Unique_ID` = '214220564' --> 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','214223703','1667484969','214223703','2022-11-02T22:59:55.273','33629853','Jana Ostergrant','Realty Associates','','','29.532581','-95.221431','29','77581','10','460000.00','Active','Kimberly','3916','Drive','Pearland','2','0','4','2867','Single-Family','This is the home you have been looking for. Cul-de-sac lot with big backyard, in ground pool with spa which was totally redone in 2021, sprinkler system in front yard and in flower beds in the backyard. New exterior paint and sidewalk from driveway to front door will be leveled on 11-8-2022. Four bedrooms, two baths, open kitchen to living area and dining room with doubled sided gas fireplace. Granite counter tops in Kitchen and primary bath, 42 inch cabinets with island and sliding drawers. Large family room with a walk in closet with lots of storage and built in book shelves. Detached 2 car garage with garage openers. Room sizes approximate.','0.3389','5','','','Gas Dryer Connections,Washer Connections','','Owner/Agent,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Pearland','Central Gas','1','SUNSET LAKES SEC 3 (A0111 PERRY & AUSTIN)(PEARLAND) BLK 9 LO','Cul-De-Sac','14762','Appraisal District','','368','0','','2','Gas Oven','1','Gunite,In Ground','','Gas Cooktop','','Composition','42 - Pearland','RUSTIC OAK ELEMENTARY SCHOOL','PEARLAND HIGH SCHOOL','PEARLAND JUNIOR HIGH EAST','Accompany,Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','1','Traditional','Sunset Lakes Sec 3','8400','2.5552','Public Sewer,Public Water','2000','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T23:25:46.240' ,`MLSNumber` = '3645722' ,`ListAgentFullName` = 'Judith Zahora' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.080931' ,`Longitude` = '-95.124166' ,`PhotoCount` = '48' ,`PostalCode` = '77336' ,`RoomCount` = '13' ,`ListPrice` = '575900.00' ,`Status` = 'Active' ,`StreetName` = 'Vista Del Lago' ,`StreetNumber` = '614' ,`StreetSuffix` = 'Drive' ,`City` = 'Huffman' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3352' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful custom-built one-of-a-kind house on 1.85 acres set back from road on quiet, winding street in the lovely lakeside master planned community of Commons of Lake Houston. A tranquil oasis from city life yet w/easy access to FM 2100, 99/Grand Parkway/major freeways. Chef’s kitchen with lots of granite counter space, custom cabinetry, 5-burner gas range, granite breakfast bar. Wonderful backyard greenhouse, lots of mature trees, breezeway, and covered patio. Plenty of land on which to build that backyard oasis/pool/spa. Oversized detached three-car garage with huge attic to build out or use for storage. Elegant front door entry, natural light galore! Study, Dining Room, Great room’s vaulted ceiling, primary bedroom suite/bath w/walk-in closets and half-bath on 1st floor. 3 bedrooms,2 full baths, game/flex room upstairs. Did I mention low property taxes, miles of hiking/biking/equestrian trails, pool, lakeside park, lakes and boat docks?? Welcome Home!!' ,`Acres` = '1.8485' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Gas,Propane' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 4 COMMONS OF LAKE HOUSTON SEC 3' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '80520' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'FALCON RIDGE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Commons Lake Houston Sec 03' ,`TaxAmount` = '9038' ,`TaxRate` = '2.0083' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484969' WHERE `Matrix_Unique_ID` = '214226104' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T22:41:52.177' ,`MLSNumber` = '89360455' ,`ListAgentFullName` = 'Donna Mitchell' ,`ListOfficeName` = 'Birdsong Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.964275' ,`Longitude` = '-95.292434' ,`PhotoCount` = '49' ,`PostalCode` = '77541' ,`RoomCount` = '9' ,`ListPrice` = '660000.00' ,`Status` = 'Active' ,`StreetName` = 'Marlin' ,`StreetNumber` = '103' ,`StreetSuffix` = 'Lane' ,`City` = 'Freeport' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BRIDGE HARBOR Canal home in the heart of the subdivision. Being sold furnished, new waterproof LVP throughout and many other updates as of 2022. Coastal living begins from the moment you walk through the gate as you are greeted by swings and a relaxing entertainment area and gorgeous landscaping. Home has multi-level decks where you can take in the surrounding views and enjoy the breeze. Inside is an open living/dining/kitchen area. First floor has two bedrooms, one with en-suite and full bath, in hallway you have half bath with laundry room. Upstairs is the larger primary bedroom with private balcony overlooking the property and a perfect spot to enjoy your coffee as the sun rises. In addition to all of the entertainment space downstairs, you also have a boat slip with lift and cleaning station to really take in what canal living is all about. During high tide, the water levels are about 4.5\'. A/C outside condenser replaced 2021. Call today to schedule your showing!' ,`Acres` = '0.116' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BRIDGE HARBOR (A0051 DIV 8 (B C I C)) (FREEPORT) LOT 102A-10' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '5053' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,No Photos/No Videos,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridge Harbor' ,`TaxAmount` = '7761' ,`TaxRate` = '2.5981' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484969' WHERE `Matrix_Unique_ID` = '214232370' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T22:01:22.300' ,`MLSNumber` = '3968928' ,`ListAgentFullName` = 'Sergio Garcia' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.846631' ,`Longitude` = '-95.651166' ,`PhotoCount` = '20' ,`PostalCode` = '77084' ,`RoomCount` = '3' ,`ListPrice` = '395000.00' ,`Status` = 'Active' ,`StreetName` = 'Winthrop Bend' ,`StreetNumber` = '16547' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2722' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous two story house features 3 bedrooms, 2.5 bathrooms, studio, Great front porch, tile & laminated flooring through out the entire house. Nice kitchen with granite countertops, stainless steel appliances, open to the main living area. Master bedroom with walk-in closet, his and her sink, separated stand-in shower and bathtub. Additional 220 sq ft. (approx.) added to create a larger dinning area so actually the house is larger than what the county records show. Extra large Back porch as wide as the house for outside entertaining. This house is located conveniently minutes away from shopping, entertaining and dining center. Easy access to major routes such as Hwy 6, FM 529 and I-10.' ,`Acres` = '0.1284' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 34 BLK 1 BERKSHIRE PLACE SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5591' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '725' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'LIEDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'WATKINS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Berkshire Place Sec 5' ,`TaxAmount` = '6543' ,`TaxRate` = '2.601' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484969' WHERE `Matrix_Unique_ID` = '214234178' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T23:15:50.013' ,`MLSNumber` = '80499272' ,`ListAgentFullName` = 'Arash Asgharian' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.757288' ,`Longitude` = '-95.591801' ,`PhotoCount` = '50' ,`PostalCode` = '77077' ,`RoomCount` = '7' ,`ListPrice` = '750000.00' ,`Status` = 'Active' ,`StreetName` = 'Heathwood' ,`StreetNumber` = '1215' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3043' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is an absolute gem! Located in Energy Corridor, just minutes from the beautiful Terry Hershey Park! This house has been FULLY remodeled. On the exterior - new roof, windows, AC, siding, gutters with leaf guard, exterior doors and more! The interior has been completely remodeled with a modern, open layout and a VERY spacious kitchen with a large island, gorgeous appliances, kitchen prep area, tons of storage and beautiful natural wood floating shelves. If you love to cook and entertain, this kitchen is a dream!\r\nEntertain guests and spend the evening relaxing in this spacious open concept living area with a gorgeous bar, sitting area and open dining/kitchen area. The gorgeous garage apartment makes the perfect area for both short/long term visitors. Make them feel at home with their own full bath and open bed/living area where they have their own space to relax in. \r\nThis home is one of a kind with so many unique features and beautiful craftsmanship.' ,`Acres` = '0.2023' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 4 WOODS OF LAKESIDE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8814' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '770' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ASHFORD/SHADOWBRIAR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Woods Lakeside' ,`TaxAmount` = '8659' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667484969' WHERE `Matrix_Unique_ID` = '214302148' --> 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','214338485','1667484970','214338485','2022-11-02T22:43:02.390','53723578','Niveen Chabaita','Bayou Vista Realty, LLC','','','29.730664','-94.965215','14','77520','2','95000.00','Active','Pearce','220','Street','Baytown','1','0','2','874','Single-Family','Great investment property in Baytown featuring 2 bedrooms, 1 bath sitting on 5000 sqft lot size. Property is sold AS IS and needs full rehab. Home is is located minutes away from Hwy 99 and 146. Don\'t miss out this opportunity. Room dimensions are approximate.','0.1148','2','','','','','No Disclosures','','','','Baytown/Harris County','Other Heating','0','LTS 3 & 4 BLK 2 WRIGHT GEORGE','Other','5000','Appraisal District','','','0','','0','','0','','','','','Wood Shingle','23 - Goose Creek Consolidated','ASHBEL SMITH ELEMENTARY SCHOOL','LEE HIGH SCHOOL (GOOSE CREEK)','HORACE MANN J H','Appointment Required','Appraisal District','1','Traditional','Wright George','1734','2.97','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','214340199','1667484970','214340199','2022-11-02T22:29:43.977','7131244','Xiaoming Shao','31 Realty','','','29.868290','-95.203977','32','77044','4','245000.00','Active','Solitude','10310','Way','Houston','2','0','4','1650','Single-Family','New paint. Move in ready','0.101','2','','','','','No Disclosures','','','','North Channel','Central Gas','1','LT 14 BLK 5 EVERGREEN VILLAS SEC 1','Other','4400','Appraisal District','','500','0','','2','','0','','','','','Composition','46 - Sheldon','CARROLL ELEMENTARY SCHOOL (SHELDON)','CE KING HIGH SCHOOL','MICHAEL R. NULL MIDDLE SCHOOL','Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Traditional','Evergreen Villas Sec 2','5347','3.0293','Public Sewer,Public Water','2017','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','214343197','1667484970','214343197','2022-11-02T22:49:28.470','59995082','Wenjie Wang','Sunet Group','','','29.743830','-95.859063','33','77494','4','659900.00','Active','Hannahs Harbor','28306','Lane','Katy','3','1','4','3404','Single-Family','LAKEVIEW!! KATY ISD!! Zoned to Tompkin High School!!! Okay Gorgeous 2-story home featuring 4 bedroom, 3.5 bathroom and 2 car garage! The 1st floor offers a grand entry. The gourmet kitchen includes granite counter tops, stainless steel appliances, beautiful backsplash and open concept floorplan with the kitchen opening to the family room while the primary bedroom has carpet, dual vanities, a bath tub, separate shower. Upstairs holds a game room, 3 bedrooms, and 2 full bathrooms. There\'s iron fence in the backyard with beautiful lake view.Come see this beautiful home situated in one of Katy\'s best communities, Tamarron. Tamarron offers everything you are looking for in a family friendly community- resort pool, splashpad, fitness center, sports fields, lakes & walking trails all included! Call today for your own private tour!','0.2138','36','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Katy - Southwest','Central Gas','1','TAMARRON SEC 38, BLOCK 1, LOT 15','Water View,Waterfront','9311','Appraisal District','','1250','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','30 - Katy','CAMPBELL ELEMENTARY SCHOOL (KATY)','JORDAN HIGH SCHOOL','WOODCREEK JUNIOR HIGH SCHOOL','Lockbox Front','Appraisal District','2','Traditional','Tamarron Sec 38','7112','3.1745','Public Sewer,Public Water,Water District','2021','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214343376','1667484970','214343376','2022-11-02T22:28:45.710','30526187','Sony Kohli','REALM Real Estate Professional','','','29.863854','-95.619014','49','77041','6','369900.00','Active','Rowena','6306','Lane','Houston','2','1','4','2934','Single-Family','Beautiful home 4 bed 2.5 bathroom. Close to all major highways and shopping centers. Quite neighborhood.','0.1452','8','','','','','Mud,Owner/Agent,Sellers Disclosure','','','1','Eldridge North','Central Gas','1','LT 34 BLK 1 CONCORD BRIDGE NORTH SEC 2','Subdivision Lot','6325','Appraisal District','','370','0','','2','','0','','','','','Composition','13 - Cypress-Fairbanks','LEE ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','CYPRESS FALLS HIGH SCHOOL','TRUITT MIDDLE SCHOOL','Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied','Appraisal District','2','Traditional','Concord Bridge North Sec 02','5865','2.471','Water District','1997','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','214343639','1667484970','214343639','2022-11-02T22:48:20.037','69561770','Wenjie Wang','Sunet Group','','','29.736287','-95.850711','33','77494','4','559000.00','Active','Shiloh Pine','27803','Lane','Katy','3','1','4','3280','Single-Family','Beautiful home with 4 bedrooms,3.5 baths,open living spaces,high ceilings,3 car garage w/4\'extension. Brick & stone elevation, covered front porch. Two story entry opens to formal dining & study. Island kitchen features granite,double ovens,gas range. Two story family room w/cast stone fireplace. Master suite on 1st floor-jetted tub,oversized shower,dual sinks. Large, enclosed gameroom. Upgraded fixtures & flooring, coffered ceilings, sprinkler system & more.','0.194','36','','','','','Sellers Disclosure','1','','','Katy - Southwest','Central Gas','1','CINCO RANCH NORTHWEST SEC 5, BLOCK 2, LOT 3','Subdivision Lot','8452','Appraisal District','','1000','0','','3','','0','','','','','Composition','30 - Katy','JENKS ELEMENTARY SCHOOL','JORDAN HIGH SCHOOL','ADAMS JUNIOR HIGH SCHOOL','Lockbox Front','Appraisal District','2','Traditional','Cinco Ranch Northwest Sec 5','10493','2.7545','Public Sewer,Public Water,Water District','2014','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214343644','1667484970','214343644','2022-11-02T22:23:46.320','36635114','Paulino Miranda','NB Elite Realty','','','29.687145','-95.328051','19','77033','4','224999.00','Active','Southmont','5961','Street','Houston','2','0','4','1350','Single-Family','Updated 4 bedroom 2 bath home near medical center blocks from 610, newr 45 Gulf freeway, airport, restaurants and stadium. Newly installed roof and siding, cabinets, granite countertops, stainless steel appliances, ceramic tiles, carpet tin bedrooms only and updated flooring throughout hoise, utility room in house with new water heater, energy efficient HVAC. Come and set your appointment and see your new home!','0.1591','3','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','','','','Medical Center South','Central Electric','0','LT 37 BLK 9 SOUTHCREST SEC 1','Cleared,Subdivision Lot','6930','Appraisal District','','','0','','0','Freestanding Oven','0','','','Freestanding Range','','Composition','27 - Houston','KELSO ELEMENTARY SCHOOL','STERLING HIGH SCHOOL (HOUSTON)','ATTUCKS MIDDLE SCHOOL','Accompany,Lockbox Front,No Appointment Required,Vacant/Unoccupied','Seller','1','Traditional','Southcrest Sec 01','1956','2.3307','Public Sewer,Public Water','1949','Appraisal District'); --> New record created successfully