Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-15T06:25:57.157' ,`MLSNumber` = '36059227' ,`ListAgentFullName` = 'Michelle Falgoust' ,`ListOfficeName` = 'The Discovery Group, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.843626' ,`Longitude` = '-95.479107' ,`PhotoCount` = '31' ,`PostalCode` = '77092' ,`RoomCount` = '11' ,`ListPrice` = '339900.00' ,`Status` = 'Active' ,`StreetName` = 'Golden Forest' ,`StreetNumber` = '6010' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2120' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UPDATE: New HVAC system (Inside and out) added 6/29/2022!\r\nProperty has been updated with new stainless kitchen appliances, new granite kitchen countertops, new kitchen sink and faucet, new bar and kitchen vent hood, new cooktops, new ceiling fans, new door hardware, new water heater, new protective garage floor coating, new entry room tile, new bathroom tile and countertops and updated front landscape.' ,`Acres` = '0.168' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Reports Available,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 397 BLK 11 FOREST WEST SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7319' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '197' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WAINWRIGHT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Left Side,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Forest West' ,`TaxAmount` = '4646' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663710776' WHERE `Matrix_Unique_ID` = '199746964' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-15T07:30:59.330' ,`MLSNumber` = '84922567' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.270203' ,`Longitude` = '-95.475957' ,`PhotoCount` = '14' ,`PostalCode` = '77304' ,`RoomCount` = '6' ,`ListPrice` = '659938.00' ,`Status` = 'Active' ,`StreetName` = 'Cibolo Creek' ,`StreetNumber` = '631' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2630' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 84922567 - Built by Drees Custom Homes - October completion! ~ The Sawyer is a multifaceted single-level layout that includes three bedrooms, a media room with wine bar, and an open living triangle. The great room and kitchen offer classic features such as a vaulted beam ceiling, fireplace, walk-in pantry and pocket office. This home has it all!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Drees Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas,Propane' ,`HOAMandatory` = '1' ,`Legal` = 'S537520 - GRAND CENTRAL PARK 20, BLOCK 4, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7906' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Central Park' ,`TaxAmount` = '' ,`TaxRate` = '3.16' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663710776' WHERE `Matrix_Unique_ID` = '205793101' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-15T07:31:22.607' ,`MLSNumber` = '50320813' ,`ListAgentFullName` = 'Ronald Black' ,`ListOfficeName` = 'Texas Investor Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.201642' ,`Longitude` = '-95.429081' ,`PhotoCount` = '36' ,`PostalCode` = '77385' ,`RoomCount` = '6' ,`ListPrice` = '419900.00' ,`Status` = 'Active' ,`StreetName` = 'Sweet Flag' ,`StreetNumber` = '9836' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2454' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOVE IN READY! NEVER LIVED IN! Former MODEL HOME with extended (2.5 car) garage, full sprinkler system, covered patio and GAME room! Gorgeous and Spacious 4 bedroom, 2.5 bath beauty with an upstairs GAME ROOM! Bring ALL your toys as this home is complete with an oversize Garage Extension! Enjoy preparing you favorite meals in the kitchen, fully equipped with large island bar, quartz-like countertops and tile backsplash with stainless steel appliances! Unwind in the spa-like primary suite, which boasts dual vanities, soaking tub, walk-in shower and large walk-in closet. You will love the quick access to The Woodlands and shopping. BONUS: Seller will INCLUDE Washer & Dryer PLUS Refrigerator with acceptable offer! COME SEE YOUR BEAUTIFUL HOME TODAY! Builder will be out by October 1st!' ,`Acres` = '0.1606' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S572710 - HARPER\'S PRESERVE 10, BLOCK 1, LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6994' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1128' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harper\'s Preserve' ,`TaxAmount` = '7826' ,`TaxRate` = '3.0088' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663710776' WHERE `Matrix_Unique_ID` = '206587259' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-15T07:17:01.137' ,`MLSNumber` = '58802742' ,`ListAgentFullName` = 'Allen Hebert' ,`ListOfficeName` = 'Register Real Estate Advisors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.176904' ,`Longitude` = '-95.158229' ,`PhotoCount` = '19' ,`PostalCode` = '77357' ,`RoomCount` = '10' ,`ListPrice` = '359990.00' ,`Status` = 'Active' ,`StreetName` = 'Fountain View' ,`StreetNumber` = '2706' ,`StreetSuffix` = '' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1942' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UC - Located in popular Roman Forest Large 4 bedrooms or 3 bedrooms with study. 2 full Baths. Craftsman style front door.White Brick on 3 sides w/white mortar and dark brown trim on Exterior. Vinyl plank throughout main areas, halls, and second bathroom. Carpet in bedrooms and closets. -Tile in master bath floor and shower surround. Double pane Vinyl windows. Kitchen and bathrooms solid surface top (Silestone),Kitchen backsplash 3x12 tile on broken joint, Job built custom cabinets to the ceiling, SS Appliances. Gas heater, stove, Furness, fireplace & dryer. High efficiency 16 seer AC, Batt Walls R13, Slope ceiling R19, and Attic blown R38., Moen Faucets (chrome). Interior paint light grey with white trim, Baseboard 1x4 with 1x4 Casing, 8’ Interior doors with 6” base and 3 1/2 casing. . Gas Fireplace. Garage door Opener, Kitchen features Breakfast bar. Covered front porch. Enjoy the 12\'x11\' covered back patio. Front of home gutters Fantastic location,30 Year Architectural shingles' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'M. Taylor Custom Hom' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S839701 - Roman Forest 01, BLOCK 16, Lot 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '18095' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'DOGWOOD ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Roman Forest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663710776' WHERE `Matrix_Unique_ID` = '207698375' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-15T06:21:41.523' ,`MLSNumber` = '21445991' ,`ListAgentFullName` = 'Tod Franklin' ,`ListOfficeName` = 'DFWCityhomes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.710788' ,`Longitude` = '-95.369159' ,`PhotoCount` = '13' ,`PostalCode` = '77004' ,`RoomCount` = '15' ,`ListPrice` = '950000.00' ,`Status` = 'Active' ,`StreetName` = 'Bayou Bend' ,`StreetNumber` = '5806' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '7' ,`BathsHalf` = '0' ,`BedsTotal` = '7' ,`SqFtTotal` = '5383' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a beautiful large lot overlooking Braes Bayou on a cul de sac off of North Mac Gregor Drive between the Texas Medical Center and University of Houston. Two-thirds of the cul de sac is being developed by the City of Houston into a bird sanctuary. The back property line is the Braes Bayou hike and bike trial. Whether the property is redeveloped into a townhouse complex or the house is remodeled, there are many options for this magnificent piece of property. The House was divided up into apartments but now the living spaces are connected. The house did not flood in Tropical Storm Allison or Hurricane Harvey.' ,`Acres` = '0.6153' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Riverside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 7 BLK 4 NORTH MACGREGOR OAKS' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot,Water View' ,`LotSize` = '26804' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOCKHART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'North Macgregor Oaks' ,`TaxAmount` = '9084' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1951' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663710776' WHERE `Matrix_Unique_ID` = '207713015' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-15T07:48:05.677' ,`MLSNumber` = '39056307' ,`ListAgentFullName` = 'Dana Olejniczak' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.030297' ,`Longitude` = '-95.223204' ,`PhotoCount` = '50' ,`PostalCode` = '77339' ,`RoomCount` = '24' ,`ListPrice` = '5490000.00' ,`Status` = 'Active' ,`StreetName` = 'Deer Ridge Estates' ,`StreetNumber` = '8' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Kingwood' ,`BathsFull` = '7' ,`BathsHalf` = '4' ,`BedsTotal` = '6' ,`SqFtTotal` = '17331' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for resort living? Come out to Kingwood where you can spread out in this Crown Jewell Estate! 25 minutes to Downtown, 5 minutes to 59 and 10 to Grand Prkwy 99-all in a safe & secured, 24 hour manned gated community. This remarkable home with over 17,000 square feet is such a wonderful opportunity only found outside of the city with room to relax and enjoy the Livable Forest. Resting on 4 wooded acres peppered with fruit trees, beauty engulfs this classic masterpiece at every turn. This iconic home makes a statement from the moment you drive into the gates and see the stunning house on the hill to the back manicured grounds with lighted tennis courts and refreshing pool. Inside find a basketball half court, distinct modern Gentlemen’s Trophy room massive in size boasting two story ceilings and extensive architectural detail, 2 separate his/her Primary bathrooms, wet and dry sauna, work out room, elevator, billiards room with full bar, 2 kitchens and separate guest quarters.' ,`Acres` = '4' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '7' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7, 8, 9, 10, Blk 4' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '174240' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '6050' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'FOSTER ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Other Style' ,`Subdivision` = 'Deer Ridge Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663710777' WHERE `Matrix_Unique_ID` = '207732153' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-15T07:52:00.123' ,`MLSNumber` = '45376296' ,`ListAgentFullName` = 'Pamela DeBlasio' ,`ListOfficeName` = 'Lake Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.742313' ,`Longitude` = '-95.089296' ,`PhotoCount` = '29' ,`PostalCode` = '77351' ,`RoomCount` = '5' ,`ListPrice` = '410000.00' ,`Status` = 'Active' ,`StreetName` = 'Harbor Addition' ,`StreetNumber` = '188' ,`StreetSuffix` = 'Drive' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '2619' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WATERVIEW!!! Highly desirable neighborhood, unobstructed water views and vacation rental friendly. The home has been updated with custom finishes throughout: Wood-look tile floors, granite counters, S/S appliances, reclaimed barn wood clad ceilings, tile and stone bathroom finishes. Garage apartment has separate entrance for privacy. Convenient lake access just a couple of blocks away at the entrance of the subdivision. This is the perfect lake getaway without the upkeep. Call today for an appointment!' ,`Acres` = '0.2064' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'INDIAN HILL HARBOR LOT 45' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot,Water View' ,`LotSize` = '8989' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '75' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Indian Hill Harbor Addition' ,`TaxAmount` = '4409' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663710777' WHERE `Matrix_Unique_ID` = '208144972' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-15T07:46:59.720' ,`MLSNumber` = '31412492' ,`ListAgentFullName` = 'Teresa Hill McCray' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.821114' ,`Longitude` = '-95.118145' ,`PhotoCount` = '8' ,`PostalCode` = '77360' ,`RoomCount` = '3' ,`ListPrice` = '70000.00' ,`Status` = 'Active' ,`StreetName` = 'Holly' ,`StreetNumber` = '286' ,`StreetSuffix` = 'Drive' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Property is located in Onalaska. Dimensions will need to be verified. This home is currently occupied, PLEASE DO NOT DISTURB THE TENANT. The property is included in a portfolio listing. Home is being sold \"As Is\". \r\nPer Seller, Mobile Home is 16 x 75. Year of home to be verified.' ,`Acres` = '0.3373' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'CANYON PARK SECTION 2 LOT 414' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14692' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Canyon Park Sec 2' ,`TaxAmount` = '88' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663710777' WHERE `Matrix_Unique_ID` = '208575671' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-15T06:23:45.840' ,`MLSNumber` = '35020403' ,`ListAgentFullName` = 'Tod Franklin' ,`ListOfficeName` = 'DFWCityhomes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.112544' ,`Longitude` = '-95.420351' ,`PhotoCount` = '40' ,`PostalCode` = '77386' ,`RoomCount` = '8' ,`ListPrice` = '619000.00' ,`Status` = 'Active' ,`StreetName` = 'Plum Creek' ,`StreetNumber` = '29003' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a flexible property in a multi-use commercial neighborhood in South Montgomery County near medical, retail, national corporate firms and entertainment venues.The 3 bedroom, 2.5 Bath Downstairs includes an income producing apartment, 900 square feet above the 2-car garage, entirely separate entrance.' ,`Acres` = '1.2652' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'SPRING HILLS 02, LOT 167' ,`LotDesciption` = 'Wooded' ,`LotSize` = '55110' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'FORD ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Spring Hills 02' ,`TaxAmount` = '4556' ,`TaxRate` = '1.8487' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663710777' WHERE `Matrix_Unique_ID` = '208763448' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-15T07:45:13.640' ,`MLSNumber` = '42102427' ,`ListAgentFullName` = 'Jarred DeMore' ,`ListOfficeName` = 'Keller Williams SoutheastTexas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.469034' ,`Longitude` = '-94.602951' ,`PhotoCount` = '47' ,`PostalCode` = '77650' ,`RoomCount` = '6' ,`ListPrice` = '649000.00' ,`Status` = 'Active' ,`StreetName` = 'Mary Lynn' ,`StreetNumber` = '966' ,`StreetSuffix` = '' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1812' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Motivated Seller-Sandy Shores Dream Home! Fully furnished and awesome amenities for a popular rental! Awesome beach side cottage with 4 spacious bedroom-sleeps 16 in beds very comfortably! Open LR/DR/Kit concept! Large deck & green space behind house offers lovely views of the sunrise and beautiful beach views! Electric fp in living, huge kit with tons of cabinets and work island that\'s spacious for a large crowd! Roomy baths! Custom barn-door laundry closet in super spacious 4th bedroom with its own private door to deck! Downstairs offers tons of space for entertaining at the awesome tiki bar, large sand shower with custom surfboard shower head feature, plenty of parking! This dream home is perfect for full-time living, part-time vacay or full-time rental! Great rental history! Comes furnished and ready for your guests! Close to shopping, ferry, churches, restaurants and more!' ,`Acres` = '0.322' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 65 PAGE 7 LOTS 31 SANDY SHORES' ,`LotDesciption` = 'Water View' ,`LotSize` = '14026' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sandy Shores' ,`TaxAmount` = '6557' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663710777' WHERE `Matrix_Unique_ID` = '209645535' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-15T06:33:23.233' ,`MLSNumber` = '28927119' ,`ListAgentFullName` = 'Tod Franklin' ,`ListOfficeName` = 'DFWCityhomes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.660401' ,`Longitude` = '-95.578083' ,`PhotoCount` = '25' ,`PostalCode` = '77099' ,`RoomCount` = '9' ,`ListPrice` = '258000.00' ,`Status` = 'Active' ,`StreetName` = 'Windmark' ,`StreetNumber` = '11231' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2306' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Large brick house w/ attached daycare unit; now remodeled. Roof, A/C, water heater all replaced 3-5 years ago. Additional partially covered patio plus covered storage area so big it spans the entire side of the house w/ electric and plumbing. All 4 bedrooms have 1 or 2 walk-in closets. Double wide & double length driveway. 2 Attics. Corner lot. Low HOA includes Pool, courts, playground, long trail. Never flooded/ no frozen pipes' ,`Acres` = '0.1198' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'HOA First Right of Refusal' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Stafford Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 3 BAYOU PLACE R/P' ,`LotDesciption` = 'Corner' ,`LotSize` = '5220' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '30' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'SMITH ELEMENTARY SCHOOL (ALIEF)' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'OLLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Bayou Place R/P' ,`TaxAmount` = '4354' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663710777' WHERE `Matrix_Unique_ID` = '209820752' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-15T06:54:35.667' ,`MLSNumber` = '66027304' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = 'Victor Jaramillo' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '30.293985' ,`Longitude` = '-95.561277' ,`PhotoCount` = '38' ,`PostalCode` = '77316' ,`RoomCount` = '5' ,`ListPrice` = '719990.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Everest' ,`StreetNumber` = '171' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3509' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This breathtaking Woodforest home was thoughtfully constructed by the esteem Highland Homes in 2/22 and was lightly lived in for just 2-3 months. Sitting at 3,500SF of luxurious living space, this 2-Story beauty offers a majestic, 4-sides white brick elevation w/ cedar accents, a 4-Car Garage, 4 Bedrooms| 4.5 Baths, Formal Study on the first floor, Game Room & Media Upstairs, and an over-sized Primary Bedroom, accompanied by a private en-suite w/ a garden tub and large walk-in shower. The kitchen is elegantly designed, featuring white quartz surfaces, ample cabinetry & built-in stainless appliances. Your dining space overlooks a spacious family room, highlighted by a floor-to-ceiling brick fireplace & 10ft sliding glass doors that lead to an extended, covered patio. This corner lot location offers optimal location to enjoy the park right across the street. Woodforest is an amenity-rich community with an award winning design & vibrant community life!' ,`Acres` = '0.1859' ,`Area` = '39' ,`BuilderName` = 'Highland' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S965283 - WOODFOREST 83, BLOCK 1, LOT 3' ,`LotDesciption` = 'Corner,Subdivision Lot,Wooded' ,`LotSize` = '8098' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest 83' ,`TaxAmount` = '971' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663710777' WHERE `Matrix_Unique_ID` = '209946953' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-15T07:46:22.730' ,`MLSNumber` = '93586007' ,`ListAgentFullName` = 'Jim Bell' ,`ListOfficeName` = 'RCR Properties Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.286223' ,`Longitude` = '-94.229531' ,`PhotoCount` = '14' ,`PostalCode` = '77657' ,`RoomCount` = '4' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'W Walton Rd' ,`StreetNumber` = '1495' ,`StreetSuffix` = '' ,`City` = 'Lumberton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2065' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home less than 3 years old sitting on almost 2 acres of land. It offers 4 bedroom and 2 bathrooms. Kitchen is open concept that has a oversized island a must see!!! Master bedroom is very large along with bathroom and closet. Property is cleared and has a newly built fence in the front with trees covering it from the back. There was also a shop built on property that could be used as a mother in law area.' ,`Acres` = '' ,`Area` = '49' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PT OF LOTS 9 & 10 BLK G BEAUMONT COLONY SOUTH P# K33-G-9 I#' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '154 - Lumberton' ,`SchoolElementary` = 'LUMBERTON PRIMARY SCHOOL' ,`SchoolHigh` = 'LUMBERTON HIGH SCHOOL' ,`SchoolMiddle` = 'LUMBERTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Beaumont Colony South' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663710778' WHERE `Matrix_Unique_ID` = '210061350' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-15T07:58:38.950' ,`MLSNumber` = '32145172' ,`ListAgentFullName` = 'Raymond Aguilar' ,`ListOfficeName` = 'J.L. Wyatt Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.375700' ,`Longitude` = '-95.530633' ,`PhotoCount` = '25' ,`PostalCode` = '77304' ,`RoomCount` = '6' ,`ListPrice` = '299999.00' ,`Status` = 'Active' ,`StreetName` = 'Sound' ,`StreetNumber` = '7026' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1766' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the Lake Conroe area and the stunning waterfront community Water Crest on Lake Conroe! Beautifully built in 2018 by D.R. Horton but never lived in until 2019, this single-story house features 4 bedrooms, 2 full bathrooms, a 2-car garage, and a private covered back patio! The entry foyer opens to lovely laminate floors that flow throughout most of the beautiful open concept floorplan. The kitchen offers a large island and breakfast bar that opens into the dining area and family room, perfect for entertaining! The fantastic split floor plan places the large primary bedroom tucked away in the back of the home for privacy. The en-suite features dual sinks, a garden tub, separate shower, and walk in closet! The great back yard space is fully fenced, has the covered back patio, and there are no back neighbors to share a fence with! Water Crest on Lake Conroe amenities include a resident\'s use boat launch, two resort style pools, ponds, clubhouse, and a pier into the Lake!' ,`Acres` = '0.1382' ,`Area` = '39' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S954413 - WATER CREST ON LAKE CONROE 13, BLOCK 2, LOT 51' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6021' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'LAGWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Water Crest On Lake Conroe 13' ,`TaxAmount` = '6215' ,`TaxRate` = '3.0823' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663710778' WHERE `Matrix_Unique_ID` = '211508389' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-15T07:17:16.220' ,`MLSNumber` = '73299451' ,`ListAgentFullName` = 'Luis Salazar' ,`ListOfficeName` = 'Jane Byrd Properties INTL.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.935451' ,`Longitude` = '-94.846037' ,`PhotoCount` = '48' ,`PostalCode` = '77535' ,`RoomCount` = '3' ,`ListPrice` = '214999.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 440' ,`StreetNumber` = '553' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1456' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '1.342' ,`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` = 'THE RANCH, SEC 3, LOT 114, ACRES 1.342, MH LABEL# PFS0818857' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '58458' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'KIMMIE M. BROWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'The Ranch, Sec 3' ,`TaxAmount` = '2431' ,`TaxRate` = '1.7507' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663710778' WHERE `Matrix_Unique_ID` = '211588639' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-15T07:34:44.000' ,`MLSNumber` = '36361207' ,`ListAgentFullName` = 'Maria Pugh' ,`ListOfficeName` = 'i Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.159480' ,`Longitude` = '-95.684124' ,`PhotoCount` = '39' ,`PostalCode` = '77362' ,`RoomCount` = '7' ,`ListPrice` = '289900.00' ,`Status` = 'Active' ,`StreetName` = 'High Oak' ,`StreetNumber` = '727' ,`StreetSuffix` = 'Lane' ,`City` = 'Pinehurst' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1064' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Oak Hill Acres, 2022 built manufactured beautiful home. Large lot, almost a half acre corner lot deep in the subdivision. Property includes also a metal frame building 50x30 work shop/warehouse. Large mature trees, septic and well water. No HOA, low taxes and few restrictions. Montgomery County and Magnolia ISD. Tour it today, excellent opportunity.' ,`Acres` = '0.4385' ,`Area` = '15' ,`BuilderName` = 'FHB' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S751000 - OAK HILL ACRES 01, LOT 50, SERIAL TXFL1AC181207013' ,`LotDesciption` = 'Corner' ,`LotSize` = '19100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Hill Acres 01' ,`TaxAmount` = '449' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663710778' WHERE `Matrix_Unique_ID` = '211647669' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-15T07:49:44.703' ,`MLSNumber` = '92303565' ,`ListAgentFullName` = 'Scott Miller' ,`ListOfficeName` = 'RE/MAX Signature Galleria' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.463471' ,`Longitude` = '-95.543025' ,`PhotoCount` = '8' ,`PostalCode` = '77318' ,`RoomCount` = '3' ,`ListPrice` = '154900.00' ,`Status` = 'Active' ,`StreetName` = 'Persimmon' ,`StreetNumber` = '11523' ,`StreetSuffix` = 'Street' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '988' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '10\' ceilings in kitchen/Living, beautiful open concept. Spacious kitchen with 42\" upper cabinets with granite countertops. Bedrooms with huge walk-in closet. Great lighting and all LED! Samsung Stainless Steel appliance package including easy clean top range with electric oven, 3 rack dishwasher, and microwave. 1 year warranty on appliances from Samsung. Ask agent about preferred lender benefits.' ,`Acres` = '0.2029' ,`Area` = '39' ,`BuilderName` = 'Starter Homes of TX' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WALNUT COVE 02, BLOCK 4, LOT 76' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8838' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '51' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'PARMLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Walnut Cove 02' ,`TaxAmount` = '1820' ,`TaxRate` = '1.8448' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663710778' WHERE `Matrix_Unique_ID` = '211983155' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-15T07:48:41.837' ,`MLSNumber` = '98668200' ,`ListAgentFullName` = 'Scott Miller' ,`ListOfficeName` = 'RE/MAX Signature Galleria' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.463467' ,`Longitude` = '-95.543042' ,`PhotoCount` = '9' ,`PostalCode` = '77318' ,`RoomCount` = '3' ,`ListPrice` = '154900.00' ,`Status` = 'Active' ,`StreetName` = 'Persimmon' ,`StreetNumber` = '11529' ,`StreetSuffix` = 'Street' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '988' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '10\' ceilings in kitchen/Living, beautiful open concept. Spacious kitchen with 42\" upper cabinets with granite countertops. Bedrooms with huge walk-in closet. Great lighting and all LED! Samsung Stainless Steel appliance package including easy clean top range with electric oven, 3 rack dishwasher, and microwave. 1 year warranty on appliances from Samsung. Ask agent about preferred lender benefits.' ,`Acres` = '0.2029' ,`Area` = '39' ,`BuilderName` = 'Starter Homes of TX' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WALNUT COVE 02, BLOCK 4, LOT 78' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8838' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '51' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'PARMLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Walnut Cove 02' ,`TaxAmount` = '1820' ,`TaxRate` = '1.8448' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663710778' WHERE `Matrix_Unique_ID` = '211983922' --> 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','212145238','1663710778','212145238','2022-09-15T07:55:32.737','54123526','Steven Kinne','Compass RE Texas, LLC','Sheysa Padilla','REALM Real Estate Professional','30.010463','-95.379166','36','77073','10','269900.00','Option Pending','Thorne Creek','3030','Lane','Houston','2','1','4','2358','Single-Family','Fantastic 4 bedroom, 2.5 bath home located in the Community of Woodcreek! This home is super clean with neutral colors throughout, crown moulding, LVP and tile downstairs with carpet flooring upstairs and updated fixtures too! Your kitchen has crisp white cabinetry, Granite countertops, sleek black appliances plus is open to the living area which makes it great for entertaining or keeping an eye on the kids. Primary suite has tile surround shower and tub combo, double sinks, tons of storage and walk-in closet. You have a fantastic private fenced backyard with no back neighbors, with a covered patio, and lots of mature trees for shade! You also have gutters, a 2-car garage and a fantastic covered front porch. Your home is located near major roadways to make your commute a breeze, call for an appointment today!','0.1912','12','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections','1','Aldine Area','Central Gas','1','LT 152 BLK 5 WOODCREEK SEC 1','Subdivision Lot','8330','Appraisal District','','575','0','','2','Electric Oven,Single Oven','0','','','Electric Cooktop','','Composition','1 - Aldine','DUNN ELEMENTARY SCHOOL (ALDINE)','NIMITZ HIGH SCHOOL (ALDINE)','TEAGUE MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Traditional','Woodcreek','4812','2.6145','Public Sewer,Public Water,Water District','1980','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','212151244','1663710778','212151244','2022-09-15T07:27:14.723','92791123','Lauren Friese','Tilbury Real Estate Advisors','','','29.824355','-95.471470','38','77092','8','389999.00','Active','Lamonte','5406','Lane','Houston','2','0','3','1408','Single-Family','New renovations accenting the natural light and flowing floorplan. The freshly painted light modern gray interior, with 2\" white blinds compliments the white base boards framing gray washed laminate floors throughout the design scheme. The bedrooms with fresh carpet & ceiling fans lights. & great closets The spa inspired bathrooms: granite counter tops, shaker cabinetry, subway tile backsplash and porcelain tile. The kitchen\'s chic custom built in white cabinetry, with satin nickel pulls; salt & pepper granite counter & subway tile backsplash. The energy efficient Frigidaire stainless steel dishwasher, microwave and \"wonder stove\" with gas range and convection oven/ Air Fryer. Other energy efficient features new electrical panel grounding and components, recessed lighting, digital thermostats, insulated doors and Low E windows. Don\'t forget the exterior details fresh paint and hardi & designer minimalist landscaping & Covered Porches and deck. Home warranty included!!','0.1515','9','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Oak Forest West Area','Central Electric,Central Gas','0','LT 8 BLK 11 MANGUM MANOR SEC 2 R/P','Cleared,Cul-De-Sac','6600','Appraisal District','','','0','','2','Convection Oven,Electric Oven,Freestanding Oven','0','','','Freestanding Range,Gas Cooktop,Gas Range','','Composition','27 - Houston','WAINWRIGHT ELEMENTARY SCHOOL','SCARBOROUGH HIGH SCHOOL','CLIFTON MIDDLE SCHOOL (HOUSTON)','Appointment Required,Lockbox Front','Appraisal District','1','Ranch','Mangum Manor Sec 02 R/P','5649','2.3307','Public Sewer,Public Water','1959','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','212158920','1663710778','212158920','2022-09-15T07:57:15.693','65689172','Edward McClintick','Joseph Walter Realty, LLC','','','35.660156','-101.402624','6','79007','5','80000.00','Active','Madison','1112','Street','Borger','2','0','4','1426','Single-Family','Amazing opportunity for an investor OR homeowner that wants instant equity. NEW ROOF! 1 year old, get straight to cosmetics and give this home your touch.','0.2346','87','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','','','','','Other Heating','0','15 BLK 1 WESTOVER HILLS','Subdivision Lot','10220','Appraisal District','','','0','','1','Convection Oven','0','','','Electric Cooktop,Gas Range','','Composition','357 - Borger','','BORGER HIGH SCHOOL','BORGER MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Other Style','Westover Hills','1936','3.0714','Public Sewer,Public Water','1950','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212186545','1663710778','212186545','2022-09-15T07:52:45.740','72277450','Pamela DeBlasio','Lake Homes Realty, LLC','','','30.744130','-95.087070','48','77351','9','465000.00','Active','Bluff','210','Drive','Livingston','2','0','3','2084','Single-Family','Beautifully remodeled home with an incredible waterviews. This home sits on the street above the waterfront giving you views above the homes below. Spacious and level back and side yards including raised planter boxes perfect for the weekend gardener. Relax and enjoy spending your days on the expansive back deck with access from the kitchen and family room as well as private access from the primary suite. Open-concept kitchen with breakfast area and family room complete with fireplace. Additional dining space with French doors leading to the deck and open to the den area. This home has great entertaining spaces with high ceilings and nice flow to the layout. Primary suite has custom wood ceilings and a large ensuite bathroom. Great neighborhood located on the prized south end of Lake Livingston with access to a free double boat launch. Just a quick 10 minutes from Downtown Livingston for all of your shopping, dining and entertaining needs. Call today for an appointment!','0.3235','44','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Lake Livingston Area','Central Electric','0','INDIAN HILL ESTATES SECTION 2 BLK 4 LOT 1 & 2 PT','Cleared,Subdivision Lot,Water View','14092','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Range','','Composition','103 - Livingston','LISD OPEN ENROLL','LIVINGSTON HIGH SCHOOL','LIVINGSTON JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','Indian Hill Estates','6253','1.8745','Aerobic,Public Water','2003','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','212284039','1663710779','212284039','2022-09-15T06:17:29.430','27331104','Tod Franklin','DFWCityhomes','','','30.181760','-95.157527','48','77357','11','630000.00','Active','Colosseum','2642','Court','New Caney','3','0','5','3306','Single-Family','Gorgeous bedroom home with so much space! Move in ready! Beautiful granite counter tops, Harwood floors, tile and carpet throughout out the home. Each bedroom has its own walk-in closet and ceiling fans. So much storage space! Very well kept and clean. The yard is landscaped up front and partial in the back. There is so much potential you could install a pool. There is a back up generator that provides for the entire house. Two AC/heat units.','0.4711','40','','','','','Sellers Disclosure','1','Gas Connections,Wood Burning Fireplace','1','Porter/New Caney East','Central Electric,Central Gas','0','Roman Forest 02, BLOCK 4, LOT 6','Corner,Subdivision Lot,Wooded','20520','Appraisal District','','','0','','','','0','','','','','Built Up,Composition,Wood Shingle','39 - New Caney','DOGWOOD ELEMENTARY SCHOOL (NEW CANEY)','NEW CANEY HIGH SCHOOL','KEEFER CROSSING MIDDLE SCHOOL','Appointment Required,No Supra Keybox','Seller','2','Ranch','Roman Forest SEC #02','9848','2.9064','Public Sewer,Public Water','2016','Seller'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212290170','1663710779','212290170','2022-09-15T07:00:52.153','4000097','Sherry Zuniga','Sparrow Realty','','','29.776056','-95.372655','41','77007','9','675000.00','Active','Ovid','1506','Street','Houston','2','0','3','1431','Single-Family','2 great homes on 1 oversized corner lot in the Heart of Houston\'s Art District with private parking. Both homes feature open concept kitchen with lots of modern touches. Tastefully furnished with pops of color. House #1 features high ceilings with stainless-steel appliances, quartz counter tops & a breakfast bar. You\'ll love the clean lines & open shelving. House #2 was completely remodeled in 2021, features 11-foot ceilings, stainless-steel appliances & granite countertops along with a dedicated work space. Charming neighborhood with tons of character, just a few streets from Jones Park. Conveniently located to Houston biking trails, Dining, Parks, Theaters, Universities, Texas Medical Center, Houston Ballet, several Community Gardens & so much more. No HOA & low taxes on this Residence. All appliances stay along with stackable washer & dryer. Income producing. Don\'t miss your chance at home ownership while producing income.','0.1383','9','','','Gas Dryer Connections,Washer Connections','','Exclusions,Other Disclosures,Sellers Disclosure,Tenant Occupied','','','','Washington East/Sabine','Central Electric','0','LT 3 BLK 1 TRUXILLO GARDENS','Cleared,Corner','6026','Appraisal District','','','0','','0','Gas Oven','0','','','Gas Range','','Composition,Other','27 - Houston','CROCKETT ELEMENTARY SCHOOL (HOUSTON)','HEIGHTS HIGH SCHOOL','HOGG MIDDLE SCHOOL (HOUSTON)','Accompany,Appointment Required,Leave Business Card,Supra Keybox','Seller','1','Traditional','Truxillo Gardens','7024','2.3307','Public Sewer,Public Water','1926','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','212325576','1663710779','212325576','2022-09-15T06:19:52.527','74247960','Tod Franklin','DFWCityhomes','','','29.716434','-95.750051','29','77450','11','432000.00','Active','Winlock Trace','20826','Drive','Katy','2','1','4','3000','Single-Family','New roof! New Carpet! Gas stove less than 1 year old. Water heater is about 2.5 years old. Master bedroom on the first floor. Granite countertops for kitchen and all bathrooms. Kitchen cabinets with pull out drawers, stainless appliances, oven, 5 burner gas cooktop. Huge storage. Huge game room up. Top schools, near to Beck Jr High and community pool. Close to Explore Park which is a pretty place for kids play and Party. The community offers swimming pools, tennis courts, volleyball & basketball courts, and Golf courses. Residents can access the 7 swimming pools (including beach club and water parks) in summer and 17 tennis courts year round','0.1852','36','','','','','Sellers Disclosure','','','1','Katy - Southeast','Central Gas','1','CINCO RANCH MEADOW PLACE SEC 5, BLOCK 2, LOT 36','Subdivision Lot','8069','Other','','','0','','2','','0','','','','','Composition','30 - Katy','CREECH ELEMENTARY SCHOOL','CINCO RANCH HIGH SCHOOL','BECK JUNIOR HIGH SCHOOL','Appointment Required,No Supra Keybox','Seller','2','Traditional','Cinco Ranch Meadow Place Sec 5','7602','2.4662','Public Sewer,Public Water,Water District','1999','Seller'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212413948','1663710779','212413948','2022-09-15T07:15:29.020','35586075','Brandy Mayr','RE/MAX Northwest, REALTORS','','','30.203742','-96.028402','26','77445','4','304000.00','Active','Park View','38484','Drive','Hempstead','2','1','4','2373','Single-Family','Beautiful 2020 build, 4 bedroom, 2,373 square foot home in the gated Deerwood Lakes Subdivision of Hempstead. This home features an open floor plan in the kitchen/living room/dining. High ceilings, granite countertops, stainless steel appliances, spacious primary bed/bath, garden tub, glass encased shower, his/her vanities. The home also features a gameroom and home office, large windows for abundant natural light throughout. 3 CAR GARAGE. Deerwood amenities include Lakes, HUGE Park, Pool & clubhouse. Hempstead has fine schools, parks, and a low cost of living/family friendly area with country style living. Build in Deerwood OR let us help you find the best location for your home in Waller County. You can live in an area where you have neighbors nearby or enjoy your solitude with some acreage surrounding you.','0.2593','26','','','','','No Disclosures','','','','Waller','Central Electric','1','S455300 DEERWOOD LAKES 3 LOT 14','Subdivision Lot','11295','Appraisal District','','110','0','','3','','0','','','','','Composition','55 - Waller','FIELDS STORE ELEMENTARY SCHOOL','WALLER HIGH SCHOOL','SCHULTZ JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','2','Ranch','Deerwood Lakes','5185','2.0243','Aerobic,Public Water,Septic Tank','2020','Appraisal District'); --> New record created successfully