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` = '2023-01-29T21:20:40.290' ,`MLSNumber` = '34207417' ,`ListAgentFullName` = 'Enrique Rangel' ,`ListOfficeName` = 'Berkshire Hathaway HomeServicePremier Properties' ,`SellingAgentFullName` = 'Gina Berlin' ,`SellingOfficeName` = 'RE/MAX Universal Northwest' ,`Latitude` = '30.032026' ,`Longitude` = '-95.450154' ,`PhotoCount` = '49' ,`PostalCode` = '77090' ,`RoomCount` = '6' ,`ListPrice` = '284995.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Maranon' ,`StreetNumber` = '707' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3206' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 2 story 5 bedroom, 3 & 1/2 bath home is MOVE IN READY! NEVER FLOODED & NOT IN A FLOOD ZONE!!! This home offers 5 spacious bedrooms, a large open kitchen with plenty of storage, living & dining rooms, 3 &1/2 bath; This home sits on a hill with a beautiful spacious backyard & gorgeous landscaping! Great for cookouts, entertaining & all the fun in the sun you can handle! Call us for your private showing today! PLEASE VERIFY ALL ROOM DIMENSIONS AS THEY ARE APPROXIMATE ESTIMATES' ,`Acres` = '0.2913' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 69 BLK 3 WESTADOR SEC 6' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '12688' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '590' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'BAMMEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westador Sec 06' ,`TaxAmount` = '6051' ,`TaxRate` = '2.3072' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266083' WHERE `Matrix_Unique_ID` = '209818202' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-29T21:52:40.750' ,`MLSNumber` = '80466669' ,`ListAgentFullName` = 'Marcelo Zubieta' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Martha Olvera' ,`SellingOfficeName` = 'Compass RE Texas, LLC' ,`Latitude` = '30.062177' ,`Longitude` = '-95.428710' ,`PhotoCount` = '37' ,`PostalCode` = '77373' ,`RoomCount` = '6' ,`ListPrice` = '260000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Cypresswood Hill' ,`StreetNumber` = '534' ,`StreetSuffix` = '' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1860' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! Beautiful, spacious, corner lot home in quiet gated community like this one is hard to find in the Houston area. Schedule your showing today, this listing will not last long. Excellent location with quick access to 99 Grand Parkway, I45, Intercontinental airport, Dining, schools, and shopping. Covered patio and large backyard provide plenty of space for activities and relaxation. Includes outdoor shed and built-in outdoor sink. Refrigerator in the house conveys with the sale. HVAC replaced 2019 and tankless water heater installed 2021. Although deemed to be correct, please verify square footage, room sizes, and school information. Community offers nice outdoor pool, beach voleyball court, and walking/running path around the lake.' ,`Acres` = '0.1128' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 3 CYPRESSWOOD LAKE SEC 3' ,`LotDesciption` = 'Corner' ,`LotSize` = '4915' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '733' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'GINGER MCNABB ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'SPRINGWOODS VILLAGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypresswood Lake Sec 03' ,`TaxAmount` = '4888' ,`TaxRate` = '2.4967' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266083' WHERE `Matrix_Unique_ID` = '210658171' --> 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','211332805','1675266084','211332805','2023-01-29T21:28:04.847','47968469','Julie Young','Allison James of Texas, LLC','Yvette McMurray','JLA Realty','30.726220','-95.552054','22','77320','6','219000.00','Option Pending','9th','1211','Street','Huntsville','2','0','3','1687','Single-Family','Great location approx 1 mile from SHSU. Just renovated home adding granite and new appliances in the kitchen, \r\nbathroom updates, interior and exterior paint, deck, and beautifully refinished original hardwood floors. Home features 2 living areas, 3 bedrooms and 2 baths. Awesome backyard with huge pecan tree. Additional room under home great for storage or potential living space.','0.18','43','','','','','Sellers Disclosure','','','','Huntsville Area','Central Gas','0','HUNTSVILLE TOWNSITE, BLOCK 10, LOT 9, ACRES .18','Subdivision Lot','7841','Appraisal District','','','0','','0','','0','','','','','Composition','64 - Huntsville','HUNTSVILLE ELEMENTARY SCHOOL','HUNTSVILLE HIGH SCHOOL','MANCE PARK MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Huntsville Townsite','2128','1.9609','Public Sewer,Public Water','1950','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-29T21:31:17.593' ,`MLSNumber` = '94732495' ,`ListAgentFullName` = 'Sam Mirza' ,`ListOfficeName` = 'NXTSQFT.COM' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.728893' ,`Longitude` = '-95.403140' ,`PhotoCount` = '50' ,`PostalCode` = '77098' ,`RoomCount` = '11' ,`ListPrice` = '1300000.00' ,`Status` = 'Active' ,`StreetName` = 'Milford' ,`StreetNumber` = '1724' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3828' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custom built Texas Hill Country home in the heart of Boulevard Oaks, an exceptional design by one of the best architects, built in 2001, with high end finishes and all custom-built cabinetries, updated kitchen with top-of-the-line appliances, wood floors, concrete countertops, updated powder room, master bathroom and guest bathroom, very unique faucets and hardware, surround system, an outside screened sunroom for your outdoor enjoyment. Other Highlights include enclosed third floor flex space, metal roof, EV charger, smart home lighting/ toilets/ thermostats/sprinkler system/, automatic driveway gate, steam shower, 2nd floor built-in refrigerator, and wired ethernet. New AC installed 2020. Not in a flood zone! Minutes from Downtown, Zoo, Museums and Fine Dining & shopping experience. Walkable to Poe Elementary. Zoned to exemplary Poe Elementary, Lanier Middle School and Lamar High School. NO HOA or any Maintenance Fees. 24/7 patrol on duty. Virtual Tour is now Live' ,`Acres` = '0.1435' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rice/Museum District' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 9 BLK 2 WEST EDGEMONT' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'POE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'West Edgemont' ,`TaxAmount` = '25917' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266084' WHERE `Matrix_Unique_ID` = '212276690' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-29T22:39:41.927' ,`MLSNumber` = '85581220' ,`ListAgentFullName` = 'Christina DeLaTorre' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.886101' ,`Longitude` = '-95.703649' ,`PhotoCount` = '22' ,`PostalCode` = '77433' ,`RoomCount` = '9' ,`ListPrice` = '294900.00' ,`Status` = 'Active' ,`StreetName` = 'Narcissus Brook' ,`StreetNumber` = '19502' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2381' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NICELY UPDATED AND READY FOR MOVE IN!This 4 Bedroom Home in the family-friendly community of Yaupon Place is Located on a cul-de-sac street. Features a spacious living Room, open kitchen, dining area and breakfast area. With the versatile separate space, you’d be able to use the breakfast room for multiple purposes, such as a home office. One bedroom is located downstairs, which would be perfect for a mother in law quarters. Primary, 2 bedrooms and gameroom are located upstairs. AC was serviced Dec. 2022. NEW Furnace and NEW evaporator coil. Conveniently located near retail stores, restaurant and minutes to Grand Parkway, FM529, Hwy6, and 290. Schedule your appt today, this home is sure to have everything you are looking for!' ,`Acres` = '0.1162' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 1 YAUPON PLACE SEC 1' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '5062' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'JOWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'HOPPER MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Yaupon Place Sec 01' ,`TaxAmount` = '6231' ,`TaxRate` = '3.041' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266084' WHERE `Matrix_Unique_ID` = '212456910' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-29T22:15:44.960' ,`MLSNumber` = '69680732' ,`ListAgentFullName` = 'Nayereh Tchamanzar' ,`ListOfficeName` = 'Texas Signature Realty' ,`SellingAgentFullName` = 'Mary Kay Chaykoski' ,`SellingOfficeName` = 'Walzel Properties' ,`Latitude` = '30.214094' ,`Longitude` = '-95.428288' ,`PhotoCount` = '16' ,`PostalCode` = '77385' ,`RoomCount` = '4' ,`ListPrice` = '312950.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Blackberry Lily' ,`StreetNumber` = '16871' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2320' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A Must See. Nothing like it on the market. More than $75,000.00 in UPGRADES. Beautiful 4 bedroom home in lovely Montgomery Creek Ranch, close to neighborhood park and also to everything The Woodlands has to offer. Brand new porcelain flooring, brand new carpet, brand new granite, open concept kitchen, brand new Master bath walk-in shower. Updated upstairs bath, updated powder room, large game room, New water heater, New roof. All measurements are approximate, buyers to measure to their satisfaction.\r\nCall me or Text me directly for private showing and for Low Interest Rate Loan.' ,`Acres` = '0.116' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S720806 - MONTGOMERY CREEK RANCH 06, BLOCK 2, LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5055' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Montgomery Creek Ranch 06' ,`TaxAmount` = '5826' ,`TaxRate` = '2.6088' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266085' WHERE `Matrix_Unique_ID` = '212712240' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-29T21:46:50.527' ,`MLSNumber` = '2396706' ,`ListAgentFullName` = 'Sheila Craniotis' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.691220' ,`Longitude` = '-94.760080' ,`PhotoCount` = '22' ,`PostalCode` = '77351' ,`RoomCount` = '3' ,`ListPrice` = '115000.00' ,`Status` = 'Active' ,`StreetName` = 'Bobcat' ,`StreetNumber` = '173' ,`StreetSuffix` = 'Trail' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1008' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking to escape the city and connect with nature? Then I have a great property with unlimited possibilities. This 1-acre total tract is located in Indian Springs Lake Estates, Livingston. This 3 bed / 2 bath cabin is nestled in the woods with no back neighbors. The wooded lot on the left side is included. The property has a great workshop with a dedicated office that could be transformed into anything you want. The property has city water, septic, and propane making it super economical. This secluded and private subdivision offers lots of room for outdoor living and activities with 3 private spring-fed lakes and an abundance of fishing, kayaking, and paddle boarding in a tranquil environment. Great lot and location for adding an income property, RV site, unrestricted w/no HOA in a remote corner of the neighborhood. Horses, goats, and chickens are welcome. Located only 10 minutes from Downtown Livingston with all the small city conveniences and 5 miles to Naskila gaming complex.' ,`Acres` = '' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'Other Heating,Propane' ,`HOAMandatory` = '0' ,`Legal` = 'INDIAN SPRINGS LAKE ESTATES SECTION 5 LOT 343 & 344' ,`LotDesciption` = 'Cleared,Other,Ravine,Subdivision Lot,Wooded' ,`LotSize` = '21200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Indian Spgs Lake Estates Se' ,`TaxAmount` = '549' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266085' WHERE `Matrix_Unique_ID` = '213156713' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-29T21:51:13.253' ,`MLSNumber` = '96501544' ,`ListAgentFullName` = 'Patrick Lim' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = 'Christie Vu' ,`SellingOfficeName` = 'United Real Estate' ,`Latitude` = '29.545518' ,`Longitude` = '-95.679127' ,`PhotoCount` = '50' ,`PostalCode` = '77479' ,`RoomCount` = '12' ,`ListPrice` = '399000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Moss Dale' ,`StreetNumber` = '1206' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2522' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous and well-maintained home located on a cul de sac in a nice neighborhood of Greatwood! Master down with 3 secondary bedrooms & a gameroom upstairs. Ceiling fans in all bedrooms including gameroom and family room area. The first floor has beautiful engineered wood floors, carpets in the master bedroom & tiles in the kitchen; it also features a spacious gameroom with a beautiful built-in bookshelf/work area, a huge living and dining combo & a sunroom with tile floors which was professionally added per previous sellers. Dining room connects to the island kitchen with quartz countertops, beautiful backsplash & lots of cabinet space. Beautiful glass blocks in master bathroom added about 5 years prior. Spacious & neat backyard with water sprinklers and fences that were replaced not too long ago. Roof - 10 years old; AC in 2013; heat furnace and water heater in 2022; refrigerator, washer & dryer included. Don\'t missed out. All information should be independently verified for accuracy.' ,`Acres` = '0.1822' ,`Area` = '30' ,`BuilderName` = 'Ryland' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GREATWOOD CROSSING SEC 1-A, BLOCK 1, LOT 10' ,`LotDesciption` = 'Cul-De-Sac,On Golf Course,Subdivision Lot' ,`LotSize` = '7936' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '910' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`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 Crossing Sec 1-A' ,`TaxAmount` = '6565' ,`TaxRate` = '2.3013' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266085' WHERE `Matrix_Unique_ID` = '213639511' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-29T21:55:38.977' ,`MLSNumber` = '42712868' ,`ListAgentFullName` = 'Mark Klebenow' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.597558' ,`Longitude` = '-95.094864' ,`PhotoCount` = '48' ,`PostalCode` = '77059' ,`RoomCount` = '11' ,`ListPrice` = '449000.00' ,`Status` = 'Active' ,`StreetName` = 'Indian Sunrise' ,`StreetNumber` = '4307' ,`StreetSuffix` = 'Court' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3268' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous, immaculate Brookwood home in the Master Planned Community of Clear Lake City. This 4 bed, 2.5 bath Perry home offers traditional styling in a contemporary open floor plan that is sure to please! Enjoy big, open living areas with high/vaulted ceilings and beautiful crown molding designed to delight. Lots of updates throughout including neutral designer paint, tile, wood/plank flooring, 2” blinds throughout, frameless glass Master bath shower, extensive recessed lighting, kitchen cabinets, appliances (1/21) and granite countertops. Fresh exterior paint (10/19), brick/Hardie siding and sprinkler system ensure care-free maintenance. A quiet, shady oversized cul-de-sac street lot w/wonderful north-facing backyard, lush landscaping, a massive deck and new fence (12/20) make for an ideal place to enjoy your summer days. Close to schools, shopping & dining, neighborhood park, tennis courts, pool and a long, walking path to Armand Bayou. Move-in ready! Never flooded per seller.' ,`Acres` = '0.2259' ,`Area` = '7' ,`BuilderName` = 'Perry' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 32 BLK 2 BROOKWOOD SEC 1A' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Wooded' ,`LotSize` = '9840' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BROOKWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Brookwood' ,`TaxAmount` = '9423' ,`TaxRate` = '2.5419' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266086' WHERE `Matrix_Unique_ID` = '214729268' --> 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','214758205','1675266086','214758205','2023-01-29T21:07:45.350','85122868','Stephanie Massey','JLA Realty','','','30.080238','-95.115350','50','77336','10','555000.00','Active','Commons Vista','1122','Drive','Huffman','3','0','4','3564','Single-Family','Welcome to Paradise!\r\nThis stunning former Model Home (K. Hovnanian) has all the upgrades and has not ignored any details.\r\nWhen driving up the extra wide driveway and seeing the beautiful landscaping, you will feel the grandeur.\r\nThe living area is a show stopper with a gorgeous stone accent wall and gas log fireplace. The flooring is a beautiful hand scraped wood. The kitchen has all you could want with granite counters and custom made cabinets. It is equipped with all stainless appliances which convey with the sale. What a fantastic area to entertain or just live life. The home is also graced by high ceilings, arches and crown molding. Your family and friends will love the media room, with its platform seating and ample room.\r\nThe bedrooms have beautiful unique murals installed by the builder. The primary bedroom also has trim accents to set it apart. There are 3 bathrooms to accommodate a large group and/or guests. \r\nThis is such a gorgeous home, you will definitely be impressed!','0.6624','32','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Huffman Area','Central Gas','1','LT 1 BLK 2 COMMONS PARK PLACE','Cleared,Subdivision Lot,Wooded','28856','Appraisal District','','1000','0','','3','Electric Oven','0','','','Gas Cooktop','','Composition','28 - Huffman','FALCON RIDGE ELEMENTARY SCHOOL','HARGRAVE HIGH SCHOOL','HUFFMAN MIDDLE SCHOOL','Appointment Required,Leave Business Card','Appraisal District','1','Traditional','Commons Park Place','9053','2.0083','Aerobic,Public Water','2014','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-29T21:37:14.433' ,`MLSNumber` = '5705467' ,`ListAgentFullName` = 'Booker Terrell' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.868670' ,`Longitude` = '-95.875803' ,`PhotoCount` = '7' ,`PostalCode` = '77493' ,`RoomCount` = '5' ,`ListPrice` = '309900.00' ,`Status` = 'Active' ,`StreetName` = 'Mule Ridge' ,`StreetNumber` = '2037' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1855' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This spacious move in ready one-story home has three bedrooms, fourth room is a flex room (has 2 windows and closet), which may be used as another Bedroom or home a office. There are two bathrooms and home boast a full suite of Whirlpool brand kitchen appliances, granite countertops, gorgeous wood cabinets and a breakfast room with a beautiful bay window. Owner’s suite is inclusive of a luxurious bathroom that features a soaker tub, step-in shower and a large walk-in closet. The back patio can be access from owner\'s suite. Bring your offers.' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'LGI Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Brookshire' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S491903 FREEMAN RANCH SECTION 3 BLK 3 LOT 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5543' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '348' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '44 - Royal' ,`SchoolElementary` = 'ROYAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ROYAL HIGH SCHOOL' ,`SchoolMiddle` = 'ROYAL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Freeman Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266086' WHERE `Matrix_Unique_ID` = '215015503' --> 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','215056072','1675266087','215056072','2023-01-29T21:41:37.800','31318023','Sheila Craniotis','Redfin Corporation','','','29.973689','-95.665008','41','77429','7','395000.00','Active','Evergreen Lake','16227','Lane','Cypress','2','1','3','2565','Single-Family','This gorgeous property is located in highly desirable Coles Crossing in Cypress. From the curb you feel a sense of warmth. Two story foyer has soaring ceilings flanked by the staircase and second story landing highlighting detail woodwork and custom built-ins. To the left is a formal dining, which can be easily used as an office. Open concept kitchen, featuring tons of cabinets, beautiful neutral Corian and SS appliances. Breakfast space and sunroom add to the living space, huge laundry room and 1/2 bath rounds out the first floor. All of the bedrooms are upstairs allowing for privacy; large primary bedroom complete with ensuite bath and big walk in closet. Two large secondary bedrooms, with J&J bath. Tons of details, crown molding, real wood cabinets and trim. Big backyard with tons of space for play & family gatherings. Enjoy a peaceful walk or bike ride at any of outdoor nature trails & local parks. Zoned to Cy-Fair ISD. Come and see why so many families love to call Cypress home.','0.17','10','','','','','Other Disclosures,Sellers Disclosure','','','1','Cypress North','Central Electric','1','LT 42 BLK 1 COLES CROSSING SEC 5','Subdivision Lot','7405','Appraisal District','','950','0','','2','','0','','','','','Composition','13 - Cypress-Fairbanks','SAMPSON ELEMENTARY SCHOOL','CYPRESS WOODS HIGH SCHOOL','SPILLANE MIDDLE SCHOOL','Supra Keybox','Appraisal District','2','Traditional','Coles Crossing Sec 05','8559','2.541','Public Sewer,Public Water,Water District','1999','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215293090','1675266087','215293090','2023-01-29T22:59:02.407','6431159','Christina DeLaTorre','REALM Real Estate Professional','','','29.816919','-95.367735','22','77022','4','309000.00','Active','King','312','Street','Houston','3','0','4','1700','Single-Family','MUST SEE this charming renovated home! Situated just minutes away from several trendy eateries, Downtown, I-45 and 610. This 4 bedroom, 3 bathroom home boasts beautiful shiplap wall & ceiling at living room, double pane windows, new HVAC system, pex plumbing, new electrical, foundation repair w/ warranty, vinyl plank flooring throughout the home, granite counters, new appliances, shaker style cabinetry, recessed lighting. Open concept floorplan. The 4th bedroom could also be used as a study. Per seller, the attic is huge and you can turn it into storage space or additional living space. Enjoy outdoor entertaining in the spacious backyard. This home has so much to offer. Call today to arrange your private showing!','0.1228','9','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Northwest Houston','Central Gas','0','LT 5 BLK 2 PAINE PLACE','Subdivision Lot','5350','Appraisal District','','','0','','0','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','ROOSEVELT ELEMENTARY SCHOOL (HOUSTON)','NORTHSIDE HIGH SCHOOL','BURBANK MIDDLE SCHOOL','Leave Business Card','Seller','1','Traditional','Paine Place','7023','2.3307','Public Sewer,Public Water','1942','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','215891975','1675266087','215891975','2023-01-29T21:39:40.163','10489007','Simmi Gautam','Keller Williams Premier RealtyKaty','','','29.797548','-95.575286','50','77043','6','450000.00','Active','Wrenwood','1826','Lakes','Houston','3','1','4','2762','Single-Family','Beautiful and sophisticated well maintained townhome in the beautiful, gated Upland Park community. Stunning wood flooring throughout paired with fabulous kitchen cabinetry. You will greatly appreciate the FIRST-FLOOR living/kitchen area with soaring ceiling height, elegant gas log fireplace, quality craftsmanship, double-paned windows, magnificent Primary Suite, HUGE walk-in closets, & superb finishes! Third floor flex-room features a private bath & closet, which could function as a 4th bedroom. The community is gated with about 200 homes. Community offers walking trails, community pool and lush landscaping!! Motivated sellers!!','0.0492','24','','','','','No Disclosures','','','1','Spring Branch','Central Gas','1','LT 5 BLK 2 UPLAND PARK 3RD PAR R/P & R/P AMEND','Subdivision Lot','2145','Appraisal District','','2000','0','','2','','0','','','','','Composition','49 - Spring Branch','SHERWOOD ELEMENTARY SCHOOL','STRATFORD HIGH SCHOOL (SPRING BRANCH)','SPRING FOREST MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','3','Traditional','Upland Park Repalat 1 Sec 3','11552','2.4415','Water District','2014','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215911753','1675266087','215911753','2023-01-29T21:55:52.297','27627499','Tina Nguyen','Key 2 Texas Realty','','','30.017143','-95.599110','6','77377','3','350000.00','Active','Lawson Cypress','11522','Drive','Tomball','2','0','3','2432','Single-Family','Come see this 1 and 1/2 story beauty with high ceilings. This home features an open kitchen concept viewing the family room with a separate cozy formal dining room. Laundry room is hidden behind the kitchen and pantry area, away from guest views. Spacious gameroom located upstairs. Showings started 1/25. ','0.1452','35','','','Electric Dryer Connections,Gas Dryer Connections','','Sellers Disclosure','1','','1','Tomball South/Lakewood','Central Gas','1','LT 6 BLK 2 TRAILS OF CYPRESS LAKE SEC 1','Other','6325','Appraisal District','','660','0','','2','Gas Oven','0','','','Gas Range','','Composition','53 - Tomball','WILLOW CREEK ELEMENTARY SCHOOL (TOMBALL)','TOMBALL MEMORIAL H S','WILLOW WOOD JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Lockbox Front,Temporarily No Showings','Appraisal District','2','Traditional','Trails/Cypress Lakes Sec 1','8511','2.5764','Water District','2012','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','216152992','1675266087','216152992','2023-01-29T21:06:21.720','72000492','Charon Marshall','Gulf Coast, Realtors','','','29.503523','-94.984768','25','77518','0','295000.00','Active','9th','4724','Street','Bacliff','2','0','4','1748','Single-Family','This 4 bedroom 2 bath has a great split floor plan. Completely fenced and sits on 2 lots. Easy access to Hwy 146. Blocks from the bay.','','33','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','','','','Bacliff/San Leon','Central Electric','0','ABST 164 E PAYNE SUR LOTS 12-13 BLK 80 CLIFTON BY THE S','Cleared','','Other','','','0','','1','Electric Oven','0','','','Electric Range','','Composition','17 - Dickinson','KENNETH E. LITTLE ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','DUNBAR MIDDLE SCHOOL (DICKINSON)','Appointment Required','Builder','1','Traditional','Clifton By The Sea','4116','2.1328','Public Sewer,Public Water,Water District','2017','Seller'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216156137','1675266087','216156137','2023-01-29T22:14:26.697','81874466','Ashley Duty','The Right Choice Realty','','','30.081829','-95.231052','38','77365','8','280999.00','Active','Brooklyn','25615','Lane','Porter','2','1','4','1907','Single-Family','**open house rescheduled from 1/29 to 2/5**\n\nCrisp, clean, barely lived in home in Brooklyn Trails. The Devonhurst II plan is a spacious 2-story home with 4 bedrooms, 2.5 baths, and 2-car garage. The first floor offers the perfect space for entertaining with a peninsula kitchen open to both the living and dining areas! The gourmet kitchen is sure to please with 42\" cabinetry and granite countertops. Retreat to the Owner\'s Suite featuring a walk-in closet and separate tub and shower. Enjoy the great outdoors with full sod and a covered patio! Conveniently located just 1 mile North of Northpark Dr. and Loop 494 - where homeowners enjoy easy access to I-69 and being comfortably nestled near the Kingwood area.\n\n','0.0909','40','','','Electric Dryer Connections','','Exclusions,Mud,Sellers Disclosure','1','','','Porter/New Caney East','Central Gas','1','S269802 - BROOKLYN TRAILS 02, BLOCK 5, LOT 3','Subdivision Lot','3959','Appraisal District','','475','0','','2','','0','','','Gas Range','','Composition','39 - New Caney','PORTER ELEMENTARY SCHOOL (NEW CANEY)','PORTER HIGH SCHOOL (NEW CANEY)','WOODRIDGE FOREST MIDDLE SCHOOL','Lockbox Front,Vacant/Unoccupied','Appraisal District','2','Traditional','Brooklyn Trails 02','5982','3.6031','Water District','2021','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','216230556','1675266087','216230556','2023-01-29T22:50:01.290','91764565','Chase Robinson','Happen Houston','Amanda Joy Schroder','Stone\'s Throw Realty','29.826688','-95.442098','18','77018','3','475000.00','Option Pending','Lamonte','1629','Lane','Houston','2','0','3','1618','Single-Family','Charming Oak Forest home boasting a facade true to the neighborhood\'s quintessence & impeccable curb appeal. Upon entry, guests are welcomed through the craftsman-style front door with a seeded glass window. A bright floor plan & original hardwood floors set the tone for what\'s to expect in the rest of the interior, with the living room offering a flexible layout. The dining area sits at the heart of the home, providing considerate flow between the living spaces and boasting custom built-ins, a modern barn door, and direct access to the backyard. The primary suite offers private access to the outdoor spaces and a spacious layout augmented for bedroom furniture. The primary shower incorporates a separate tub/shower combination & custom cabinetry. The living space extends to the private backyard through the spacious covered patio, providing a great area for gatherings all year long. The proximity to Oak Forest\'s most desirable amenities & interior features makes this home an ideal fit.','0.1669','9','','','','','Sellers Disclosure','1','','','Oak Forest East Area','Central Gas','0','LT 29 BLK 53 OAK FOREST SEC 6','Subdivision Lot','7270','Appraisal District','','','0','','1','','0','','','','','Composition','27 - Houston','STEVENS ELEMENTARY SCHOOL','WALTRIP HIGH SCHOOL','BLACK MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Oak Forest','8548','2.3307','Public Sewer,Public Water','1950','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216264493','1675266087','216264493','2023-01-29T21:40:08.307','87233397','Jennifer Pareya','JLA Realty','Francisco Torres','Prime Realty Group','29.624272','-95.204657','26','77034','12','319900.00','Option Pending','Palmbeach','12342','Street','Houston','2','0','4','1900','Single-Family','Nestled on a corner lot this 4 bedroom, 2 bath home was recently elegantly remodeled with stylish lighting and fixtures, wood and tile flooring. Stunning extra large primary bedroom, Bathroom with Whirlpool tub, walk-in shower and oversized vanity, porcelain tile along with a walk in closet along with access to the back patio. The kitchen features custom built cabinets, quartz counter tops, modern back splash and new stainless French door refrigerator, gas stove with an Air Fryer/Oven combo, microwave & dishwasher. Framed Utility Shed in the backyard. Updated home features, roof, windows, HVAC, electrical, Apex water lines, porcelain tile & wood floors.\r\nEasy access to 45 and Beltway 8. \r\nProperty has never flooded.','0.1992','3','','','','','Sellers Disclosure','1','','','Southbelt/Ellington','Central Gas','0','LT 21 BLK 18 GULF PALMS SEC 2','Subdivision Lot','8677','Appraisal District','','','0','','0','Gas Oven','0','','','Gas Range','','Composition','41 - Pasadena','GENOA ELEMENTARY SCHOOL','MEMORIAL HIGH SCHOOL (PASADENA)','BONDY INTERMEDIATE SCHOOL','Appointment Required,Supra Keybox','Seller','1','Traditional','Gulf Palms Sec 02','3470','2.6863','Public Sewer','1955','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','216436809','1675266087','216436809','2023-01-29T22:44:37.100','83018409','Kris Weiss','BHGRE Gary Greene','Linh Ward','Home & Investment Group','30.171993','-95.591166','50','77354','15','729000.00','Option Pending','Almondell','166','Way','The Woodlands','3','2','4','3756','Single-Family','Stunning 4 bedroom and 3.2 bath home with 3 car tandem garage in the highly desirable neighborhood of Almondell in The Woodlands. Great curb appeal with beautiful brick exterior and covered front porch. This casually elegant home with a fantastic floor plan features wood floors throughout the downstairs living areas and primary bedroom. Gorgeous family room with vaulted ceiling and wood beams open to the kitchen with white cabinetry, large island, granite countertops, gas cooktop, and walk-in pantry. Spacious and elegant formal dining room and large study with vaulted ceiling and French doors. Two bedrooms down including a gorgeous primary retreat with a luxurious primary bath and large walk-in closet. Upstairs includes gameroom, media room, half bath and two bedrooms and bathroom. GORGEOUS backyard retreat is the perfect getaway after a busy day which includes saltwater pool, spa, waterfalls, covered patio, fire pit and pergola. Give us a call to view this amazing home!','','15','Highland Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections','1','The Woodlands','Central Gas','0','WDLNDS VIL STERLING RIDGE 98, BLOCK 2, LOT 5','Subdivision Lot','9831','Appraisal District','','','0','','3','','1','Gunite,Heated,Salt Water','','Gas Cooktop','','Composition','36 - Magnolia','CEDRIC C. SMITH ELEMENTARY SCHOOL','MAGNOLIA HIGH SCHOOL','BEAR BRANCH JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','2','Traditional','Wdlnds Village Sterling Ridge 98','17182','2.4731','Water District','2011','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','216609036','1675266087','216609036','2023-01-29T22:58:49.867','39127612','Alma Pimentel','D. Real Estate','','','29.985219','-95.678972','8','77429','10','336800.00','Active','Pelican Marsh','14426','Drive','Cypress','2','1','5','2619','Single-Family','No Showings Till Further Notice! Gorgeous Private Swimming Pool!! This 2 Story 5 bedroom 2 1/2 bathrooms home has a lot to offer. 8 ft Fence Backyard for swimming pool privacy, an inside fence in yard around pool for safety, all windows with Black screen ,A/c Replaced on 2018 and Roof replaced on 2017, Upon entry to the huge Living room with high ceiling to the spacious kitchen with lots of cabinets, Has a Great floor plan, beautiful nice floor tile/slate on first floor, a Must see!! Needs a bit of TLC Priced to sell Fast, Will Upload more pictures when Rooms are Cleared\r\nCypress Point community offers a swimming pool, tennis courts, and a park. Schools within walking distance .The home is centrally located close to restaurants, shopping (Outlets Mall), and freeway access (290, 99, or 249). Seller Has Terminal Cancer , Be Kind when your realtor takes you to view the home, She has a hard time clearing and Cleaning the house on her own. \r\nAll room sizes are approximate','0.143','35','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Cypress North','Central Gas','1','LT 22 BLK 2 CYPRESS POINT SEC 5','Subdivision Lot','6229','Appraisal District','','575','0','','2','','1','In Ground','','Gas Range','','Composition','13 - Cypress-Fairbanks','FARNEY ELEMENTARY SCHOOL','CYPRESS WOODS HIGH SCHOOL','GOODSON MIDDLE SCHOOL','Accompany,Appointment Required,Call Occupant,Leave Business Card,No Supra Keybox','Seller','2','Traditional','Cypress Point Sec 05','6917','2.6281','Water District','2000','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','216700573','1675266087','216700573','2023-01-29T22:31:30.460','64374842','Kasey Sharretts','Coldwell Banker Realty','','','30.012639','-95.748256','38','77433','9','300000.00','Active','Ochre Willow','20831','Trail','Cypress','2','0','3','2196','Single-Family','This stunning one story home next to a green space and park is a fabulous opportunity in the desirable master planned community of Fairfield. Zoned to highly acclaimed Cypress-Fairbanks ISD schools and conveniently located near 99 and 290, Fairfield offers plentiful amenities. All brick exterior, no side neighbors, large back yard. The open island kitchen with breakfast bar features white cabinets, stainless steel appliances, granite counters and custom backsplash. The split plan features a primary suite with double sinks, separate jetted tub and shower, and two closets. French doors in the primary suite lead to another room with closet that would be a great study, nursery or workout room. On the other side of the home, you will find two more bedrooms and a bath. Refrigerator included.','0.1846','35','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections','1','Cypress North','Central Gas','1','LT 9 BLK 6 FAIRFIELD VILLAGE WEST SEC 14','Subdivision Lot','8040','Appraisal District','','1020','0','','2','Electric Oven,Freestanding Oven','0','','','Electric Cooktop,Freestanding Range','','Composition','13 - Cypress-Fairbanks','KEITH ELEMENTARY SCHOOL','BRIDGELAND HIGH SCHOOL','SALYARDS MIDDLE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Fairfield Village West Sec 14','7545','2.4781','Water District','2004','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','216836612','1675266087','216836612','2023-01-29T21:16:33.113','54932752','Myrna Lopez','Beyond Real Estate','','','30.696137','-96.363293','18','77803','4','230000.00','Active','Bluebonnet','1807','','Bryan','2','0','3','1289','Single-Family','This beautiful NEW CONSTRUCTION is MOVE IN READY! With 3 bedrooms and 2 bathrooms, this home boasts raised vaulted ceilings, open concept floor plan, granite counters throughout, and tiled floors in the main areas. The kitchen features custom cabinetry, stainless steel appliances, and large island with eating bar. Primary bedroom has ensuite bathroom with double sink vanity and large walk-in shower. Enjoy the outdoors in the spacious back yard. Close proximity to restaurants, shopping, and Hwy 6. No HOA! This charming home is ready for you!','','61','My Angel Clean Homes','','','','No Disclosures','1','','','','Central Electric','0','Durwood Thompson, Block 3, Lot 7','Cleared','','','','','1','Never Lived In','0','','0','','','Electric Range','','Composition','148 - Bryan','BONHAM ELEMENTARY SCHOOL (BRYAN)','JAMES EARL RUDDER HIGH SCHOOL','ARTHUR L. DAVILA MIDDLE SCHOOL','Lockbox Front,No Appointment Required','Builder','1','Traditional','Durwood Thompson','','','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216850504','1675266087','216850504','2023-01-29T22:28:22.440','42493611','Virginia Price','Virginia Price Realty, LLC','YoLanda Fultz','Fultz Realty, LLC','30.390407','-96.082503','46','77868','8','199500.00','Pending Continue to Show','Mcalpine','812','Street','Navasota','4','0','2','1746','Single-Family','Adorable 2-bdroom, 2-bathroom home in the heart of Navasota, just minutes from downtown shopping and dining. This cozy stone cottage was built in 1937. It has gorgeous hardwood flooring in the original part of the home, new windows with a transferrable warranty, new toilets, fairly new composition roof (approximately 4 years old), tankless hot water heater in the home, and a new hot water heater in the garage that services the washing machine. In the backyard there is a small building finished with electricity just waiting to be used for the hobby of your choice. This home has so much character and the trees in the area are magnificent.','0.1109','60','','','Electric Dryer Connections,Washer Connections','','Estate','1','','','','Central Gas','0','H&TC, BLOCK 104, LOT 3 (E/2), 4(W37.5\')','Other','4830','Appraisal District','','','0','','2','Freestanding Oven','0','','','Gas Range','','Composition','129 - Navasota','WEBB ELEMENTARY SCHOOL (NAVASOTA)','NAVASOTA HIGH SCHOOL','NAVASOTA JUNIOR HIGH','Appointment Required','Appraisal District','1','Traditional','H&Tc','4465','2.2111','Public Sewer,Public Water','1937','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','216862485','1675266087','216862485','2023-01-29T21:22:08.507','4832263','Alex Webb','Douglas Elliman Real Estate','','','29.738675','-95.454540','44','77027','13','2650000.00','Active','Banning','4619','Drive','Houston','5','2','5','5787','Single-Family','Another beautifully executed, thoughtfully planned Laird Custom Homes, Afton Oaks Project. Transitional/Minimalist facade opens to grandly proportioned living spaces bathed in natural light and replete with state-of-art finishes, fixtures and appliances. Enjoy 1 floor living with generous Primary Bedroom down along with graciously proportioned formals, open family/breakfast/kitchen and study. Afton Oaks is a deed restricted enclave of beautifully maintained boulevards and neighborhood green space quietly tucked away in Houston\'s most vibrant commercial, retail & cultural locations. AO has become one of the most desirable locations inside The Loop boasting luxury compounds on 25,000+ square foot lots with values of more than $4MM. AO residents especially enjoy the luxury of being walking distance to the finest dining & shopping that H-Town offers. Banning is literally 3 blocks from River Oaks District and only slightly further afield are Highland Village, Central Market & The Galleria.','0.197','16','Laird Custom Homes','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','Gaslog Fireplace,Wood Burning Fireplace','2','Royden Oaks/Afton Oaks','Central Gas,Zoned','1','LT 6 & TR 7A BLK 2 AFTON OAKS SEC 1','Subdivision Lot','8580','Appraisal District','','800','1','To Be Built/Under Construction','3','Convection Oven,Double Oven,Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','27 - Houston','SCHOOL AT ST GEORGE PLACE','LAMAR HIGH SCHOOL (HOUSTON)','LANIER MIDDLE SCHOOL','Accompany,Appointment Required','Builder','2','Other Style','Afton Oaks','19835','2.3307','Public Sewer,Public Water','2022','Builder'); --> New record created successfully