Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T22:33:32.840' ,`MLSNumber` = '31922457' ,`ListAgentFullName` = 'Diana Ali' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.041539' ,`Longitude` = '-95.360634' ,`PhotoCount` = '21' ,`PostalCode` = '77373' ,`RoomCount` = '3' ,`ListPrice` = '205000.00' ,`Status` = 'Active' ,`StreetName` = 'Donalbain' ,`StreetNumber` = '4527' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1284' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Cozy House! Three Bedroom, Two Full Baths. Recently Painted and New Carpet in 2022. Kitchen Granite Countertops, New Flooring throughout the Living Room Area, with a Spacious Big Backyard for Great Barbecue\'s! Just Minutes away from George Bush Airport. The Community also features Great Amenities such as a Neighborhood Playground, Swimming Pool to keep cool and beat the Summer Heat.\r\nSchedule your Showing Today! NEVER FLOODED.' ,`Acres` = '0.1722' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 & TR 14B BLK 10 FAIRFAX SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '370' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'MILDRED JENKINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairfax Sec 01' ,`TaxAmount` = '4144' ,`TaxRate` = '2.9367' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042205' WHERE `Matrix_Unique_ID` = '210883747' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T23:50:04.087' ,`MLSNumber` = '90826692' ,`ListAgentFullName` = 'Josephine Bruno' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.884597' ,`Longitude` = '-95.645895' ,`PhotoCount` = '49' ,`PostalCode` = '77095' ,`RoomCount` = '11' ,`ListPrice` = '424900.00' ,`Status` = 'Active' ,`StreetName` = 'River Garden' ,`StreetNumber` = '7419' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3460' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic Copperfield Southdown beauty updated to the max.... attic insulation cap, roof, ext paint, cement board siding-2020, HVAC-2021, 2022-landscaping, int-paint, carpet & vinyl plank floors entire home, brand new never used primary bath reno, fiberglass front & rear doors, light fixtures, 2\" blinds, and the list goes on! Simple floorplan w/huge rooms thru-out. Fabulous open kitchen with spacious island, large pantry, granite counters, & stainless Jenn-Air kitchen appliances, all included. Finished 3-car garage is a man-cave delight, stereo and tv included. LOW Taxes & HOA Dues. Highly Acclaimed CFISD schools w/beloved elementary 3-blocks away, an absolute must see for this price in a master plan community!' ,`Acres` = '0.2041' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 2 COPPERFIELD SOUTHDOWN VILLAGE SEC 6' ,`LotDesciption` = 'Corner' ,`LotSize` = '8892' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '645' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'LOWERY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LANGHAM CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'ARAGON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Copperfield Southdown Village' ,`TaxAmount` = '6958' ,`TaxRate` = '2.357' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042205' WHERE `Matrix_Unique_ID` = '210977373' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T23:26:22.317' ,`MLSNumber` = '85002935' ,`ListAgentFullName` = 'Geng Zhou' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.587529' ,`Longitude` = '-95.601306' ,`PhotoCount` = '27' ,`PostalCode` = '77479' ,`RoomCount` = '7' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Jenny' ,`StreetNumber` = '2914' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2432' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEVER FLOODED! This magnificently maintained one-story 3-bedroom 2-bathroom is located in First Colony. Back to green belt, offering extra privacy with no back neighbors. Open concept with tons of living space that opens to kitchen and breakfast area. Split bedrooms with a versatile game-room loft. Fresh paint (2022), and brand-new cooktop and dishwasher (2022). Highly acclaimed Fort Bend schools. Zoned to Settlers Way ES, First Colony MS, and Clements HS. Low HOA and taxes. Short drive from premier shopping, dinning, and entertainment. Schedule your private showing today!' ,`Acres` = '0.1581' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Seller may be subject to foreign tax and Buyer withholding per IRS,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SETTLERS PARK SEC 1, BLOCK 1, LOT 41' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6887' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '420' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SETTLERS WAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Settlers Park Sec 1' ,`TaxAmount` = '6103' ,`TaxRate` = '2.1584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042205' WHERE `Matrix_Unique_ID` = '211375405' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T22:18:02.360' ,`MLSNumber` = '21083071' ,`ListAgentFullName` = 'Gary Bisha' ,`ListOfficeName` = 'My Castle Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.822970' ,`Longitude` = '-95.425518' ,`PhotoCount` = '49' ,`PostalCode` = '77018' ,`RoomCount` = '5' ,`ListPrice` = '1050000.00' ,`Status` = 'Active' ,`StreetName` = 'Fisher' ,`StreetNumber` = '1013' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4138' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'OwnerFin Available at 5%! Or seller will contribute up to 25K to buyer Fin. Building New Pool 33x16 ft. Fully renovated home features 2 primary suites with, Bigger one up and the other downstairs, with Texas-Size Closets and Bathrooms. Open-Concept Kitchen with top of the line appliances, 60in Viking Professional Refrigerator, Wolf 48in 8 Burner Double Oven Range, KitchenAid Micro. Huge Kitchen with (10ft by 5ft) Island and tons of Soft-Close Cabinets. Kitchen overlooks the Family & Dining area with quick access to back patio, perfect for entertaining. Recent windows, doors & White Oak Solid Hardwoods throughout. Huge shower w/ shower heads that illuminate (blue/cold water, green/warm, red/hot). Dimmable LED Lights with dimmer switches in each Room. Upstairs is the Game Room with Kitchenette/bar/w full bathroom which can double as guest suite. Plenty of green-space in the backyard for a pool, pets, and play (bath in shed). Mins to popular restaurants, parks, 610, I-45, 290 & Downtown.' ,`Acres` = '0.1612' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 7 BLK 16 OAK FOREST SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7020' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GARDEN OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Oak Forest' ,`TaxAmount` = '19173' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042205' WHERE `Matrix_Unique_ID` = '211938561' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T23:07:53.810' ,`MLSNumber` = '3817396' ,`ListAgentFullName` = 'Ronald Espling' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.669957' ,`Longitude` = '-95.496725' ,`PhotoCount` = '42' ,`PostalCode` = '77096' ,`RoomCount` = '9' ,`ListPrice` = '599900.00' ,`Status` = 'Active' ,`StreetName` = 'Yarwell' ,`StreetNumber` = '6027' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2819' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming home in the highly sought after and established neighborhood of Maplewood South has been tastefully renovated! The homes layout has been taken from closed off/isolated to spacious/open! New windows welcome tons of natural light as well as providing better efficiency. The stunning kitchen has been generously expanded and offers soft close cabinetry, new stainless steel appliances, gas range, lux glass tile backsplash, and more! Home office/study area offers a nice place to work or focus on daily tasks. Large primary suite has more than enough room for a king sized bed and a seating area and offers a stunning spa like primary bathroom with gorgeous glass tile shower and walk in closet. Large secondary bedrooms offer family the space they crave and one of the secondary bedrooms offers its own private en suite bathroom. Other updates: PEX plumbing, new lux flooring, New electrical, new quartz counters, new tile, recessed lighting, new cabinets, new paint inside and out, and more!' ,`Acres` = '0.1901' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 24 MAPLEWOOD SOUTH SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8280' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '487' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ELROD ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'FONDREN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Other Style,Traditional' ,`Subdivision` = 'Maplewood South Sec 06' ,`TaxAmount` = '7030' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042206' WHERE `Matrix_Unique_ID` = '212455505' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T22:34:45.970' ,`MLSNumber` = '2753790' ,`ListAgentFullName` = 'Corinne Hill' ,`ListOfficeName` = 'Keller Williams Hou Preferred' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.520395' ,`Longitude` = '-95.425640' ,`PhotoCount` = '39' ,`PostalCode` = '77583' ,`RoomCount` = '5' ,`ListPrice` = '339900.00' ,`Status` = 'Active' ,`StreetName` = 'Spicewood Harbor' ,`StreetNumber` = '13203' ,`StreetSuffix` = 'Court' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2120' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new Home!! Located in the quite and peaceful neighborhood of Laurel Heights at Savannah, in Rosharon Texas right off 288. This Stunning Lennar Home is sitting on corner lot with Gorgeous Landscaping to compliment the brick exterior, 2 car garage, and Tons of Extras, including Solar power with backup battery system for outages. 12\'x14\' Home Depot Storage shed with professionally installed electricity. Security Cameras with Remote access. Soaking Garden tub and Separate standing shower in Primary Bedroom with walk in closet, and added professionally installed bathroom cabinets. And 3 secondary rooms for plenty added space !! Schedule Your Showing Today !!' ,`Acres` = '0.1736' ,`Area` = '5' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAUREL HEIGHTS AT SAVANNAH SEC 9 (A0302 HT&BRR) BLK 1 LOT 17' ,`LotDesciption` = 'Corner' ,`LotSize` = '7562' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '90' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'POMONA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Laurel Heights At Savannah' ,`TaxAmount` = '9173' ,`TaxRate` = '3.3694' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042206' WHERE `Matrix_Unique_ID` = '212710773' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T22:08:31.703' ,`MLSNumber` = '2228588' ,`ListAgentFullName` = 'Shan Qiu' ,`ListOfficeName` = 'S & J Company' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.707593' ,`Longitude` = '-95.605294' ,`PhotoCount` = '24' ,`PostalCode` = '77072' ,`RoomCount` = '8' ,`ListPrice` = '289000.00' ,`Status` = 'Active' ,`StreetName` = 'Bayberry Bend Circle' ,`StreetNumber` = '12710' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2129' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New improved listing price.\r\nBeautifully Remodeled Perry Homes on a corner lot near Bellaire in Dairy Ashford. The whole house is recently upgraded by waterproof vinyl plank flooring. Kitchen is totally renovated: new granite countertop, new stainless-steel sink and new kitchen faucet, new stove, new microwave, new light fixtures, new fans. New paint everywhere, new toilets. Crown molding is through the house, even the two-car garage is nicely done, supplying a lot space for entertainment and comfort living. Good Location: low tax region, easy access to Bellaire, Dairy Ashford, Bellway 8, Hwy 6 and Westpark tollway. Closed to school. You will like it. Hurry, it wouldn’t last long!\r\nPlease wear shoe covers provided by the owner besides the door to enter the house.' ,`Acres` = '0.0852' ,`Area` = '28' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 1 HIGH STAR SEC 3' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '3713' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'MAHANAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'O\'DONNELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'High Star Sec 03' ,`TaxAmount` = '4075' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042206' WHERE `Matrix_Unique_ID` = '212798095' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T22:22:35.780' ,`MLSNumber` = '54468939' ,`ListAgentFullName` = 'Mary Markwardt' ,`ListOfficeName` = 'HOUSTON TOP REALTY' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.504049' ,`Longitude` = '-95.427705' ,`PhotoCount` = '48' ,`PostalCode` = '77583' ,`RoomCount` = '9' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Baron Hill' ,`StreetNumber` = '13215' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2082' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'There\'s a Lot to LOVE about this Home! The spacious living room is light and bright with a corner fireplace and soaring ceiling. Tile flooring in entry, kitchen, breakfast and living room. Homeowner turned the formal dining room into a study with french doors. Upstairs offers a game room, two additional bedrooms and full bath. The utility room is oversized and offers a great space for a beer fridge or doggie kennel. Plenty of storage. New A/C and furnace August, 2022. Lakes of Savannah offers two pools, two club houses, splash pad, parks, ponds & miles of sidewalks. Located near Hwy. 6 and Hwy. 288. Just minutes to Pearland Town Center. Neighborhood did NOT lose power during the big freeze of 2021! Welcome to your new HOME!' ,`Acres` = '0.137' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SAVANNAH MEADOWS SEC 4 (A0562 HT&BRR) BLK 4 LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5968' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '670' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'SAVANNAH LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes of Savannah' ,`TaxAmount` = '8138' ,`TaxRate` = '3.1908' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042206' WHERE `Matrix_Unique_ID` = '212802693' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T22:24:52.167' ,`MLSNumber` = '82355698' ,`ListAgentFullName` = 'Mary Markwardt' ,`ListOfficeName` = 'HOUSTON TOP REALTY' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.499673' ,`Longitude` = '-95.442193' ,`PhotoCount` = '30' ,`PostalCode` = '77583' ,`RoomCount` = '8' ,`ListPrice` = '310000.00' ,`Status` = 'Active' ,`StreetName` = 'Windy Knoll' ,`StreetNumber` = '5705' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2259' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'JUST UNPACK & MOVE IN! Lovely 4 bedroom one story with spacious open floor plan. Home has fresh custom interior paint throughout! No need for any touchups here. The living room, dining room and kitchen are open and flowing offering a great space for entertaining. Brand new luxury vinyl plank flooring and new carpet installed August, 2022. There is an ample sized covered back patio with an extended wooden deck which is the perfect setting for reading, cranking up the grill or even dancing! A little music and twinkle lights and you\'re set! No power lines on this lot. New A/C June of 2022. Lakes of Savannah offers two pools, two club houses, splash pad, parks, ponds & miles of sidewalks. Located near Hwy. 6 and Hwy. 288. Just minutes to Pearland Town Center. Neighborhood did NOT lose power during the big freeze of 2021! Welcome HOME!' ,`Acres` = '0.1589' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SAVANNAH RIDGE SEC 1 (A0403 ACH&B), BLOCK 2, LOT 36, ACRES 0' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6922' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '670' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'SAVANNAH LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes of Savannah' ,`TaxAmount` = '6985' ,`TaxRate` = '3.1908' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042206' WHERE `Matrix_Unique_ID` = '212802983' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T23:20:54.830' ,`MLSNumber` = '52408704' ,`ListAgentFullName` = 'Shermae Lopez' ,`ListOfficeName` = 'New Home Star Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.185996' ,`Longitude` = '-96.277399' ,`PhotoCount` = '1' ,`PostalCode` = '77437' ,`RoomCount` = '5' ,`ListPrice` = '194139.00' ,`Status` = 'Active' ,`StreetName` = 'Palacios' ,`StreetNumber` = '507' ,`StreetSuffix` = '' ,`City` = 'El Campo' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2004' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.254' ,`Area` = '55' ,`BuilderName` = 'Censeo Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'N/A' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '198 - El Campo' ,`SchoolElementary` = '' ,`SchoolHigh` = 'EL CAMPO HIGH SCHOOL' ,`SchoolMiddle` = 'EL CAMPO MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'El Campo' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1666042207' WHERE `Matrix_Unique_ID` = '212958168' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T23:46:18.903' ,`MLSNumber` = '91881045' ,`ListAgentFullName` = 'Shermae Lopez' ,`ListOfficeName` = 'New Home Star Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.206829' ,`Longitude` = '-96.255319' ,`PhotoCount` = '7' ,`PostalCode` = '77437' ,`RoomCount` = '2' ,`ListPrice` = '134999.00' ,`Status` = 'Active' ,`StreetName` = 'Fred St' ,`StreetNumber` = '1305' ,`StreetSuffix` = '' ,`City` = 'El Campo' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is a one story Plan with 3 bedrooms, 1 bath home, open concept kitchen overlooking the large living-dining combo, which makes it perfect for entertaining. Vinyl plank flooring in living areas and plush carpet in the bedrooms. Moen fixtures in a timeless chrome finish are placed throughout the home. The Energy efficient features in the home will be reflected in your utility bills. Beautiful black appliance package included, home is engineered and inspected by a third-party engineer, has a seer HVAC system, double pane insulated Low-E windows, ENERGY EFFICIENT! \r\nWarranty: 1 yr workmanship & materials, 2 yr on all systems- plumbing, electrical, HVAC & other Mechanical Systems, 10 yr Major Structural components' ,`Acres` = '0.151' ,`Area` = '55' ,`BuilderName` = 'Censeo Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BACA EXT. LOT 3' ,`LotDesciption` = 'Other' ,`LotSize` = '6578' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '198 - El Campo' ,`SchoolElementary` = '' ,`SchoolHigh` = 'EL CAMPO HIGH SCHOOL' ,`SchoolMiddle` = 'EL CAMPO MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Baca Ext' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042207' WHERE `Matrix_Unique_ID` = '212980167' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T23:22:54.497' ,`MLSNumber` = '36011948' ,`ListAgentFullName` = 'Shermae Lopez' ,`ListOfficeName` = 'New Home Star Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.096716' ,`Longitude` = '-96.091642' ,`PhotoCount` = '3' ,`PostalCode` = '77445' ,`RoomCount` = '6' ,`ListPrice` = '234999.00' ,`Status` = 'Active' ,`StreetName` = '21st Street LOT 1' ,`StreetNumber` = '910' ,`StreetSuffix` = '' ,`City` = 'Hempstead' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1549' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction Energy-efficient home with Low Tax rate! This home is a 2-story plan with 4 bedrooms, 2 bathrooms and 1 half bathroom downstairs. Open concept kitchen overlooking the large living-dining combo, which makes it perfect for entertaining. Vinyl plank flooring in living areas and plush carpet in bedrooms with Moen fixtures in a timeless chrome finish throughout the home. Beautiful black appliance package including dishwasher, microwave and electric range, home is all electric with 40-gal water heater, engineered and inspected by third party engineer, 14.5 seer HVAC system, double pane insulated Low-E windows, ENERGY EFFICIENT! LOW ELECTRIC BILLS. Ready to make it yours, easy to show. Warranty: 1 yr. workmanship & materials, 2 yr. on all systems- plumbing, electrical, HVAC & other Mechanical Systems, 10 yr. Major Structural components.' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Censeo Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hempstead' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'N/A' ,`LotDesciption` = 'Other' ,`LotSize` = '6200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '24 - Hempstead' ,`SchoolElementary` = 'HEMPSTEAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEMPSTEAD HIGH SCHOOL' ,`SchoolMiddle` = 'HEMPSTEAD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Town of Hempstead' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042207' WHERE `Matrix_Unique_ID` = '212989944' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T23:23:39.097' ,`MLSNumber` = '97142849' ,`ListAgentFullName` = 'Shermae Lopez' ,`ListOfficeName` = 'New Home Star Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.096645' ,`Longitude` = '-96.091645' ,`PhotoCount` = '3' ,`PostalCode` = '77445' ,`RoomCount` = '6' ,`ListPrice` = '254999.00' ,`Status` = 'Active' ,`StreetName` = '21st Street LOT 2' ,`StreetNumber` = '920' ,`StreetSuffix` = '' ,`City` = 'Hempstead' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1770' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction Energy-efficient home with Low Tax rate! This home is a 2-story plan with 4 bedrooms, 2 bathrooms and 1 half bathroom downstairs. Open concept kitchen overlooking the large living-dining combo, which makes it perfect for entertaining. Vinyl plank flooring in living areas and plush carpet in bedrooms with Moen fixtures in a timeless chrome finish throughout the home. Beautiful black appliance package including dishwasher, microwave and electric range, home is all electric with 40-gal water heater, engineered and inspected by third party engineer, 14.5 seer HVAC system, double pane insulated Low-E windows, ENERGY EFFICIENT! LOW ELECTRIC BILLS. Ready to make it yours, easy to show. Warranty: 1 yr. workmanship & materials, 2 yr. on all systems- plumbing, electrical, HVAC & other Mechanical Systems, 10 yr. Major Structural components.' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Censeo Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hempstead' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Hempstead-Lot 3+4-Blk 229' ,`LotDesciption` = 'Other' ,`LotSize` = '6200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '24 - Hempstead' ,`SchoolElementary` = 'HEMPSTEAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEMPSTEAD HIGH SCHOOL' ,`SchoolMiddle` = 'HEMPSTEAD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Town of Hempstead' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042207' WHERE `Matrix_Unique_ID` = '213033794' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T22:13:22.913' ,`MLSNumber` = '51457492' ,`ListAgentFullName` = 'Sara Hall-Narvacan' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = 'Sara Hall-Narvacan' ,`SellingOfficeName` = 'Coldwell Banker Realty' ,`Latitude` = '29.585387' ,`Longitude` = '-95.598160' ,`PhotoCount` = '38' ,`PostalCode` = '77479' ,`RoomCount` = '5' ,`ListPrice` = '305500.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Frontier' ,`StreetNumber` = '3126' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1913' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOVE IN READY! Charming one story refreshed home in First Colony. In the heart of Sugar Land with quick access to Highway 6, 59, and First Colony Mall. Zoned to top rated Fort Bend ISD schools - Clements High School. Spacious with 3 bedrooms and 2 baths. House is light and bright. Foundation repair with transferrable lifetime warranty. Never flooded. Refrigerator included. This is only the second owner and has been meticulously maintained. This house won\'t last long! What are you waiting for? Schedule your showing now!' ,`Acres` = '0.145' ,`Area` = '29' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SETTLERS PARK SEC 1, BLOCK 4, LOT 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6315' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '498' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SETTLERS WAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Settlers Park Sec 1' ,`TaxAmount` = '5161' ,`TaxRate` = '2.1584' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042207' WHERE `Matrix_Unique_ID` = '213042440' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T22:25:53.333' ,`MLSNumber` = '67729298' ,`ListAgentFullName` = 'Linh Pham' ,`ListOfficeName` = 'V-Pro Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.864004' ,`Longitude` = '-95.622250' ,`PhotoCount` = '25' ,`PostalCode` = '77041' ,`RoomCount` = '8' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Pago' ,`StreetNumber` = '6310' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1914' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL ONE-STORY 3/4 BEDROOMS with DINING ROOM, OFFICE, BREAKFAST ROOM. NEW WATER HEATER. 2 year old ROOF REPLACED 2020 with Warranty, FURNACE REPLACED 2018, 2 YEAR OLD KENDMORE FRIDGE. Primary Bathroom has DOUBLE SINKS, BATHTUB, SHOWER. Granite counter tops in ALL bathrooms. Beautiful tiles throughout the floors. High ceiling. CEILING FANS in ALL bedrooms. Beautiful DEN room with double FRENCH DOORS that can turn into a bedroom. Formal Dining Room can turn into a game room or extra office. Nice COVERED PATIO. Easy access to Hwy6, 290, Beltway 8, and I10. Convenient to all the major arteries, shopping and restaurants. Award winning Cy-Fair ISD and great Catholic schools. Nice neighborhood with large PLAYGROUND and Subdivision beautiful swimming pool. Room measurements are approximated. VARIOUS FIXTURES Upgrade. NO CARPET. ALL TILES FLOOR.' ,`Acres` = '' ,`Area` = '8' ,`BuilderName` = 'Kimball Hills Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 32 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6325' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '370' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'LEE ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Concord Bridge' ,`TaxAmount` = '4614' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042208' WHERE `Matrix_Unique_ID` = '213134062' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T22:00:54.810' ,`MLSNumber` = '78875270' ,`ListAgentFullName` = 'Michael Parker' ,`ListOfficeName` = 'Phyllis Foster Real Estate Ser' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.522616' ,`Longitude` = '-95.056190' ,`PhotoCount` = '25' ,`PostalCode` = '77573' ,`RoomCount` = '5' ,`ListPrice` = '269800.00' ,`Status` = 'Active' ,`StreetName` = 'Greenshire' ,`StreetNumber` = '127' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1492' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come tour this 4 bedroom 2 full bath home located in Meadow Bend. The family features large brick fireplace. The updated primary suite has upgraded shower and tub. The secondary bathroom also features upgraded shower. Recent improvements include updated carpet, paint, A/C, and roof. Book your appointment today!!!' ,`Acres` = '0.1638' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 18 M MULDOON SUR LOT 15 BLK 5 MEADOW BEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7137' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'HYDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'LEAGUECITY INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meadow Bend' ,`TaxAmount` = '4492' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042208' WHERE `Matrix_Unique_ID` = '213158021' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T22:52:00.753' ,`MLSNumber` = '21964969' ,`ListAgentFullName` = 'Annu Naik' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.666184' ,`Longitude` = '-95.684494' ,`PhotoCount` = '32' ,`PostalCode` = '77407' ,`RoomCount` = '12' ,`ListPrice` = '675000.00' ,`Status` = 'Active' ,`StreetName` = 'Huttons Court' ,`StreetNumber` = '16919' ,`StreetSuffix` = '' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3977' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous Move-In ready family home in sought after Master Planned Aliana community. Layout is very inviting, practical, convenient and extremely functional with 2 BRs down, large secondary bedrooms upstairs with all of them having walk-in closets. Upstairs game room is a bonus to have quality family time. High ceilings, covered patio in the back and front porch are a very nice touch in this very elegant home. View of the serene, private backyard to enjoy while having morning coffee, breakfast as well as while relaxing in your family room.' ,`Acres` = '0.2066' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'ALIANA SEC 2, BLOCK 1, LOT 21, REPLAT NO 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1285' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'MADDEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Aliana Sec 2' ,`TaxAmount` = '11086' ,`TaxRate` = '2.9329' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042208' WHERE `Matrix_Unique_ID` = '213262005' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T22:38:07.817' ,`MLSNumber` = '91479318' ,`ListAgentFullName` = 'Patricia Castillo' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.941396' ,`Longitude` = '-95.699160' ,`PhotoCount` = '48' ,`PostalCode` = '77433' ,`RoomCount` = '11' ,`ListPrice` = '870000.00' ,`Status` = 'Active' ,`StreetName` = 'Jodie Lynn' ,`StreetNumber` = '26047' ,`StreetSuffix` = 'Circle' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '5792' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! Gracefully situated on a very quiet street in the sought after Cypress Creek Lakes Community. This luxurious 4 Bedroom and 3.5 Bath Perry Home has highly desirable features which include inviting double doors, huge Grand Rotunda entry with cathedral ceiling, wrought iron circular double stairs. Enormous Formal Living and Dining Rooms. Spacious Gourmet Kitchen with custom cabinets and granite countertops, huge walk-in pantry, and professional grade appliances including new Cooktop, Dishwasher & Microwave. Enormous master retreat with fireplace and seating area. Stunning Family Room with wall of windows. Open Flowing Floor Plan. Elegant raised Study with french doors . Climb the elegant curved staircase to find a big Game Room, 2nd Master Suite and 2 additional Bedrooms, 2 Full Baths and a Media Room. Enjoy the outdoors with your own Tropical Backyard with a Big Saltwater Pool with Grotto Spa. 3 Car Garage. Top Rated CFISD Schools.' ,`Acres` = '0.3587' ,`Area` = '25' ,`BuilderName` = 'Perry' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 2 CYPRESS CREEK LAKES SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15625' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WARNER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Crk Lakes Sec 2' ,`TaxAmount` = '15010' ,`TaxRate` = '2.801' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042208' WHERE `Matrix_Unique_ID` = '213262577' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T22:39:14.457' ,`MLSNumber` = '95285943' ,`ListAgentFullName` = 'Gracie Galvan' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = 'Veronica Cisneros' ,`SellingOfficeName` = 'Jane Byrd Properties INTL.' ,`Latitude` = '29.882919' ,`Longitude` = '-95.339679' ,`PhotoCount` = '16' ,`PostalCode` = '77093' ,`RoomCount` = '6' ,`ListPrice` = '150000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Hurlingham' ,`StreetNumber` = '3018' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1176' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home has lots of potential, perfect for first-time homeowners or investors looking to flip. \r\nThe property offers living space, dining room with three bedrooms, one bathroom and extra storage or another room since garage has been closed in. The home has some updates as tile though out home, updated shower with tile. The oversized back yard and front provides plenty of room for entertaining family and friends. The property is priced to sell. Home needs TLC and being SOLD as is. \r\nLocation is a plus, just 12 miles from Bush Intercontinental Airport and 10 miles from Downtown Houston.' ,`Acres` = '0.1879' ,`Area` = '34' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Space Heater' ,`HOAMandatory` = '0' ,`Legal` = 'LT 351 BLK 19 OAKWILDE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8184' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'WORSHAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MACARTHUR HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'MEAD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oakwilde Sec 03' ,`TaxAmount` = '1720' ,`TaxRate` = '2.1553' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042208' WHERE `Matrix_Unique_ID` = '213330251' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T23:33:26.663' ,`MLSNumber` = '67297082' ,`ListAgentFullName` = 'Paul Kamau' ,`ListOfficeName` = 'Compass Realty & Associates LL' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.659527' ,`Longitude` = '-95.499736' ,`PhotoCount` = '32' ,`PostalCode` = '77096' ,`RoomCount` = '6' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Sanford' ,`StreetNumber` = '6127' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2232' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.2003' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'RES F3 BLK 5 FONDREN SW NORTHBROOK 1 RP EXT' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8725' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HALPIN/TINSLEY' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'FONDREN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fondren Sw Northbrook 01 Rp Ext' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042209' WHERE `Matrix_Unique_ID` = '213331211' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T22:22:28.543' ,`MLSNumber` = '16481526' ,`ListAgentFullName` = 'Sharon Dimicelli' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.504130' ,`Longitude` = '-95.713653' ,`PhotoCount` = '49' ,`PostalCode` = '77469' ,`RoomCount` = '15' ,`ListPrice` = '559000.00' ,`Status` = 'Active' ,`StreetName` = 'Cobalt Ridge' ,`StreetNumber` = '6106' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3640' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning Like New 5 bedroom home is priced under market value! Entertainers Home w/Gorgeous tile wood look flooring, designer finishes, soaring ceilings, Former K Hov Model Home w/ tons of upgrades throughout! Formal dining w/designer carpet! Home office w/designer wall and closet. Large Open Kitchen with huge upgraded granite island and tons of countertops and modern white cabinets, stainless appliances, high-end fridge w/Keurig coffee maker! Fall in love with the walk-in pantry, designer backsplash and deep stainless farmhouse sink! Tandem garage w/ epoxy floor & A/C! Family room w/contemporary fireplace and high ceiling! Bonus sunroom -great nursery, 2nd office, workout room! Five ample bedrooms, huge closets, dual sinks in all the full baths! Media Room! Loft Game Room! Walk in Attics! Great back covered patio with Outdoor Kitchen, Grill and Play System! All brick, Fully sprinklered, well maintained! Great Schools! Excellent amenities! Move in Ready!' ,`Acres` = '0.2131' ,`Area` = '30' ,`BuilderName` = 'K Hov' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'STONECREEK ESTATES SEC 1 AMENDING PLAT NO 1, BLOCK 7, LOT 4' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9282' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CARTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Stonecreek Estates Sec 1 Amd 1' ,`TaxAmount` = '11528' ,`TaxRate` = '3.1948' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042209' WHERE `Matrix_Unique_ID` = '213354497' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T22:49:08.470' ,`MLSNumber` = '85833586' ,`ListAgentFullName` = 'Larry Cockman' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.837209' ,`Longitude` = '-95.787333' ,`PhotoCount` = '32' ,`PostalCode` = '77493' ,`RoomCount` = '5' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Rivage Ridge' ,`StreetNumber` = '23710' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1934' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful like new home purchased in 2017 is simply spectacular inside and out! Offering 1,934 square feet of living space, 4 spacious bedrooms, 2 bathrooms, wonderfully-equipped kitchen, and a bright and inviting living space! Boasting incredible attention to detail and upgrades throughout including gorgeous tile, stainless steel appliances, beautiful wood cabinetry, and modern finishes. The master bath is relaxing, featuring a spa like bath and sitting room, with so much more. Sitting on a corner / oversized lot with a well-maintained lawn that is easy to maintain with the sprinkler system. Enjoy viewing your backyard masterpiece while relaxing on your covered extended patio. The community of Ventana Lakes features pools, splash pads, trails, parks, a clubhouse, schools, easy access to 99 and I-10.' ,`Acres` = '0.2387' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 3 VENTANA LAKES SEC 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10397' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BETHKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ventana Lakes Sec 9' ,`TaxAmount` = '7704' ,`TaxRate` = '3.2768' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042209' WHERE `Matrix_Unique_ID` = '213454668' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T22:23:19.723' ,`MLSNumber` = '90927038' ,`ListAgentFullName` = 'Glenda Colmenero' ,`ListOfficeName` = 'Five Star Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.419097' ,`Longitude` = '-97.011652' ,`PhotoCount` = '37' ,`PostalCode` = '78947' ,`RoomCount` = '6' ,`ListPrice` = '455000.00' ,`Status` = 'Active' ,`StreetName` = 'Private Road 7045' ,`StreetNumber` = '1048' ,`StreetSuffix` = '' ,`City` = 'Lexington' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1592' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '4 yr. young Tilson built brick home on 3.6+ wooded acres in highly sought after gated community of Fedor Estates. Interior consists of crown molding, ceramic flooring/carpeting throughout. Wood burning fireplace. Split floor plan for added privacy. Stainless steel appliances that include double oven complete the galley kitchen. Washer, dryer & refrigerator to stay. Walk in showers with bench seating. Backyard decking with walkway to hot tub. Metal storage shed with covered parking. Concrete padding for addt\'l parking.(RV\'s, trailers etc.) A long drive into property & wooded surroundings adds for extra privacy. Covered carport parking with brick accents and remote control ceiling fans. Plenty of wildlife to be found wondering around the premises. Approximately 1-1.5 hrs. from either Houston or Austin. Country living close to the city makes this an outstanding place to live, retire or just getaway. Furnishings negotiable.' ,`Acres` = '3.628' ,`Area` = '70' ,`BuilderName` = 'Tilson' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'FEDOR ESTATES SECTION 2, LOT 7, ACRES 3.628' ,`LotDesciption` = 'Wooded' ,`LotSize` = '158036' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '165 - Lexington' ,`SchoolElementary` = 'LEXINGTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LEXINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'LEXINGTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Fedor Estates Sec 2' ,`TaxAmount` = '4970' ,`TaxRate` = '1.7753' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1666042209' WHERE `Matrix_Unique_ID` = '213458779' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T23:25:46.797' ,`MLSNumber` = '41606861' ,`ListAgentFullName` = 'Shermae Lopez' ,`ListOfficeName` = 'New Home Star Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.102716' ,`Longitude` = '-96.089071' ,`PhotoCount` = '2' ,`PostalCode` = '77445' ,`RoomCount` = '4' ,`ListPrice` = '179999.00' ,`Status` = 'Active' ,`StreetName` = '19th Street' ,`StreetNumber` = '248' ,`StreetSuffix` = '' ,`City` = 'Hempstead' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1040' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This one Story Plan with 3 bedrooms, 1 bath, one story home is energy efficient, with an open Concept Kitchen overlooking the large living-dining combo, making this home perfect for entertaining. This home includes LED Lighting, and vinyl plank flooring in the living room, dining, kitchen, and baths. Moen fixtures in a timeless chrome finish are placed throughout the home. Lush carpeting in the bedrooms. Beautiful black appliance package included, home is engineered and inspected by a third-party engineer, has a seer HVAC system, double pane insulated Low-E windows, ENERGY EFFICIENT! \r\nWarranty: 1 yr workmanship & materials, 2 yr on all systems- plumbing, electrical, HVAC & other Mechanical Systems, 10 yr Major Structural components' ,`Acres` = '0.254' ,`Area` = '26' ,`BuilderName` = 'Censeo Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hempstead' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'N/A' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '24 - Hempstead' ,`SchoolElementary` = 'HEMPSTEAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEMPSTEAD HIGH SCHOOL' ,`SchoolMiddle` = 'HEMPSTEAD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Town of Hempstead' ,`TaxAmount` = '' ,`TaxRate` = '2.59' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042209' WHERE `Matrix_Unique_ID` = '213504881' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T22:26:37.963' ,`MLSNumber` = '10103645' ,`ListAgentFullName` = 'Fady Chaban' ,`ListOfficeName` = 'All County Prime Property' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.815190' ,`Longitude` = '-95.731102' ,`PhotoCount` = '42' ,`PostalCode` = '77449' ,`RoomCount` = '9' ,`ListPrice` = '400000.00' ,`Status` = 'Active' ,`StreetName` = 'Redgum' ,`StreetNumber` = '3103' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2590' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Move-In Ready 4/5 bedroom home completely updated in the heart of Katy. Never Flooded, meticulously maintained, and impeccably updated while respecting the clean lines of classic modern style. Brick exterior; Fresh interior Paint; Granite Counters in Kitchen; Easy Care Landscaping; Flooring Engineered Wood, Ceramic Tile, & Carpet. Washer and Dryer included. Spacious Flex room on the first floor that can be formal dining, office, studio, or just another room. Owner\'s Retreat with oversized shower, dual vanities, and a walk-in closet. This unique home has a large room (~500 sqft) with AC, this could be an entertainment room with endless possibilities. There you can also have a grill area with high-power smoke extraction units to enjoy a refreshing summer kitchen next to a delightful backyard. A large patio area features a basketball ½ court surrounded by gardening beds for your outdoor gathering. Moreover, the fence gate allows boats/work trucks to be backed in from the street.' ,`Acres` = '0.1613' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 1 RAINTREE VILLAGE SEC 4 PAR R/P' ,`LotDesciption` = 'Corner' ,`LotSize` = '7028' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '435' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'FRANZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MORTON RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'MCDONALD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Raintree Village Sec 04 Prcl R' ,`TaxAmount` = '6046' ,`TaxRate` = '2.5633' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042210' WHERE `Matrix_Unique_ID` = '213520630' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T23:59:31.873' ,`MLSNumber` = '34129073' ,`ListAgentFullName` = 'Emily Peng' ,`ListOfficeName` = 'Living Quarters LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.034658' ,`Longitude` = '-95.346164' ,`PhotoCount` = '15' ,`PostalCode` = '77373' ,`RoomCount` = '5' ,`ListPrice` = '167900.00' ,`Status` = 'Active' ,`StreetName` = 'Moss Falls' ,`StreetNumber` = '22101' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1276' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nice 3 bedroom, 2 bath, 1 attached garage, one story DUPLEX HOME (1/2 duplex) on a corner\r\nlot. Fenced yard with a side-covered patio. Vaulted ceiling in living & dining areas. Wood-burning fireplace. Master bedroom with his and her closets and double vanity sinks. Recent\r\nupdates include new interior and exterior paint. New stove and dishwasher. New carpet, ceiling fans\r\n, and window blinds. Close to schools and shopping. Easy access to major freeways and to Bush\r\nairport.' ,`Acres` = '0.0838' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TR 60A BLK 3 POSTWOOD SEC 5' ,`LotDesciption` = 'Cleared' ,`LotSize` = '3650' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '285' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`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,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Post Wood 5' ,`TaxAmount` = '3076' ,`TaxRate` = '2.5868' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042210' WHERE `Matrix_Unique_ID` = '213580940' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T23:29:12.607' ,`MLSNumber` = '9596878' ,`ListAgentFullName` = 'Maria Hernandez' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.841787' ,`Longitude` = '-95.463468' ,`PhotoCount` = '14' ,`PostalCode` = '77091' ,`RoomCount` = '3' ,`ListPrice` = '284000.00' ,`Status` = 'Active' ,`StreetName` = 'Broom' ,`StreetNumber` = '4916' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1456' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great opportunity to own this beautiful totally renovated 3 bedrooms and 2 full bathrooms. Everything is new here, except part of the frame and the water heater. Upgraded with hight ceiling and master bedroom addition. Granite kitchen countertops, master vanities and shower seat. Quartz second bath vanity. Wood look water resistance laminate flooring throughout. New electrical, plumbing, HVAC Systems. Two sink in master and walk in closet. Stainless Steel appliances. Soft close cabinets including a lazy Susan in kitchen for your storage convenience. Within minutes to the Galleria, Houston Downtown, TC Jester Park and Kroger. Quiet neighborhood, low taxes, no HOA, no flood zone. Schedule your showing today!' ,`Acres` = '0.1' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 27 BLK 23 ROSSLYN HEIGHTS SEC 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '3000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SMITH ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Rosslyn Heights Sec 01' ,`TaxAmount` = '2742' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042210' WHERE `Matrix_Unique_ID` = '213606738' --> 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','213643356','1666042210','213643356','2022-10-16T22:54:19.810','83194895','Ngoc Pham','Intercontinental Properties','','','29.659478','-95.681208','39','77407','8','495000.00','Active','Kilgarth','16831','Drive','Richmond','3','0','4','2631','Single-Family','Beautiful home with open floor plan in Alina. FEATURES INCLUDE: Covered backyard patio, granite countertops, upgraded elevation, upgraded carpet, tile floors in family room and hallway, wood floors in formal dining. Tankless water heater.','0.1515','37','PERRY HOMES','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Sugar Land West','Central Gas','1','ALIANA SEC 21, BLOCK 1, LOT 21','Subdivision Lot','6600','Appraisal District','','1250','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','19 - Fort Bend','MADDEN ELEMENTARY SCHOOL','TRAVIS HIGH SCHOOL (FORT BEND)','GARCIA MIDDLE SCHOOL (FORT BEND)','Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Aliana Sec 21','9487','2.9329','Water District','2012','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T23:28:06.477' ,`MLSNumber` = '81526444' ,`ListAgentFullName` = 'Mohammad Khatri' ,`ListOfficeName` = 'G+A Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.611558' ,`Longitude` = '-95.571742' ,`PhotoCount` = '32' ,`PostalCode` = '77477' ,`RoomCount` = '10' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Marathon' ,`StreetNumber` = '422' ,`StreetSuffix` = 'Way' ,`City` = 'Stafford' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2681' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Completely remodeled. Great opportunity, this home has been nicely remodeled. All interior and exterior paint including kitchen cabinets. New granite counters and backsplash in the kitchen. The new carpet is all in neutral colors. Additional covered 11x11 sunroom. Extended area in the breakfast area(Can be used as computer/work area.Large tiled shower in master bath. This 2-story home includes both a formal (with high ceilings), a family room, and an upstairs game room. Lots of love and TLC in this house. Good size backyard, low tax rate, and low HOA fees. Easy access to Hwy 90. The property is occupied and Appointment Required.' ,`Acres` = '0.1401' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Stafford Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'THE PROMENADE AT STAFFORD RUN SEC 1, BLOCK 2, LOT 31' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6104' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '50 - Stafford' ,`SchoolElementary` = 'STAFFORD ELEMENTARY SCHOOL (STAFFORD MSD)' ,`SchoolHigh` = 'STAFFORD HIGH SCHOOL' ,`SchoolMiddle` = 'STAFFORD INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'The Promenade At Stafford Run Sec 1' ,`TaxAmount` = '5193' ,`TaxRate` = '1.9342' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042210' WHERE `Matrix_Unique_ID` = '213722881' --> 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','213729066','1666042210','213729066','2022-10-16T23:03:36.053','68088716','Dawn Bajalieh','RE/MAX Integrity','','','29.892064','-95.679573','1','77095','14','429000.00','Active','Emerald Bluff','7907','Court','Houston','2','1','4','2545','Single-Family','','0.1843','8','','','','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Copperfield Area','Central Gas','1','LT 27 BLK 4 COPPERFIELD WESTCREEK VILLAGE SEC 4','Subdivision Lot','8030','Appraisal District','','708','0','','2','','1','Heated,In Ground','','','','Composition','13 - Cypress-Fairbanks','COPELAND ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','LANGHAM CREEK HIGH SCHOOL','ARAGON MIDDLE SCHOOL','Appointment Required,Lockbox Front,Temporarily No Showings','Appraisal District','2','Traditional','Copperfield Westcreek Village','6728','2.471','Water District','1992','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','213737510','1666042210','213737510','2022-10-16T22:30:26.470','3832018','Katie Villanueva','Texas United Realty','','','29.948106','-95.692704','24','77433','3','573000.00','Active','Deepwater Ridge','11827','Way','Cypress','2','1','3','2326','Single-Family','Looking for a home that has it all? Look no further because this is it! This one-of-a-kind, better than new single story home has been incredibly updated and features open concept living with 3 bedrooms, 2.5 baths, a large study currently used as a dining room, a flex space between the secondary bedrooms, and a large covered patio overlooking the sparkling saltwater pool and spa. This stunning kitchen features an oversized island with custom drawers, Quartz countertops, free standing double convection gas range, custom refrigerator cabinet, and walk-in pantry. Indoor and outdoor built in speakers make entertaining easy, whether inside or outside on the covered patio relaxing by the pool. Located in the award winning community of Towne Lake which offers a 300 acre private lake, boat docks & rentals, a marina, beaches, lazy river, pool, parks, and lake house. Minutes from Hwy 99 and 290 with countless shopping and dining options and zoned to Cy-Fair ISD schools.','0.1431','25','David Weekley','','Gas Dryer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Cypress South','Central Gas','1','LT 14 BLK 7 TOWNE LAKE SEC 53','Subdivision Lot','6233','Survey','','1674','0','','2','Double Oven','1','Gunite,Heated,In Ground,Salt Water','','Gas Range','','Composition','13 - Cypress-Fairbanks','RENNELL ELEMENTARY SCHOOL','CYPRESS RANCH HIGH SCHOOL','ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)','Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox','Builder','1','Traditional','Towne Lake Sec 53','12470','3.471','Water District','2020','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','213744258','1666042211','213744258','2022-10-16T23:48:52.793','38540564','Sophie Zhang','REALM Real Estate Professional','','','29.728719','-95.848112','22','77441','8','518000.00','Active','Huggins Crest','27606','Court','Fulshear','3','0','4','2887','Single-Family','Former BEAZER MODEL HOME in Master Planned Community in the Capri Floor plan. This 1.5 story home features 4 bedrooms, 3 baths, a study, Game room, and loft. There are 3 bedrooms downstairs! Upgrades galore with Stainless steel apliances, granite counter tops, iron spindles,and 2 master closets! There are tile and wood flooring throughout most of the home. Don\'t miss the great covered patio out back and it\'s on a CUL-DE-SAC street across from the pool! Hurry to see this gorgeous home today!','0.1609','36','','','','','Mud','1','','','Katy - Southwest','Central Gas','1','CHURCHILL FARMS SEC 1, BLOCK 1, LOT 16','Subdivision Lot','7009','Appraisal District','','630','0','','2','Freestanding Oven,Gas Oven','0','','','Gas Cooktop','','Composition','30 - Katy','CAMPBELL ELEMENTARY SCHOOL (KATY)','JORDAN HIGH SCHOOL','ADAMS JUNIOR HIGH SCHOOL','Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Churchill Farms Sec 1','8511','2.8745','Public Sewer,Public Water','2012','Appraisal District'); --> New record created successfully