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-06T12:28:01.993' ,`MLSNumber` = '91908376' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.268202' ,`Longitude` = '-95.557946' ,`PhotoCount` = '50' ,`PostalCode` = '77316' ,`RoomCount` = '8' ,`ListPrice` = '1250000.00' ,`Status` = 'Active' ,`StreetName` = 'Larkhaven Drive' ,`StreetNumber` = '129' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '4' ,`BathsHalf` = '3' ,`BedsTotal` = '4' ,`SqFtTotal` = '4481' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 91908376 - Built by Huntington Homes - March completion! ~ An ELEGANT 2 Story Home located in a Golf Course Community. This Luxury Plan Features a STUCCO Elevation w/ Stunning COURTYARD at the Entry. A MODERN KITCHEN with Painted Cabinetry and Professional appliances including a planning desk, mud bench and pool bath. A Large GREAT Room has soaring A-Framed Ceilings with beams & Gorgeous 10\' Sliding Glass Doors to frame the view of the covered patio and drawing in Natural light. The1st floor Media Room is perfect for Entertaining Guests. While the Primary Suite offers Dual Master sinks with ample Cabinetry a walk in Shower with a sleek Freestanding Tub. Tankless Water Heater, Full Sprinklers, PEX Plumbing, Built-In Pest Control. Kwikset Smart code Deadbolt, Honeywell Smart Thermostat, EERO Router System, Lift master WIFI GA Door Opener!!' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Huntington Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7, Block 1' ,`LotDesciption` = 'Greenbelt,In Golf Course Community,Subdivision Lot,Wooded' ,`LotSize` = '13678' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1391' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LONE STAR ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest Larkhaven' ,`TaxAmount` = '' ,`TaxRate` = '2.77' ,`WaterSewer` = 'Other Water/Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675105560' WHERE `Matrix_Unique_ID` = '208309975' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-06T11:43:01.600' ,`MLSNumber` = '36575166' ,`ListAgentFullName` = 'Cameron Ansari' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.750200' ,`Longitude` = '-95.417797' ,`PhotoCount` = '10' ,`PostalCode` = '77019' ,`RoomCount` = '0' ,`ListPrice` = '1775000.00' ,`Status` = 'Active' ,`StreetName` = 'Pelham' ,`StreetNumber` = '2521' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '0' ,`BathsHalf` = '0' ,`BedsTotal` = '0' ,`SqFtTotal` = '4061' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ready to build the dream home you’ve been talking about for years? Want your children to attend acclaimed River Oaks-area schools? (Buyer to verify eligibility for attendance.) This prime Pelham Drive lot is finally ready for its next act. It’s 9550 square feet (per HCAD) of space – plenty of room to build a large home and pool, anchored by mature trees in both the front and back yards. The site is just three houses east of Kirby Drive and two blocks north of San Felipe – essentially the heart of River Oaks and close to River Oaks Elementary. Handsome new construction as well as elegantly preserved vintage homes are all around. The original 1936 home is not inhabitable, and this property is being offered as a lot. At less than $186 per square foot, it represents a superlative opportunity for a new single-family home. As this is an estate, all offers will be subject to approval of probate court.' ,`Acres` = '0.2192' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Probate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'River Oaks Area' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 40 RIVER OAKS SEC 1' ,`LotDesciption` = 'Wooded' ,`LotSize` = '9550' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2340' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'RIVER OAKS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'River Oaks' ,`TaxAmount` = '35967' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1936' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675105560' WHERE `Matrix_Unique_ID` = '208546388' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-06T11:43:12.817' ,`MLSNumber` = '81573310' ,`ListAgentFullName` = 'Amy Raper' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = 'Heather Perry' ,`SellingOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`Latitude` = '29.794915' ,`Longitude` = '-94.931060' ,`PhotoCount` = '33' ,`PostalCode` = '77521' ,`RoomCount` = '7' ,`ListPrice` = '335000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Russell' ,`StreetNumber` = '5830' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2124' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 3 bed, 3 bath all brick home sits on oversized corner lot with easy access to I-10 and Hwy 146. One of the youngest homes in the neighborhood, recently updated with fresh paint on ceilings, walls, decorative molding, and cabinetry. The neutral color palette is on-trend, light and inviting. Kitchen features abundant cabinetry, stainless steel appliances including new oven range, breakfast bar, and convenient walk-in pantry. Large primary bedroom with en-suite bath has expansive walk-in closet, separate dual vanities, jacuzzi tub, and shower. Striking flex space (study, media, music, or fitness room) is filled with natural light and well-appointed with vaulted ceiling, wainscoting, and full en-suite bath with shower. Beadboard accented walls and gas log brick fireplace accentuate the family room. Secondary bedrooms and hall have luxury vinyl plank flooring. Screened back patio overlooks back yard with no rear neighbors. Home has never flooded and includes a whole home generator.' ,`Acres` = '0.3679' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 19 BLK 6 CEDAR BAYOU PARK WEST' ,`LotDesciption` = 'Corner' ,`LotSize` = '16026' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Cedar Bayou Park West' ,`TaxAmount` = '6144' ,`TaxRate` = '2.3712' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675105561' WHERE `Matrix_Unique_ID` = '209513028' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-06T12:58:43.317' ,`MLSNumber` = '63791371' ,`ListAgentFullName` = 'Iliana Sanchez' ,`ListOfficeName` = 'NuWay Realty Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.876519' ,`Longitude` = '-95.451404' ,`PhotoCount` = '27' ,`PostalCode` = '77088' ,`RoomCount` = '6' ,`ListPrice` = '319900.00' ,`Status` = 'Active' ,`StreetName` = 'Sunnyhill' ,`StreetNumber` = '8318' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1598' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MODERN NEW CONSTRUCTION!Welcome to your beautiful 3 bedroom,2.5 bath,2 car garage home!From the moment you walk through the covered porch leading to the MODERN GLASS FRONT DOOR you will be WOWED! Home features OPEN CONCEPT FLOOR PLAN with high ceilings,tile flooring in main living area and recessed lighting throughout. Kitchen features beautiful QUARTZ COUNTER TOPS, breakfast bar,STAINLESS STEEL APPLIANCES, modern design back splash,42\"cabinets.The half bath is conveniently located on first floor.Beautiful stained stair treads leading up to the second floor.The EXTRA LARGE PRIMARY BEDROOM can perfectly accommodate any size bedroom set and features a COVERED BALCONY!The en-suite bath features a modern frame less shower and separate tub, DOUBLE SINKS with quartz counter tops, and best of all a LARGE WALK IN CLOSET! The utility room is centrally located between all bedrooms on the second floor. The backyard is fully fenced and features a covered porch.Schedule your showing today!' ,`Acres` = '' ,`Area` = '11' ,`BuilderName` = 'TL Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 3 WASHINGTON HEIGHTS ANNEX SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2750' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'ANDERSON ACADEMY' ,`SchoolHigh` = 'CARVER H S FOR APPLIED TECH/ENGINEERING/ARTS' ,`SchoolMiddle` = 'DREW ACADEMY' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Washington Heights Annex Sec 0' ,`TaxAmount` = '539' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675105561' WHERE `Matrix_Unique_ID` = '212298973' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-06T12:59:11.193' ,`MLSNumber` = '96937922' ,`ListAgentFullName` = 'Iliana Sanchez' ,`ListOfficeName` = 'NuWay Realty Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.876258' ,`Longitude` = '-95.451284' ,`PhotoCount` = '27' ,`PostalCode` = '77088' ,`RoomCount` = '6' ,`ListPrice` = '319900.00' ,`Status` = 'Active' ,`StreetName` = 'Sunnyhill' ,`StreetNumber` = '8320' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1598' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MODERN NEW CONSTRUCTION!Welcome to your beautiful 3 bedroom,2.5 bath,2 car garage home!From the moment you walk through the covered porch leading to the MODERN GLASS FRONT DOOR you will be WOWED! Home features OPEN CONCEPT FLOOR PLAN with high ceilings,tile flooring in main living area and recessed lighting throughout. Kitchen features beautiful QUARTZ COUNTER TOPS, breakfast bar,STAINLESS STEEL APPLIANCES, modern design back splash,42\"cabinets.The half bath is conveniently located on first floor.Beautiful stained stair treads leading up to the second floor.The EXTRA LARGE PRIMARY BEDROOM can perfectly accommodate any size bedroom set and features a COVERED BALCONY!The en-suite bath features a modern frame less shower and separate tub, DOUBLE SINKS with quartz counter tops, and best of all a LARGE WALK IN CLOSET! The utility room is centrally located between all bedrooms on the second floor. The backyard is fully fenced and features a covered porch.Schedule your showing today!' ,`Acres` = '' ,`Area` = '11' ,`BuilderName` = 'TL Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 3 WASHINGTON HEIGHTS ANNEX SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2750' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'ANDERSON ACADEMY' ,`SchoolHigh` = 'CARVER H S FOR APPLIED TECH/ENGINEERING/ARTS' ,`SchoolMiddle` = 'DREW ACADEMY' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Washington Heights Annex Sec 0' ,`TaxAmount` = '539' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675105561' WHERE `Matrix_Unique_ID` = '212303676' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-06T11:26:16.163' ,`MLSNumber` = '26299012' ,`ListAgentFullName` = 'Daniel Loria' ,`ListOfficeName` = 'RE/MAX Eastside' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.101075' ,`Longitude` = '-94.828990' ,`PhotoCount` = '44' ,`PostalCode` = '77535' ,`RoomCount` = '6' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'FM 2797' ,`StreetNumber` = '2118' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '4032' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Escape the city & enjoy a peaceful retreat with this stunning country property, located just 45 minutes from downtown Houston. Spread out over 4 unrestricted acres, this spacious property offers plenty of privacy & room to roam. The blacktop driveway leads to a large carport, & the grand 4000 Sqft doublewide. Designed with entertaining in mind, the home features 6-7 bedrooms, 4 bathrooms, multiple living areas, and a pool table. The custom kitchen is a chef\'s delight, with granite countertops & a vaulted ceiling, with plenty of storage & space in the large laundry room, pantry, and flex-room off the kitchen. When you want to enjoy the great outdoors, head out to one of the many porches - the front porch is perfect for sipping tea, while the back porch is great for grilling up a feast. Included is a 1,800 sqft metal shop with restroom, a pole barn for storing all your tractors, boats, ATVs, & golf carts. Also offering a small gun range in the back of the property. \r\n$5k towards closing' ,`Acres` = '4.16' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '000043 REASON GREEN, TRACT 334, ACRES 4.16, MH LABEL# NTA122' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '181210' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'RICHTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Reason Green' ,`TaxAmount` = '3943' ,`TaxRate` = '1.7595' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675105561' WHERE `Matrix_Unique_ID` = '212317241' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-06T11:33:27.740' ,`MLSNumber` = '55924072' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'June Onguko' ,`SellingOfficeName` = 'Fortune Investment Properties' ,`Latitude` = '29.681071' ,`Longitude` = '-95.830919' ,`PhotoCount` = '28' ,`PostalCode` = '77406' ,`RoomCount` = '13' ,`ListPrice` = '447527.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Cecilia Star' ,`StreetNumber` = '10555' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2410' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Terrace, Elevation B). CURRENTLY UNDER CONSTRUCTION. Two story. 4 bedrooms. 3.5 baths. Spacious island kitchen open to informal dining room and family room. Primary suite with large walk in closet. Large Game Room and three additional bedrooms upstairs. Covered patio and attached 2 car garage. Candela offers new homes for sale in Richmond, Texas. The community is the perfect combination of small-town charm and easy access to big city conveniences. Take a stroll through Downtown Historic Richmond, visit the Imperial Farmer\'s Market and enjoy the great outdoors at Brazos Bend State Park. Major employers in Houston, Katy and Sugar Land are only a short commute away. Great restaurants, and local and big box retail offerings are all close by. Visit Candela today to find your new home!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BLOCK 4, LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5832' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Candela' ,`TaxAmount` = '' ,`TaxRate` = '3.15' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675105562' WHERE `Matrix_Unique_ID` = '212820920' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-06T12:57:25.007' ,`MLSNumber` = '92221595' ,`ListAgentFullName` = 'Kathleen Montes' ,`ListOfficeName` = 'Target Realty, Inc.' ,`SellingAgentFullName` = 'Carol Hughes' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '30.076953' ,`Longitude` = '-95.331432' ,`PhotoCount` = '50' ,`PostalCode` = '77386' ,`RoomCount` = '12' ,`ListPrice` = '1599900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Benton Brook' ,`StreetNumber` = '27009' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '5179' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This meticulously maintained custom home in highly sought after Benders Landing Estates has open floor plan with a formal dining,2 primary suites,2 game rooms & study.Enjoy cooking & entertaining in the spacious gourmet island kitchen with granite counters, SS appliances, double ovens w/convection, induction cooktop, solid wood cabinets, Sonic type icemaker, & prep sink. Relax in the master suite, w/sitting area.Master bath boasts Bain air bubble tub (more hygienic), walk-thru shower, 2 vanities, heated floors & huge custom closet.2nd primary on 1st floor has its own living area with built in kitchenette.Upstairs you will find large gameroom, bedroom and full bath.Enjoy on the covered custom patio with built in kitchen, & wood ceiling overlooking the pool and spa.Check out the 1000 sq ft. workshop with 1/2 bath, numerous ideas for this space (mancave, MIL suite, home office, add\'tl garage). Sprinkler system, generator, 3 car garage are just a few of the amenities of this home!' ,`Acres` = '0.9869' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S257207 - BENDERS LANDING ESTATES 07, BLOCK 2, LOT 17' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '42990' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'ANN K. SNYDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Benders Landing Estates 07' ,`TaxAmount` = '15911' ,`TaxRate` = '1.8487' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675105562' WHERE `Matrix_Unique_ID` = '212950479' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-06T12:56:55.667' ,`MLSNumber` = '46588593' ,`ListAgentFullName` = 'Jessica Armstrong' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.315541' ,`Longitude` = '-96.627042' ,`PhotoCount` = '27' ,`PostalCode` = '77879' ,`RoomCount` = '3' ,`ListPrice` = '104500.00' ,`Status` = 'Active' ,`StreetName` = 'Park View' ,`StreetNumber` = '605' ,`StreetSuffix` = 'Lane' ,`City` = 'Somerville' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1024' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your home away from home in one of the most sought after subdivisions around Lake Somerville! This property is the definition of \"weekend retreat\", featuring a home, 2 car carport, a separate pad for RV, & a shed/workshop with electricity inside. The inside of the home features 2 bedrooms, 1 bathroom, & 2 EXTRA bonus rooms that could be used as additional sleeping areas, an office, or more living area. This is all situated in Birch Creek Forest on 0.6 wooded acres with large established trees. This subdivision includes swimming pool, volunteer fire department, helipad, boat ramp, trash services & more. The property is large enough to expand if needed and has the ability to customize the land for your needs. If you like privacy, leave as many trees as you want, or clear just enough to add additional structures for boat/jet ski storage! The outdoor workshop has TONS of space to store boat toys, lawnmowers, etc. Come take a tour today and don\'t let this paradise slip by.' ,`Acres` = '0.6' ,`Area` = '59' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S2501 BIRCH CREEK FOREST BLK 8 LOT 5/11-13 0.5976 ACRES' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '26031' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '276' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '158 - Somerville' ,`SchoolElementary` = 'SOMERVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SOMERVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'SOMERVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Birch Creek Forest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675105562' WHERE `Matrix_Unique_ID` = '213100734' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-06T12:00:55.927' ,`MLSNumber` = '80567435' ,`ListAgentFullName` = 'Giril Edakkunnath' ,`ListOfficeName` = 'Prompt Realty & Mortgage, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.541724' ,`Longitude` = '-95.167029' ,`PhotoCount` = '37' ,`PostalCode` = '77546' ,`RoomCount` = '10' ,`ListPrice` = '305000.00' ,`Status` = 'Active' ,`StreetName` = 'Man O War' ,`StreetNumber` = '16814' ,`StreetSuffix` = 'Lane' ,`City` = 'Friendswood' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2236' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is the move-in ready home you\'ve been waiting for! \r\nZoned to CCISD, don’t miss this beautifully renovated home with formal dining, formal living, breakfast area, living room with high ceilings, and an oversized covered backyard patio to make the best of your outdoor living! Primary suite located on the first floor with an additional 2 bedrooms located upstairs. All bathrooms have been newly renovated along with a half bath on the first floor for guests. Brand new floors including tile, carpet and laminate. Fresh paint inside and outside. Water heater and Central AC were both replaced recently per owner. Two mature trees in the front and backyard provide plentiful shade. Come see it today before it’s gone!' ,`Acres` = '0.1446' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'HOA First Right of Refusal,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 71 BLK 12 HERITAGE PARK SEC 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'LANDOLT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'WESTBROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Heritage Park' ,`TaxAmount` = '5491' ,`TaxRate` = '2.166' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675105562' WHERE `Matrix_Unique_ID` = '213377031' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-06T12:02:49.163' ,`MLSNumber` = '33578344' ,`ListAgentFullName` = 'Marsae Batey' ,`ListOfficeName` = 'Marsae\'s Coastal Living Proper' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.290887' ,`Longitude` = '-94.807970' ,`PhotoCount` = '27' ,`PostalCode` = '77550' ,`RoomCount` = '6' ,`ListPrice` = '449884.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue N' ,`StreetNumber` = '3807' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1555' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'STUNNING home w/modern updates yet it offers the old classic charm of Galveston homes. Gorgeously refinished hardwood flooring throughout plus shiplap walls. Dining room features a beautiful bay window & build-in desk nook/bar area. Kitchen spared no details with the black shiplap ceiling, island with range and stove, breakfast bar, pantry, and original spice nook. Gold and black details really make the kitchen sparkle! The remarkable primary suite with a giant walk-in closet, shiplap ceiling and extraordinary primary bath is a must see from the free standing soaking tub with shower, his/her sinks & unique custom built vanity. Secondary bedroom features the original chandelier, shiplap ceiling, and private entrance to backyard. You don’t find many fenced backyards in Galveston with this square footage. Outside has great curb appeal, 2 car garage w/alley access, shaded paver patio, and covered front porch. New in 2022- roof, A/C, heater, and appliances. This home has so much character!' ,`Acres` = '0.1475' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOT 6 & E 10-8.5 FT OF LOT 5 NW BLK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6424' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Galveston Outlots' ,`TaxAmount` = '6306' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675105563' WHERE `Matrix_Unique_ID` = '213385536' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-06T12:26:28.070' ,`MLSNumber` = '58270997' ,`ListAgentFullName` = 'Maria Giovinale' ,`ListOfficeName` = 'CDW Group Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.762766' ,`Longitude` = '-95.883391' ,`PhotoCount` = '44' ,`PostalCode` = '77423' ,`RoomCount` = '6' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Village Orchard' ,`StreetNumber` = '2002' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2148' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 2002 Village Orchard!!! This STUNNING 4 bedrooms, 3 bathrooms OPEN concept floorplan is full of enchanting upgrades such as quartz counter tops, reverse osmosis system, high ceilings and 8 ft doors throughout the property. All the faucets are from the high-end brand Moen and include a transferrable warranty to the new buyer. Luxury vinyl plank flooring across the house and upgraded taller baseboards. Covered extended patio & private back yard are perfect for your outdoor get-togethers and weekend cookouts. \r\n\r\nAdditionally, you can enjoy the new and well-maintained amenities from the Young Ranch community, such as splash water park, playground, and private gym. Do not wait! Come and see your dream home!' ,`Acres` = '0.1741' ,`Area` = '30' ,`BuilderName` = 'M/I Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'YOUNG RANCH SEC 12, BLOCK 1, LOT 36' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7585' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1090' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Young Ranch Sec 12' ,`TaxAmount` = '8225' ,`TaxRate` = '3.072' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675105563' WHERE `Matrix_Unique_ID` = '213399509' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-06T12:25:26.293' ,`MLSNumber` = '83188430' ,`ListAgentFullName` = 'Cheryl Espiritu Belin' ,`ListOfficeName` = 'Homelove Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.965155' ,`Longitude` = '-95.195808' ,`PhotoCount` = '37' ,`PostalCode` = '77346' ,`RoomCount` = '7' ,`ListPrice` = '429900.00' ,`Status` = 'Active' ,`StreetName` = 'Buffalo Peak' ,`StreetNumber` = '17022' ,`StreetSuffix` = 'Court' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2630' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning home with a sparkling pool and spa is ideally located on a cul de sac street in the amenity-rich master planned community of Eagle Springs and is zoned to incredible schools! This Highland Home with stone and brick façade features a formal dining room, island kitchen with butler\'s pantry, wine fridge, granite counters, and stainless steel appliances, including a gas cooktop, expansive living room with soaring ceilings, hardwood floors, and stone gas fireplace, and a primary retreat with en suite bath that includes a dual vanity, separate shower, soaking tub, and walk in closet! There is a secondary bedroom and full bath on the first floor! Upstairs you will find a game room, two bedrooms, and a jack and jill bath! The pool and spa were replastered and tiled in 2020! Upgraded lighting! Fresh paint 10/22! Zoned to West Lake Middle! Neighborhood amenities include competition and resort style pools, fitness center, splash pad, sports fields, parks, and a ton of events!' ,`Acres` = '0.1567' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 4 EAGLE SPRINGS SEC 27 AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6825' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'ATASCOCITA SPRINGS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Eagle Springs' ,`TaxAmount` = '7228' ,`TaxRate` = '2.913' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675105563' WHERE `Matrix_Unique_ID` = '213619270' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-06T12:17:43.580' ,`MLSNumber` = '68088716' ,`ListAgentFullName` = 'Dawn Bajalieh' ,`ListOfficeName` = 'RE/MAX Integrity' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.892064' ,`Longitude` = '-95.679573' ,`PhotoCount` = '46' ,`PostalCode` = '77095' ,`RoomCount` = '14' ,`ListPrice` = '419000.00' ,`Status` = 'Active' ,`StreetName` = 'Emerald Bluff' ,`StreetNumber` = '7907' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '2545' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Reflect Your Success, in this well appointed 4 bedroom 2 full & 2 half baths located in a well established neighborhood with an abundance of trees. This magnificent home boasts a newly remodeled kitchen, featuring quartz counters, upgraded tile backsplash, a Viking gas cooktop, a range hood vent includes a hand sensor & remote. Both the new LG Convection oven & the ever so quiet Bosch dishwasher have a 5 year warranty. The large walk-in pantry has an outlet & motion sensor. This dream kitchen has new cabinets & beautiful copper pulls, under cabinet lights. Perfect for a gourmet cook who loves to entertain. Plantation shutters, crown molding throughout, and tall ceilings, all exude the classic sophistication of this home. Recent updates hot water heater, pool salt cell, new control board \r\nfor salt cell chlorine generator sprinkler system, new Polaris pump, pool resurfaced 6/2019. Sprinkler system. There are several French drains for added drainage. Home & neighborhood never flooded.' ,`Acres` = '0.1843' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 27 BLK 4 COPPERFIELD WESTCREEK VILLAGE SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8030' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '708' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'COPELAND ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'LANGHAM CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'ARAGON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Copperfield Westcreek Village' ,`TaxAmount` = '6728' ,`TaxRate` = '2.471' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675105563' WHERE `Matrix_Unique_ID` = '213729066' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-06T11:31:02.320' ,`MLSNumber` = '4924475' ,`ListAgentFullName` = 'John McNiece' ,`ListOfficeName` = 'D. Real Estate' ,`SellingAgentFullName` = 'William Finnorn' ,`SellingOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`Latitude` = '30.049905' ,`Longitude` = '-95.595479' ,`PhotoCount` = '19' ,`PostalCode` = '77375' ,`RoomCount` = '7' ,`ListPrice` = '269000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Twisted Creek' ,`StreetNumber` = '19827' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2372' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great 4 bedroom, 2 1/2 bath home on corner lot in Three Lakes East. This home is one of the largest floor plans in the neighborhood with quick access to the Grand Parkway. Sprinkler system. New stainless stove, dishwasher and microwave vent hood. Granite counter tops in kitchen. Updated light fixtures and ceiling fans. Extended back yard with deck. Tile in primary bedroom and two closets.' ,`Acres` = '0.1155' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 9 THREE LAKES EAST SEC 4' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '5032' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '345' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KOHRVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'ULRICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Three Lakes East Sec 04' ,`TaxAmount` = '5926' ,`TaxRate` = '2.7066' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675105564' WHERE `Matrix_Unique_ID` = '213986779' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-06T12:31:51.010' ,`MLSNumber` = '55168104' ,`ListAgentFullName` = 'Darren Morris' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.037071' ,`Longitude` = '-95.365944' ,`PhotoCount` = '9' ,`PostalCode` = '77373' ,`RoomCount` = '3' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Twisting Pine' ,`StreetNumber` = '22939' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2160' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully Renovated from the Roof to the Floor. All work was done in 2022, and that includes a brand new roof, resurfacing the kitchen cabinets and countertop, painting the entire interior, new carpet, new beautiful plank floors, all completely new appliances, and much more. Minutes away from 1960, great location for easy access to the big airport. Game room upstairs, and plenty of room in the bedrooms. This house isn\'t going to last, come see it soon! Complete list of renovations is available on request. Pool, tennis courts, and recreational facilities provided by the HOA!' ,`Acres` = '0.1085' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 1 SPRING PLACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4725' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '370' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'MILDRED JENKINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Place' ,`TaxAmount` = '4975' ,`TaxRate` = '2.9367' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675105564' WHERE `Matrix_Unique_ID` = '214060580' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-06T11:53:53.490' ,`MLSNumber` = '59789907' ,`ListAgentFullName` = 'Sharon Bourdon' ,`ListOfficeName` = 'Parkway Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.126900' ,`Longitude` = '-95.737277' ,`PhotoCount` = '30' ,`PostalCode` = '77355' ,`RoomCount` = '8' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Pinion Creek' ,`StreetNumber` = '17223' ,`StreetSuffix` = 'Circle' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2446' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ARE YOU LOOKING FOR UNRESTRICTED COUNTRY LIVING AND COMPLETELY UPDATED HOME?? The approximately half acre culdesac lot offers privacy and great outdoor entertainment area and The hard work has been done to update this home with all the bells and whistles! Complete remodel in 2017 from the inside and out included the addition of a two car garage w/ game room &media room above , formal dining and additional of luxurious ensuite primary bath! Outside updates include-new roof, siding and Hvac and new double paned windows- inside you\'ll love the wood floors throughout living area, complete remodel in kitchen and baths with new cabinetry, sinks, stainless appliances and new lighting fixtrues, custom wine bar with wine chiller and space for beverage fridge-. Decorator colors, tray ceilings and crown molding finish out the package! Outdoor living area offers covered patio with summer kitchen and fire pit. Storage area in back yard. FULL RV HOOK UP -Electronic gate at drive' ,`Acres` = '0.5473' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PINION CREEK, BLOCK 3, LOT 30, ACRES 0.547' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '23840' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'NICHOLS SAWMILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Pinion Creek' ,`TaxAmount` = '5249' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675105564' WHERE `Matrix_Unique_ID` = '214135357' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-06T12:57:49.187' ,`MLSNumber` = '70911050' ,`ListAgentFullName` = 'Kirk Richards' ,`ListOfficeName` = 'Kobank Homes LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.930289' ,`Longitude` = '-95.083138' ,`PhotoCount` = '29' ,`PostalCode` = '77532' ,`RoomCount` = '6' ,`ListPrice` = '249000.00' ,`Status` = 'Active' ,`StreetName` = 'Flying Bridge' ,`StreetNumber` = '711' ,`StreetSuffix` = 'Way' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1806' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come and see this beauty with plenty of updates that will make for a wonderful new home. Move-in ready, featuring 4 bedrooms, 2 full & 1 half bathrooms, an open kitchen and plenty of open living space that will please the eye from every angle. Fresh interior & exterior paint, new carpet, tile flooring, and granite countertops throughout. Easy color palette that allows for any decorating scheme. Come and see this home quick, it won’t last long!' ,`Acres` = '0.1865' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 12 NEWPORT SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8125' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '55' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'NEWPORT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Newport Sec 06' ,`TaxAmount` = '4299' ,`TaxRate` = '2.7105' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675105564' WHERE `Matrix_Unique_ID` = '214295572' --> 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','214635702','1675105565','214635702','2023-01-06T11:42:06.643','11334861','Jennifer Martin','All City Real Estate, Ltd. Co.','','','29.618243','-95.737559','22','77406','8','369000.00','Active','Fernglade','726','Drive','Richmond','2','1','3','2366','Single-Family','Amazing updated two-story home with huge pool in golf course community of Pecan Grove. BBQ/ Backyard Kitchen with fridge and TV. LARGE 1 bed down with full bathroom, jetted tub, separate shower. 2 bedrooms, jack n jill up, and huge room. Stone fireplace in living, crown molding, 5 1/4 baseboards, two-tone paint, Samsung stainless steel double oven, bosch dishwasher, and breakfast area. Black granite counters, custom cabinets. Huge Oversized 3-car garage, Motions lights/Ring at Garage and Backyard. Beautiful huge trees landscaped front yard, corner lot, zoned to award-winning Lamar Schools.','0.2','37','','','','','Home Protection Plan,Mud,Owner/Agent,Sellers Disclosure','1','','1','Fort Bend County North/Richmond','Central Gas','1','PECAN GROVE PLANTATION SEC 6, BLOCK 2, LOT 12','Corner','8712','Appraisal District','','209','0','','3','','1','Gunite,In Ground','','','','Composition','33 - Lamar Consolidated','AUSTIN ELEMENTARY SCHOOL (LAMAR)','LAMAR CONSOLIDATED HIGH SCHOOL','WESSENDORF/LAMAR JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox','Appraisal District','1.5','Ranch,Traditional','Pecan Grove Plantation Sec 6','5894','2.3298','Public Sewer,Public Water','1984','Appraisal'); --> 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','215425536','1675105565','215425536','2023-01-06T11:08:03.383','53751971','Ellis Young','CB&A, Realtors- Southeast','','','29.447169','-95.281105','26','77511','5','499999.00','Active','County Road 147','1148','','Alvin','2','0','4','1980','Single-Family','Quite the unique property with endless uses and possibilities. Over 4 acres of unrestricted land with easy access to Hwy 6. This property already has well and septic set up with the opportunity for another septic system. Huge workshop that is fully equipped to run a business out of, work on your own projects, store your toys, or make one hell of a mancave. 4 bed 2 bath Palm Harbor home already sits on the property. With the space you have you can build your forever home while have a place to live then rent out the existing home on the property. Own a great property with monthly income already established.','4.04','5','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Alvin North','Central Electric','0','A0412 A C H & B TRACT 6D-6A1A-6B1A ACRES 4.04','Cleared','175982','Appraisal District','','','0','','0','Electric Oven,Freestanding Oven','0','','','Electric Range','','Composition','3 - Alvin','HOOD-CASE ELEMENTARY SCHOOL','ALVIN HIGH SCHOOL','G W HARBY J H','Appointment Required','Builder','2','Traditional','A C H & B','4619','2.1307','Septic Tank,Well','2019','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','215652925','1675105565','215652925','2023-01-06T12:09:46.157','20634281','Patricia Mack','2011 AMERICAN REAL ESTATE CO.','','','29.873224','-93.954527','22','77640','6','130000.00','Active','Rev Raymond Scott','1821','Avenue','Port Arthur','1','1','3','920','Single-Family','Looking for that move in ready home? Completely updated, then Look No Further. No corner went untouched in this home. The roof is less than a yr. old, New A/C in and out, cherry shaker cabinets, Beautiful Island and all appliances are less than 2 yrs old. Check out this property before it\'s gone. It Wont last Long!','0.1607','51','','','','','Sellers Disclosure','','','','','Central Gas','0','LT 12 BLK 13 P A HTS','Corner','7000','Appraisal District','','','0','','2','','0','','','','','Composition','236 - Port Arthur','DEQUEEN ELEMENTARY SCHOOL','MEMORIAL HIGH SCHOOL (PORT ARTHUR)','LINCOLN MIDDLE SCHOOL (PORT ARTHUR)','Accompany,Appointment Required,Leave Business Card,Request Online Appointment','Builder','1','Traditional','Port Arthur Heights','1499','3.176','Public Sewer,Public Water','1968','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','215754924','1675105565','215754924','2023-01-06T11:42:11.480','90812195','Brett Stanaker','Fathom Realty','','','30.352343','-95.331024','46','77303','9','315000.00','Active','Firewood','15494','Drive','Conroe','2','0','4','1740','Single-Family','Nicely renovated home resting on 1.2 wooded acres with room to roam! Features include: fresh paint in/out, recent baseboards/trim, large den w/high ceiling & ceiling fan. Kitchen addition w/$10K tall custom wood cabinets, hard surface counters, new sink & vinyl floors. Big flex room/game room/extra bedroom off den w/barn door. New back door, new light fixtures, recent carpet & new closet doors throughout, hard vinyl floors in utility room, hallways & baths. Large bathroom w/double sinks, recent cabinets, extra long tub/shower, open shelves & high capacity water heater. All bedrooms w/ceiling fans & carpet. Large primary bedroom, primary bath w/pedestal sink & tub/shower. Geothermal central electric HVAC (5 yrs) & new windows throughout. Within last 6 mo: new roof, covered front porch stairs w/ceiling fan, covered back stairs, circular gravel driveway, 12x12 workshop on slab w/electric & ceiling fan, gate, perimeter fencing, lattice & stone masonry on house beams & mailbox. Low taxes!','1.2','19','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Conroe Northeast','Central Electric','0','OAK FOREST ESTATES 03, LOT 19, 20','Corner,Subdivision Lot,Wooded','52272','Appraisal District','','','0','','0','Electric Oven,Freestanding Oven','0','','','Electric Range,Freestanding Range','','Composition','11 - Conroe','AUSTIN ELEMENTARY SCHOOL (CONROE)','CANEY CREEK HIGH SCHOOL','MOORHEAD JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox,Vacant/Unoccupied','Appraisal','1','Traditional','Oak Forest Estates','2151','1.8488','Aerobic,Public Water,Septic Tank','1993','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','215765150','1675105565','215765150','2023-01-06T12:37:09.990','83567952','Robert Moore','Perry Homes Realty, LLC','','','30.271660','-95.472930','22','77304','6','414900.00','Active','Sand Branch','604','Drive','Conroe','2','0','3','1984','Single-Family','PERRY HOMES NEW CONSTRUCTION! Home office with French doors set at entry with 11-foot ceiling. Open kitchen offers center island and corner walk-in pantry. Dining area opens to spacious family room with wall of windows. Private primary suite includes bedroom with wall of windows. Dual vanity, corner garden tub, separate glass-enclosed shower and large walk-in closet in primary bath. Abundant closet space and natural light throughout. Covered backyard patio. Mud room off two-car garage.','','19','Perry Homes','','Washer Connections','','Mud','','','1','Conroe Southwest','Central Gas,Zoned','1','Grand Central Park 26, BLOCK 3, Lot','Subdivision Lot','5969','Other','','1180','1','To Be Built/Under Construction','2','Electric Oven,Single Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','WILKINSON ELEMENTARY SCHOOL','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Appointment Required,Request Online Appointment,Vacant/Unoccupied','Builder','1','Traditional','Grand Central Park','','3.066','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','215809208','1675105565','215809208','2023-01-06T12:40:18.730','97375738','Robert Moore','Perry Homes Realty, LLC','','','30.271830','-95.472890','17','77304','6','429900.00','Active','Sand Branch','627','Drive','Conroe','3','0','4','2169','Single-Family','PERRY HOMES NEW CONSTRUCTION! Extended entry with 12-foot ceiling leads to open kitchen dining area and family room with 10-foot ceilings throughout. Kitchen features walk-in pantry, generous counter space and inviting island with built-in seating space. Dining area features wall of windows. Family room features wall of windows. Primary suite with 10-foot ceiling and wall of windows. Double doors lead to primary bath with dual vanities, garden tub, separate glass-enclosed shower and large walk-in closet with access to utility room. A guest suite with private bath adds to this one-story design. Covered backyard patio. Mud room off two-car garage.','','19','Perry Homes','','Washer Connections','','Mud','','','0','Conroe Southwest','Central Gas,Zoned','1','Grand Central Park 26, BLOCK 1, Lot 6','Subdivision Lot','5400','Other','','1180','1','To Be Built/Under Construction','2','Electric Oven,Single Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','WILKINSON ELEMENTARY SCHOOL','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Appointment Required,Request Online Appointment,Vacant/Unoccupied','Builder','1','Traditional','Grand Central Park','','3.066','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','215809605','1675105565','215809605','2023-01-06T12:38:18.957','97180783','Robert Moore','Perry Homes Realty, LLC','','','30.271830','-95.472890','22','77304','6','484900.00','Active','Sand Branch','608','Drive','Conroe','3','0','4','2169','Single-Family','PERRY HOMES NEW CONSTRUCTION! Extended entry with 12-foot ceiling leads to open kitchen, dining area and family room with 10-foot ceilings throughout. Kitchen features center island. Family room features wall of windows. Primary suite with 10-foot ceiling and wall of windows. Dual vanities, garden tub, separate glass-enclosed shower and large walk-in closet in primary bath. A guest suite with private bath adds to this four-bedroom home. Covered backyard patio. Mud room off two-car garage.','','19','Perry Homes','','Washer Connections','','Mud','','','0','Conroe Southwest','Central Gas,Zoned','1','Grand Central Park 26, BLOCK 3, Lot 10','Subdivision Lot','5400','Other','','1180','1','To Be Built/Under Construction','2','Electric Oven,Single Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','WILKINSON ELEMENTARY SCHOOL','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Appointment Required,Request Online Appointment,Vacant/Unoccupied','Builder','1','Traditional','Grand Central Park','','3.066','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','215848526','1675105565','215848526','2023-01-06T12:17:25.313','78831005','Jacey-Kay Carter','Exit Realty Property Pros','','','30.140226','-93.807621','46','77632','4','465000.00','Active','FM 1078','1160','','Orange','2','0','4','2824','Single-Family','Looking for acreage out of city limits in the quiet country? This ranch style home has SO much to offer while sitting on almost +/-20 fenced in acres!! 6 of the 20 acres are wooded. NEVER FLOODED!!! 4 bedrooms, 2 full baths PLUS an bonus room! Raised ceiling throughout the living room and primary suites. This home is built for entertaining, not only does it have the interior space, but you\'ve got to check out the backyard! Covered back patio with concrete walk way to the in-ground Fiberglass pool, multiple fenced area for pets and livestock. 30 x 50 shop is only a couple years old, and of course don\'t miss the chicken coop and well shed! 2 year old geothermal HVAC system. Home is wired up for portable generator connection and workshop already has the plumbing ready for a bathroom. Make your appointment today, because there\'s still room for endless possibilities!','19.969','50','','','Electric Dryer Connections,Washer Connections','','Other Disclosures,Sellers Disclosure','1','Wood Burning Fireplace','1','','Central Electric','0','121 ABST. 121 BEN JOHNSON, TRACT 003, ACRES 18.969, PT OF AB','Cleared,Wooded','','Appraisal District','','','0','','2','Electric Oven','1','Fiberglass','','Electric Cooktop,Electric Range','','Composition','270 - West Orange-Cove Consolidated','WEST ORANGE-STARK ELEMENTARY SCHOOL','WEST ORANGE-STARK HIGH SCHOOL','WEST ORANGE-STARK MIDDLE SCHOOL','Appointment Required,Lockbox Back','Appraisal District','1','Ranch','Ben Johnson','4906','1.9725','Aerobic,Well','1986','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','215913910','1675105565','215913910','2023-01-06T11:52:07.180','54927112','Tammy Fruge','Westin Homes','','','30.399449','-95.508883','26','77318','18','674957.00','Active','Harbour Hills','114','Drive','Conroe','4','1','5','3759','Single-Family','Westin Homes NEW Construction (Carter XL, Elevation B) CURRENTLY B