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-04T09:42:28.100' ,`MLSNumber` = '98857225' ,`ListAgentFullName` = 'Dawn McLawchlin' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.324029' ,`Longitude` = '-94.993427' ,`PhotoCount` = '27' ,`PostalCode` = '77327' ,`RoomCount` = '6' ,`ListPrice` = '420000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 2239' ,`StreetNumber` = '198' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2458' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy country living in this beautiful custom built home features 4 bedrooms, 2 baths, on 2(+) acres. This open concept living area opens to the kitchen and dining area and features new flooring and high ceilings. The windows throughout the home offers beautiful views of the yard and allows lots of natural light. The kitchen has custom cabinets and granite countertops and leads you to the pantry and mudroom. The primary bedroom features an oversized walk-in closet, master bath with a garden tub and stand-up shower. On the opposite end of the home are 3 more bedrooms and full bath. Walking out the back door, enjoy sitting on the recently added patio. The property also offers a recently added two car carport, and large boat and RV storage.' ,`Acres` = '2.0304' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '000025 M DONAHO, TRACT 366, ACRES 2.0304' ,`LotDesciption` = 'Cleared,Other,Wooded' ,`LotSize` = '88444' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '102 - Tarkington' ,`SchoolElementary` = 'TARKINGTON PRIMARY SCHOOL' ,`SchoolHigh` = 'TARKINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'TARKINGTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Other Style,Ranch,Traditional' ,`Subdivision` = 'M Donaho' ,`TaxAmount` = '3479' ,`TaxRate` = '1.7288' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675101448' WHERE `Matrix_Unique_ID` = '210080576' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T10:10:55.470' ,`MLSNumber` = '73624819' ,`ListAgentFullName` = 'Jennifer Christmas' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.025885' ,`Longitude` = '-95.545247' ,`PhotoCount` = '25' ,`PostalCode` = '77379' ,`RoomCount` = '11' ,`ListPrice` = '449900.00' ,`Status` = 'Active' ,`StreetName` = 'Theisswood' ,`StreetNumber` = '17803' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3367' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW YEAR-NEW PRICE for your NEW HOME!! Located on the corner of a quiet cul-de-sac with beautiful mature trees. This updated 2-story 5bd/3.5 bath house also boasts a beautiful kitchen w/ tons of storage, granite countertops, Dbl Jenn-air ovens & wine fridge. LARGE office (downstairs), quaint sitting area just off of the dining that overlooks the beautiful pool. 23x13 covered patio that is perfect for outdoor entertaining! Primary bedroom downstairs has an ensuite w/ large walk-in shower & HIS/HERS closets! Let\'s not forget the upstairs, 4 larger than average secondary bedrooms, 1 full bath, 1 jack n jill bathroom and a game room that includes a study nook. Please see list of Updates and Exclusions in the Attachments - too many to list. Conveniently located (distance is approx) 3.5 mi to Hwy 249, 3.2 mi to 99 & 9 mi to 45. Most of the big-ticket items have been taken care of for you! Bring your personal style to make this beautiful home your own!' ,`Acres` = '0.2479' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLK 22 017*M1876900-004-022-028 MEMORIAL NORTHWEST SEC' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '10800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '625' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'THEISS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Northwest Sec 04 Pt' ,`TaxAmount` = '6322' ,`TaxRate` = '2.3213' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675101448' WHERE `Matrix_Unique_ID` = '210539971' --> 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','210828809','1675101449','210828809','2023-01-04T09:45:16.670','49753830','Jane NgaDung Nguyen','Alpha, REALTORS','','','29.699273','-95.567814','20','77072','5','249000.00','Active','Sharpview','10614','Drive','Houston','2','0','3','1606','Single-Family','Charming home three-bedroom and two baths rooms located in the Alief district, located close to Chinatown Shopping area and minutes from Arthur Storey Park. Home features a family room with corner brick fireplace, tile & laminate flooring, spacious yard.Close to 59 and Sam Houston highway for easy traveling. Low HOA, Low Tax Rate.','0.1515','28','','','Washer Connections','','Sellers Disclosure','','Freestanding,Wood Burning Fireplace','1','Alief','Central Electric','1','E 55 FT LT 4 & W 5 FT LT 5 BLK 3 IMPERIAL POINT SEC 1 R/P','Cleared','6600','Appraisal District','','150','0','','2','Freestanding Oven','0','','','Freestanding Range','','Composition','2 - Alief','CHAMBERS ELEMENTARY SCHOOL','AISD DRAW','KILLOUGH MIDDLE SCHOOL','Leave Business Card,Lockbox Front','Seller','1','Traditional','Imperial Point Sec 01 R/P','2602','2.4411','Public Sewer,Public Water','1968','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T09:32:44.740' ,`MLSNumber` = '27841985' ,`ListAgentFullName` = 'Ronald Cooper' ,`ListOfficeName` = 'Compass RE Texas, LLC- Lake Conroe' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.397685' ,`Longitude` = '-95.611125' ,`PhotoCount` = '32' ,`PostalCode` = '77356' ,`RoomCount` = '9' ,`ListPrice` = '449900.00' ,`Status` = 'Active' ,`StreetName` = 'Emerson' ,`StreetNumber` = '3518' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2664' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this custom built, 3518 Emerson Dr! Tucked away in the Waterfront and Golf Course community of Walden, this property offers a new roof(May 2022), flex room above the garage, an attached expansive guest suite with oversized closet(W/D hookup) with double vanity bathroom, a private study, renovated master bathroom, and so much more. Need storage space? The 2.5+ garage with soaring ceilings can easily fit your fishing boat and/or golf cart. Enjoy weekends spent on the back patio grilling out, watching college football with the Definitive Surround Sound System! All mounted televisions stay as well as Washer/Dryer. Schedule your private showing today!' ,`Acres` = '0.2369' ,`Area` = '39' ,`BuilderName` = 'Seneca Homes Corp.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'WALDEN 01, BLOCK 2, LOT 21' ,`LotDesciption` = 'In Golf Course Community,Other,Subdivision Lot' ,`LotSize` = '10320' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MADELEY RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Walden 06' ,`TaxAmount` = '5137' ,`TaxRate` = '2.1392' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675101449' WHERE `Matrix_Unique_ID` = '212462753' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T10:58:08.460' ,`MLSNumber` = '30042093' ,`ListAgentFullName` = 'Kipp Kerbow' ,`ListOfficeName` = 'Legacy South Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.655595' ,`Longitude` = '-95.476747' ,`PhotoCount` = '13' ,`PostalCode` = '77035' ,`RoomCount` = '8' ,`ListPrice` = '379000.00' ,`Status` = 'Active' ,`StreetName` = 'Endicott' ,`StreetNumber` = '11514' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1850' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully remodeled home, conveniently located in highly sought-after Westbury subdivision. Some of the key features include all new custom cabinets with soft close doors and drawers and stainless steel appliances, custom LED recessed lighting throughout the living areas, wood-look vinyl plank floors in kitchen, new ceramic floors in bathrooms, new tub/shower surrounds, enlarged master shower, beautifully refinished hardwood floors throughout the rest of the house, granite countertops in kitchen and bathrooms, all new energy efficient windows, new HVAC ducts, all new six-panel doors, all new light fixtures and hardware, updated plumbing and electrical with new 200-amp service panel, and a new garage door opener. Foundation repair with engineer design and lifetime transferable warranty. It has the look and feel of a brand-new home while being nestled in a well-established neighborhood.' ,`Acres` = '0.2118' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 55 WESTBURY SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9225' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '365' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PARKER ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westbury Sec 03' ,`TaxAmount` = '4476' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675101449' WHERE `Matrix_Unique_ID` = '212616036' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T10:13:56.190' ,`MLSNumber` = '58598090' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.512653' ,`Longitude` = '-95.315191' ,`PhotoCount` = '17' ,`PostalCode` = '77584' ,`RoomCount` = '7' ,`ListPrice` = '424990.00' ,`Status` = 'Active' ,`StreetName` = 'Sandspur Springs' ,`StreetNumber` = '6116' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2264' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction in Pearland! Make your selections now! The Glenwood plan by CastleRock Communities is located in a beautiful new development just minutes from 288! Massey Oaks entry will welcome you with an Oak Tree lined street, plenty of walking trails, lakes, and a splash pad, loaded with amenities! The Glenwood is a popular 1-story, this open concept plan has high ceilings, 3 bedrooms, an optional 4th/study, formal dining, 2 baths, and 3 car garage. This home has great flow with elegant entry, double stacked octagon ceiling in formal dining & durable Rigid Core laminate wood flooring from entry, kitchen/dining, family & all hallways. The kitchen features Quartz countertops, an under-mount stainless sink, 42\" cabinets & stainless appliances! Master bedroom on the first floor, separate soaker tub and shower, and walk-in closet Full sod and sprinkler system on all lots! Tankless water heater! Four sides brick! CastleRock Communities has builder backed 2/10 year warranty on all homes!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4, Block 3, Section 2' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'HOOD-CASE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'G W HARBY J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Massey Oaks' ,`TaxAmount` = '' ,`TaxRate` = '3.67' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101449' WHERE `Matrix_Unique_ID` = '212811594' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T10:06:36.020' ,`MLSNumber` = '15303012' ,`ListAgentFullName` = 'Khai Tran' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.747584' ,`Longitude` = '-95.574384' ,`PhotoCount` = '21' ,`PostalCode` = '77042' ,`RoomCount` = '8' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Briar Forest' ,`StreetNumber` = '11203' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2228' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Timeless style meets modern convenience. This spectacular home sits on a corner lot. Covered patio provides a perfect outdoor space to lounge and entertain. Notable features include: French entry door, Luxury vinal wood floors, Spacious family room, Formal dining, Large primary suite, Custom bathroom design with his and her closets, New soft-close cabinets and Quartz counter-tops throughout, Large kitchen island, Breakfast bar, Samsung stainless appliance package, Modern colorway, Floating iron staircase, All new fixtures, 2 car garage. Located within the energy corridor. Shopping, entertainment and restaurants just a few minutes away. Schedule your showing today!' ,`Acres` = '0.0818' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 12 BLK 2 EXECUTIVE ROW T/H' ,`LotDesciption` = 'Corner' ,`LotSize` = '3562' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ASKEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Executive Row' ,`TaxAmount` = '5690' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675101449' WHERE `Matrix_Unique_ID` = '212861734' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T10:54:26.477' ,`MLSNumber` = '52125623' ,`ListAgentFullName` = 'Hilliary Tyner' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.134303' ,`Longitude` = '-94.381388' ,`PhotoCount` = '17' ,`PostalCode` = '77659' ,`RoomCount` = '3' ,`ListPrice` = '359000.00' ,`Status` = 'Active' ,`StreetName` = 'Cuniff' ,`StreetNumber` = '1485' ,`StreetSuffix` = 'Road' ,`City` = 'Sour Lake' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1516' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home sitting on 11.25 acres in the Hardin Jefferson School District. Featuring 3 bedroom, 1 bathroom. Updated electrical and plumbing. Located in the heart of Sour Lake. Lots of potential for a forever home or could be a great investment to divide land and build. Lots of possibilities for the new owner. Make your appointment today.' ,`Acres` = '11.25' ,`Area` = '49' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'AB 49 H STEPHENSON P# 49-47' ,`LotDesciption` = 'Other' ,`LotSize` = '490050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '163 - Hardin-Jefferson' ,`SchoolElementary` = 'SOUR LAKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARDIN-JEFFERSON HIGH SCHOOL' ,`SchoolMiddle` = 'HENDERSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'n/a' ,`TaxAmount` = '' ,`TaxRate` = '1.8384' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675101450' WHERE `Matrix_Unique_ID` = '213422887' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T10:13:46.160' ,`MLSNumber` = '35918551' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.515325' ,`Longitude` = '-95.319990' ,`PhotoCount` = '22' ,`PostalCode` = '77584' ,`RoomCount` = '8' ,`ListPrice` = '449990.00' ,`Status` = 'Active' ,`StreetName` = 'Spanish Moss' ,`StreetNumber` = '6415' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2817' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction in Pearland! Make your selections now! Concho plan by CastleRock Communities is located in a beautiful new development just minutes from 288! Massey Oaks entry will welcome you with an Oak Tree-lined street, plenty of walking trails, lakes, a splash pad, and loaded with amenities! The Concho is an open concept plan that has dramatic high ceilings, 4 bedrooms, a study, a game room, 3.5 baths, and a 2.5 car garage. This open-concept plan is perfect for entertaining, the kitchen features Quartz countertops, an under-mount stainless sink, 42\" cabinets, and an island! Master bedroom on the first floor, separate soaker tub and shower, and walk-in closet! Gameroom for the kids and a secluded study for those who work from home! Full sod and sprinkler system on all lots! Four sides of brick on the first floor! CastleRock Communities has builder backed 2/10 year warranty on all homes!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 27, Block 1, Section 1' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '7080' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'HOOD-CASE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'G W HARBY J H' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Massey Oaks' ,`TaxAmount` = '' ,`TaxRate` = '3.67' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101450' WHERE `Matrix_Unique_ID` = '213806632' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T10:13:36.053' ,`MLSNumber` = '63484537' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.515331' ,`Longitude` = '-95.319865' ,`PhotoCount` = '19' ,`PostalCode` = '77584' ,`RoomCount` = '7' ,`ListPrice` = '374990.00' ,`Status` = 'Active' ,`StreetName` = 'Spanish Moss' ,`StreetNumber` = '6411' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1915' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction in Pearland! Make your selections now! The Sabine plan by CastleRock Communities is located in a beautiful new development just minutes from 288! Massey Oaks entry will welcome you with an Oak Tree-lined street, plenty of walking trails, lakes, and a splash pad. The Sabine is an open-concept one-story plan with 3 bedrooms, office/flex space, 2 baths, and 2.5 car garage. This open-concept plan is perfect for entertaining, the kitchen features Quartz countertops in the kitchen, an under-mount stainless sink, 42\" cabinets, an island, a walk-in pantry, and tons of cabinets perfect for all your storage needs! Spacious master bedroom and bathroom with separate soaker tub and shower, and walk-in closet! Flex space for the kids or and separate study for those who work from home, with a view of the backyard! Full sod and sprinkler system on all lots! Four sides of brick on the first floor! CastleRock Communities has builder backed 2/10 year warranty on all homes!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 28, Block 1, Section 1' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '6832' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'HOOD-CASE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'G W HARBY J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Massey Oaks' ,`TaxAmount` = '' ,`TaxRate` = '3.67' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101450' WHERE `Matrix_Unique_ID` = '213807331' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T10:13:22.713' ,`MLSNumber` = '49313225' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.515364' ,`Longitude` = '-95.318861' ,`PhotoCount` = '17' ,`PostalCode` = '77584' ,`RoomCount` = '7' ,`ListPrice` = '332990.00' ,`Status` = 'Active' ,`StreetName` = 'Spanish Moss' ,`StreetNumber` = '6311' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1604' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction in Pearland! Make your selections now! The Comal plan by CastleRock Communities is located in a beautiful new development just minutes from 288! Massy Oaks entry will welcome you with an Oak Tree-lined street, plenty of walking trails, lakes, and a splash pad! The Comal is an open concept, with a formal dining room featuring 3 bedrooms, 2 baths, and a 2.5 car garage. This open-concept plan is perfect for entertaining, the kitchen features Quartz countertops, an under-mount stainless sink, and 42\" cabinets! Spacious master bedroom and bathroom with separate soaker tub and shower, and walk-in closet! Full sod and sprinkler system on all lots! Four sides of brick on the first floor! CastleRock Communities has builder backed 2/10 year warranty on all homes!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 33, Block 1, Section 1' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '7168' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'HOOD-CASE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'G W HARBY J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Massey Oaks' ,`TaxAmount` = '' ,`TaxRate` = '3.67' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101450' WHERE `Matrix_Unique_ID` = '213808472' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T10:59:55.597' ,`MLSNumber` = '14822890' ,`ListAgentFullName` = 'Kitten Leopold' ,`ListOfficeName` = 'Leopold & Strahan Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.354232' ,`Longitude` = '-95.015935' ,`PhotoCount` = '17' ,`PostalCode` = '77563' ,`RoomCount` = '3' ,`ListPrice` = '183900.00' ,`Status` = 'Active' ,`StreetName` = 'Crestview' ,`StreetNumber` = '206' ,`StreetSuffix` = 'Drive' ,`City` = 'Hitchcock' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1332' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cute single-family home right in the heart of Hitchcock, Tx!! This home is 3 bedrooms 2 baths with a formal dining area. Large spacious room living room. Tons of storage. Huge kitchen with an abundance of cabinet/countertop space. Ready for your pesonal touches. Large fenced in backyard with mature trees perfect for an outdoor barbecue. Estate Sale. HURRY UP AND MAKE AN OFFER TODAY!' ,`Acres` = '0.2065' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hitchcock' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 2 PAGE 11 LOT 16 OAK RIDGE' ,`LotDesciption` = 'Other' ,`LotSize` = '8995' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '26 - Hitchcock' ,`SchoolElementary` = 'HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HITCHCOCK HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (HITCHCOCK)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Ridge' ,`TaxAmount` = '2474' ,`TaxRate` = '2.3428' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1957' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675101451' WHERE `Matrix_Unique_ID` = '213919018' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T09:41:56.137' ,`MLSNumber` = '58460185' ,`ListAgentFullName` = 'Wesley Bryant' ,`ListOfficeName` = 'Partners in Building LP' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.450697' ,`Longitude` = '-95.511789' ,`PhotoCount` = '41' ,`PostalCode` = '77318' ,`RoomCount` = '9' ,`ListPrice` = '789936.00' ,`Status` = 'Active' ,`StreetName` = 'Greenridge View' ,`StreetNumber` = '9764' ,`StreetSuffix` = 'Drive' ,`City` = 'Willis' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3007' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Inside you’ll admire dynamic soaring ceilings, brilliant natural light and beautiful wood floors that take you effortlessly through this flowing floor plan. At the entry there is an elegant office space. The kitchen exudes sophistication, fully equipped with high-end appliances, custom designed cabinets, granite countertops and center eat-on island. It also features a sliding glass door to the outside patio. Great for quiet morning coffee, or gatherings. The kitchen/dining area opens to the sunny family room with large windows, for a nice view! The primary suite features a huge walk-in closet, and luxurious ensuite bath, with dual vanities & walk-in shower. Two secondary bedrooms with ensuite baths. Two highlights of this home are a nicely tucked away nook, and a retreat area…for guests to wind down in the evening, to steal away with your favorite book, or get in some cardio. There\'s also golf cart garage space. Chambers Creek is the newest 55+ Active Adult community in Willis, Texas.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Partners in Building' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S336403 - Chambers Creek 03, BLOCK 2, Lot 22' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '9336' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3480' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'C.C. HARDY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch' ,`Subdivision` = 'Chambers Creek' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101451' WHERE `Matrix_Unique_ID` = '213923330' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T09:18:44.547' ,`MLSNumber` = '81651865' ,`ListAgentFullName` = 'Kathryn Hensley' ,`ListOfficeName` = 'Keller Williams Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.307618' ,`Longitude` = '-94.842451' ,`PhotoCount` = '22' ,`PostalCode` = '75904' ,`RoomCount` = '3' ,`ListPrice` = '219000.00' ,`Status` = 'Active' ,`StreetName` = 'State Highway 94' ,`StreetNumber` = '7540' ,`StreetSuffix` = '' ,`City` = 'Lufkin' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1560' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home Sweet Home! Don\'t miss out on this adorable, updated 3bedroom, 2bath home with a large guest house or man cave in the back - all nestled on 1.33 acres. This lot comes with a RV hook up too! Call for a showing today!' ,`Acres` = '1.33' ,`Area` = '45' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angelina County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABS 0704 WRIGHT C. C.,TRACT 3.1,ACRES 1.33' ,`LotDesciption` = 'Cleared' ,`LotSize` = '57935' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '262 - Hudson' ,`SchoolElementary` = 'W.H. BONNER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUDSON HIGH SCHOOL' ,`SchoolMiddle` = 'HUDSON MIDDLE SCHOOL (HUDSON)' ,`ShowInstructions` = 'Leave Business Card' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'none' ,`TaxAmount` = '2415' ,`TaxRate` = '1.7378' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675101451' WHERE `Matrix_Unique_ID` = '214295726' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T10:04:38.053' ,`MLSNumber` = '13676190' ,`ListAgentFullName` = 'Christina Morehouse' ,`ListOfficeName` = 'Vive Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.365480' ,`Longitude` = '-94.789970' ,`PhotoCount` = '43' ,`PostalCode` = '77327' ,`RoomCount` = '7' ,`ListPrice` = '99999.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 2122a' ,`StreetNumber` = '95' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the desired Trinity River and Lake Estates subdivision, this lake house has 2 bedrooms and 1 full bath in the main house and a shed that was converted into a cabin-like style with bunk beds and a mini-split for AC & heating. The lake house has its own access to the Old River Lake, this is a private lake for residents only. The lake house sits on a nice spacious lot between Old River Lake and the George Ruby Bend. The house has many upgrades from the kitchen cabinets to the waterproof flooring, recess lighting inside and outside, new plumbing piping in the main bathroom. What you see is what you get with this one, everything you see on the photos stay with the property. Call today for your private showing.' ,`Acres` = '0.2314' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Liberty County East' ,`HeatSystem` = 'Propane,Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'TRINITY RIVER & LAKE ESTATES, BLOCK 25, LOT 63 64, ACRES .23' ,`LotDesciption` = 'Corner,Water View,Waterfront' ,`LotSize` = '10080' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '107 - Hardin' ,`SchoolElementary` = 'HARDIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARDIN HIGH SCHOOL' ,`SchoolMiddle` = 'HARDIN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Trinity River & Lake Estates' ,`TaxAmount` = '834' ,`TaxRate` = '1.7656' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675101451' WHERE `Matrix_Unique_ID` = '214702745' --> 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','214807376','1675101452','214807376','2023-01-04T10:28:16.740','57410462','Michael O\'Neal','Keller Williams RealtyNortheast','','','30.047113','-95.165213','21','77345','4','550000.00','Active','Golden Pond','2107','Drive','Houston','3','1','4','4269','Single-Family','Calling investors, fixer uppers to rebuild!! Home is being sold as is. So much opportunity to make this place your home. Great location on a cul-de-sac in Fosters Mill Village a quite, family friendly community of Kingwood. Located near 59N and the Grand Parkway and minutes away from Bush Airport. Stop by and see it today!','1.4354','32','','','','','Sellers Disclosure','','Freestanding','1','Kingwood East','Central Gas','1','LT 7 BLK 1 FOSTERS MILL VILLAGE SEC 4','Subdivision Lot','62525','Appraisal District','','615','0','','2','','0','','','','','Composition','29 - Humble','DEERWOOD ELEMENTARY SCHOOL','KINGWOOD HIGH SCHOOL','RIVERWOOD MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Traditional','Fosters Mill Village Sec 04','10588','2.5839','Public Sewer,Public Water','1984','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T10:57:09.650' ,`MLSNumber` = '68873312' ,`ListAgentFullName` = 'Ernesto Jimenez' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.131528' ,`Longitude` = '-95.793063' ,`PhotoCount` = '10' ,`PostalCode` = '77355' ,`RoomCount` = '5' ,`ListPrice` = '619000.00' ,`Status` = 'Active' ,`StreetName` = 'Camwood' ,`StreetNumber` = '460' ,`StreetSuffix` = '' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2752' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Virtual tour is of previous home built with similar floor plan. Under Construction! This exceptional home offers many upgrades to enjoy sitting on 1.38 acres. This spacious kitchen has stainless steel appliances, a double oven, quartz countertops, a tile backsplash, a large island, recessed lighting, a walk-in pantry, and a built-in microwave. The spacious primary bedroom comes complete with a spacious bathroom and a large closet with ample space. The primary bathroom features a stand alone tub and separate shower with his and her vanity areas. Engineered hardwood flooring throughout with tile flooring in wet areas. Utilize a spacious oversized attached garage.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Marielle Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CLEAR CREEK FOREST 11, BLOCK 6, LOT 29' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '60450' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '175' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'J.L. LYON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Clear Creek Forest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101452' WHERE `Matrix_Unique_ID` = '215091438' --> 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','215110192','1675101452','215110192','2023-01-04T09:48:49.260','68450304','Tami Peters','Peters Properties','','','29.846269','-95.265736','29','77028','3','155000.00','Active','Fringewood','8621','Drive','Houston','1','0','3','1248','Single-Family','3 bedrooms, 1 bathroom home 59 and 610. ! This home is a prime fixer-upper and is ready for your personal touch to be added it to it. Make this house into your dream home! It is also in a great location with room to grow! Don\'t miss out, call us today for more information! Seller is selling the home as-is.','0.3881','2','','','','','No Disclosures','','','','Northeast Houston','Window Unit','0','LTS 7 & 8 BLK 1 NEWHAVEN PLACE','Subdivision Lot','16905','Appraisal District','','','0','','0','','0','','','','','Composition','27 - Houston','HILLIARD ELEMENTARY SCHOOL','NORTH FOREST HIGH SCHOOL','FOREST BROOK MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Newhaven Place','1937','2.3307','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','215200903','1675101452','215200903','2023-01-04T09:46:32.263','25790338','Brock Sanchez','Realty Associates','','','29.729668','-95.359225','23','77004','5','220000.00','Active','Sauer','3305','Street','Houston','1','0','2','890','Single-Family','LOW TAXES & NO HOA! Fully Renovated, beautiful large 2 bedroom, 1 bath Bungalow with high ceilings throughout just completed and ready for tours! This home was remodeled from the ground up to include roof, electrical, PEX plumbing, AC, ducting, hot water system, double paned windows, flooring, insulation, all sheetrock with real wood accent walls, doors and trim, ceiling fans and light fixtures throughout, Quartz kit counters with soft close kit cabinets and drawers. The exterior boasts a two car double wide double ribbon driveway that leads up to the welcoming covered front porch entrance and also has a backyard that also has a covered porch deck perfect for relaxing. The backyard has access to a 20-mile bike trail that extends from Herman Park to the Heights. Centrally located within walking distance to Metro Rail just minutes from UH, TSU, Rice U, Emancipation Park and within 10 minutes of the Medical Center and downtown. Schedule your tour today!','0.0594','4','','','Electric Dryer Connections,Washer Connections','','Other Disclosures','1','','','University Area','Central Electric','0','TRS 3B & 4A BLK 4 FOREST HOME','Other','2586','Appraisal District','','','0','','0','Freestanding Oven','0','','','Freestanding Range','','Composition','27 - Houston','BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)','YATES HIGH SCHOOL','CULLEN MIDDLE SCHOOL (HOUSTON)','Accompany,Appointment Required,Lockbox Front','Seller','1','Contemporary/Modern','Forest Home','2385','2.3307','Public Sewer,Public Water','1936','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','215460847','1675101452','215460847','2023-01-04T09:34:23.797','76436383','Mariana Alvarez','Texan Preferred Realty','','','30.428000','-95.626811','30','77356','8','540000.00','Active','Bermuda','181','Circle','Montgomery','3','1','4','2965','Single-Family','New contruction in a gated community of Bentwater. This house offers 4 bedrooms, Primary and 2 bedrooms are situated in the fist floor, the 4th bedroom is in the second floor, Second floor has an extra espace for game room with a complete bathroom.\r\nThe kichen has a spacious quartz island open the living room with space for four people to be seated. Stainless appliances,cabinets with underlights.\r\nPrimary bathroom offers separate rain shower, and soaking tub, you will be impressed by the walk in closet.','0.1653','39','AYR Homes, LLC','','','','Mud','1','','1','Lake Conroe Area','Central Gas','1','BENTWATER 05, BLOCK 2, LOT 2','Subdivision Lot','7200','Appraisal District','','1146','1','Never Lived In','2','Electric Oven','0','','','Gas Cooktop','','Composition','37 - Montgomery','LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)','MONTGOMERY HIGH SCHOOL','MONTGOMERY JUNIOR HIGH SCHOOL','Appointment Required,Vacant/Unoccupied','Builder','1.5','Traditional','Bentwater 05','381','2.1142','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','215808899','1675101452','215808899','2023-01-04T10:37:45.517','39794018','Jude Nassar','Vibrant Realty LLC','','','30.125385','-95.492363','32','77380','7','270000.00','Active','Wilderness','24615','Road','Spring','2','0','3','1490','Single-Family','Charming house located in Spring just on the outskirts of The Woodlands, this light and bright home was completely remodeled in 2019, featuring upgraded kitchen with granite countertops, updated fixtures, large living area perfect for entertaining, Spacious master bedroom with large walk in closet, home is sitting on an oversized lot just under 1/4 of an acre, must see to appreciate.','0.2488','15','','','Gas Dryer Connections,Washer Connections','','Mud,Seller may be subject to foreign tax and Buyer withholding per IRS,Sellers Disclosure,Tenant Occupied','1','','0','Spring/Klein','Central Gas','1','S924003 - TIMBER LAKES 3A&3B, LOT 346','Cleared','10838','Appraisal District','','67','0','','2','Single Oven','0','','','Gas Range','','Composition','11 - Conroe','SAM HAILEY ELEMENTARY SCHOOL','THE WOODLANDS COLLEGE PARK HIGH SCHOOL','KNOX JUNIOR HIGH SCHOOL','Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied','Appraisal District','1','Ranch,Traditional','Timber Lakes 3a&3b','4594','2.5954','Water District','1975','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','215843434','1675101452','215843434','2023-01-04T09:24:06.163','27251036','Leann Acuna','San Antonio Portfolio KW RE','','','29.730564','-95.378537','50','77004','8','425000.00','Active','Rosewood','1529','Street','Houston','3','1','3','2294','Single-Family','One-of-a-kind corner lot in the heart of the museum district and minutes from Downtown. You are greeted by beautiful hardwood floors throughout. First floor bedroom with an en suite and outdoor access to a covered patio. At the top of the stairs, you are welcomed into a cozy main living area with a gas fireplace and numerous windows that allow for plenty of natural light. This space allows for easy socializing and gathering with the kitchen being partially open to the living area and a breakfast nook just off the kitchen. Grand kitchen includes stainless steel gas appliances, an oversized island for food preparation, and plenty of storage in the upper and lower cabinets. Master bedroom located on the top floor with a full en suite, built-in shelving and walk in closet. Rooftop terrace has brand new turf for added comfort and unbeatable views of Houston\'s skyline. Home did not flood during Hurricane Harvey and maintained electricity during the previous Texas freeze in 2021.','0.0386','17','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Rice/Museum District','Central Gas','1','LT 15 BLK 1 CATCO CRAWFORD PARK','Corner','1680','Appraisal District','','300','0','','2','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','MACGREGOR ELEMENTARY SCHOOL','LAMAR HIGH SCHOOL (HOUSTON)','CULLEN MIDDLE SCHOOL (HOUSTON)','Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','3','Craftsman','Catco Crawford Park','10195','2.3307','Public Sewer,Public Water','2008','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','215895628','1675101452','215895628','2023-01-04T09:44:25.517','71625594','Brenda Thomas','Red Barn Realty','','','31.362478','-96.144505','23','75846','3','215000.00','Active','Waltman','114','Street','Jewett','1','0','3','1189','Single-Family','Check this out: A 3 bedroom, 1 bath brick home on pier and beam foundation with a composition roof, central air and heat, and an attached one car carport with an 8x12 storage room. Additionally, there are 2 buildings that have Hwy 79 (Main St. Jewett) frontage, directly across the street from the popular Jewett Flea Market. The corner building (building #1) is 16x22 (308 SF +/-) with a 6x16 covered front porch and a 6x8 covered back porch, it has 1 window unit and a bathroom with a shower. The second building (building #2) is 1056 SF +/- with central a/h and a half bath. Both buildings are metal with wood frames and lie on .0574 of an acre. All three are for sale together for list price of $215,000.00.','0.1722','63','','','','','Sellers Disclosure','','','','Buffalo Area','Central Electric','0','JEWETT CITY BLK 112 LT 9 & 10 0.172 AC AB 591 J MCGREW','Other','7501','Appraisal District','','','0','','0','','0','','','','','Composition','195 - Leon','LEON ELEMENTARY SCHOOL','LEON HIGH SCHOOL','LEON JUNIOR HIGH SCHOOL','Accompany,Appointment Required','Appraisal District','1','Traditional','na','3033','1.7407','Public Sewer,Public Water','1958','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','216047660','1675101452','216047660','2023-01-04T10:17:46.910','65049273','Mark Maniha','Mark Maniha, Broker Experts','','','29.836500','-95.431692','37','77018','10','1550000.00','Active','Candlelight','1240','Lane','Houston','5','1','5','4365','Single-Family','Another Stunning Custom Home By New Oak Homes. 5 bed, 5 1/2 bath, Massive Master Suite , Custom Front Doors, Wall of windows with this stunning entry and trim work! This beautiful home has 12\' ceilings and solid hardwood floors throughout. Formal Study, Formal Dinning, Media/Game Room, Huge Back Yard w/ Full Outdoor Kitchen plenty of room for a Pool. Upgraded features, Whole-home Dehumidification and Upgraded HVAC, Smart Home, Generator ready, Tankless Water Heaters, Upgraded Foam Insulation, 6\" exterior walls, Solid Wood Custom Cabinetry, Chef Kitchen, 48inch Stove, double ovens, 10ft Kitchen island, crown molding and custom trim work, designer plumbing fixtures. 10 YEAR WARRANTY! Master Retreat offers private coffee/wine bar, His and Her walk-in closets, oversized shower, soaking tub, his and her vanities. Oversized secondary bedrooms! Mudroom entry off garage, tons of storage. Alarm system and 4 security cameras included, wired for surround sound inside and out.','','9','New Oak Homes','','Gas Dryer Connections,Washer Connections','','Owner/Agent','1','Gas Connections,Gaslog Fireplace','1','Oak Forest East Area','Central Gas','0','LT 23 BLK 35 OAK FOREST SEC 3','Subdivision Lot','8400','Appraisal District','','','1','To Be Built/Under Construction','2','Convection Oven,Double Oven,Freestanding Oven','0','','','Freestanding Range,Gas Range,Grill','','Aluminum,Composition','27 - Houston','OAK FOREST ELEMENTARY SCHOOL (HOUSTON)','WALTRIP HIGH SCHOOL','BLACK MIDDLE SCHOOL','Appointment Required','Builder','2','Contemporary/Modern,Traditional','Oak Forest','7696','2.5264','Public Sewer,Public Water','2023','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','216047686','1675101452','216047686','2023-01-04T10:23:52.610','67939954','Michael Serna','The Collective Realty Group','','','30.040359','-95.338315','30','77373','7','225000.00','Active','Rustygate','6015','Drive','Spring','2','0','3','1556','Single-Family','Home is move in ready! Wood tile flooring, Brick Fireplace in living room, covered patio, Granite Countertops in Kitchen along with mosaic backsplash, and breakfast bar. Master Bedroom has a walk-in closet, dual trench vanities, and an open shower. Near shopping, dining, entertainment at Deerbrook Mall. Schools are zones to Spring ISD.','0.1515','12','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Spring East','Central Gas','1','LT 22 BLK 10 GREENGATE PLACE SEC 2','Subdivision Lot','6600','Appraisal District','','399','0','','2','','0','','','','','Composition','48 - Spring','CHET BURCHETT ELEMENTARY SCHOOL','SPRING HIGH SCHOOL','DUEITT MIDDLE SCHOOL','Accompany,Appointment Required','Appraisal District','1','Traditional','Greengate Place Sec 02','5511','2.6867','Water District','1977','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','216047708','1675101452','216047708','2023-01-04T10:17:05.790','70505122','Cyndi Kornegay','Gatehouse Properties','','','30.269965','-95.466287','12','77304','8','386199.00','Active','Trapper Creek','221','Drive','Conroe','2','0','4','1660','Single-Family','Welcome to this charming one-story home. With its white painted brick exterior and 8’ front door, this home offers instant curb appeal. As you enter through the front door you are greeted by an open concept design. Leading your way into the heart of the home you will instantly notice the abundance of natural light. Luxury Vinyl planks pave your way throughout the main living areas and primary bedroom. The gourmet kitchen includes an upgraded stone countertop, under-counter lighting, stainless-steel appliances, and a large island, a perfect layout for holiday gatherings. The secluded primary suite, with a bowed window, is complete with a luxurious bath that features dual sinks, and separate tub and shower. At the end of a long day retreat to your private backyard, with no rear neighbors, and relax on your covered outdoor patio. Come see what this charming home has to offer today!','','19','Coventry Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Other Disclosures','1','','','Conroe Southwest','Central Gas','1','Lot 13 Block 2','Subdivision Lot','4901','Survey','','1180','1','To Be Built/Under Construction','2','Freestanding Oven,Gas Oven','0','','','Gas Range','','Composition','11 - Conroe','WILKINSON ELEMENTARY SCHOOL','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Accompany,Appointment Required,No Supra Keybox','Builder','1','Traditional','Grand Central Park','','3.06','Public Sewer,Water District','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','216048120','1675101452','216048120','2023-01-04T10:32:28.410','17892006','Libby Mitchell','REGENCY REAL ESTATE PROF','','','30.081646','-93.792372','7','77630','7','257340.00','Active','Balsa Wood','608','Drive','Orange','2','0','4','1885','Single-Family','DSLD Homes \"Ravenswood\" plan offers a 4 bedroom and 2 full bathroom open floor plan. Special features: Black appliances, 3 cm granite countertops throughout, birch cabinets throughout, Luxury Vinyl Plank flooring in living area, halls, and wet areas with carpet in bedrooms; ceiling fans in the living area and master bedroom, Bronze plumbing fixtures in the bathrooms, post tension slab, and more! Energy Efficient Features: Tankless gas water heater, low E tilt-in windows, radiant barrier roof decking, and more!','','50','DSLD Homes, LLC','','','','No Disclosures','1','','','','Central Gas','1','Lot 5 Sec. 2','Cleared','','','','130','1','To Be Built/Under Construction','2','Electric Oven,Freestanding Oven','0','','','Electric Range,Freestanding Range','','Composition','367 - Bridge City','BRIDGE CITY ELEMENTARY SCHOOL','BRIDGE CITY HIGH SCHOOL','BRIDGE CITY MIDDLE SCHOOL','Appointment Required,Vacant/Unoccupied','Builder','1','Traditional','Cypresswood Village','','','Public Sewer,Public Water','2023','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','216048187','1675101452','216048187','2023-01-04T10:27:29.787','61350516','Mark Maniha','Mark Maniha, Broker Experts','','','29.835684','-95.431879','49','77018','5','1577000.00','Active','Richelieu','1244','Lane','Houston','5','1','5','4458','Single-Family','Another NEW Stunning home by NEW OAK HOMES! 5 bed, 5 full bath, formal dining, formal study, wine grotto, massive master retreat, Pool bath, outdoor kitchen, and room for a pool! This beautiful home has hardwood floors throughout. Solid Wood Custom Cabinetry, Chef Kitchen, 48 inch Range Stainless appliances, double ovens, wine grotto/chiller, 10ft island, crown molding and custom trim work, designer plumbing fixtures, walls of windows offering tons of natural light. Master Retreat offers private coffee/wine bar, huge walk-in closet, massive shower, separate soaking tub, his and her vanities. Oversized secondary bedrooms all w/private baths. Mudroom entry. Large laundry room up. Alarm and security cameras included, wired for surround sound inside and out. Upgraded 6\" exterior walls, foam spray insulation including garage, tankless water heaters, whole home dehumidification system w/upgraded HVAC. 10 YEAR WARRANTY! Smart Home and Generator Ready!','0.1653','9','New Oak Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Home Protection Plan,Owner/Agent','1','Gaslog Fireplace','1','Oak Forest East Area','Central Gas','0','LT 39 BLK 34 OAK FOREST SEC 3','Cleared,Subdivision Lot','7600','Survey','','','1','To Be Built/Under Construction','2','Double Oven','0','','','Gas Range','','Aluminum,Composition','27 - Houston','OAK FOREST ELEMENTARY SCHOOL (HOUSTON)','WALTRIP HIGH SCHOOL','BLACK MIDDLE SCHOOL','Appointment Required','Builder','2','Contemporary/Modern,Traditional','Oak Forest','7023','2.4216','Public Sewer,Public Water','2023','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','216048603','1675101452','216048603','2023-01-04T10:33:16.360','54852669','Cyndi Kornegay','Gatehouse Properties','','','30.271410','-95.467195','15','77304','8','404003.00','Active','Sendero','858','Trail','Conroe','2','0','3','1855','Single-Family','Welcome to this charming one-story design, built with an impressive modern Texas elevation. Entering through the front door, you are sure to be impressed by the spacious foyer. Directly off the entryway is your home office with French doors, offering desired privacy. Enjoy making family dinners in the gourmet kitchen featuring stainless-steel appliances and a large island, with upgraded stone, that overlooks the casual dining and family room. The secluded primary suite is tucked away in the back of the home and is complimented by bowed windows. The primary bath is luxurious and includes a separate tub and shower. Take entertaining outdoors on the Texas-sized covered patio, that includes a ‘gas stub out’ for future BBQ’s. Come see your future home today.','','19','Coventry Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Other Disclosures','1','','','Conroe Southwest','Central Gas','1','Lot 5 Block 1','Subdivision Lot','5339','Survey','','1180','1','To Be Built/Under Construction','2','Freestanding Oven,Gas Oven','0','','','Gas Range','','Composition','11 - Conroe','WILKINSON ELEMENTARY SCHOOL','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Accompany,Appointment Required,No Supra Keybox','Builder','1','Contemporary/Modern,Traditional','Grand Central Park','','3.14','Public Sewer,Water District','2023','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','216048952','1675101452','216048952','2023-01-04T10:59:25.880','83149054','Katey Sada','REALM Real Estate Professional','','','29.918635','-95.580070','32','77064','6','449999.00','Active','White Oak Trail','10127','Lane','Houston','3','1','5','4107','Single-Family','Welcome to this wonderful home that can accommodate to every member of your family! This floor plan has it all; five oversized bedrooms, huge game room AND media room (or optional 6th bedroom!!), both formals, high ceilings, large kitchen, downstairs study/office and a primary en-suite that offers built-ins, jetted tub, separate shower, double sink and a large walk-in closet. Home has been upgraded with tankless instant hot water heater, marble floors and columns downstairs, tile and granite countertops in kitchen, wood laminate floors, NEW carpet upstairs AND fresh paint throughout. HOME DID NOT FLOOD in Ike, Harvey, Freeze, or ever, per Seller. Prime location with quick access to 290, Beltway 8, hospitals, shopping, dining and more! Zoned to Cy-Fair ISD! Don\'t miss out!','0.1446','10','','','','','Mud,Sellers Disclosure','1','','1','Jersey Village','Central Gas','1','LT 3 BLK 2 WILLOW POINTE SEC 6','Subdivision Lot','6300','Appraisal District','','499','0','','2','','0','','','','','Composition','13 - Cypress-Fairbanks','BANG ELEMENTARY SCHOOL','CYPRESS RIDGE HIGH SCHOOL','CAMPBELL MIDDLE SCHOOL','Accompany,Leave Business Card,Request Online Appointment,Supra Keybox','Appraisal District','2','Traditional','Willow Pointe','7312','2.641','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','216049523','1675101452','216049523','2023-01-04T10:45:49.307','59934352','Libby Mitchell','REGENCY REAL ESTATE PROF','','','30.080802','-93.793723','6','77630','7','281745.00','Active','Mimosa','4511','Drive','Orange','2','0','4','2204','Single-Family','DSLD Homes \"Camellia\" plan offers a 4 bedroom and 2 full bathroom open floor plan. Special features: Black appliances, 3 cm granite countertops throughout, birch cabinets throughout, Luxury Vinyl Plank flooring in living area, halls, and wet areas with carpet in bedrooms; ceiling fans in the living area and master bedroom, Bronze plumbing fixtures in the bathrooms, post tension slab, and more! Energy Efficient Features: Tankless gas water heater, low E tilt-in windows, radiant barrier roof decking, and more!','','50','DSLD Homes, LLC','','','','No Disclosures','1','','','','Central Gas','1','Lot 13 Sec. 2','Cleared','12354','Appraisal District','','130','1','To Be Built/Under Construction','2','Electric Oven,Freestanding Oven','0','','','Electric Range,Freestanding Range','','Composition','367 - Bridge City','BRIDGE CITY ELEMENTARY SCHOOL','BRIDGE CITY HIGH SCHOOL','BRIDGE CITY MIDDLE SCHOOL','Appointment Required','Builder','1','Traditional','Cypresswood Village','','','Public Sewer,Public Water','2023','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','216049550','1675101452','216049550','2023-01-04T10:47:46.833','88158610','Mark Maniha','Mark Maniha, Broker Experts','','','29.823073','-95.415758','27','77018','6','588000.00','Active','Brinkman','4006','Street','Houston','3','1','3','2275','Single-Family','Stunning Modern Farmhouse, walking distance to Garden Oaks Elementary, with custom trim work, Stainless appliances, hardwoods and custom finishes selected by Christine Heartsill Design, New Oak Homes has created a breath-taking and Elegant 3 story home with the feel of a true custom. Private Driveway, Private Back Yard, and Full size 2 car Garage. Our homes include a MASSIVE Primary Suite, His and Her closets, large soaking tub and separate shower. First floor full guest suite. Oversized secondary bedrooms with walk-in closets and private baths. A beautiful open floor plan perfect for hosting family and friends, solid hardwood floors. Upgraded features include, Foam Insulation, Radiant Barrier, Tankless hotwater heaters, 6\" exterior walls (more insulation and strength), Solid Wood Cabinetry, Chef Kitchen with custom island, Fridge included, designer plumbing fixtures, lovely Balcony. Mudroom entry! Laundry room up. Alarm system and wired for security cameras. Smart Home Ready!','','9','NEW OAK HOMES','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Home Protection Plan,Owner/Agent','1','','','Oak Forest East Area','Central Gas','0','BRINKMAN ESTATES LOT 3 BLK 1','Patio Lot,Subdivision Lot','','','','','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Cooktop,Gas Range','','Composition','27 - Houston','GARDEN OAKS ELEMENTARY SCHOOL','WALTRIP HIGH SCHOOL','BLACK MIDDLE SCHOOL','Appointment Required','Builder','3','Contemporary/Modern,Craftsman,Traditional','GARDEN OAKS','','','Public Sewer,Public Water','2023','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','216050044','1675101452','216050044','2023-01-04T10:55:12.510','64527576','Mark Maniha','Mark Maniha, Broker Experts','','','29.823073','-95.415758','27','77018','6','588000.00','Active','Brinkman','4008','Street','Houston','3','1','3','2275','Single-Family','Stunning Modern Farmhouse design, using the custom trim work, appliances, high-end selections, and quality from our 1 million dollar homes, New Oak Homes is accustom to building here in Oak Forest, we have created a breath-taking and Elegant 3 story home with the feel of a true custom. Private Driveways, Private Back Yard, and Full size 2 car Garage. Our homes include a MASSIVE Primary Suite, His and Her walk-in closets, large soaking tub and separate shower. Oversized secondary bedroom suites with walk-in closets and full private baths. This beautiful home has open floor plan perfect for hosting family and friends, solid hardwood floors throughout. Upgraded features include, Foam Insulation, Radiant Barrier, 6\" exterior walls (more insulation and strength), Solid Wood Cabinetry, Chef Kitchen with custom island, Stainless Appliances, designer plumbing fixtures, lovely Balcony. Mudroom entry off garage. Laundry room up. Alarm system and 4 security cameras included. Smart Home Ready!','','9','NEW OAK HOMES','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Home Protection Plan,Owner/Agent','1','','','Oak Forest East Area','Central Gas','0','OAK GROVE (BRINKMAN) ESTATES LOT 4 BLK 1','Patio Lot,Subdivision Lot','','','','','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Cooktop,Gas Range','','Composition','27 - Houston','GARDEN OAKS ELEMENTARY SCHOOL','WALTRIP HIGH SCHOOL','BLACK MIDDLE SCHOOL','Appointment Required','Builder','3','Contemporary/Modern,Craftsman,Traditional','OAK GROVE','','','Public Sewer,Public Water','2023','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','216050234','1675101453','216050234','2023-01-04T10:58:54.697','46350064','Libby Mitchell','REGENCY REAL ESTATE PROF','','','30.081294','-93.792125','6','77630','6','255320.00','Active','Balsa Wood','702','Drive','Orange','2','0','3','1848','Single-Family','Another beauty by DSLD Homes, the \"Trillium\" plan offers a 3 bedroom and 2 full bathroom open floor plan. Special features: Black appliances, 3 cm granite countertops throughout, birch cabinets throughout, Luxury Vinyl Plank flooring in living area, halls, and wet areas with carpet in bedrooms; ceiling fans in the living area and master bedroom, Bronze plumbing fixtures in the bathrooms, post tension slab, and more! Energy Efficient Features: Tankless gas water heater, low E tilt-in windows, radiant barrier roof decking, and more!','','50','DSLD Homes, LLC','','','','No Disclosures','1','','','','Central Gas','1','Lot 7','Cleared','','','','130','1','To Be Built/Under Construction','2','Electric Oven,Freestanding Oven','0','','','Electric Range,Freestanding Range','','Composition','367 - Bridge City','BRIDGE CITY ELEMENTARY SCHOOL','BRIDGE CITY HIGH SCHOOL','BRIDGE CITY MIDDLE SCHOOL','Appointment Required','Builder','1','Traditional','Cypresswood Village','','','Public Sewer,Public Water','2023','Builder'); --> New record created successfully