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-08T06:55:42.620' ,`MLSNumber` = '60777034' ,`ListAgentFullName` = 'Bao Ly' ,`ListOfficeName` = 'Camelot Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.685906' ,`Longitude` = '-95.484997' ,`PhotoCount` = '8' ,`PostalCode` = '77096' ,`RoomCount` = '5' ,`ListPrice` = '309000.00' ,`Status` = 'Active' ,`StreetName` = 'Indigo' ,`StreetNumber` = '5511' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1415' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home being sold AS-IS, WHERE-IS. Wonderful opportunity to customize to your specifications! Or to be renovated by seller/builder\'s specifications for $369,000. Zoned to Bellaire High School and has NEVER been flooded. Located near Gail Reeves Park, Braes Bayou Trails, HEB, and Meyerland Plaza. Please call for more information!' ,`Acres` = '0.1649' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Meyerland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 3 NORWOOD MEADOWS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7183' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HEROD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'FONDREN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Norwood Meadows' ,`TaxAmount` = '5773' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238146' WHERE `Matrix_Unique_ID` = '206600303' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T06:53:54.437' ,`MLSNumber` = '91005950' ,`ListAgentFullName` = 'Bao Ly' ,`ListOfficeName` = 'Camelot Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.683850' ,`Longitude` = '-95.485381' ,`PhotoCount` = '8' ,`PostalCode` = '77096' ,`RoomCount` = '5' ,`ListPrice` = '309000.00' ,`Status` = 'Active' ,`StreetName` = 'Jason' ,`StreetNumber` = '5518' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1650' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home being sold AS-IS, WHERE-IS. Wonderful opportunity to customize to your specifications! Or to be renovated by seller/builder\'s specifications for $369,000. Zoned to Bellaire High School and has NEVER been flooded. Located near Gail Reeves Park, Braes Bayou Trails, HEB, and Meyerland Plaza. Please call for more information!' ,`Acres` = '0.1638' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Meyerland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK 5 NORWOOD MEADOWS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7137' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HEROD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'FONDREN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Norwood Meadows' ,`TaxAmount` = '5980' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238146' WHERE `Matrix_Unique_ID` = '206600671' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T07:02:56.593' ,`MLSNumber` = '55434034' ,`ListAgentFullName` = 'Ali Nikzad' ,`ListOfficeName` = 'Kolbeh Realty & Custom Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.727213' ,`Longitude` = '-95.412427' ,`PhotoCount` = '38' ,`PostalCode` = '77098' ,`RoomCount` = '10' ,`ListPrice` = '1899000.00' ,`Status` = 'Active' ,`StreetName` = 'Bartlett' ,`StreetNumber` = '2248' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '5483' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning & inviting home in prime Houston location: near Rice Village, Rice University, Medical Center and Downtown. Beautiful home with an open floor-plan 11\' (1st floor) & 10\' (2nd floor) hight ceilings, large windows, and plenty of natural light. Gorgeous engineering wood floors throughout the house, sliding doors that open to a covered patio and lush backyard with an outdoor grill, perfect for gatherings and entertaining. Open kitchen designed to maximize cabinet space, has a huge island with breathtaking quartz countertop, and is finished with stainless steel Thermador appliances. Home is also elevator capable and includes a sophisticated study/home office. Bar, snack with wine&beverage cooler for both floor, spacious game room. Bright bedrooms lead to plentiful closet space, and a spectacular, bright master suite includes a tasteful, modern master bath. Central vacuum and sprinkler system included. Other details available upon request.' ,`Acres` = '0.1263' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rice/Museum District' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 4A CHEVY CHASE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'POE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial,Contemporary/Modern' ,`Subdivision` = 'Chevy Chase Resub Rep' ,`TaxAmount` = '39090' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238147' WHERE `Matrix_Unique_ID` = '208432397' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T07:42:26.160' ,`MLSNumber` = '62063080' ,`ListAgentFullName` = 'Steve Owen' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.881337' ,`Longitude` = '-95.714118' ,`PhotoCount` = '35' ,`PostalCode` = '77433' ,`RoomCount` = '8' ,`ListPrice` = '224900.00' ,`Status` = 'Active' ,`StreetName` = 'Mountain Dale' ,`StreetNumber` = '19939' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1296' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 3 bedroom, 2 bath Cypress home warmly welcomes you. The inviting living with a beamed vaulted ceiling and brick fireplace is the heartbeat of this house and is open to the dining room. A great floor plan for hosting guests. The bright eat-in kitchen offers built-in appliances, a tiled backsplash, and plenty of storage space. Cozy primary bedroom with en-suite bath. Texas-Sized private backyard with shady mature trees and a charming patio provides additional outdoor living and entertaining space. Recently replaced roof. Don\'t miss out on this rare gem. 3D tour available online!' ,`Acres` = '0.0964' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TR 124 BLK 2 LANCASTER SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '312' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'DURYEA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'HOPPER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lancaster' ,`TaxAmount` = '4349' ,`TaxRate` = '3.041' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238147' WHERE `Matrix_Unique_ID` = '208565192' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T07:51:37.427' ,`MLSNumber` = '36109827' ,`ListAgentFullName` = 'Lisa Carnes' ,`ListOfficeName` = 'Carnes Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.797969' ,`Longitude` = '-95.387746' ,`PhotoCount` = '48' ,`PostalCode` = '77008' ,`RoomCount` = '3' ,`ListPrice` = '573500.00' ,`Status` = 'Active' ,`StreetName` = 'Studewood' ,`StreetNumber` = '1426' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1238' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A lovely Craftsman home in the heart of Norhill is inviting from the moment you walk in, with easy access to everything the Heights has to offer. This Meticulously cared-for home has 2 bedrooms, one bath and a 3rd room that could be a study or easily made into a 2nd bathroom in the main house, Plus a large bonus room/bedroom and bathroom on top of the oversized 2 car garage for a perfect guest ensuite or Gameroom, or Airbnb with extra storage spaces throughout both the home and garage. An electronic gate to enter the oversized driveway makes it easy to enter from the street, with extra parking for the entire family. \r\nThe updates are abundant in the kitchen which includes custom cabinets, x-beverage/wine fridge, an island with a gas cooktop. \r\nOutside amenities abound, with a spacious back deck, and a fully fenced backyard with room to play, expand, and garden. This Unique home offers so many extra\'s inside and out. Sellers are motivated, come check it out!' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 BLK 112 NORTH NORHILL' ,`LotDesciption` = 'Cleared,Other' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'FIELD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Call Occupant,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'North Norhill Add' ,`TaxAmount` = '8496' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238147' WHERE `Matrix_Unique_ID` = '209879116' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T06:20:50.760' ,`MLSNumber` = '50807843' ,`ListAgentFullName` = 'Jeanette Solis' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.201622' ,`Longitude` = '-95.513527' ,`PhotoCount` = '31' ,`PostalCode` = '77381' ,`RoomCount` = '10' ,`ListPrice` = '549900.00' ,`Status` = 'Active' ,`StreetName` = 'Deerfern' ,`StreetNumber` = '39' ,`StreetSuffix` = 'Place' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2857' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely, well maintained home with pool in pleasant cul de sac, within walking distance to elementary school and park, in the heart of beautiful Cochran’s Crossing, is perfect for a young family since all the bedrooms are upstairs. The home features a covered front porch for watching the kids play. Upon entry, one faces a beautiful staircase and high ceilings. The lofty office showcases detailed wood work and French doors which open to the formal living room. The family room and large open-concept kitchen are excellent for gatherings with family and friends. This Lifeforms home features lots of wonderful natural light with excellent views of the lush backyard and pool. In essence, the lovely, tranquil backyard becomes an extension of the living space. Centrally located to all local attractions and family activities' ,`Acres` = '0.1724' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL COCHRANS CR 23, BLOCK 2, LOT 25' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7508' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'POWELL ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Cochrans Cr 23' ,`TaxAmount` = '7329' ,`TaxRate` = '2.0869' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238147' WHERE `Matrix_Unique_ID` = '210199418' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T07:52:19.657' ,`MLSNumber` = '45511336' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.287953' ,`Longitude` = '-95.556363' ,`PhotoCount` = '8' ,`PostalCode` = '77316' ,`RoomCount` = '8' ,`ListPrice` = '400000.00' ,`Status` = 'Active' ,`StreetName` = 'Sky Top' ,`StreetNumber` = '313' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2111' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Homes Brookstone Collection, \'\'Sandstone\'\' Plan, Elevation \"B\" in beautiful Woodforest! Wonderful 1 Story 3 bedroom, 2.5 bath, 2 car garage, with STUDY. This versatile home features a Lovely Kitchen with Designer Cabinets, Sparkling Countertops & a Great Appliance Package! Owner\'s Suite has a Luxurious Master Bath! Energy Efficient w/16 SEER HVAC; Covered Patio, Fully Sodded Yards & MORE!' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0081 BLK 002 LOT 008' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest' ,`TaxAmount` = '' ,`TaxRate` = '2.93' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665238147' WHERE `Matrix_Unique_ID` = '210684497' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T07:28:30.370' ,`MLSNumber` = '44270485' ,`ListAgentFullName` = 'Roston Veal' ,`ListOfficeName` = 'Legacy Homes & Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.136849' ,`Longitude` = '-95.380684' ,`PhotoCount` = '39' ,`PostalCode` = '77386' ,`RoomCount` = '13' ,`ListPrice` = '387500.00' ,`Status` = 'Active' ,`StreetName` = 'Pinewood Bend' ,`StreetNumber` = '3717' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2492' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this gem in the highly sought after Imperial Oaks subdivision in Spring, Texas! This beautiful two-story has it all! It all starts from the grand entry in the foyer, to the dining room, kitchen with a pantry and adjoining breakfast nook, family room, and functional walk-in utility room. The first floor owner\'s bedroom features an en suite bathroom with dual sinks, stand-up shower along with a soaker tub and a generous walk-in closet. The second floor features a spacious game room, three additional secondary bedrooms, and a full bathroom,.' ,`Acres` = '0.141' ,`Area` = '15' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S504221 - FALLS AT IMPERIAL OAKS 21, BLOCK 1, LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6141' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BRADLEY ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Falls At Imperial Oaks 21' ,`TaxAmount` = '9360' ,`TaxRate` = '3.1987' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238147' WHERE `Matrix_Unique_ID` = '210950985' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T07:12:51.460' ,`MLSNumber` = '41483151' ,`ListAgentFullName` = 'Damon Welborn' ,`ListOfficeName` = 'Threshold Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.733405' ,`Longitude` = '-95.621556' ,`PhotoCount` = '25' ,`PostalCode` = '77082' ,`RoomCount` = '6' ,`ListPrice` = '369990.00' ,`Status` = 'Active' ,`StreetName` = 'Kimbleton' ,`StreetNumber` = '2611' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1954' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The showstopper of showstoppers, meticulously updated to the nines in every nook & cranny, thanks to its Professional Designer Owner. If you have refined taste & appreciate the finer things, this is your home, all ready to go with over $150K in custom upgrades from its commercial Italian gas range to its dramatic European firebox with marble mantle. Custom doors, hardware, shutters, & loads of details everywhere you turn! Get organized thanks to custom cabinetry from the kitchen, to primary closet, to utility room to garage. The home is a beautiful blend of the old world & new, with modern touches like subway tile showers, commercial grade gray tile floors, & epoxy garage floor. Designer details are a \'given\' throughout, like all baseboards & casings that were replaced, dimmers, recessed lighting, & built-in stereo speakers. All with pool & stunning designer landscaping with lighting & sprinkler nestled in quiet cul-de-sac in a gated community with easy access to Beltway/Westpark!' ,`Acres` = '0.1796' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 1 GREENLEAF' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7822' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'HEFLIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'O\'DONNELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Greenleaf' ,`TaxAmount` = '6011' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238148' WHERE `Matrix_Unique_ID` = '211333455' --> 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','211449365','1665238148','211449365','2022-10-08T07:52:26.473','17347018','Bobbie Callahan Spain','Keller Williams RealtyNortheast','','','29.992877','-95.188585','21','77346','8','245000.00','Active','Flax Bourton','5718','Street','Humble','2','0','4','2078','Single-Family','Charming and remodeled 1.5 story, 4 bed/2 bath home! Home includes 2 living spaces; w/ downstairs family room, featuring high ceilings and wood burning fireplace, and a bonus upstairs game room! All bedrooms downstairs! Primary bedroom, w/ private bath, separate from the additional 3 bedrooms. Secondary bath features dual sink vanity! Home includes both formal dining and breakfast nook off kitchen. Updated granite countertops in kitchen and both bathrooms. Wood-look luxury vinyl downstairs and brand new carpet on the stairs and upstairs game room! All new interior paint in 2022! Enjoy a covered back patio area surrounded by privacy fencing. A/C compressor and heater replaced 2021. Close to schools and shopping with easy access to Hwy 59.','0.1515','1','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Wood Burning Fireplace','1','Atascocita South','Central Electric','1','LT 67 BLK 12 ATASCOCITA TRAILS SEC 1','Subdivision Lot','6600','Appraisal District','','400','0','','2','Electric Oven,Freestanding Oven,Single Oven','0','','','Electric Range,Freestanding Range','','Composition','29 - Humble','OAK FOREST ELEMENTARY SCHOOL (HUMBLE)','ATASCOCITA HIGH SCHOOL','TIMBERWOOD MIDDLE SCHOOL','Supra Keybox,Vacant/Unoccupied','Appraisal District','1.5','Traditional','Atascocita Trails Sec 01','4650','2.492','Water District','1979','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T06:11:36.297' ,`MLSNumber` = '53732677' ,`ListAgentFullName` = 'Jessica Turk' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.560580' ,`Longitude` = '-95.677551' ,`PhotoCount` = '37' ,`PostalCode` = '77479' ,`RoomCount` = '4' ,`ListPrice` = '510000.00' ,`Status` = 'Active' ,`StreetName` = 'Guinevere' ,`StreetNumber` = '7502' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3663' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 7502 Guinevere Drive! This stunning home sits on a 11,165 sq/ft lot on the Greatwood Golf Course and offers a spacious 3,663 sq/ft of living space with 4 bedrooms, 3 and a half bathrooms, sits on a quiet street with beautiful landscaping, brick exterior, and all zoned to Lamar Consolidated ISD! You\'ll love all the incredible features this home has to offer, including a primary suite, double closets, high ceilings, welcoming den, spacious living room, upstairs game room overlooking backyard and golf course, wood cabinets, butler\'s pantry, kitchen island, fully fenced backyard, back patio, and so much more! This home has had no other owners, two attached garages with 3 large windows, and a balcony overlooking the front yard! Greatwood Manor is minutes from 69 and Grand Parkway 99 - in an excellent location! Schedule your private showing today!' ,`Acres` = '0.2563' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GREATWOOD MANOR SEC 1, BLOCK 2, LOT 14' ,`LotDesciption` = 'In Golf Course Community,On Golf Course,Subdivision Lot' ,`LotSize` = '11165' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'DICKINSON ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Greatwood Manor' ,`TaxAmount` = '9948' ,`TaxRate` = '2.3013' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238148' WHERE `Matrix_Unique_ID` = '211680545' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T07:54:04.847' ,`MLSNumber` = '97290908' ,`ListAgentFullName` = 'Kristina Smitha' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.801360' ,`Longitude` = '-95.065338' ,`PhotoCount` = '44' ,`PostalCode` = '77351' ,`RoomCount` = '6' ,`ListPrice` = '221900.00' ,`Status` = 'Active' ,`StreetName` = 'Iris' ,`StreetNumber` = '230' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1606' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOVE IN READY!!!!! Welcome to The Meadows located in Cedar Point Subdivision. 24 hour manned gate. Two story, 3/2-1/2. The first floor opens living room, dining and kitchen. 1/2 bath located on first floor for guests. Second floor offers additional family-game room, Second floor offers three bedrooms. Primary Bedroom with walk-in closet and private bathroom. Two bedrooms with walk in closets and a full bath. Many upgrades recently new - Security lighting, front door security camera, new sink and mirror in half bath, vinyl flooring, kitchen counter tops and backsplash, microwave over the stove, remote controlled ceiling fans in bedrooms, lighting fixtures, enjoy \"working out\" to your favorite music in the 19x19 insulated garage Enjoy the back yard. Sit under the big shade tree and sip your morning coffee. Showing Smart for appointments.' ,`Acres` = '0.1527' ,`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` = 'THE MEADOWS SECTION 1 BLK 39 LOT 22' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6650' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '578' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`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' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Meadows' ,`TaxAmount` = '3016' ,`TaxRate` = '1.7215' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238148' WHERE `Matrix_Unique_ID` = '211760741' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T07:56:40.970' ,`MLSNumber` = '63288422' ,`ListAgentFullName` = 'Elisa Gonzalez' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.884706' ,`Longitude` = '-95.632671' ,`PhotoCount` = '35' ,`PostalCode` = '77095' ,`RoomCount` = '12' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'El Miranda' ,`StreetNumber` = '14918' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2274' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don’t miss this beautiful 2 story home in the desirable neighborhood of Hearthstone. This property features a fresh and bright interior, crown molding, gas log fireplace, plantation shutters, and built-ins. Make yourself at home in the spacious primary bedroom with en-suite bath with large closet, his and her vanities, whirlpool tub, and separate shower. Walking distance to Hearthstone Country Club complete with championship golf course. Community amenities include swimming pool, park, and walking trails. Great location with easy access to SH 290 and Highway 6. Schools are zoned to Cypress-Fairbanks ISD.' ,`Acres` = '0.1928' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 13 HEARTHSTONE SEC 1' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '560' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'OWENS ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'LABAY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hearthstone Sec 01' ,`TaxAmount` = '5718' ,`TaxRate` = '2.501' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238148' WHERE `Matrix_Unique_ID` = '211966507' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T07:25:12.033' ,`MLSNumber` = '59158108' ,`ListAgentFullName` = 'Kelly Kelley' ,`ListOfficeName` = 'RE/MAX Leading Edge' ,`SellingAgentFullName` = 'Brittany Cassin' ,`SellingOfficeName` = 'Compass RE Texas, LLC' ,`Latitude` = '29.219974' ,`Longitude` = '-94.936790' ,`PhotoCount` = '50' ,`PostalCode` = '77554' ,`RoomCount` = '8' ,`ListPrice` = '1625000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Moyenne' ,`StreetNumber` = '13419' ,`StreetSuffix` = 'Place' ,`City` = 'Galveston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2834' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Sprawling waterfront home has been expertly crafted for the avid entertainer whether you want to sip cocktails poolside, take in a stunning sunset from your gazebo or take the boat out for a day on the water. Impressive open floor plan includes a sprawling living area, separate dining, gourmet kitchen, office/den & 4 large bedrooms with 4 full bathrooms. Lower level houses the entertainment hub with plenty of room for gathering with friends & family poolside, sidle up to the built-in bar, relax by the fire pit or dine outdoors on warm summer nights. Up above a jetty takes you past the glistening pool & down to your gazebo. Perfect place to relax with a glass of wine at the end of a long day out on the boat. A boat lift is housed below along with a charming deck where you can sit with your morning coffee & watch the canal come to life as the boaters take just minutes to get to West Bay. Freshly painted interior. This must see home conveys furnished.' ,`Acres` = '0.3868' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 44 LOT 5 BLK 6 PIRATES COVE SEC 6 REPLAT' ,`LotDesciption` = 'In Golf Course Community,Water View,Waterfront' ,`LotSize` = '16850' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '765' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Laffites Cove' ,`TaxAmount` = '' ,`TaxRate` = '2.03' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238148' WHERE `Matrix_Unique_ID` = '212093495' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T07:22:50.167' ,`MLSNumber` = '40204274' ,`ListAgentFullName` = 'Amy Greene' ,`ListOfficeName` = 'New Leaf Real Estate' ,`SellingAgentFullName` = 'Christopher Lewis' ,`SellingOfficeName` = 'Chris Lewis Realty' ,`Latitude` = '29.503177' ,`Longitude` = '-95.399048' ,`PhotoCount` = '34' ,`PostalCode` = '77578' ,`RoomCount` = '10' ,`ListPrice` = '349000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Palomar' ,`StreetNumber` = '4' ,`StreetSuffix` = '' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3174' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Unique opportunity in the fabulous Rodeo Palms subdivision on a great block. 5 bedrooms, 3 and one half bath with a Primary suite down, large game room up and open concept island kitchen and Den/Family room. All four secondary bedrooms are located upstairs. Large, green fenced backyard with covered patio. Minutes to Med Center and Downtown Houston! Seller has never occupied property. Sellers Disclosure to come.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PALM COURT SEC1 A0459&A0299 MANVEL)BLK 4 LOT 40 Rodeo Palms' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6399' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'DON JETER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Rodeo Palms' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238149' WHERE `Matrix_Unique_ID` = '212120071' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T07:58:00.247' ,`MLSNumber` = '63569781' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Newmark Homes' ,`SellingAgentFullName` = 'Steven Totten' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.948033' ,`Longitude` = '-95.781773' ,`PhotoCount` = '27' ,`PostalCode` = '77433' ,`RoomCount` = '13' ,`ListPrice` = '995592.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Blue Wood Aster' ,`StreetNumber` = '21323' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4511' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is THE VERSAILLES (aka with the COURTYARD.) Bridgeland\'s most popular new home plan. This FULL STUCCO 70\' floor plan offers everything you expect in a master planned community! 5 beds (2 down), 5.5 baths, living, formal dining, mud room, loft, game room, media room, and 3 car garage. This is the one you\'ve seen online, modern, sleek, and elegant. Come see this LUXURY ENTERTAINER ASAP...' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Newmark Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '32/01/06' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9640' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1197' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.637885' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665238149' WHERE `Matrix_Unique_ID` = '212275037' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T07:48:47.840' ,`MLSNumber` = '90485726' ,`ListAgentFullName` = 'Steven Franco' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.866274' ,`Longitude` = '-95.700622' ,`PhotoCount` = '38' ,`PostalCode` = '77449' ,`RoomCount` = '12' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Old Glory' ,`StreetNumber` = '6310' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2552' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful two-story home with a pool. It features formal dining, living room with a cozy fireplace. Kitchen has Quartz countertops, New stainless steel appliances. New Luxury Vinyl plank flooring and carpet throughout. Elegant staircase and high ceiling foyer. Game room upstairs. Large primary bedroom, primary bathroom with double sinks, separate tub and custom shower with frameless glass, and walking closet. Spacious bedrooms. Large sparkling blue water swimming pool ideal to entertain your family during the hot summer days with new plaster, waterline tile and pump. Come and enjoy relaxing evenings in the hot spa. Large back yard with plenty of space for pool parties and BBQ\'s. Good established neighborhood. Great location, Katy ISD schools, and easy access to major roads and freeways. Call today for a private showing!! See attached seller upgrade sheet.' ,`Acres` = '0.172' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 1 BEAR CREEK PLANTATON SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7491' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '460' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'JOWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bear Creek Plantaton Sec 03' ,`TaxAmount` = '5512' ,`TaxRate` = '2.671' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238149' WHERE `Matrix_Unique_ID` = '212314974' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T07:53:29.310' ,`MLSNumber` = '18979885' ,`ListAgentFullName` = 'Patricia Justice' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.065744' ,`Longitude` = '-95.843360' ,`PhotoCount` = '30' ,`PostalCode` = '77447' ,`RoomCount` = '22' ,`ListPrice` = '1350000.00' ,`Status` = 'Active' ,`StreetName` = 'FM 2920' ,`StreetNumber` = '21745' ,`StreetSuffix` = 'Road' ,`City` = 'Hockley' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '5045' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Majestic Mediterranean! Notice the detail at first sight in the wrought iron work. Downstairs has 2 primary bedrooms and 4 baths downstairs. Huge family room/chef’s kitchen/breakfast. Elevator shaft and a library with floor-to-ceiling shelving and ladder. Upstairs You will find a full bath, sitting room and game room upstairs Back balcony covers porch and outdoor are two more bedrooms. Large 3 car garage is a motorist’s delight. See more details in the Important Information!!! \r\nCurrently has septic and well. Will be residential for tax purposes, per Tennessee Township. Future high-end subdivisions, will likely surround the property. Total construction period will be ongoing for a few years, as there are three sections. Public water and sewer, will probably be available within one year. There is no current HOA, however, there might be an HOA in future. There will be ongoing public improvements The house is situated about two-tenths of a mile off FM 2920. Do your DUE DILIGENCE.' ,`Acres` = '1.345' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'NA' ,`LotDesciption` = 'Wooded' ,`LotSize` = '58598' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range,Grill' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'EVELYN TURLINGTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,No Photos/No Videos,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'NA' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238149' WHERE `Matrix_Unique_ID` = '212495735' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T07:13:58.027' ,`MLSNumber` = '55002855' ,`ListAgentFullName` = 'Kathy Baize' ,`ListOfficeName` = 'Keller Williams Heritage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.696895' ,`Longitude` = '-95.171760' ,`PhotoCount` = '50' ,`PostalCode` = '77331' ,`RoomCount` = '12' ,`ListPrice` = '549999.00' ,`Status` = 'Active' ,`StreetName` = 'Clearview' ,`StreetNumber` = '10' ,`StreetSuffix` = 'Drive' ,`City` = 'Coldspring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2816' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Lake Livingston view! Unique 3br/2.5 bath water view lake home sits on 0.63 acres fenced corner lot with mature shade trees and lush green yard. In 2016, 1808 sq ft was added to the home for a total of 2808 sq ft. In 2019 the original side of the home was remodeled. Located in the quiet community of Holiday Shores III. Access to boat ramp via subdivision gated area. You can cast your line in the pond located directly behind the property. The views are wonderful that surround this tranquil property. Inside, the open floor plan is warm & inviting with lots of natural light, 9ft ceilings, electric fireplace (multiple flame colors) w/natural wood mantle, surround sound (3 zones includes front & back porches), wide plank pine floors throughout and tile in the wet areas. Kitchen features plenty of storage & counter space, soft close drawers & cabinets. The views are generous through any window. Step outside to the porch and take it all in. Come tour this magical lake property!' ,`Acres` = '0.6372' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric,Other Heating' ,`HOAMandatory` = '1' ,`Legal` = 'HOLIDAY SHORES SUB 3, BLOCK 36 & 35, LOT 264, SECT 3, 265, S' ,`LotDesciption` = 'Cleared,Corner,Greenbelt,Subdivision Lot,Water View' ,`LotSize` = '27756' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Split Level,Traditional' ,`Subdivision` = 'Holiday Shores Sub 3' ,`TaxAmount` = '4015' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1665238149' WHERE `Matrix_Unique_ID` = '212660805' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T07:49:05.453' ,`MLSNumber` = '25813213' ,`ListAgentFullName` = 'Ileana Riojas' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = 'Andre Tolbert' ,`SellingOfficeName` = 'Coldwell Banker Realty' ,`Latitude` = '29.025444' ,`Longitude` = '-95.431212' ,`PhotoCount` = '18' ,`PostalCode` = '77566' ,`RoomCount` = '3' ,`ListPrice` = '189000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Redwood' ,`StreetNumber` = '217' ,`StreetSuffix` = 'Street' ,`City` = 'Lake Jackson' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1361' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A lovely home with a bright, open floor plan. The inviting living room is a great place to relax and unwind after a long day. The kitchen is built for function and flexibility with stainless steel appliances and plenty of natural light.\r\n The master bedroom is enveloped in warm light with plenty of closet space. The bathroom is light and airy. Additional rooms includes a home office perfect for working from home. The fully fenced backyard is a beautiful oasis with mature trees, the perfect place to relax and enjoy the outdoors, away from the hustle and bustle of everyday life. Come and take a look today!' ,`Acres` = '0.1667' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Jackson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'BRAZOS OAKS (LAKE JACKSON), BLOCK 6, LOT 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7261' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'ROBERTS ELEMENTARY SCHOOL (BRAZOSPORT)' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE JACKSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Brazos Oaks Lake Jackson' ,`TaxAmount` = '3567' ,`TaxRate` = '2.3371' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1954' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238149' WHERE `Matrix_Unique_ID` = '212691660' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T07:50:07.870' ,`MLSNumber` = '32179807' ,`ListAgentFullName` = 'Yelena Grinina' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = 'Yelena Grinina' ,`SellingOfficeName` = 'Keller Williams Metropolitan' ,`Latitude` = '29.766424' ,`Longitude` = '-95.480206' ,`PhotoCount` = '43' ,`PostalCode` = '77057' ,`RoomCount` = '16' ,`ListPrice` = '3300000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Bayou Glen' ,`StreetNumber` = '5804' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '7' ,`BathsHalf` = '2' ,`BedsTotal` = '6' ,`SqFtTotal` = '8788' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Impressive masterpiece by Stacey Fine Homes nestled in a beautiful & quiet part of Tanglewood. Family room with Wall of Windows and door that leads to patio; Chef\'s kitchen with full Thermador appliance package and island opens to a large living area viewing heated, salt water pool, spa, and water feature. Australian cypress flooring throughout. Central wet bar, butler’s pantry, wine room & formal dining room are designed for family gathering and entertaining. Guest bedroom, study, home office, air conditioned outdoor kitchen w/fireplace all on the first floor. Game room has powder room + wet bar, media room, and primary bedroom + 4 bedrooms up. Primary suite Includes separate coffee bar with microwave, ice maker & fridge, fireplace, two huge closets, oversized Bain Ultra Air Tub & Walk-in Shower. Fully air-conditioned sunroom features beamed ceiling, fireplace, and pool bath; air conditioned 3 car oversized garage has gated motor court. Elevator' ,`Acres` = '' ,`Area` = '22' ,`BuilderName` = 'Stacey Fine Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Tanglewood Area' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'TR 6 BLK 53 TANGLEWOOD SEC 11' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '14250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Photos/No Videos' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Tanglewood Sec 11' ,`TaxAmount` = '69942' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238150' WHERE `Matrix_Unique_ID` = '212848720' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T07:49:21.007' ,`MLSNumber` = '74606928' ,`ListAgentFullName` = 'Angelica Teachout' ,`ListOfficeName` = 'Boulevard Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.745155' ,`Longitude` = '-95.852550' ,`PhotoCount` = '33' ,`PostalCode` = '77494' ,`RoomCount` = '9' ,`ListPrice` = '529700.00' ,`Status` = 'Active' ,`StreetName` = 'Ember Pass' ,`StreetNumber` = '2730' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3462' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 2-story single family home, located in the highly sought-after Cinco Ranch Northwest subdivision! This home showcases 4 beds/3.5 baths, a study, and game room. Upon entry, you are greeted with a dramatic two-story foyer that flows into a spacious light-filled living room with soaring ceilings up to 20ft high, windows galore, fireplace, and floor plan that opens to the kitchen and dining room. Kitchen features a large island, granite countertops, and walk-in pantry. Primary bedroom retreat boasts a tray ceiling, crown molding, plantation shutters, and an ensuite bath with spa tub & separate standing shower. Large game room overlooks family area and additional flex space! Prime location and conveniently located near shopping, restaurants with easy access to I-10. Perfect house for entertaining equipped with covered patio.' ,`Acres` = '' ,`Area` = '36' ,`BuilderName` = 'Trendmaker Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Cinco Ranch Northwest Sec 12, BLOCK 1, Lot 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6673' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'JENKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Other Style,Traditional' ,`Subdivision` = 'Cinco Ranch Northwest' ,`TaxAmount` = '11354' ,`TaxRate` = '2.75' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238150' WHERE `Matrix_Unique_ID` = '212851590' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T07:25:22.827' ,`MLSNumber` = '63540862' ,`ListAgentFullName` = 'Claudia Cooper' ,`ListOfficeName` = 'City Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.946264' ,`Longitude` = '-95.243797' ,`PhotoCount` = '28' ,`PostalCode` = '77396' ,`RoomCount` = '11' ,`ListPrice` = '332900.00' ,`Status` = 'Active' ,`StreetName` = 'Clanton Pines' ,`StreetNumber` = '9723' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2756' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Simply GORGEOUS!! One of CastleRocks most prettiest Floor-plans located in the gated community of Canyon Gate at Park Lake. Your new 1 1/2 Story home features a GOURMET Kitchen with GRANITE counters, 42” Upper Cabinets, large pantry, tile floors, and stainless undermount sink. The open floor plan is perfect for entertaining as you have a California sweeping stairway that leads up to a HUGE Game-room that comes with a private en-suite. You will love the large primary bedroom suite that comes equipped with a LARGE walk-in closet, two vanities, garden tub with sitting bench and stand up shower. The secondary and third bedrooms are both very nice size. Covered patio with good size backyard! Amenities include community pool, splash pad, basketball courts, playground, and walking trails around the community lake. Conveniently located near Beltway 8, 59, IAH. Theaters, dining, and lots of shopping nearby! Don’t let this one get away! Schedule your private tour TODAY!' ,`Acres` = '0.1458' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Humble Area East' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 32 BLK 7 CANYON GATE AT PARK LAKES SEC 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6351' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'PARK LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'HUMBLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Gate/Pk Lakes Sec 16' ,`TaxAmount` = '7868' ,`TaxRate` = '2.9873' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238150' WHERE `Matrix_Unique_ID` = '212985356' --> 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','212989422','1665238150','212989422','2022-10-08T07:19:18.400','11105746','Kolawole Ayeni','Texas Signature Realty','','','29.810662','-95.713161','34','77084','10','350000.00','Active','Oakwood Falls','19602','Trail','Houston','2','1','4','2458','Single-Family','This freshly painted 4/2/2 home is ready for move in. Open floor plan with lots of upgrades including wood shutters, tile and wood flooring etc. Home comes with crown molding, ceiling fans throughout, extra storage in the attic and pre-wired for surround sound. Oversized lot with access to the Bayou. The backyard is shaded with tall trees and spacious for your family and friends to play and run. Great location in KISD with access to I-10, shops, restaurants and hospitals','0.241','25','','','','','Mud,Sellers Disclosure','1','','1','Katy - North','Central Gas','1','LT 4 BLK 3 CREEK BEND ESTATES SEC 3','Corner,Subdivision Lot','10498','Appraisal District','','643','0','','2','','0','','','','','Composition','30 - Katy','STEPHENS ELEMENTARY SCHOOL (KATY)','MAYDE CREEK HIGH SCHOOL','MAYDE CREEK JUNIOR HIGH SCHOOL','Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Creek Bend Estates Sec 03','5761','2.572','Public Sewer,Public Water','1999','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T07:45:34.903' ,`MLSNumber` = '67402719' ,`ListAgentFullName` = 'Deborah Fontenette' ,`ListOfficeName` = 'Realty Austin, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.051940' ,`Longitude` = '-95.383587' ,`PhotoCount` = '35' ,`PostalCode` = '77373' ,`RoomCount` = '5' ,`ListPrice` = '179999.00' ,`Status` = 'Active' ,`StreetName` = 'Prairie Bird' ,`StreetNumber` = '23415' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '920' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully remodeled inside and out 2 Bedroom 1 bath home with one car attached garage. Designer kitchen and bathroom that you will fall in love with. High ceilings combined with fresh paint, ceiling fans, updated fixtures and lovely covered side patio area will creates an inviting home that leaves you feeling warm and welcomed. Truly have to see this beautiful home for yourself. Roof was replaces in July 2022. Come see this beautiful one story home in the heart of Spring. A great location with easy access to everything Spring has to offer Close to area shopping, dining, schools, 45 and Hardy toll road. Schedule your showing today!' ,`Acres` = '0.1313' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TR 42A BLK 10 CYPRESS TRAILS OF TIMBERLANE 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5720' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'GLORIA MARSHALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Trails Timberlane 01' ,`TaxAmount` = '3304' ,`TaxRate` = '3.0268' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238150' WHERE `Matrix_Unique_ID` = '212993273' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T06:23:30.770' ,`MLSNumber` = '65142987' ,`ListAgentFullName` = 'Jackie Zehl' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.527481' ,`Longitude` = '-95.157212' ,`PhotoCount` = '36' ,`PostalCode` = '77598' ,`RoomCount` = '11' ,`ListPrice` = '255000.00' ,`Status` = 'Active' ,`StreetName` = 'Virginia Colony' ,`StreetNumber` = '2810' ,`StreetSuffix` = 'Drive' ,`City` = 'Webster' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1532' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stylish Updates Abound throughout this Attractive Traditional Style Residence, positioned on a Landscaped Lot within the Established Neighborhood of Heritage Park. Smartly Appointed with Fresh \"Bright White\" Paint, Diagonally Set Light-Taupe Hued Ceramic Tile Floors, Picture Sized Windows, & Sliding Barn Door. Inviting Living Area/Den features a Beamed Cathedral Ceiling & Double French Doors, which Open to the Covered Patio & Spacious Fenced Backyard. Open Concept Kitchen features White Painted Raised Panel Cabinetry, Faux Granite Countertops, G.E. Smooth Surface 4 Burner Range (w/Oven Below), G.E. Built-in Microwave, Frigidaire Dishwasher, SS Sink, & Shelved Pantry. Breakfast Rm/Dining Area offers a Built-in Banquette & a Bank of Windows, which View the Backyard complete w/ a Majestic Tree. Newly Updated Primary & Hall Baths tout a Quartz Topped Vanity, Dual Sinks, & Full Tub/Shower w/ Tile Surround. Split Bedroom Plan. Refrig,Washer, Dryer Remain. Freestanding Backyard Storage Shed.' ,`Acres` = '0.1742' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 10 HERITAGE PARK SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7590' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '202' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'GREENE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'BROOKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Heritage Park' ,`TaxAmount` = '3888' ,`TaxRate` = '2.166' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238150' WHERE `Matrix_Unique_ID` = '213020402' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T07:50:04.983' ,`MLSNumber` = '42335020' ,`ListAgentFullName` = 'Jessica Giraldo' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.986310' ,`Longitude` = '-95.503844' ,`PhotoCount` = '47' ,`PostalCode` = '77069' ,`RoomCount` = '11' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Cashel Forest' ,`StreetNumber` = '14028' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2616' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'STUNNING home In Champion Forest. FULLY Remodeled 4Bed, 2.5Bath. Only property with a private POOL and brand NEW turf installed & NEW Deck. Master down with NEW JACUZZI TUB. NEW Bathrooms, NEW Kitchen with Soft Closing Cabinets, and GORGEOUS White QUARTZ Countertops. NEW SS Whirlpool Appliances (Fridge & mini Fridge INCLUDED), NEW waterproof laminate flooring, NO CARPET! Captivating HIGH CEILING OPEN SPACE, Breakfast room and formal dining. NEW AUTO Garage door opener. NEW Fixtures (Lamps & Fans). Lawn Service Included in the HOA dues. Conveniently located near 245, 45, & Sam Houston Tollway. Shopping and dining at walking distance. NEVER FLOODED!' ,`Acres` = '0.2082' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'HOA First Right of Refusal,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TR 29A BLK 2 CHAMPIONS TERRACE SEC 1 U/R' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9069' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MITTELSTADT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Champions Terrace Sec 01 U/R' ,`TaxAmount` = '4532' ,`TaxRate` = '2.3715' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238151' WHERE `Matrix_Unique_ID` = '213032679' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T07:19:49.647' ,`MLSNumber` = '38375799' ,`ListAgentFullName` = 'Karina Wade-Gledhill' ,`ListOfficeName` = 'Seabrook Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.938800' ,`Longitude` = '-95.687154' ,`PhotoCount` = '28' ,`PostalCode` = '77433' ,`RoomCount` = '4' ,`ListPrice` = '480700.00' ,`Status` = 'Active' ,`StreetName` = 'Bluewater Lagoon' ,`StreetNumber` = '11002' ,`StreetSuffix` = 'Circle' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2205' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful David Weekly home is located in the community of Towne Lake in Cypress, Texas. It is a single story home that is 2,205 sqft. and has a huge fenced in cul-de-sac lot. The lot is 14,436 sqft. and has plenty of room for a pool. There is an outdoor patio, and a sprinkler system that covers all the grounds. This home has a Kepley floor plan with a few modifications. The Kitchen has quartz countertops, with a free standing gas range, stainless steel appliances, and a built in wine bar. It opens up to the dining and living area with great views of the backyard. The refrigerator is included with the sales price. The community amenities are; Fitness center, Waterpark, Puckett Island, Lake, Community Garden, Water Taxi, Veterans Memorial, Parks & Trails, Towne Lake Docs, Lakehouse, Clubhouse, and Boardwalk.' ,`Acres` = '0.3314' ,`Area` = '25' ,`BuilderName` = 'David Weekly' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 3 TOWNE LAKE SEC 46' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '14436' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1699' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'RENNELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'TOWNE LAKE' ,`TaxAmount` = '11798' ,`TaxRate` = '3.471' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238151' WHERE `Matrix_Unique_ID` = '213076412' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T07:13:05.203' ,`MLSNumber` = '85183271' ,`ListAgentFullName` = 'Sarah Conway' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.430316' ,`Longitude` = '-95.639671' ,`PhotoCount` = '50' ,`PostalCode` = '77356' ,`RoomCount` = '4' ,`ListPrice` = '715000.00' ,`Status` = 'Active' ,`StreetName` = 'Blue Hill' ,`StreetNumber` = '134' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3872' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful estate home in the gated Lake Conroe subdivision of Bentwater. Better than NEW w/ loads of upgrades. This elegant 4/5 BR, 3/2 BA home boasts open living areas & soaring ceilings. Gourmet kitchen w/Smart GE Café dual fuel Slide-in gas range w/ convection oven, 36” Custom commercial vent, & gleaming quartz counters. Lrg living area w/ statement fireplace. Custom Bali motorized solar shades (operable via Smartphone). Convenience & functionality of Smart Lutron light, dimmer, & security switches throughout. Escape to the spacious Owner’s Suite w/Spa-like bath. Spacious secondary BRs & 2.5 baths up! Study & formal Dining. Upstairs Media RM, GAME ROOM, generous Study, & home gym!!! Extend entertainment outdoors w/ a fabulous patio & built-in Summer Kitchen w/ Paradise grill & enjoy views of the pool-sized backyard. Come and live like you’re on vacation - w/country club access, THREE 18-hole championship golf courses, yacht & sports club, 24-hr manned gate. See Feature Sheet!' ,`Acres` = '0.1961' ,`Area` = '39' ,`BuilderName` = 'Destin Homes LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BENTWATER 33, BLOCK 1, LOT 19' ,`LotDesciption` = 'Corner,In Golf Course Community,Subdivision Lot,Wooded' ,`LotSize` = '8540' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1146' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`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' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Bentwater' ,`TaxAmount` = '9141' ,`TaxRate` = '2.1142' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238151' WHERE `Matrix_Unique_ID` = '213077476' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T07:23:11.727' ,`MLSNumber` = '8424250' ,`ListAgentFullName` = 'Kelly Kelley' ,`ListOfficeName` = 'RE/MAX Leading Edge' ,`SellingAgentFullName` = 'Kelly Kelley' ,`SellingOfficeName` = 'RE/MAX Leading Edge' ,`Latitude` = '29.215086' ,`Longitude` = '-94.950892' ,`PhotoCount` = '43' ,`PostalCode` = '77554' ,`RoomCount` = '6' ,`ListPrice` = '1300000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Treasure' ,`StreetNumber` = '3434' ,`StreetSuffix` = 'Circle' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1737' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Better than Bayfront, this canal home offers bay views off the West Deck & open water views on the East decks. On the street side, you will love how it is nestled on a cul-de-sac surrounded by lush landscaping. On the waterside you will be overjoyed by the wide water views and over 100 ft of water frontage. Take the stairs or elevator up to the main area of the home. The coastal chic home was designed to be cozy & easy to maintain. Finishes include beadboard walls & cabinets, tile flooring, granite countertops, & custom window treatments. High ceilings and walls of windows and doors brings the outdoors in. No shortage of closet space in this home! With immediate access to the bay & short golf cart ride to the beach, you get the best of both worlds. You will also be able to enjoy the epic Galveston sunrises & sunsets! Conveys fully furnished & with a coveted social membership to the Galveston Country Club.' ,`Acres` = '0.1322' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 39 LOT 107 BLK 1 PIRATES COVE SEC 5' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '5760' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '168' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Pirates Cove' ,`TaxAmount` = '20324' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238151' WHERE `Matrix_Unique_ID` = '213093518' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T07:52:14.353' ,`MLSNumber` = '70381746' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Keller Williams Platinum' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.399627' ,`Longitude` = '-95.096145' ,`PhotoCount` = '50' ,`PostalCode` = '77510' ,`RoomCount` = '10' ,`ListPrice` = '499900.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue Q' ,`StreetNumber` = '2949' ,`StreetSuffix` = '' ,`City` = 'Santa Fe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2086' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy comfort and privacy in this beautiful 5-bedroom, 3.5-bathroom home in Lakner Special, boasting tile flooring, a detached 3-car garage, crown molding, a gas log fireplace, study, open great room, and a workshop in the sprawling green space. Get creative in the island kitchen, fully equipped with granite countertops, an electric cooktop, stainless steel appliances, glass-fronted cabinets, a breakfast bar, and pendant lighting. Central Vacuum System. Seek comfort in the tranquil primary suite, featuring a walk-in closet and a shower. Situated between I-45 and Hwy 6, commuters benefit from quick access to Galveston and other major business centers. Popular dining, shopping, and entertainment can be found minutes away at the La Marque Crossing Shopping Center, Tanger Outlets, and Mainland City Center. Zoned to Santa Fe ISD.' ,`Acres` = '2.79' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 1 PAGE 8 & 9 LOT 2 LAKNER SPECIAL SUB' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '121532' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'ROY J. WOLLAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakner Special Sub' ,`TaxAmount` = '9398' ,`TaxRate` = '2.3536' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238151' WHERE `Matrix_Unique_ID` = '213114235' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T07:30:27.837' ,`MLSNumber` = '53934527' ,`ListAgentFullName` = 'Steven Franco' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.890145' ,`Longitude` = '-95.682123' ,`PhotoCount` = '33' ,`PostalCode` = '77095' ,`RoomCount` = '9' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Lone Meadow' ,`StreetNumber` = '7706' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2357' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A must have NEWLY renovated 1-story, 4 bedroom, 2 bath, in a cul-de-sac, with a POOL with NEW plaster, in Copperfield Westcreek!! Gourmet Island kitchen with New upgraded granite countertops, plenty of cabinets and a window seat in the breakfast nook and Brand New Stainless Steel Microwave and Open, Plus New Down vent cooktop! Large master suite has a sitting area, and opens out to the beautiful covered patio leading to the saltwater pool! Zoned to Exemplary Copeland Elementary in walking distance! Neighborhood has 2 pools & parks, tennis courts and walking trails!' ,`Acres` = '0.2151' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 73 BLK 1 COPPERFIELD WESTCREEK VILLAGE SEC 5' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9368' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '555' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'COPELAND ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'LANGHAM CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'ARAGON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Copperfield Westcreek Village' ,`TaxAmount` = '6537' ,`TaxRate` = '2.471' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238151' WHERE `Matrix_Unique_ID` = '213162480' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T06:44:49.020' ,`MLSNumber` = '75559998' ,`ListAgentFullName` = 'Kevin Hayes' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.934698' ,`Longitude` = '-95.519316' ,`PhotoCount` = '29' ,`PostalCode` = '77086' ,`RoomCount` = '4' ,`ListPrice` = '259900.00' ,`Status` = 'Active' ,`StreetName` = 'Clarks Fork' ,`StreetNumber` = '13807' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1575' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Conveniently located one story sitting in quiet subdivision. This beautiful home features 3 spacious bedrooms and 2 bathrooms, the kitchen is open to the bright living room ad offers the perfect environment for family gatherings. Do not miss the opportunity to call this beauty HOME.' ,`Acres` = '0.1743' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 6 BLUE CREEK SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7594' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MCDOUGLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'KLEIN INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Blue Creek Sec 4' ,`TaxAmount` = '3914' ,`TaxRate` = '2.4615' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238152' WHERE `Matrix_Unique_ID` = '213168761' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T06:50:10.750' ,`MLSNumber` = '86342939' ,`ListAgentFullName` = 'Malisa Walker' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.296393' ,`Longitude` = '-94.799194' ,`PhotoCount` = '30' ,`PostalCode` = '77550' ,`RoomCount` = '4' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue L' ,`StreetNumber` = '2924' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1858' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great home in the heart of Galveston. There is so much to love in this 4 bedroom 2 bath split level home. Enjoy the beauty of Galveston from your porch. Your yard is ready to be turned into an oasis of serenity. Home is SOLD AS IS' ,`Acres` = '0.1244' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR PT OF LOTS 4 & 5 (4-3) BLK 89 GALVES' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5421' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Split Level,Traditional' ,`Subdivision` = 'Galveston Townsite' ,`TaxAmount` = '3332' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238152' WHERE `Matrix_Unique_ID` = '213188481' --> 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','213223998','1665238152','213223998','2022-10-08T07:53:28.920','86356188','James Townsend','My Castle Realty','','','30.003292','-95.746346','50','77433','10','499000.00','Active','Cumberland Oak','15906','Court','Cypress','4','4','4','3287','Single-Family','You don’t want to miss this well-maintained, two story home in the heart of Fairfield! This 4/5 bedroom, 4 full bathroom home is within walking distance to the Fairfield Athletic Center, baseball fields/tennis courts, elementary school, swimming pools and parks. This beautiful home is on a great cul-de-sac lot alongside a green belt with open space for your children to play. It also features an oversized, detached garage with an automatic privacy gate and a GORGEOUS patio space for entertaining. Fresh exterior paint, recently installed LVP flooring downstairs and updated stainless appliances make this immaculate home move-in ready!','0.1983','35','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','1','Gas Connections','1','Cypress North','Central Gas','1','LT 15 BLK 2 FAIRFIELD VILLAGE WEST SEC 3','Cul-De-Sac','8640','Appraisal District','','950','0','','','Electric Oven','0','','','Gas Range','','Composition','13 - Cypress-Fairbanks','KEITH ELEMENTARY SCHOOL','BRIDGELAND HIGH SCHOOL','SALYARDS MIDDLE SCHOOL','Accompany,Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Fairfield Village West Sec 3','9020','2.616','Public Sewer,Public Water','2002','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T07:47:57.923' ,`MLSNumber` = '77275246' ,`ListAgentFullName` = 'Jonathan Patrick' ,`ListOfficeName` = 'Francais Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.892248' ,`Longitude` = '-95.701940' ,`PhotoCount` = '46' ,`PostalCode` = '77433' ,`RoomCount` = '10' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Arapahoe Ridge' ,`StreetNumber` = '8007' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2541' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful cozy home in Cypress zoned in good school.' ,`Acres` = '0.1181' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 3 YAUPON RANCH SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5143' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'JOWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'HOPPER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Yaupon Ranch Sec 5' ,`TaxAmount` = '6828' ,`TaxRate` = '3.041' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238152' WHERE `Matrix_Unique_ID` = '213253758' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T06:37:00.837' ,`MLSNumber` = '8128330' ,`ListAgentFullName` = 'Nancy Ware' ,`ListOfficeName` = 'Coldwell Banker Realty, Cy-Fair Office' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.003319' ,`Longitude` = '-95.791327' ,`PhotoCount` = '33' ,`PostalCode` = '77447' ,`RoomCount` = '7' ,`ListPrice` = '340000.00' ,`Status` = 'Active' ,`StreetName` = 'Casa Linda' ,`StreetNumber` = '31646' ,`StreetSuffix` = 'Drive' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2072' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home ready for immediate move in. Fantastic location, only a few minutes from 99 and Hwy 290. Located on a large corner lot with full sprinklers. Inside you will find fresh, trendy colors and tons of natural light. You will love the open living area with a kitchen that boasts all stainless appliances, gas cooktop, granite countertops and new island pendant lighting. The owner\'s suite bathroom has an oversized shower and spacious closet. There are three additional bedrooms and a home office. Some recent updated include 4\' shutters and blinds, electric garage door opener, recessed lighting, entry and kitchen island lighting, as well as shrubs, crepe myrtles and full yard sprinklers. Convenient to Houston Premium Outlet mall, dining, churches and hospitals.\r\nCall agent today for private showing.' ,`Acres` = '0.1735' ,`Area` = '25' ,`BuilderName` = 'Gehan' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 1 STONE CREEK RANCH SEC 9 R/P' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7556' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Stone Crk Ranch Sec 9 Rep 1' ,`TaxAmount` = '8184' ,`TaxRate` = '3.1924' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238152' WHERE `Matrix_Unique_ID` = '213329238' --> 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','213346486','1665238152','213346486','2022-10-08T07:01:13.527','518080','Miguel Canas','Texas United Realty','','','30.192633','-95.142068','31','77372','5','280000.00','Active','S Tram','17296','','Splendora','2','1','3','2040','Single-Family','Welcome home to this charming 2 story home, three bedroom and 2.5 bath, upstairs the primary bedroom offer his/her vanities and 2 large walk-in closet, all bedroom are equipped with ceiling fan, game room. Downstairs you will find open concept with a large living room, all tile through the entire first floor, beautiful white kitchen cabinets, pantry and refrigerator included, garage door opener, nice patio and a fully fenced backyard.\r\nThis beautiful home is \"Unrestricted\" and a moving ready!!','','40','Magdaleno Gutierrez','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','','Porter/New Caney East','Central Electric','0','S737002 - Muleshoe Lake 02, BLOCK 4, Lot 42-A, ACRES 0.192','Cleared','8366','Survey','','','1','Never Lived In','2','Electric Oven,Single Oven','0','','','Electric Range','','Composition','47 - Splendora','TIMBER LAKES ELEMENTARY SCHOOL','SPLENDORA HIGH SCHOOL','SPLENDORA JUNIOR HIGH','Supra Keybox','Builder','2','Traditional','Muleshoe','','','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T07:37:39.420' ,`MLSNumber` = '18598819' ,`ListAgentFullName` = 'Becky Davis' ,`ListOfficeName` = 'Compass RE Texas, LLCHeights' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.799240' ,`Longitude` = '-95.404522' ,`PhotoCount` = '32' ,`PostalCode` = '77008' ,`RoomCount` = '9' ,`ListPrice` = '950000.00' ,`Status` = 'Active' ,`StreetName` = 'Waverly' ,`StreetNumber` = '1536' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2959' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning Modern Greek Revival is reminiscent of the Garden District in New Orleans. An amazing front yard with pet-friendly turf and impeccable landscaping leads to a porch where you can relax and greet neighbors. The study and formal dining area flank the entryway. A gas-log fireplace anchors the oversized family room, perfect for a night in, or entertaining guests. High-end appliances, a countertop bar, and a butler\'s pantry are all features of the gourmet kitchen. The adjacent breakfast room completes the first floor\'s open-concept living area. The backyard, with a patio and covered porch, is ideal for dining al fresco. On the second level, a sizable primary suite offers a sitting area and access to a private balcony. Two large secondary bedrooms and connecting bathroom complete the upstairs. Amenities include hardwoods, recessed lighting, and crown molding throughout. Updates include new paint, landscaping, kitchen appliances, 2 new AC units, and so much more!' ,`Acres` = '0.101' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 31 BLK 146 HOUSTON HEIGHTS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Houston Heights' ,`TaxAmount` = '18737' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238152' WHERE `Matrix_Unique_ID` = '213372442' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T06:59:19.350' ,`MLSNumber` = '4796232' ,`ListAgentFullName` = 'Thuy Nguyen' ,`ListOfficeName` = 'Aimpro Realty & Management LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.596904' ,`Longitude` = '-95.245598' ,`PhotoCount` = '41' ,`PostalCode` = '77089' ,`RoomCount` = '7' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Glenkirk' ,`StreetNumber` = '10027' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2569' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home is ready to move in and renovated. It has 5 bedrooms , 2 full baths (3 showers) and 1 haft bath. New roof (July 2022), appliances are brand new. New Granite countertops. The home is located within walking distance of Moore Elementary and Dobie High School. Close to Beltway, Gulf Freeway, walking trails and the park.' ,`Acres` = '0.1626' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 2 KIRKMONT SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7085' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'MOORE ELEMENTARY SCHOOL (PASADENA)' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'BEVERLYHILLS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kirkmont Sec 02' ,`TaxAmount` = '6576' ,`TaxRate` = '2.6655' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238153' WHERE `Matrix_Unique_ID` = '213378566' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T07:23:25.780' ,`MLSNumber` = '46956841' ,`ListAgentFullName` = 'Karina Wade-Gledhill' ,`ListOfficeName` = 'Seabrook Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.534529' ,`Longitude` = '-95.042176' ,`PhotoCount` = '27' ,`PostalCode` = '77573' ,`RoomCount` = '8' ,`ListPrice` = '389900.00' ,`Status` = 'Active' ,`StreetName` = 'Hidden Lake' ,`StreetNumber` = '121' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2901' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful 4 bedroom home is located in the subdivision of Harbour Park in League City, Tx. This home is 2,900 sqft. and has a 8295 sqft fenced corner lot. The kitchen has butcher-block counters, center island, ample cabinets, and counterspace. This two story unique split level home has high ceilings, hard wood floors on the main level, and has tonnes of natural light. The split bedroom floorplan offers privacy for the spacious master retreat, which features an en-suite bath with dual vanities, walk-in-shower, soaking bathtub, and a walk-in closet. The three secondary bedrooms share a hall bath. It is walking distance to Ferguson Elementary and the neighborhood pool. Only minutes away from Kemah, Galveston, Nasa, and great food and dining. Schedule your showing today.' ,`Acres` = '0.1904' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 18 M MULDOON SUR LOT 14 BLK 2 HARBOUR PARK SEC 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '8295' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'FERGUSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CLEAR CREEK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harbour Park Sec 2 90' ,`TaxAmount` = '7283' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238153' WHERE `Matrix_Unique_ID` = '213391886' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T07:50:58.180' ,`MLSNumber` = '19898595' ,`ListAgentFullName` = 'Kendall Lanningham' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.872765' ,`Longitude` = '-95.456431' ,`PhotoCount` = '0' ,`PostalCode` = '77088' ,`RoomCount` = '3' ,`ListPrice` = '229000.00' ,`Status` = 'Active' ,`StreetName` = 'Saratoga' ,`StreetNumber` = '3503' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1567' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This cute 3 bedroom, 2 bath home has been painted inside, along with most of the outside. Numerous repairs have been made both inside and outside. Some of the windows have been replaced, along with numerous interior doors, and one exterior door. The large covered back patio, with elevated deck, is perfect for these cooler evenings in the back yard. Fully fenced back yard, with plenty of shade from mature trees. Come take a look and enjoy the peace and quiet this home has to offer.' ,`Acres` = '0.162' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 11 INWOOD PINES SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7056' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '260' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CARAWAY ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'EISENHOWER HIGH SCHOOL' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Inwood Pines Sec 03' ,`TaxAmount` = '3284' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238153' WHERE `Matrix_Unique_ID` = '213399806' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T07:06:14.930' ,`MLSNumber` = '14243338' ,`ListAgentFullName` = 'Bobby Jones' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.661538' ,`Longitude` = '-95.498797' ,`PhotoCount` = '37' ,`PostalCode` = '77096' ,`RoomCount` = '8' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Claridge' ,`StreetNumber` = '6110' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2556' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful house with great curb appeal. Great location and close to Hwy 59, Hwy 90 and Bltw 8. The house has been freshly painted throughout, Recently installed carpet. Recent bathroom counters. Large bedrooms with walk-in closets, spacious den with fireplace, formal dining and formal living. Kitchen has a large walk-in pantry and double ovens. Refrigerator included. Large backyard with recent fence. Large home with lots of space on a private street.' ,`Acres` = '0.1864' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 112 BLK 5 FONDREN SW NORTHBROOK 1 RP EXT' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '495' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HALPIN/TINSLEY' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'FONDREN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fondren Sw Northbrook 01 Rp Ext' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238153' WHERE `Matrix_Unique_ID` = '213434120' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T06:00:43.117' ,`MLSNumber` = '10023742' ,`ListAgentFullName` = 'Alexandra Schubiger' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.246925' ,`Longitude` = '-95.899122' ,`PhotoCount` = '22' ,`PostalCode` = '77484' ,`RoomCount` = '5' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Rolling Hill' ,`StreetNumber` = '17443' ,`StreetSuffix` = 'Lane' ,`City` = 'Waller' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '948' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This newly remodeled home invites for afternoon tea on the front porch. It sits on approx. 1.57 acres, with wooded and cleared areas. The lot is very private, close to the end of the street, unrestricted and allows you to put your own touch. The big living room features vaulted ceilings and a lot of light coming through the three windows. The generously sized kitchen accesses the living room and a mud room, which leads to the outdoors. Appliances are brand new and features a white cast iron farmhouse sink. The home has 3 bedrooms, the spectacular master bedroom has two windows and a sliding door leading to the porch. \nBrand new roof, doors, windows and aircon!\nDon\'t let this opportunity slip to make it your own. Welcome to your country home!' ,`Acres` = '1.57' ,`Area` = '60' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Plantersville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'W MAGNOLIA FRST SEC 18, BLOCK 3, LOT 13,14 ACRES 1.57' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '129 - Navasota' ,`SchoolElementary` = 'HIGH POINT ELEMENTARY SCHOOL (Navasota)' ,`SchoolHigh` = 'NAVASOTA HIGH SCHOOL' ,`SchoolMiddle` = 'NAVASOTA JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'W Magnolia Forest Sec 18' ,`TaxAmount` = '1925' ,`TaxRate` = '1.7749' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238153' WHERE `Matrix_Unique_ID` = '213436911' --> 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','213442786','1665238154','213442786','2022-10-08T07:12:26.253','10770458','Miguel Canas','Texas United Realty','','','30.037547','-95.339105','31','77373','7','305000.00','Active','Fallengate','22210','Court','Spring','2','0','3','1934','Single-Family','Gorgeous single-story home three bedrooms two bath. House located on a cu-de-sac. This home offers granite counter tops, 2 breakfast bar, a formal living room and huge family room with a water sink. Extensive interior upgrades including a recently remodeled kitchen with a new appliances, water faucet, granite top, backsplash, light fixtures, fresh paint, new carpet, all rooms are equipped with ceiling fan, both bath has been updated with tile and granite counters, back cover patio, roof about 4 years old! All room measurement are approximate. This home is moving ready!','0.2295','12','','','','','Sellers Disclosure','','','','Spring East','Central Electric','1','LT 29 BLK 18 GREENGATE PLACE SEC 3','Cul-De-Sac','9996','Appraisal District','','374','0','','2','','0','','','','','Composition','48 - Spring','ANDERSON ELEMENTARY SCHOOL (SPRING)','SPRING HIGH SCHOOL','DUEITT MIDDLE SCHOOL','Supra Keybox','Appraisal District','1','Traditional','Greengate Place Sec 03','4445','2.6867','Public Sewer,Public Water','1976','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','213453229','1665238154','213453229','2022-10-08T06:46:35.707','36827441','Andrew Codia','Ameri Choice Realty, LLC','','','29.812515','-95.798719','15','77493','4','390000.00','Active','Lakecrest Bend','24703','Drive','Katy','2','0','4','2772','Single-Family','Easy access to Hwy 99, I-10, Hwy 99, and Westpark Toll Rd. A few minutes away from the new Katy Asian Town, Katy Mills, Costco, Walmart, and major groceries. Located in award-winning Katy ISD. Build by Perry Home. House features 4 bedrooms, 2 full baths, 2 car garages, high ceilings, split floor plan, breakfast, combo formal dining and living, family room, ceramic tile, french door, and oversized cover patio.\r\nLOW TAXES 2.6083 AND LOW HOA DUE.','0.1205','25','','','','','Sellers Disclosure','','','','Katy - Old Towne','Central Gas','1','LT 2 BLK 4 LAKECREST FOREST SEC 1','Subdivision Lot','5250','Appraisal District','','575','0','','2','','0','','','','','Composition','30 - Katy','KING ELEMENTARY SCHOOL','PAETOW HIGH SCHOOL','HASKETT JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','Lakecrest Forest Sec 01','7042','2.6083','Public Sewer,Public Water','2007','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','213453265','1665238154','213453265','2022-10-08T07:21:18.253','91133364','Craig Zietsman','Sprout Realty','','','30.166879','-95.415685','25','77385','3','185000.00','Active','Beech','1511','Drive','Conroe','2','0','3','1799','Single-Family','This home needs some work and attention and it can be something beautiful. Chateau Woods is a great little neighborhood tucked away in the trees close to all major roads and industries here in The Woodlands. This home is perfect for someone who isn\'t afraid of doing some work or an investment company that can fix it up.','0.2451','15','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Spring Northeast','Central Gas','0','S656007 - LAKE CHATEAU WOODS 07, LOT 9-D','Subdivision Lot','10676','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','11 - Conroe','HOUSER ELEMENTARY SCHOOL','OAK RIDGE HIGH SCHOOL','IRONS JUNIOR HIGH SCHOOL','Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Traditional','Lake Chateau Woods 07','3619','2.1802','Public Sewer,Public Water','1970','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','213453300','1665238154','213453300','2022-10-08T07:12:02.883','72753075','Samantha Adkison','Berkshire Hathaway HomeServicePremier Properties','','','29.684728','-95.898013','0','77441','9','740000.00','Active','Garden Glenn','30422','Court','Fulshear','3','1','4','3322','Single-Family','Impeccable luxury residence in the newly developed community of Fulbrook on Fulshear Creek. This one story home features a three car garage, game/library/ or movie room, designated and designed office space, as well as an expansive outdoor kitchen, living, and entertainment area. The stunning indoor kitchen is open to the family room, breakfast nook, and just right off to the garage and game/movie room creating an open concept with vast 14 foot ceilings. Corner cast stone fireplace, and ceramic tile floor add impeccable finishes to the living space, with kitchen island and walk-in pantry. Secluded primary suite with curved wall windows, garden tub with separated stand alone shower, double vanity, and his & hers closets. Mud room upon garage entry. Pool is heated with fantastic heating system heating on a cold winter day in under a hour! Quiet and welcoming community with star views, & neighborhood amenities including pool and club house, private gym, walking trails, and man-made lakes','0.2388','30','Perry Homes','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','1','Fulshear/South Brookshire/Simonton','Central Gas','1','FULBROOK ON FULSHEAR CREEK SEC 8, BLOCK 1, LOT 20','Cul-De-Sac,Subdivision Lot','10400','Appraisal District','','1200','0','','3','Electric Oven','1','In Ground','','Gas Cooktop','','Composition','33 - Lamar Consolidated','HUGGINS ELEMENTARY SCHOOL','FULSHEAR HIGH SCHOOL','ROBERTS/LEAMAN JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','Fulbrook On Fulshear Creek Sec 8','13940','2.9978','Other Water/Sewer','2018','Appraisal District'); --> New record created successfully