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-15T07:35:45.763' ,`MLSNumber` = '40553766' ,`ListAgentFullName` = 'Karen DeLeon-Bailes' ,`ListOfficeName` = 'Bailes Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.669984' ,`Longitude` = '-95.492534' ,`PhotoCount` = '34' ,`PostalCode` = '77096' ,`RoomCount` = '10' ,`ListPrice` = '449900.00' ,`Status` = 'Active' ,`StreetName` = 'Yarwell' ,`StreetNumber` = '5903' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*NEVER FLOODED* Impressive Updates & Amenities Abound throughout this Refined Single Story *Never Flooded* Open Concept Residence. This Home Offers a Timeless Floorplan & Showcases Hardwood Floors, Plantation Shutters, Spacious rooms with ample storage throughout. Gourmet kitchen boasts Granite Counters, Decorative Backsplash, Breakfast Bar/peninsula, SS Appliance Package with 5 Burner Gas Cooktop & Jenn Air Double Ovens. Wonderfully Spacious Den features a Beamed Cathedral & Gas Fireplace. Split Bedroom Plan with Primary Suite featuring a Walk-in Closet, a Walk-in Shower and jetted tub. Hall Bath offers Dual Sinks & Full Tub/Shower. Beautiful large Corner Lot with circular drive. Private Patio and fenced back yard. Flex Room touts a Wall of Built-in Bookshelves Can be used as private office, game room, gym etc. Close to Tx Medical Center and Galleria, easy access to 610, 59, Beltway and 288! (approx. an additional 200 sq ft.)' ,`Acres` = '0.2222' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 25 MAPLEWOOD SOUTH SEC 6' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9680' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '495' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ELROD ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'FONDREN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Maplewood South Sec 06' ,`TaxAmount` = '7407' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665839810' WHERE `Matrix_Unique_ID` = '205914137' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T07:46:25.420' ,`MLSNumber` = '17671518' ,`ListAgentFullName` = 'Patrick Burbridge' ,`ListOfficeName` = 'CitiQuest Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.847240' ,`Longitude` = '-95.416786' ,`PhotoCount` = '41' ,`PostalCode` = '77091' ,`RoomCount` = '5' ,`ListPrice` = '344990.00' ,`Status` = 'Active' ,`StreetName` = 'W Tidwell' ,`StreetNumber` = '778' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1535' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNDER CONSTRUCTION! Move-in ready by Fall 2022! Gorgeous new construction by Disama Group. Nestled in a quite gated community within the charming historical Highland Heights, this stunning two-story home offers an open concept living area & kitchen on the first floor & three bedrooms on the second floor, private driveway and fenced backyard/patio. Upgraded modern finishes throughout including smart home system features, quartz counter tops, stainless-steel appliances, upgraded cabinets with soft close drawers. Enjoy this 19-home gated community located minutes away from Downtown Houston. Easy access to I45 and 610.\r\nPhotos from another community by the same builder - finishes and layout will vary!\r\nGPS address: 781 Davidson St. Houston TX 77091' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Disama Group' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2, Block 1' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '2167' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'HIGHLAND HEIGHTS VILLAS' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665839810' WHERE `Matrix_Unique_ID` = '207484799' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T07:48:39.483' ,`MLSNumber` = '89824440' ,`ListAgentFullName` = 'Patrick Burbridge' ,`ListOfficeName` = 'CitiQuest Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.847240' ,`Longitude` = '-95.416786' ,`PhotoCount` = '41' ,`PostalCode` = '77091' ,`RoomCount` = '5' ,`ListPrice` = '344990.00' ,`Status` = 'Active' ,`StreetName` = 'W Tidwell' ,`StreetNumber` = '778' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1535' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNDER CONSTRUCTION! Move-in ready by Fall 2022! Gorgeous new construction by Disama Group. Nestled in a quite gated community within the charming historical Highland Heights, this stunning two-story home offers an open concept living area & kitchen on the first floor & three bedrooms on the second floor, private driveway and fenced backyard/patio. Upgraded modern finishes throughout including smart home system features, quartz counter tops, stainless-steel appliances, upgraded cabinets with soft close drawers. Enjoy this 19-home gated community located minutes away from Downtown Houston. Easy access to I45 and 610.\r\nPhotos from another community by the same builder - finishes and layout will vary!\r\nGPS address: 781 Davidson St. Houston TX 77091' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Disama Group' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3, Block 1' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '1531' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'HIGHLAND HEIGHTS VILLAS' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665839810' WHERE `Matrix_Unique_ID` = '207679938' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T07:58:32.293' ,`MLSNumber` = '80145411' ,`ListAgentFullName` = 'Patrick Burbridge' ,`ListOfficeName` = 'CitiQuest Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.847240' ,`Longitude` = '-95.416786' ,`PhotoCount` = '40' ,`PostalCode` = '77091' ,`RoomCount` = '5' ,`ListPrice` = '344990.00' ,`Status` = 'Active' ,`StreetName` = 'W Tidwell' ,`StreetNumber` = '782' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1535' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'OPEN HOUSES AT THE SALES OFFICE - 5406 TUSKEGEE ST. Saturdays & Sundays 1-5pm.\r\nUNDER CONSTRUCTION! Move-in ready by Fall 2022! Gorgeous new construction by Disama Group. Nestled in a quite gated community within the charming historical Highland Heights, this stunning two-story home offers an open concept living area & kitchen on the first floor & three bedrooms on the second floor, private driveway and fenced backyard/patio. Upgraded modern finishes throughout including smart home system features, quartz counter tops, stainless-steel appliances, upgraded cabinets with soft close drawers. Enjoy this 19-home gated community located minutes away from Downtown Houston. Easy access to I45 and 610.\r\nPhotos from another community by the same builder - finishes and layout will vary! \r\nGPS address: 781 Davidson St. Houston TX 77091' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Disama Group' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 18, Block 1' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '1886' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'HIGHLAND HEIGHTS VILLAS' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665839810' WHERE `Matrix_Unique_ID` = '207696996' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T07:39:26.720' ,`MLSNumber` = '18884200' ,`ListAgentFullName` = 'Mel Reyna' ,`ListOfficeName` = 'The Reyna Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.799729' ,`Longitude` = '-95.476527' ,`PhotoCount` = '50' ,`PostalCode` = '77055' ,`RoomCount` = '10' ,`ListPrice` = '999000.00' ,`Status` = 'Active' ,`StreetName` = 'Janak' ,`StreetNumber` = '7410' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3820' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**BUILDER OFFERING $20k Buyer TO BE USED TOWARDS RATE BUYDOWN OR UPGRADES IF CLOSED BY 12/31/22** Welcome to 7410 Janak! This NEW CONSTRUCTION Quintessa Home is located in the Pine Terrace subdivision of Spring Branch & offers 4 Bedrooms/3.5 Baths/2-Car Garage w/ RARE 1st Floor Guest Suite, 1st Floor Study, 2nd Floor Game Room, Media Room & Additional Study/Hobby Room. Exterior features Painted Brick w/ Metal Roof accents, Over-sized Designer Coach Lights & Covered Patio w/ pre-plumb. Interior features include Oak wood floors throughout, 10 \" baseboards, Electric Linear Fireplace, Security System/Camera Pre-wire, Mudroom built-ins & is Nest/Ring doorbell compatible. Chef\'s Kitchen offers a Large waterfall Island w/ Quartz counter tops, Designer selected fixtures & hardware, High-end appliance package & Porcelain Farmhouse sink. Primary Suite features Separate vanities w/ high-end quartz counters, soaking tub, separate walk-in shower & Dual Primary walk-in Closets.' ,`Acres` = '0.1653' ,`Area` = '24' ,`BuilderName` = 'Quintessa Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 17 BLK 8 PINE TERRACE SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HOUSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pine Terrace Sec 04' ,`TaxAmount` = '5262' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665839810' WHERE `Matrix_Unique_ID` = '209584456' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T06:41:36.647' ,`MLSNumber` = '18086824' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.564615' ,`Longitude` = '-95.746311' ,`PhotoCount` = '49' ,`PostalCode` = '77469' ,`RoomCount` = '9' ,`ListPrice` = '493350.00' ,`Status` = 'Active' ,`StreetName` = 'Sweeny Valley' ,`StreetNumber` = '23718' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Bring your creative design ideas to life in the spacious and sophisticated Omaha family home plan. Your glamorous Owner’s Retreat offers a scenic backyard view, expansive walk-in closet, and an everyday-spa bathroom. Each lovely spare bedroom provides ample closets and room for personalization. Create the ultimate home office in the lively and bright study. Explore new vistas of culinary delight in the streamlined kitchen, featuring a presentation island and countertops that extend to the dining room. Design your ideal living arrangement in the open-concept floor plan. Take a breath of fresh air and enjoy a gentle breeze from your timeless covered patio. Bonus features include extra storage in the 2-car garage and a central laundry room. What specialty rooms will you create in the FlexSpace? of this superb new home plan?' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4 Block 1' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'PHELAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Veranda' ,`TaxAmount` = '' ,`TaxRate` = '3.22' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665839811' WHERE `Matrix_Unique_ID` = '209704375' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T07:22:27.613' ,`MLSNumber` = '69185561' ,`ListAgentFullName` = 'Nancy Tullis' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.105349' ,`Longitude` = '-95.534389' ,`PhotoCount` = '49' ,`PostalCode` = '77389' ,`RoomCount` = '11' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Leblanc Landing' ,`StreetNumber` = '23838' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3310' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Motivated seller, below appraisal price!!! Beautiful home with stone accents in private GATED neighborhood, close to 99 and 45! Enter the home with an impressive high ceiling entry, home office to the right with french doors. Dining room to the left. Large Family/Kitchen area with eat at bar. Side by side refrigerator stays. Washer/Dryer included. Family room is centered around a gas log fireplace, and has surround sound already installed. 10 foot ceilings! Large Primary bedroom downstairs has separate shower, soaking tub large closet. Upstairs is a large Game Room and separate MEDIA room to watch your favorite movies! All equipment in media room and chairs will stay! Guest suite with ensuite bath and walk in closet on second floor. All bedrooms are large with lots of storage. Back yard is completely fenced, private and ready for your next barbeque! This is the home you have been waiting for!' ,`Acres` = '0.168' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 PRESERVE AT NORTHAMPTON SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7320' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'NORTHAMPTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HILDEBRANDT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Preserve/Northampton Sec 1' ,`TaxAmount` = '8427' ,`TaxRate` = '2.834' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1665839811' WHERE `Matrix_Unique_ID` = '209780794' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T07:27:15.510' ,`MLSNumber` = '94373096' ,`ListAgentFullName` = 'Elaine Strahan' ,`ListOfficeName` = 'Strada' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.648632' ,`Longitude` = '-95.782536' ,`PhotoCount` = '36' ,`PostalCode` = '77406' ,`RoomCount` = '12' ,`ListPrice` = '600000.00' ,`Status` = 'Active' ,`StreetName` = 'Tierra Amarilla' ,`StreetNumber` = '3611' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3469' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The one story home you\'ve been looking for and filled with amenities to amaze! On over 1/2 acre corner lot, home offers high tray ceilings w accent niches lining the way to your large master suite. Master bath presents spa experience w extended 3 head shower including one rain/waterfall effect, and jetted tub for soaking. Includes 2 vanities, walk in closet & TV fixture. Head to Media room for movie night w surround sound, windows, blackout curtains & closet. Large open kitchen w lots of cabinets, loads of counter space & double ovens overlooks the spacious yet cozy family room. Flexibility to place TV above fireplace or on flanking built-in cabinets w surround sound connection. Informal & formal dining rooms. Step out back to enjoy covered patio w gas grill, bar & fridge. Take mere steps to fire pit to enjoy conversations & evening sunsets. Home w 4 oversized bedrooms, 1 used currently as Office w french doors, window & closet, which can easily be reverted to a bedroom.' ,`Acres` = '0.5466' ,`Area` = '37' ,`BuilderName` = 'K HOVNANIAN' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKES OF MISSION GROVE SEC 2, BLOCK 1, LOT 1, ACRES 0.5466' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '23810' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Lakes Of Mission Grove Sec 2' ,`TaxAmount` = '7210' ,`TaxRate` = '1.6948' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665839811' WHERE `Matrix_Unique_ID` = '210482985' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T07:04:39.180' ,`MLSNumber` = '59478510' ,`ListAgentFullName` = 'Fran Summey' ,`ListOfficeName` = 'NextHome Top Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.952353' ,`Longitude` = '-95.265318' ,`PhotoCount` = '31' ,`PostalCode` = '77396' ,`RoomCount` = '8' ,`ListPrice` = '249000.00' ,`Status` = 'Active' ,`StreetName` = 'Catbird' ,`StreetNumber` = '16106' ,`StreetSuffix` = 'Court' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2194' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 4 bedroom 2.5 baths on a corner lot is move-in ready. Three bedrooms are upstairs including the primary bedroom and game room. One bedroom is downstairs could be the perfect mother-in-law suite. The kitchen has two dining areas. There is crown molding in almost every room in the house. Updates include electrical, plumbing, new appliances, new carpet and vinyl flooring, new granite countertops, new sinks, new faucets, new water heater, new toilets, new A/C & furnace. This home is convenient to Hwy 59/I69, Beltway 8, downtown Houston, Bush Airport, shopping and dining.' ,`Acres` = '0.1815' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Humble Area East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 5 AUDUBON PARK SEC 2 R/P' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7906' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '353' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'JACK M. FIELDS SR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'HUMBLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Audubon Park' ,`TaxAmount` = '4635' ,`TaxRate` = '2.7373' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665839811' WHERE `Matrix_Unique_ID` = '210530304' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T07:14:03.770' ,`MLSNumber` = '83272401' ,`ListAgentFullName` = 'Angela Chaney' ,`ListOfficeName` = 'Texas Premier Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.083379' ,`Longitude` = '-95.198357' ,`PhotoCount` = '30' ,`PostalCode` = '77339' ,`RoomCount` = '9' ,`ListPrice` = '362500.00' ,`Status` = 'Active' ,`StreetName` = 'Same' ,`StreetNumber` = '3210' ,`StreetSuffix` = 'Way' ,`City` = 'Kingwood' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3660' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You will fall in love with this 4 bedroom, 4.5 bath home nestled on a quiet cul-de-sac street. The kitchen has just been updated with granite countertops, stacked stone backsplash and has matching stainless steel appliances. Texas Sized Family room, kitchen and dining room makes this perfect for family gatherings. Enjoy your privacy with three of the four bedrooms having their very own private bathrooms. Home has a flex room downstairs currently being used as a gym and a gameroom upstairs (pool table is negotiable). Neighborhood has access to the Elm Grove subdivision community pool, is close to Kingwood parks, great schools, shopping, over 75 miles of bike trails and all of this with a low tax rate! Home has Never Flooded.' ,`Acres` = '0.1452' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 35 BLK 2 NORTH KINGWOOD FOREST' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6327' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '380' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'ELM GROVE ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'North Kingwood Forest' ,`TaxAmount` = '7038' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665839811' WHERE `Matrix_Unique_ID` = '210876441' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T07:49:17.377' ,`MLSNumber` = '30271470' ,`ListAgentFullName` = 'Laura Miranda' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.695539' ,`Longitude` = '-95.705035' ,`PhotoCount` = '26' ,`PostalCode` = '77407' ,`RoomCount` = '4' ,`ListPrice` = '405000.00' ,`Status` = 'Active' ,`StreetName` = 'Flintrock Hollow' ,`StreetNumber` = '7410' ,`StreetSuffix` = 'Trail' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2336' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful like-new 4 bed, 2.5 bath home zoned to Fort Bend ISD on an oversized lot. Open concept living with vaulted ceilings makes the home feel so grand. The kitchen has granite countertops, stainless steel appliances, and walk-in pantry. Abundance of natural light throughout, low-e double pane windows and energy efficient appliances! The upstairs features a game room and 3 additional bedrooms. On the first floor, you\'ll find the enclosed study with french door and spacious primary suite. The primary suite sits on the rear end of the home, tucked away behind the living room and features a large walk-in bathroom and closet. Walking & biking trails are easily accessible. Westpark Tollway, Highway 6, Hwy 90 and 99 all minutes away. Play where you live in the fast-growing city of Richmond! This house has been maintained immaculately and like-new!' ,`Acres` = '0.1447' ,`Area` = '37' ,`BuilderName` = 'DR HORTON' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKEVIEW RETREAT SEC 3, BLOCK 5, LOT 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6302' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakeview Retreat Sec 3' ,`TaxAmount` = '8415' ,`TaxRate` = '3.0697' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665839811' WHERE `Matrix_Unique_ID` = '211162410' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T07:45:36.390' ,`MLSNumber` = '54754212' ,`ListAgentFullName` = 'Quynh Luong' ,`ListOfficeName` = 'Coldwell Banker Realty, Cy-Fair Office' ,`SellingAgentFullName` = 'LaWanda Lendsey' ,`SellingOfficeName` = 'Houston Home Realty Group, LLC' ,`Latitude` = '29.841963' ,`Longitude` = '-95.695378' ,`PhotoCount` = '29' ,`PostalCode` = '77084' ,`RoomCount` = '5' ,`ListPrice` = '340000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Plum Forest' ,`StreetNumber` = '4806' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3088' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful high ceiling house ready for move-in! Great 2-story home with an inviting entry, with new laminate floors, new paint, new appliances and a new roof in 2021. Spacious formal dining, living room, game room and all the bedrooms. The Primary room is down. This property provides a relaxing view of the lake in the backyard. Easy access to Barker Cypress, I10, 99 Grand Parkway and all major shopping centers. Well kept home and for the next family.' ,`Acres` = '0.144' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 8 ROLLING CREEK SEC 1' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '6272' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '710' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'SHERIDAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'WATKINS MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Rolling Creek' ,`TaxAmount` = '6933' ,`TaxRate` = '2.731' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665839812' WHERE `Matrix_Unique_ID` = '211199818' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T07:53:39.140' ,`MLSNumber` = '64597217' ,`ListAgentFullName` = 'Patrick Burbridge' ,`ListOfficeName` = 'CitiQuest Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.847240' ,`Longitude` = '-95.416786' ,`PhotoCount` = '41' ,`PostalCode` = '77091' ,`RoomCount` = '5' ,`ListPrice` = '329900.00' ,`Status` = 'Active' ,`StreetName` = 'W Tidwell' ,`StreetNumber` = '778' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1535' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'TO-BE-BUILT! Move-in ready by SUMMER 2023! Gorgeous new construction by Disama Group. Nestled in a quite gated community within the charming historical Highland Heights, this stunning two-story home offers an open concept living area & kitchen on the first floor & three bedrooms on the second floor, private driveway and fenced backyard/patio. Upgraded modern finishes throughout including smart home system features, quartz counter tops, stainless-steel appliances, upgraded cabinets with soft close drawers. Enjoy this 19-home gated community located minutes away from Downtown Houston. Easy access to I45 and 610.\r\nPhotos from another community by the same builder - finishes and layout will vary!\r\nGPS address: 781 Davidson St. Houston TX 77091' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Disama Group' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 8, Block 1' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '1910' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'HIGHLAND HEIGHTS VILLAS' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665839812' WHERE `Matrix_Unique_ID` = '211568041' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T07:49:00.373' ,`MLSNumber` = '56607344' ,`ListAgentFullName` = 'Martha Bravo' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.632763' ,`Longitude` = '-95.630804' ,`PhotoCount` = '39' ,`PostalCode` = '77498' ,`RoomCount` = '0' ,`ListPrice` = '495000.00' ,`Status` = 'Active' ,`StreetName` = 'Oakland' ,`StreetNumber` = '919' ,`StreetSuffix` = 'Court' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3577' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custom Built Home in the Established Community of Sugar Mill. This 4/5 Bedroom, 3.5bath features a Marble Entry, separate study with it\'s own fireplace, large formal dining room, Breakfast nook, updated KITCHEN with an OVERSIZED WALK IN Pantry, Double Stairs, HUGE Upstairs Game Room, 2 Wet Bars, Whirl Pool Tub, Upstairs Separate study or craft nook, Built IN\'s Galore including a built-in WorkBench in the GARAGE!, Recently Installed AC & Furnace, Recently Installed FENCE, Roof less 5 years. OVERSIZED backyard Deck, Nice Size Back yard, Mature Trees. Sugar Mill has 2 community pools, a tennis court; Centrally located in Sugar Land, TX near major highways. . Zoned to excellent Fort Bend ISD. Walking Distance to Sugar Mill Elementary and Sugar Land Middle School. LOW Taxes Come look at this Gorgeous HOME. It\'s TRULY One OF a KIND with so many upgrades, personality and charm. You will love this Culdesac Home! Come See it TODAY!' ,`Acres` = '0.2017' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sugar Land North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SUGARMILL SEC 5, BLOCK 2, LOT 48' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8786' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '825' ,`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` = 'SUGAR MILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KEMPNER HIGH SCHOOL' ,`SchoolMiddle` = 'SUGAR LAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sugarmill' ,`TaxAmount` = '6534' ,`TaxRate` = '2.0094' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665839812' WHERE `Matrix_Unique_ID` = '211582752' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T06:54:34.843' ,`MLSNumber` = '73274288' ,`ListAgentFullName` = 'Lisa Sanders' ,`ListOfficeName` = 'Living Vogue Real Estate' ,`SellingAgentFullName` = 'Barbara Trammell' ,`SellingOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`Latitude` = '29.480960' ,`Longitude` = '-94.938666' ,`PhotoCount` = '48' ,`PostalCode` = '77539' ,`RoomCount` = '8' ,`ListPrice` = '419000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Dick Bay' ,`StreetNumber` = '1232' ,`StreetSuffix` = 'Drive' ,`City` = 'San Leon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1904' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for a property with PROVEN Airbnb income? You can live the high life upstairs while renting out the downstairs and an additional six income-producing covered boat slips with lifts! No HOA, so you can even store your RV in front! Perfect income-producing home! Just blocks from Top Water Grill! This fully furnished home sits on the mouth of the deepwater canal leading to Dickinson Bay in the historic city of San Leon. This property features two large living areas, two full kitchens, two full bathrooms, a bar, and a sunroom. Walk outside to the backyard and enjoy a covered patio with a swing, picnic table, fans, smoker, grill, and fire pit. Plenty of seating to relax and enjoy the boats and the water. Imagine fishing and catching crab out of the backyard. It comes furnished and is currently rented out consistently throughout the year. New Roof 2017, new storm windows 2015, New AC 2021, new plumbing 2021, new water heater 2021, boathouse built-in 2013, and over 220 ft of bulkhead.' ,`Acres` = '0.2459' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Central Gas,Other Heating,Propane' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 10 A EDWARDS SUR LOT 46 FIESTA ESTATES' ,`LotDesciption` = 'Other,Water View,Waterfront' ,`LotSize` = '10712' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SAN LEON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Fiesta Estates' ,`TaxAmount` = '3507' ,`TaxRate` = '2.7147' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665839812' WHERE `Matrix_Unique_ID` = '211911786' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T07:59:48.937' ,`MLSNumber` = '40315214' ,`ListAgentFullName` = 'Karly Anderson' ,`ListOfficeName` = 'Century 21 Realty Partners' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.812252' ,`Longitude` = '-95.106101' ,`PhotoCount` = '8' ,`PostalCode` = '77360' ,`RoomCount` = '4' ,`ListPrice` = '85000.00' ,`Status` = 'Active' ,`StreetName` = 'Buffalo' ,`StreetNumber` = '159' ,`StreetSuffix` = 'Street' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1368' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Single family home on a very good sized corner lot. Being offered AS-IS only. Super fixer upper and is priced well under market value.' ,`Acres` = '0.2066' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'IMPALA WOODS SECTION 1 BLK 12 LOT 1, 20, 21 & 22' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '291' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`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,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Impala Woods Sec 1' ,`TaxAmount` = '824' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665839812' WHERE `Matrix_Unique_ID` = '212413830' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T07:53:50.030' ,`MLSNumber` = '70897237' ,`ListAgentFullName` = 'Elizabeth Clark' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.052153' ,`Longitude` = '-95.560083' ,`PhotoCount` = '29' ,`PostalCode` = '77379' ,`RoomCount` = '8' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Sternwood Manor' ,`StreetNumber` = '19710' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1886' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fabulous one story home with pool/spa, gas fire pit and NO BACK NEIGHBORS in the highly sought after Gleannloch Farms. Adorable front porch, no carpet anywhere!\r\nAdditional features include spacious study, formal dining and island kitchen. Countertops are\r\nAvanza Natural Quartz, faucet is Moen touchless, and 2022 stainless steel refrigerator is included, as well as laundry room refrigerator. AC Unit replaced May 2021, gutters replaced 2020! Family room boasts gas log fireplace overlooking backyard with privacy fence replaced in 2018 and no back neighbors. Spacious covered back patio built in 2018- perfect to sit and enjoy the beautiful sunset after dipping in the pool or spa. Pool\r\npumps replaced in 2021, pool plaster cleaned (soda blasted) June of this year! Pool settings\r\ncontrolled with remote. Walking distance to neighborhood pool, park, baseball/soccer fields,\r\nbasketball and volleyball courts. Zoned to highly acclaimed Klein ISD school district.\r\nDon\'t miss out on this one!' ,`Acres` = '0.1628' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 2 GLEANNLOCH FARMS SEC 23' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7091' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'FRANK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gleannloch Farms Sec 23' ,`TaxAmount` = '6202' ,`TaxRate` = '2.7315' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1665839813' WHERE `Matrix_Unique_ID` = '212422044' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T07:22:00.843' ,`MLSNumber` = '51093631' ,`ListAgentFullName` = 'Otilia Robles' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.351767' ,`Longitude` = '-95.123107' ,`PhotoCount` = '35' ,`PostalCode` = '77517' ,`RoomCount` = '11' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Highland Rd' ,`StreetNumber` = '6503' ,`StreetSuffix` = '' ,`City` = 'Santa Fe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2128' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Country Living is calling you!! This updated manufactured home with four bedrooms and two baths nestled on 2.5 acres in Santa Fe is a must-see. Features include an updated island kitchen with granite countertops, breakfast bar, and gorgeous pot rack. The adjacent laundry room has a standalone sink and accesses the back porch area. The wood-burning fireplace flanked by windows is the focal point of the spacious living/dining combo. Ample storage in the updated primary bath ensuite includes a walk-in closet. The primary bedroom holds a king-size bed with room to spare. The guest bath updates include granite-topped cabinets. Three secondary bedrooms are currently being used for an office, cycling studio, and storage. The back porch area is decked and provides the perfect spot to enjoy early morning coffee and watch the sunrise. \r\n\r\nNo deed restrictions. No HOA.' ,`Acres` = '2.5' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 47 L CRAWFORD SUR PT OF OUTLOT 414 (414-19) ALTA LOMA O' ,`LotDesciption` = 'Cleared' ,`LotSize` = '108900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'DAN J KUBACAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Alta Loma Outlots' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665839813' WHERE `Matrix_Unique_ID` = '212591389' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T06:42:05.663' ,`MLSNumber` = '61558782' ,`ListAgentFullName` = 'Sarah Conway' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.425743' ,`Longitude` = '-95.620436' ,`PhotoCount` = '50' ,`PostalCode` = '77356' ,`RoomCount` = '9' ,`ListPrice` = '479900.00' ,`Status` = 'Active' ,`StreetName` = 'Carmel' ,`StreetNumber` = '22' ,`StreetSuffix` = 'Court' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2911' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spectacular home on cul-de-sac lot in the desirable gated Lake Conroe community of Bentwater. Nestled on the stunning golf course street, this 3-BR, 2.5-Bath property boasts generous room sizes, plantation shutters, living area with tray ceiling & built-ins, an elegant formal dining room, and a spacious study overlooking the courtyard. The island kitchen includes expansive countertops & loads of storage; open the breakfast room with far-reaching views. Owner’s suite w/ generous walk-in closet, dual vanities, tub, & separate shower. 2 private secondary BRs share a pass-through bath. Oversized screened porch w/ picturesque golf course views of Weiskopf #8 and pond! NEW ROOF! Fenced yard, bug spray system, & mature landscaping. Enjoy life like you\'re on a vacation with access to the country club, THREE 18-hole championship golf courses, the yacht club, sports club, pickle ball, dog park, and 24 hr manned gate!!! Sought after MISD!' ,`Acres` = '0.184' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'BENTWATER 68, BLOCK 1, LOT 19' ,`LotDesciption` = 'Cleared,In Golf Course Community,On Golf Course,Patio Lot,Subdivision Lot,Water View' ,`LotSize` = '8017' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1146' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bentwater' ,`TaxAmount` = '6827' ,`TaxRate` = '2.1142' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665839813' WHERE `Matrix_Unique_ID` = '212709978' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T07:27:54.167' ,`MLSNumber` = '95519695' ,`ListAgentFullName` = 'Kathy Grey' ,`ListOfficeName` = 'Xterra Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.698736' ,`Longitude` = '-95.495271' ,`PhotoCount` = '30' ,`PostalCode` = '77074' ,`RoomCount` = '3' ,`ListPrice` = '194900.00' ,`Status` = 'Active' ,`StreetName` = 'Roos' ,`StreetNumber` = '6402' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1062' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovingly Maintained by same Owner for 50+ years, SINGLE STORY Mid-Century home. This cute and cozy single story packs so many spaces into it. 3 beds, one full bath plus a formal dining AND paneled TV room. Sharpstown is known for it\'s large lots. One car attached garage. The backyard contains a storage shed.' ,`Acres` = '0.1708' ,`Area` = '21' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sharpstown Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 30 BLK 8 SHARPSTOWN SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7440' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SUTTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHARPSTOWN HIGH SCHOOL' ,`SchoolMiddle` = 'LONG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Sharpstown Sec 01' ,`TaxAmount` = '3535' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665839813' WHERE `Matrix_Unique_ID` = '212717714' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T06:31:31.530' ,`MLSNumber` = '38514172' ,`ListAgentFullName` = 'Sara Loftin' ,`ListOfficeName` = 'Loyal Texas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.762770' ,`Longitude` = '-95.246192' ,`PhotoCount` = '22' ,`PostalCode` = '77029' ,`RoomCount` = '3' ,`ListPrice` = '178500.00' ,`Status` = 'Active' ,`StreetName` = 'Chadwick' ,`StreetNumber` = '10322' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to this freshly renovated 3 bed, 2 bath beauty in the heart of Jacinto City. Enjoy a cup of coffee on your front porch or backyard grilling in the spacious backyard. Home features new kitchen cabinets, new stainless steel kitchen sink w/pull down sprayer on faucet, granite countertops, new LG stainless steel gas cooktop w/convection oven, new Samsung stainless steel microwave, new doors throughout, new ceramic tile flooring in wet areas & living room, in addition to new carpet in all bedrooms. Interior & exterior has been fully painted including front porch which has ample space for an outdoor swing. All new light fixtures, new bath sinks/vanity, new tiled bath showers & new shower heads and toilets. More updates include new RHEEM performance 40gal water heater, central/ac & heating. Jacinto City is minutes from I-10, downtown, Galena Park, Northshore & driving distance to many restaurants & shopping, parks & fields and trails. Schedule showing TODAY, don\'t miss out!' ,`Acres` = '0.1148' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 40A INDUSTRIAL' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`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,No Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Industrial Add' ,`TaxAmount` = '1621' ,`TaxRate` = '2.993' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665839813' WHERE `Matrix_Unique_ID` = '212724867' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T07:26:21.020' ,`MLSNumber` = '53665838' ,`ListAgentFullName` = 'Melody Pevateaux' ,`ListOfficeName` = 'Weichert,REALTORS-Murray Group' ,`SellingAgentFullName` = 'Kyle Tweed' ,`SellingOfficeName` = 'Compass RE Texas, LLC' ,`Latitude` = '30.371247' ,`Longitude` = '-95.601312' ,`PhotoCount` = '42' ,`PostalCode` = '77356' ,`RoomCount` = '6' ,`ListPrice` = '399000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'April Wind' ,`StreetNumber` = '168' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1825' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you\'ve been looking for a HOME SWEET POOL HOME in the gated community of April Sound, then look no further! This completely remodeled single story home is an entertainers dream that greets you with soaring ceilings and a view of your personal oversized backyard oasis the moment you walk through the front door. This fabulous property offers a gourmet kitchen made for the chef with stainless high end Frigidaire Professional appliances including a five burner cooktop, commercial grade double oven, and ample counter space. On the warm fall days, lay by your newly remodeled pool, hop in the spa, or relax under your custom covered patio. This home also offers a 750 sq ft oversized garage, and a new driveway that can accommodate a 40ft RV. Other energy efficent features include a two year old HVAC and new ducting, dual pane vinyl windows, tankless gas water heater, and blown in attic insulation with an R-38 rating. No expense has been spared with this home. Make this your home today!' ,`Acres` = '0.2403' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'APRIL SOUND 04, BLOCK 2, LOT 10' ,`LotDesciption` = 'Cleared,In Golf Course Community' ,`LotSize` = '10466' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '234' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'April Sound 04' ,`TaxAmount` = '5045' ,`TaxRate` = '2.2625' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665839814' WHERE `Matrix_Unique_ID` = '212875539' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T07:55:09.323' ,`MLSNumber` = '18036842' ,`ListAgentFullName` = 'Janice Macek' ,`ListOfficeName` = 'The Property Source' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.093299' ,`Longitude` = '-95.549798' ,`PhotoCount` = '34' ,`PostalCode` = '77375' ,`RoomCount` = '9' ,`ListPrice` = '349000.00' ,`Status` = 'Active' ,`StreetName` = 'Red Pine' ,`StreetNumber` = '22547' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2570' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing and Gorgeous, Contemporary home with over $119K in upgrades!!! A complete Makeover and like having a New Home!!! New roof October 2022. In September 2019, New Double Pane Windows, Window Treatments, 2 - AC units (Transferrable Warranties), Carpet & Pad on Second Floor & Stairs, all neutral Tile on first floor, Recess Lighting in all Rooms, All Switches and Other Lights throughout, all Hardware throughout, Fireplace Face, Total Kitchen Remodel, LG appliances, Quartz Countertops, Fans in all Bedrooms, Living room and Office. Total Bathroom Remodel includes Primary, Secondary and Half Bath. Complete Interior and Exterior Fresh paint! Water Tank replace in 2018. Move-in Ready so Hurry, it won\'t last Long!!!' ,`Acres` = '0.202' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 407 BLK 15 017*W3465200-002-015-407 WILLOW FOREST SEC 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '473' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'SCHULTZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HILDEBRANDT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Willow Forest Sec 02' ,`TaxAmount` = '6844' ,`TaxRate` = '2.8765' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665839814' WHERE `Matrix_Unique_ID` = '212954193' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T06:40:24.637' ,`MLSNumber` = '21682869' ,`ListAgentFullName` = 'Andrea Credit' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = 'Richard Francis' ,`SellingOfficeName` = 'CB&A, Realtors' ,`Latitude` = '29.555272' ,`Longitude` = '-95.290454' ,`PhotoCount` = '24' ,`PostalCode` = '77584' ,`RoomCount` = '12' ,`ListPrice` = '425000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Lost Maples' ,`StreetNumber` = '2817' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2985' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 4 bed 3 1/2 bath has a grand two story entry that leads to the formal dining room. Tile and laminate floors on the first floor. The kitchen features plety of cabinet and counter top space, breakfast bar and stainless steel appliance package. The spacious 1st story master retreat has room for a sitting area and the en-suite bath features dual vanities, walk-in shower and separate soaking bathtub. The 2nd floor is complete with a game room, 3 bedrooms and 2 full bathrooms. The backyard has new fence and is made for entertaining with nice size pool. Schedule your showing today.' ,`Acres` = '0.1584' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'PARKS AT WALNUT BEND SEC 2 (A0239 HT&BRR) , BLOCK 2, LOT 48' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '315' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'C J HARRIS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH EAST' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Parks At Walnut Bend Sec 1-2' ,`TaxAmount` = '10849' ,`TaxRate` = '2.8851' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665839814' WHERE `Matrix_Unique_ID` = '212990416' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T07:36:39.473' ,`MLSNumber` = '17547267' ,`ListAgentFullName` = 'Mel Reyna' ,`ListOfficeName` = 'The Reyna Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.795411' ,`Longitude` = '-95.464813' ,`PhotoCount` = '34' ,`PostalCode` = '77055' ,`RoomCount` = '11' ,`ListPrice` = '929000.00' ,`Status` = 'Active' ,`StreetName` = 'Wharton' ,`StreetNumber` = '6506' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3820' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**BUILDER OFFERING $15K TO BE USED TOWARDS RATE BUYDOWN & UPGRADES IF CLOSED BY 12/31/22 ** This New Construction by Quintessa Homes is located in the Westview Terrace subdivision of Spring Branch. Home offers 4-5 Bedrooms/3.5 Baths w/ a RARE Guest Suite & Separate Study on the 1st Floor as well as an additional 2nd Office/Hobby Space on the 2nd Floor. Exterior Features include Designer Brick & Stone Exterior w/ Metal Roof Accent, Over-sized Coach Lights, Custom Metal Front Door, Sod/Sprinklers. Interior Features include Oak Wood floors, Electric Fireplace, 10in baseboards (1st Floor), Home Audio/Automation/Security System Pre-wire & is Nest/Ring Compatible. Kitchen features a Large Island w/ Quartz counters, Designer selected fixtures, Kent-Moore Cabinetry & SS Appliance package. Primary Suite offers separate vanities, Freestanding Tub & separate Walk-in Shower w/ glass enclosure , High-end Quartz counter tops and Double Walk-in Closets.' ,`Acres` = '0.1567' ,`Area` = '24' ,`BuilderName` = 'Quintessa Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 19 BLK 11 WESTVIEW TERRACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6825' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HOUSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Right Side,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westview Terrace' ,`TaxAmount` = '6832' ,`TaxRate` = '2.5733' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665839814' WHERE `Matrix_Unique_ID` = '213166244' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T07:38:22.510' ,`MLSNumber` = '81380904' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.784181' ,`Longitude` = '-95.439956' ,`PhotoCount` = '28' ,`PostalCode` = '77055' ,`RoomCount` = '10' ,`ListPrice` = '772899.00' ,`Status` = 'Active' ,`StreetName` = 'Weston Manor' ,`StreetNumber` = '3620' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3027' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to your stately 3 story home! Designed for all lifestyles, this exquisite home gives you a wide, grand entry! French door gives privacy to Study. The 11 ft ceilings & big windows across the rear of the home, bring the outside in! The Kitchen is a cooks dream w/large island/brk bar, separate oven/micro & gas c-top w/updraft vent hood make you proud to show it off to friends & family! The built in cabinets at Dining are an added plus for storage. The covered rear patio provides a perfect entertaining space!! And after a long day retreat to your large Master suite w/treyed ceiling w/big walk-in shower @ Mstr bath, plus big custom walk closet! Doing laundry is fun in this oversized laundry room w/folding table! Loft area @ 2nd fl can be a workout space or 2nd study! Separate gameroom & 4th bedrm at 3rd floor complete this home! David Weekley Homes is an Environments for Living DIAMOND level builder. Heating/cooling usage GUARANTEED for 3 yrs. Com. pool, manned gate, dog pk' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Timbergrove/Lazybrook' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1, Block 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '3099' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Controlled Access,Leave Business Card,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Other Style' ,`Subdivision` = 'Somerset Green' ,`TaxAmount` = '' ,`TaxRate` = '2.83' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665839814' WHERE `Matrix_Unique_ID` = '213224270' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T07:27:38.143' ,`MLSNumber` = '32632642' ,`ListAgentFullName` = 'Machell Tompkins' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.694954' ,`Longitude` = '-95.119060' ,`PhotoCount` = '28' ,`PostalCode` = '77536' ,`RoomCount` = '7' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'X' ,`StreetNumber` = '409' ,`StreetSuffix` = 'Street' ,`City` = 'Deer Park' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated home in heart of Deer Park! Recent roof, siding, paint, pex plumbing, total kitchen upgrade ,granite, sink hardware, appliances, master and guest bath with granite,double sinks,complete tile shower makeover Primary beautiful wood look vinyl flooring in den, dining, kitchen and carpet in bedrooms,\r\nceiling fans & more! Make an appt today for a private tour..' ,`Acres` = '0.1637' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Deer Park' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 45 BLK 4 PALM TERRACE' ,`LotDesciption` = 'Other' ,`LotSize` = '7130' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (DEER PARK)' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'DEER PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Palm Terrace' ,`TaxAmount` = '6236' ,`TaxRate` = '2.8239' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665839815' WHERE `Matrix_Unique_ID` = '213225185' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T07:01:20.207' ,`MLSNumber` = '81945736' ,`ListAgentFullName` = 'Ebony Royal' ,`ListOfficeName` = 'Braden Real Estate Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.238874' ,`Longitude` = '-95.314192' ,`PhotoCount` = '29' ,`PostalCode` = '77302' ,`RoomCount` = '4' ,`ListPrice` = '299990.00' ,`Status` = 'Active' ,`StreetName` = 'Silent Pines' ,`StreetNumber` = '16814' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2077' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your home! Built in 2020, this open concept layout has everything your family needs. Features include a total of 4 bedrooms (Master down), 2.5 Baths, corner lot, Gameroom upstairs with remaining 3 bedrooms, large kitchen island, tankless water heater, and MASSIVE BACKYARD!\r\n\r\nThe community features an 11-acre park with splashpad, pavilion, 6 acre lake, and walking trails. Conveniently located near shopping and entertainment at Valley Ranch Town Center, Downtown Conroe, and 20 minutes from the Woodlands Market Street. Check out the virtual tour and schedule your showing today!' ,`Acres` = '0.2449' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S539500 - GRANGER PINES 01, BLOCK 2, LOT 36' ,`LotDesciption` = 'Corner' ,`LotSize` = '10667' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'HOPE ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Granger Pines 01' ,`TaxAmount` = '4648' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665839815' WHERE `Matrix_Unique_ID` = '213231487' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T06:48:55.923' ,`MLSNumber` = '35944932' ,`ListAgentFullName` = 'Carol Marple' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.081124' ,`Longitude` = '-95.194422' ,`PhotoCount` = '35' ,`PostalCode` = '77339' ,`RoomCount` = '10' ,`ListPrice` = '289900.00' ,`Status` = 'Active' ,`StreetName` = 'Knoll Terrace' ,`StreetNumber` = '5434' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2204' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous two-story brick home nestled amongst mature trees on a quiet cul-de sac. As you enter the home you will feel like you are at home....the open family room/dining room has been updated with new flooring, crown molding, and a modern fireplace. Kitchen has fresh paint and shiplap, granite counters & a stone backsplash that adds to the coziness of this home. The spacious primary retreat boasts an updated en suite with dual sinks, jetted tub, and huge walk in closet. Three spacious bedrooms up allows plenty of room for the entire family. Texas-sized back yard is great for entertaining and family BBQ\'s. Sprinkler system, washer, dryer & refrigerator included. NEVER FLOODED with access to the Greenbelt Trails, parks, pool, golf, tennis, restaurants, & shopping. COME LIVE LIFE IN THE WOODS....KINGWOOD!' ,`Acres` = '0.2039' ,`Area` = '32' ,`BuilderName` = '' ,`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 26 BLK 34 ELM GROVE VILLAGE SEC 3' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '8880' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '439' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'ELM GROVE ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Elm Grove Village' ,`TaxAmount` = '5366' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665839815' WHERE `Matrix_Unique_ID` = '213256015' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T07:13:32.087' ,`MLSNumber` = '6160935' ,`ListAgentFullName` = 'Wesley Jurena' ,`ListOfficeName` = 'Texas Legacy Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.659587' ,`Longitude` = '-95.486254' ,`PhotoCount` = '36' ,`PostalCode` = '77096' ,`RoomCount` = '10' ,`ListPrice` = '562900.00' ,`Status` = 'Active' ,`StreetName` = 'Sanford' ,`StreetNumber` = '5631' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2270' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to another beautiful remodel by Crew Ventures! This impressive Westbury home is in a great neighborhood with wide tree lined streets. Extensively remodeled with designer touches this home offers an open floor plan throughout the kitchen and living are, a beautiful butcher block island and laundry room. Also includes a private office or flex space. So much new, to include paint inside and out, windows, stainless steel appliances, cabinets throughout, quartz counter tops, laminate and tile flooring. New pex plumbing and fixtures, new electrical panel and wiring and fresh landscape. Zoned to Parker Elementary with Westbury Park and pool in the neighborhood. Easy access to 610, Galleria and the Medical Center. This home has never flooded and is in Zone X, no mandatory flood insurance. Schedule your showing today!' ,`Acres` = '0.2287' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 188 WESTBURY SEC 5 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9960' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '365' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PARKER ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westbury Sec 05 R/P' ,`TaxAmount` = '6721' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665839815' WHERE `Matrix_Unique_ID` = '213453445' --> 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','213454668','1665839815','213454668','2022-10-15T07:12:49.623','85833586','Larry Cockman','eXp Realty, LLC','','','29.837209','-95.787333','32','77493','5','350000.00','Active','Rivage Ridge','23710','Drive','Katy','2','0','4','1934','Single-Family','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.','0.2387','25','','','','','Sellers Disclosure','','','','Katy - North','Central Gas','1','LT 13 BLK 3 VENTANA LAKES SEC 9','Subdivision Lot','10397','Appraisal District','','850','0','','2','','0','','','','','Composition','30 - Katy','BETHKE ELEMENTARY SCHOOL','PAETOW HIGH SCHOOL','STOCKDICK JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Ventana Lakes Sec 9','7704','3.2768','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','213468537','1665839815','213468537','2022-10-15T07:56:13.720','55180659','Carlos Alvarez','Texas Ally Real Estate Group,','','','29.888530','-95.512131','48','77040','3','248000.00','Active','Log Hollow','7926','Drive','Houston','2','0','3','1532','Single-Family','Elegantly renovated, All-Flooring with Ceramic Tile. Studio with French Doors. High Ceilings. Upgraded Kitchen with New Fixtures and Stainless Steel Appliances in an open concept to Dining room. Fridge, Washer and Dryer included. New Electric Fixtures and New Ceiling Fans. Main Bedroom with spacious Bathroom with Tub and separate Spa Dual Shower and New Fixtures. Large Backyard. One of the newest Floorplan and Construction in the Subdivision. Outside of Flood Zone and never flooded. Accessible Location close by Sam Houston Parkway, 610 Loop and 59 Freeway.','0.168','11','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Northwest Houston','Central Electric','1','LT 954 BLK 25 WOODLAND OAKS SEC 4','Subdivision Lot','7320','Appraisal District','','285','0','','2','Electric Oven','0','','','','','Composition','13 - Cypress-Fairbanks','REED ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','JERSEY VILLAGE HIGH SCHOOL','DEAN MIDDLE SCHOOL','Lockbox Front','Appraisal District','1','Traditional','Woodland Oaks Sec 04','3466','2.091','Public Sewer,Public Water','1996','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T07:28:59.437' ,`MLSNumber` = '63078271' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.784072' ,`Longitude` = '-95.440031' ,`PhotoCount` = '31' ,`PostalCode` = '77055' ,`RoomCount` = '9' ,`ListPrice` = '673089.00' ,`Status` = 'Active' ,`StreetName` = 'Longford Manor' ,`StreetNumber` = '3601' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2393' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This fabulous layout with all the right spaces offers a home you will be proud to show off to friends and family! Large windows at Living bring the outside in & provide lots of sunlight! Low maintenance vinyl plank floors at 1st floor provide a warm, rich feeling. This versatile Study w/glass door allows you to work privately if needed! And everyone will gather around the large island in the Kitchen, providing a great work space or for homework! And you cooks will love the GE Cafe 5 burner gas cooktop w/stainless chimney vent hood & separate convection oven! Like to grill, a gas line is there for your convenience as well as a covered patio for you to enjoy your fenced rear yard that is maintained by the HOA! And when you are ready to relax, you will love the large walk-in shower w/rain shower head & large Master suite! Somerset Green is a gated community w/manned guard gate! Community pool! Weekley Homes is an Env. for Living DIAMOND level bldr. Heat/cool usage GUARANTEED for 3 yrs.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Timbergrove/Lazybrook' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 20, Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2587' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Controlled Access,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Somerset Green' ,`TaxAmount` = '' ,`TaxRate` = '2.83' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665839815' WHERE `Matrix_Unique_ID` = '213474159' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T07:14:21.460' ,`MLSNumber` = '50366068' ,`ListAgentFullName` = 'Michelle Hoover' ,`ListOfficeName` = 'Hoover Lake Conroe Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.393179' ,`Longitude` = '-95.722763' ,`PhotoCount` = '30' ,`PostalCode` = '77356' ,`RoomCount` = '7' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Brocks' ,`StreetNumber` = '258' ,`StreetSuffix` = 'Lane' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1679' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gently lived in 2 yr old home. Four bedrooms, two bath. single story. Open concept living room/dining/kitchen. Counter height island with room for bar stools. Washer, Dryer and refrigerator included. Water softener, gutters and expanded back patio. Large fenced backyard. Neighborhood playground. Near schools in highly acclaimed Montgomery school district.' ,`Acres` = '0.1716' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Montgomery County Northwest' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S582403 - THE HILLS OF TOWN CREEK 03, BLOCK 3, LOT 5' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '7473' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Hills Of Town Creek 03' ,`TaxAmount` = '5331' ,`TaxRate` = '2.2242' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665839816' WHERE `Matrix_Unique_ID` = '213511071' --> 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','213537093','1665839816','213537093','2022-10-15T07:59:10.170','96263245','Erica Nehls','Erica Nehls Real Estate','','','29.523827','-95.181224','18','77546','6','265000.00','Active','Saffron','4314','Lane','Friendswood','2','0','4','1716','Single-Family','Lovely home in Forest Bend. Fully remodeled and move-in ready! Wood look tile flooring throughout, the beautiful kitchen has loads of cabinetry. The water heater, a/c, heat, ductwork, interior and exterior paint updated, as well as both bathrooms. Upgraded windows were installed in 2021, the foundation was repaired through Allied Foundation in 2014 with a transferrable warranty. Room sizes are approximate, please verify.','0.1666','7','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Friendswood','Central Electric','1','LT 34 BLK 10 FOREST BEND SEC 5','Subdivision Lot','7257','Appraisal District','','220','0','','2','Electric Oven,Single Oven','0','','','Electric Cooktop','','Composition','9 - Clear Creek','WEDGEWOOD ELEMENTARY SCHOOL','CLEAR BROOK HIGH SCHOOL','BROOKSIDE INTERMEDIATE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Forest Bend Sec 05','4229','2.2534','Public Sewer,Public Water','1975','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T07:43:58.640' ,`MLSNumber` = '88838370' ,`ListAgentFullName` = 'Christy Luong' ,`ListOfficeName` = 'Precious Realty & Mortgage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.901462' ,`Longitude` = '-95.666121' ,`PhotoCount` = '33' ,`PostalCode` = '77095' ,`RoomCount` = '9' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Innisbrook' ,`StreetNumber` = '16702' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2796' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is beautiful FORMAER MODEL house located in the gated Brookside Court subdivision of Copperfield area features 4 bedrooms, 2.5 bath 2 car garage, LARGE island kitchen with upgraded granite countertop & title backsplash, large family room with corner fireplace/mantle. All bedrooms are upstairs, great master bedroom with large master bath with walk-in closet, his and her vanity tub and separate shower. There are well size secondary bedroom and along long with hug game room. This home offered soaring high ceiling, open concept, large window and tons of natural light. This home RECENTLY REMODEL in 2021. High rated Cypress Fairbanks ISD schools and conveniently located close to HWY 290. 99 Grand Parkway, Beltway 8, Dinning, Shopping, Outlet Mall and Entertaiment. Home has never flooded. A MUST SEE!!!!' ,`Acres` = '0.137' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 2 BROOKSIDE COURT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5968' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '737' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'BIRKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LANGHAM CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'ARAGON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Brookside Court' ,`TaxAmount` = '7311' ,`TaxRate` = '2.881' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665839816' WHERE `Matrix_Unique_ID` = '213561952' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T06:49:12.130' ,`MLSNumber` = '5883875' ,`ListAgentFullName` = 'Michael Seder' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.182426' ,`Longitude` = '-95.498363' ,`PhotoCount` = '22' ,`PostalCode` = '77381' ,`RoomCount` = '8' ,`ListPrice` = '398700.00' ,`Status` = 'Active' ,`StreetName` = 'Robin Springs' ,`StreetNumber` = '17' ,`StreetSuffix` = 'Place' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1969' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Adorable one story home conveniently located in Cochran\'s Crossing, where you\'ll be close to shops, restaurants, parks with lighted tennis courts and miles of walking trails! As you enter the home, you\'ll notice the open concept floor plan and tons of natural light through the large windows. The main living area features a vaulted ceiling and stone fireplace, which opens to the dining room with built-ins and doors that lead to a screened-in porch. The light and bright kitchen offers a planning desk, center island, gorgeous counters and plenty of cabinet storage. The kitchen opens to the breakfast nook. The spacious owner\'s retreat has sliding doors that lead to the recently added patio with outdoor shower. There\'s also a full bath with dual sinks, tub shower and walk in closets. Two guest bedrooms share a Jack and Jill bath. Located on a cul-de-sac street, this home has a two car attached garage, fully fenced yard with easy maintenance natural landscaping, and walking trails behind.' ,`Acres` = '0.2423' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL COCHRANS CR 03, BLOCK 2, LOT 32' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10553' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'DAVID ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Cochrans Cr 03' ,`TaxAmount` = '5682' ,`TaxRate` = '2.1811' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665839816' WHERE `Matrix_Unique_ID` = '213595483' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T07:30:43.563' ,`MLSNumber` = '65259144' ,`ListAgentFullName` = 'Donna Norris' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.475453' ,`Longitude` = '-95.118250' ,`PhotoCount` = '50' ,`PostalCode` = '77573' ,`RoomCount` = '10' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Bullhead' ,`StreetNumber` = '2317' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3088' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated home features 4 bedrooms, 3 full bathrooms plus large home office/media room. Formal dining, den and island kitchen/breakfast combo all overlook custom tiled fireplace surround and view to back garden, sharing 10\' ceilings and upgraded molding. Counter height bar in kitchen and island are granite, with gorgeous travertine tile back splash and lighting beneath the 42\" cabinets. Huge primary bedroom has cathedral ceiling and lovely accent wall as well as walk-through access to the laundry room via the closet. Many rooms have motion activated lighting; all light fixtures/fans are upgraded. Interior newly repainted, and exterior freshly landscaped. Oversized 2-car garage has been drywalled; upstairs is additional finished 392 sq ft, with its own private entrance, HVAC unit (plumbing stub out for future bathroom is in place) and is currently used as a craft room. Spray foam insulation with sealed attic system ensures low utility bills. Super low 2.06% tax rate - no MUD!' ,`Acres` = '0.2311' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEDONA SEC 3 (2014) ABST 3, BLOCK 8, LOT 4, ACRES 0.23' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot' ,`LotSize` = '10066' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BAUERSCHLAG ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'VICTORYLAKES INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sedona' ,`TaxAmount` = '9163' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665839816' WHERE `Matrix_Unique_ID` = '213600892' --> 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','213603593','1665839816','213603593','2022-10-15T06:21:16.320','33811486','Anthony Meza','Cy-Fair Real Estate','','','29.984016','-95.697513','27','77429','6','335000.00','Active','Windwood Park','14646','Lane','Cypress','2','0','3','1916','Single-Family','Welcome to this immaculately kept home in a corner lot of Cypress Mill Park. The home features a front covered porch with a new side fence recently installed. As you walk into the home, you will be greeted with new flooring throughout the home as well as paint. The home follows a split floorplan from the owner\'s bedroom to the secondary rooms and office space. Spacious open-concept kitchen and dining room combo with cabinets reaching the ceiling open to the large vaulted ceiling living room. The home has double-paned windows for efficiency, Pex piping, and the roof shingles were replaced 5 years ago, and you can feel the pride in homeownership as you walk through this very well-kept home. The community itself includes access to two pools, parks, walking trails, tennis courts, and a clubhouse exclusively for residents of the community. This home is zoned out to some of the best schools in the very recognized Cy-Fair ISD. With so many great features it is a must-see!','0.1308','35','Ryland Homes','','Electric Dryer Connections,Washer Connections','','Exclusions,Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Cypress North','Central Gas','1','LT 1 BLK 8 CYPRESS MILL PARK SEC 2','Corner','5697','Appraisal District','','600','0','','2','Convection Oven','0','','','Gas Range','','Composition','13 - Cypress-Fairbanks','A ROBISON ELEMENTARY SCHOOL','CYPRESS WOODS HIGH SCHOOL','SPILLANE MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal','1','Traditional','Cypress Mill Park Sec 02','6111','2.761','Water District','2005','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T07:13:00.873' ,`MLSNumber` = '50887069' ,`ListAgentFullName` = 'Livee Gao' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.732924' ,`Longitude` = '-95.482621' ,`PhotoCount` = '15' ,`PostalCode` = '77057' ,`RoomCount` = '7' ,`ListPrice` = '385000.00' ,`Status` = 'Active' ,`StreetName` = 'Fairdale' ,`StreetNumber` = '5909' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2480' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well-kept home has a large yard. Big balcony on 2nd floor. Fabulous family room has 18+ ft ceiling. Master bedroom at 1st floor. 2nd&3rd bedrooms on 3rd floor. Small study in kitchen area. Great open floor plan. Also for lease $2400/m.' ,`Acres` = '0.0459' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Galleria' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 7E .25 U/D INT IN TR 7 (COMMON AREA) WESTHEIMER GARDENS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2001' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SCHOOL AT ST GEORGE PLACE' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Westheimer Gardens' ,`TaxAmount` = '6469' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665839816' WHERE `Matrix_Unique_ID` = '213630687' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T07:12:07.020' ,`MLSNumber` = '29347426' ,`ListAgentFullName` = 'Isela Truong' ,`ListOfficeName` = 'Terramont Realty Partners' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.368054' ,`Longitude` = '-95.608529' ,`PhotoCount` = '38' ,`PostalCode` = '77356' ,`RoomCount` = '7' ,`ListPrice` = '435000.00' ,`Status` = 'Active' ,`StreetName` = 'Springs Edge' ,`StreetNumber` = '266' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2448' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stately home sits on a corner, cul-de-sac lot with views of the golf course. Roof is only 6 years old and the home comes with a whole house Generac Generator! Recently updated with New Quartz countertops, backsplash, stove with wifi, pop up exhaust vent, stainless steel sink, fresh paint and carpet, all new faucets and LED lighting. Simply Charming home, light and bright, located on one of the nicest streets in April Sound. Pride of ownership shows in all the surrounding homes. Covered balcony off the primary bedroom with stairs to access the patio below. Kitchen boasts a double bar for additional seating on both ends. Owner is offering $500 towards a home warranty of your choice. Schedule your tour today!' ,`Acres` = '0.3036' ,`Area` = '39' ,`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` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'APRIL SOUND 01, BLOCK 5, LOT 51' ,`LotDesciption` = 'Corner,Cul-De-Sac,In Golf Course Community,On Golf Course,Subdivision Lot,Wooded' ,`LotSize` = '13223' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '234' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'April Sound 01' ,`TaxAmount` = '5587' ,`TaxRate` = '2.2525' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665839817' WHERE `Matrix_Unique_ID` = '213668641' --> 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','213678185','1665839817','213678185','2022-10-15T06:27:19.717','69969611','Michael Parker','BHGRE Gary Greene','','','29.583390','-95.112890','41','77062','12','565000.00','Active','Scenic View','15838','Drive','Houston','3','1','4','3493','Single-Family','Updated & well maintained 2 story home situated on large lot in desirable Bay Forest Community. Exterior offers a manicured lawn w/ beautiful landscaping, mature trees, and great curb appeal. There is a 3-car garage with cabinets for storage. You will love the extra parking in wide driveway. Electric plug in garage for EV. Inside the home you will love the beautiful oak wood throughout the home. There is wood flooring and tile throughout downstairs . The kitchen boasts granite counter tops along with two sinks,stainless steel appliances and built-in pantry. Utility room has a sink w/granite counter top. First floor primary bedroom has its own A/C, bath has double sinks, granite counter tops, separate shower and jetted tub, and two walk-in cedar lined closets. Upstairs you will find a great game room/den with built-ins, 3 bedrooms and 2 baths with granite counter tops. There are 2 large storage attics. Back yard with covered patio with fans and sky lights is perfect for entertaining.','0.2968','7','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Clear Lake Area','Central Gas','1','LT 12 BLK 5 BAY FOREST SEC 1','Corner','12930','Appraisal District','','720','0','','3','Electric Oven,Single Oven','0','','','Electric Cooktop','','Composition','9 - Clear Creek','FALCON PASS ELEMENTARY SCHOOL','CLEAR LAKE HIGH SCHOOL','SPACE CENTER INTERMEDIATE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Bay Forest Sec 01','12214','2.5769','Public Sewer,Public Water','1988','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','213699860','1665839817','213699860','2022-10-15T07:12:55.570','6502534','Margaret Matarazzo','Galveston First Realty','','','29.320971','-94.770055','19','77550','8','239000.00','Active','Ferry','512','Road','Galveston','2','0','4','1176','Single-Family','Very nice 4 bedroom 2 bath home located on large fenced in lot. Lots of storage. Located close to UTMB, Coast Guard, Seawall and Beach.','0.1511','33','','','','','Sellers Disclosure','','','','East End','Central Electric','0','ABST 628 M B MENARD SUR LOT 3 FERRY ROAD SUB','Subdivision Lot','6580','Appraisal District','','','0','','0','','0','','','','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required','Appraisal District','2','Traditional','Ferry Road Sub 96','1939','2.0662','Public Sewer,Public Water','1996','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','213700915','1665839817','213700915','2022-10-15T06:16:40.577','14568474','Lacy DeSouza','Coldwell Banker Realty','','','30.012963','-95.192985','0','77346','6','255000.00','Active','Heronwood','5403','','Humble','2','0','3','1500','Single-Family','','','1','','','Electric Dryer Connections','','Mud,Sellers Disclosure','1','Gas Connections','1','Atascocita North','Central Gas','1','LT 1 BLK 11 ATASCOCITA NORTH SEC 2','Corner,Subdivision Lot','10491','Appraisal District','','240','0','','2','Gas Oven','0','','','Gas Range','','Composition','29 - Humble','OAKS ELEMENTARY SCHOOL','ATASCOCITA HIGH SCHOOL','TIMBERWOOD MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Atascocita North','','','Water District','1983','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','213713288','1665839817','213713288','2022-10-15T07:24:35.627','20253884','Lynda Carouthers-Ford','Switch, Realtors','','','29.816701','-95.712007','0','77449','3','160000.00','Active','Silverside','3315','Drive','Katy','2','0','2','1400','Single-Family','This recently remodeled home features 2 bedrooms, 2 full baths, and oversized backyard in KATY school zone. The stunning kitchen features updated cabinetry and countertops in the kitchen. The family room includes a fireplace, gorgeous flooring, and large sliding glass doors allowing the natural light to shine through and providing access to the backyard. You don\'t want to miss all this home has to offer!','0.1187','25','','','','','Other Disclosures,Tenant Occupied','1','','1','Katy - North','Central Electric','1','LT 13 BLK 10 SILVERMILL SEC 1 R/P','Subdivision Lot','5170','Appraisal District','','0','0','','0','','0','','','','','Composition','30 - Katy','RHOADS ELEMENTARY SCHOOL','MAYDE CREEK HIGH SCHOOL','CARDIFF JUNIOR HIGH SCHOOL','Accompany,Call Occupant','Appraisal District','1','Traditional','Silvermill Sec 01 R/P','2679','2.822','Water District','1981','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','213716831','1665839817','213716831','2022-10-15T07:17:42.417','19997709','Mario Guzman','RE/MAX Real Estate Assoc.','','','29.689855','-95.232408','19','77502','7','185000.00','Active','Pecan','1307','Drive','Pasadena','2','0','4','1420','Single-Family','4/2 STARTER HOME IN ESTABLISHED SOUTHMORE PLAZA, FRESH INTERIOR/EXTERIOR PAINT, SPACIOUS PRIMARY BEDROOM, 2 CAR CARPORT, 15X8 COVERED PATIO, NEVER FLOODED','0.1584','6','','','','','Sellers Disclosure','','','','Pasadena','Central Gas','0','LT 82 BLK 10 SOUTHMORE PLAZA SEC 6','Subdivision Lot','6900','Appraisal District','','','0','','0','','0','','','','','Composition','41 - Pasadena','WILLIAMS ELEMENTARY SCHOOL (PASADENA)','PASADENA HIGH SCHOOL','QUEENS INTERMEDIATE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Southmore Plaza Sec 06','3051','2.6514','Public Sewer,Public Water','1954','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','213716841','1665839817','213716841','2022-10-15T07:02:51.823','15357071','Edward McClintick','Joseph Walter Realty, LLC','','','29.711754','-95.650646','23','77082','4','219999.00','Active','Barnwell','4114','Drive','Houston','2','0','3','1471','Single-Family','DONT MISS THIS ONE!!!!!! \r\nThis Houston one-story home offers 3 beds, 2 baths, 1,471 SqFt, a large patio, and a spacious garage. Tile flooring along the house, ceiling fans, and sizable closets. A great home and neighborhood to make new memories. Showings have started so don\'t miss your chance to BranchOut to Houston Texas!','0.1354','37','','','','','Sellers Disclosure','','','1','Mission Bend Area','Central Gas','1','LT 32 BLK 3 WEST BEND SEC 1','Other','5900','Appraisal District','','646','0','','1','','0','','','','','Composition','2 - Alief','HOLMQUIST ELEMENTARY SCHOOL','AISD DRAW','ALBRIGHT MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','West Bend Sec 01','3534','2.405','Public Sewer,Public Water','1982','Appraisal District'); --> New record created successfully