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-12-07T10:17:31.100' ,`MLSNumber` = '75524347' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.766045' ,`Longitude` = '-95.250155' ,`PhotoCount` = '28' ,`PostalCode` = '77029' ,`RoomCount` = '3' ,`ListPrice` = '169999.00' ,`Status` = 'Active' ,`StreetName` = 'Wiggins' ,`StreetNumber` = '10141' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '902' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is in a great area, and waiting for you to call it home! With easy access to 610 and Highway 10, you can get to whatever part of Houston you need to with ease. Home features a full interior/exterior paint job, new countertops, new sinks and new vinyl flooring in the living room, kitchen and bathroom area. This property also features new light fixtures and a new carpet. See it for yourself! Call to schedule a viewing today!' ,`Acres` = '0.1205' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 24 BLK 33A INDUSTRIAL' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '5250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'JACINTO CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GALENA PARK HIGH SCHOOL' ,`SchoolMiddle` = 'GALENA PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Industrial Add' ,`TaxAmount` = '2327' ,`TaxRate` = '3.0062' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675088318' WHERE `Matrix_Unique_ID` = '200186744' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T10:18:15.390' ,`MLSNumber` = '20255872' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.132545' ,`Longitude` = '-95.587776' ,`PhotoCount` = '30' ,`PostalCode` = '77375' ,`RoomCount` = '4' ,`ListPrice` = '419999.00' ,`Status` = 'Active' ,`StreetName` = 'Thinleaf Alder' ,`StreetNumber` = '11111' ,`StreetSuffix` = 'Way' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2850' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Every home has a story to tell. For many, that story has already been forged by the hands of another. Seeping into the walls and paint, the floors and stonework in the form of thoughts and memories conveying a constant reminder that a former has lived there before you. But what about a new home? Not just any new home... but this one, right here... right now. Presenting this beautifully-crafted, masterfully-woven home by David Powers. A four bedroom three and-a-half bath allurement of splendid wonder. The slate is clean. The pages are blank. The story is yet to unfold. Your story. Your memories. You can own the first step across the threshold of this memory maker and experience this wholesome never-ending dream. A dream fashioned just for you. Imagine the satisfaction of forging a new story of your own for someone else to envy. This property now features a new driveway. Call us to find out how you can own this home today!' ,`Acres` = '0.1791' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 28 BLK 3 FAIRWAY FARMS SEC 1 R/P' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'CREEKVIEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Fairway Farms Sec 1 Rep #1' ,`TaxAmount` = '6025' ,`TaxRate` = '3.3987' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675088318' WHERE `Matrix_Unique_ID` = '200976072' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T09:22:17.167' ,`MLSNumber` = '74027204' ,`ListAgentFullName` = 'Victoria Staff' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.718912' ,`Longitude` = '-95.408773' ,`PhotoCount` = '12' ,`PostalCode` = '77005' ,`RoomCount` = '9' ,`ListPrice` = '3300000.00' ,`Status` = 'Active' ,`StreetName` = 'Rice' ,`StreetNumber` = '2136' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rare opportunity for almost half an acre premier corner lot (19,800 sq. ft.per HCAD) in highly desirable Southampton Place. The value is in the land. Property has beautiful frontage along Rice Blvd. (across from the acclaimed Rice University campus) and expansive footage with garage access along Shepherd Dr. Beautiful and perfectly placed mature oak trees in the front and back yard await your vision for luxurious new construction with ample room for a pool, or remodel existing home (w/ civic club approval). Residents enjoy private security patrols and an active Civic Club. Deed restrictions/building guidelines are available on the civic club website. This desirable, prosperous residential neighborhood with no commercial or multi-family properties is zoned to 3 highly rated schools (Buyer to verify eligibility) and offers close proximity to the Texas Medical Center, Museum District, Hermann Park & popular Rice Village. Please do not walk lot without an appointment. All info per Seller.' ,`Acres` = '0.4545' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rice/Museum District' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 4 SOUTHAMPTON PLACE' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '19800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'POE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = '' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Southampton Place' ,`TaxAmount` = '43473' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675088318' WHERE `Matrix_Unique_ID` = '201955521' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T10:16:11.043' ,`MLSNumber` = '14894781' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.862522' ,`Longitude` = '-95.300393' ,`PhotoCount` = '18' ,`PostalCode` = '77016' ,`RoomCount` = '3' ,`ListPrice` = '174999.00' ,`Status` = 'Active' ,`StreetName` = 'Homestead' ,`StreetNumber` = '10338' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1216' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 3 bedrooms, 1 bathroom brick home! The home features a 1 car garage, a large backyard, and a new roof. It also features full interior/exterior paint, vinyl floor in the kitchen, and painted kitchen cabinets. This property is within close proximity to Brock Park Golf Course and has quick access to I-69 North. You will love being close to downtown Houston, and all the great attractions the downtown area has to offer like the Downtown Aquarium and Discovery Green Park. Contact us today for more information!' ,`Acres` = '0.1667' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 30 BLK 42 SCENIC WOODS' ,`LotDesciption` = 'Other' ,`LotSize` = '7260' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHADYDALE ELEMENTARY' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Scenic Woods' ,`TaxAmount` = '1428' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675088318' WHERE `Matrix_Unique_ID` = '206076631' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T09:36:37.060' ,`MLSNumber` = '38404930' ,`ListAgentFullName` = 'Maria Bonilla' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.840461' ,`Longitude` = '-95.315150' ,`PhotoCount` = '10' ,`PostalCode` = '77016' ,`RoomCount` = '5' ,`ListPrice` = '199000.00' ,`Status` = 'Active' ,`StreetName` = 'Laura Koppe' ,`StreetNumber` = '5204' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1194' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for an open concept with lots of privacy? This is the house for you. This house offers three bedrooms with each one having their own private bathroom. Minutes from shopping centers and freeways. Schedule your showings today.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Europa Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'na' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'COOK ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Trinity Gardens Sec 3' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675088319' WHERE `Matrix_Unique_ID` = '208388479' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T09:19:29.830' ,`MLSNumber` = '5377922' ,`ListAgentFullName` = 'Roxie Krisher Hippard' ,`ListOfficeName` = 'Krisher-McKay, Inc., REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.900586' ,`Longitude` = '-95.026394' ,`PhotoCount` = '29' ,`PostalCode` = '77532' ,`RoomCount` = '5' ,`ListPrice` = '659900.00' ,`Status` = 'Active' ,`StreetName` = 'Bohemian Hall' ,`StreetNumber` = '14823' ,`StreetSuffix` = 'Road' ,`City` = 'Crosby' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1254' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'What a rare find...15.95 acres m/l with two barns**One barn is 36\'36\' with a 15\' overhang.**This barn has four stalls**Each stall is 12\'x12\'**Tack room is 24\'x12\'** The other barn is a shed row style 18\'x48\' including a chicken pen and storage area. Ideal for horse boarding. This is a great property for your livestock. Beautiful crossed fenced pastures with a pond. Mature tree lined property**Unrestricted**The house has a fully fenced yard with a covered breezeway that leads to a oversized 2 car garage**Great location and easy access to I-10, HWY 90 and the new Grand parkway**Plenty of room to build your dream home**' ,`Acres` = '15.95' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'PT TR 6A (HOMESITE) ABST 805 T TOBY' ,`LotDesciption` = 'Other' ,`LotSize` = '694782' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'BARRETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'T Toby' ,`TaxAmount` = '1844' ,`TaxRate` = '2.0943' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1949' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675088319' WHERE `Matrix_Unique_ID` = '209338337' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T09:50:17.300' ,`MLSNumber` = '61806136' ,`ListAgentFullName` = 'James Monk' ,`ListOfficeName` = 'J. Frank Monk Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.950402' ,`Longitude` = '-96.254741' ,`PhotoCount` = '22' ,`PostalCode` = '77418' ,`RoomCount` = '7' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Harris' ,`StreetNumber` = '33' ,`StreetSuffix` = 'Street' ,`City` = 'Bellville' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1652' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming historical home is in a prime, central location right near Bellville Town Square! This home was the old Das Dwochenblatt Newspaper building and published papers in Bellville from 1891-1909. On a large corner lot, with beautiful mature trees and the perfect front porch for rocking in the chairs. Walk inside to find the gorgeous hardwood floors, shiplap walls and high ceilings! Stairs up to the over sized attic lead to a large additional bedroom with potential bathroom, game room, and or loft. With its prime, in-town location and plenty of space for parking, this property would be the perfect place for an office or charming Air BNB. Property is to be sold As Is. Don’t wait to see this beautiful historical home in Bellville!' ,`Acres` = '0.376' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BELLVILLE TOWNSITE LOT 12 (NE PART OF OUTLOT 12)' ,`LotDesciption` = 'Cleared' ,`LotSize` = '16378' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '136 - Bellville' ,`SchoolElementary` = 'WEST END ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'BELLVILLE JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bellville Townsite' ,`TaxAmount` = '2772' ,`TaxRate` = '2.1116' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1890' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675088319' WHERE `Matrix_Unique_ID` = '209681333' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T10:23:19.923' ,`MLSNumber` = '12307575' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.836674' ,`Longitude` = '-95.395662' ,`PhotoCount` = '9' ,`PostalCode` = '77022' ,`RoomCount` = '2' ,`ListPrice` = '222500.00' ,`Status` = 'Active' ,`StreetName` = 'Spell' ,`StreetNumber` = '339' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '852' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cozy 2 bedroom, 1 bathroom home located in North Houston. With this home, you get it all! Fiesta Mart is located within 5 minutes. Houston Community College is only a 6-minute drive. Easy access to Interstate 45 with a short drive to the downtown. It features new interior/exterior lighting, cosmetic repairs, new flooring in the den area, as well as an updated kitchen area. Don\'t miss out, give us a call today for more information!' ,`Acres` = '0.1708' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 49 BLK 6 VICTORIA GARDENS' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7440' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KENNEDY ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Victoria Gardens' ,`TaxAmount` = '2130' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675088319' WHERE `Matrix_Unique_ID` = '209832194' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T10:22:43.030' ,`MLSNumber` = '71616779' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.698115' ,`Longitude` = '-95.349362' ,`PhotoCount` = '17' ,`PostalCode` = '77021' ,`RoomCount` = '2' ,`ListPrice` = '178500.00' ,`Status` = 'Active' ,`StreetName` = 'Kingsbury' ,`StreetNumber` = '4506' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this lovely 2 bedroom, 1+ bathroom home located South of Houston. This home features historic details, hardwood floors, a fireplace, and a laundry room. Easy access to 45 and 610 FWY. 3 miles from Texas Medical center and 4 miles from Houston Zoo. Contact us today for more information!' ,`Acres` = '0.1598' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 6 SOUTHERN VILLAGE SEC 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6961' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PECK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Southern Village Sec 01' ,`TaxAmount` = '1728' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675088319' WHERE `Matrix_Unique_ID` = '211441848' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T10:20:51.133' ,`MLSNumber` = '49411049' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.703590' ,`Longitude` = '-95.331726' ,`PhotoCount` = '15' ,`PostalCode` = '77021' ,`RoomCount` = '4' ,`ListPrice` = '219999.00' ,`Status` = 'Active' ,`StreetName` = 'Nassau' ,`StreetNumber` = '5131' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1560' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '4 bedroom, 2 bathroom home near downtown Houston! This home consists of wood floors in select areas, ceramic tile in the bathroom, and a great sized backyard for your children to play in or your furry friends! A great location that offers you quick access to I-45 South and destinations like the Museum District and Texas Medical Center. It features new interior paint and cosmetic repairs. Give us a call today for more information!' ,`Acres` = '0.1667' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 36 BLK 6 MACGREGOR PLACE SEC 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7260' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PECK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Macgregor Place Sec 02' ,`TaxAmount` = '2967' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675088320' WHERE `Matrix_Unique_ID` = '211731463' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T10:16:48.157' ,`MLSNumber` = '49934600' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.664067' ,`Longitude` = '-95.336262' ,`PhotoCount` = '15' ,`PostalCode` = '77033' ,`RoomCount` = '3' ,`ListPrice` = '194999.00' ,`Status` = 'Active' ,`StreetName` = 'Belmark' ,`StreetNumber` = '5715' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1128' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home with 3 bedrooms, 1 bath, and 1-car garage. Coming with new interior paint, new ceiling fans, upgrade kitchen and bathroom, and nice backyard. Easy access to 610 and 288. Close to Medical Center, universities, and Downtown. Give us a call today for more information!' ,`Acres` = '0.1566' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 39 BLK 35 BELFORT PARK SEC 5' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6820' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MADING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Belfort Park Sec 05' ,`TaxAmount` = '1904' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1951' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675088320' WHERE `Matrix_Unique_ID` = '211738187' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T10:45:25.417' ,`MLSNumber` = '89483089' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.672020' ,`Longitude` = '-95.369980' ,`PhotoCount` = '9' ,`PostalCode` = '77051' ,`RoomCount` = '3' ,`ListPrice` = '174999.00' ,`Status` = 'Active' ,`StreetName` = 'Rosemont' ,`StreetNumber` = '3709' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '828' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This lovely home has 3 bedrooms,1 bath, wood floors, and a cute front porch for you to enjoy. Easy access to 288 and the Loop-610, just 10 min away from the Medical Center. Recently updated. Features include a gate for privacy, long extended driveway, nice faux wood ceramic flooring when you walk into the house, tile flooring in the kitchen. Contact us today for more information!' ,`Acres` = '0.1098' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 10 BLK 80 SUNNYSIDE PLACE' ,`LotDesciption` = 'Cleared' ,`LotSize` = '4785' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'YOUNG ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunnyside Place' ,`TaxAmount` = '2156' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675088320' WHERE `Matrix_Unique_ID` = '211743996' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T10:29:32.177' ,`MLSNumber` = '46710786' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.847051' ,`Longitude` = '-95.162329' ,`PhotoCount` = '8' ,`PostalCode` = '77049' ,`RoomCount` = '2' ,`ListPrice` = '237500.00' ,`Status` = 'Active' ,`StreetName` = 'Harmony' ,`StreetNumber` = '8403' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1260' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 bedroom, 1 bathroom home with an upstairs loft! This home features new interior/exterior paint, new light fixtures, new flooring in select areas and cosmetic repairs. It also features foundation repairs. It sits in a lovely half-acre lot, and is located 15 miles away from downtown. Quick access to Crosby FWY. A nice home like this one won\'t last long.' ,`Acres` = '0.57' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'TR 82J HOUSTON FARMS' ,`LotDesciption` = 'Other' ,`LotSize` = '24829' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'SHELDON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'MICHAEL R. NULL MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Houston Farms' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675088320' WHERE `Matrix_Unique_ID` = '212310737' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T09:46:27.610' ,`MLSNumber` = '67212626' ,`ListAgentFullName` = 'Huongthao Do' ,`ListOfficeName` = 'Exceed Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.298822' ,`Longitude` = '-94.914618' ,`PhotoCount` = '42' ,`PostalCode` = '77554' ,`RoomCount` = '3' ,`ListPrice` = '580000.00' ,`Status` = 'Active' ,`StreetName` = 'Tahiti' ,`StreetNumber` = '335' ,`StreetSuffix` = 'Road' ,`City` = 'Tiki Island' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1332' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3-bedroom and 2 bath water views from Tiki Island This updated one-story home features with high ceilings with abundance of natural light, quartzite countertop in kitchen, roof replaced 2018, all concrete driveway and backyard, and laminate flooring throughout. Relax and take in the views from the covered porch on the upper deck. A MUST SEE!!!' ,`Acres` = '0.1' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tiki Island' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 7 S C BUNDICK SUR LOT 7 TIKI ISLAND SEC 6' ,`LotDesciption` = 'Water View' ,`LotSize` = '4356' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HAYLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tiki Island 6' ,`TaxAmount` = '7247' ,`TaxRate` = '2.4912' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675088321' WHERE `Matrix_Unique_ID` = '212627781' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T09:01:19.467' ,`MLSNumber` = '75583601' ,`ListAgentFullName` = 'Ron Brown' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.797934' ,`Longitude` = '-95.475262' ,`PhotoCount` = '29' ,`PostalCode` = '77055' ,`RoomCount` = '7' ,`ListPrice` = '640000.00' ,`Status` = 'Active' ,`StreetName` = 'Shadyvilla Pointe' ,`StreetNumber` = '7323' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2420' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning gated Contemporary Spring Branch home conveniently located between I-10, 290 & close to 610. Beautifully decorated open floorplan features tons of windows & extremely high ceilings overlooking a lush backyard. Designer lighting throughout with Jenn-Air appliances, quartz countertops, custom remote controlled Hunter Douglas shades & modern finishes. Gorgeous primary bedroom and bath & separate his/hers walk-in closets. Energy efficient HVAC, tankless water heater, water softener & water filtration system. A real show stopper. All info per Seller.' ,`Acres` = '0.0357' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 1 SHADY VILLA ANNEX SEC 1 PAR R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1553' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HOUSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Shadyvilla Add' ,`TaxAmount` = '12038' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675088321' WHERE `Matrix_Unique_ID` = '213417593' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T10:23:39.063' ,`MLSNumber` = '11611321' ,`ListAgentFullName` = 'Jacqueline Wallman' ,`ListOfficeName` = 'Texas Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.740015' ,`Longitude` = '-95.566357' ,`PhotoCount` = '24' ,`PostalCode` = '77042' ,`RoomCount` = '6' ,`ListPrice` = '500000.00' ,`Status` = 'Active' ,`StreetName` = 'Ella Lee' ,`StreetNumber` = '10719' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2198' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your Search has Ended! Spacious 3 BR home desirable community. Home features wood and tile flooring throughout. Spacious living room with raised ceilings and plenty of natural lighting. Island kitchen comes with granite counter tops and plenty of cabinet/counter space. Large primary with walk in closet. Nice size secondary rooms. Just minutes from Energy Corridor and Memorial City Mall. Excellent location! Come see today!' ,`Acres` = '0.2022' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Briargrove Park/Walnutbend' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 3 WALNUT BEND SEC 1 EXTN & R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8806' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '220' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WALNUT BEND ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Walnut Bend Sec 01 Ext & R/P' ,`TaxAmount` = '8872' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675088321' WHERE `Matrix_Unique_ID` = '214079855' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T10:04:01.937' ,`MLSNumber` = '77674908' ,`ListAgentFullName` = 'Ari Spahiu' ,`ListOfficeName` = 'Texas Advantage Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.256114' ,`Longitude` = '-95.530521' ,`PhotoCount` = '20' ,`PostalCode` = '77384' ,`RoomCount` = '7' ,`ListPrice` = '415000.00' ,`Status` = 'Active' ,`StreetName` = 'Wonder Lake' ,`StreetNumber` = '14234' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2565' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Brick Exterior! Versatile Interior Layout with GAMEROOM & HOME OFFICE/STUDY/5th BDRM! Features: Quartz Counters, Stainless Steel Appliances with Gas Cooktop, & 36\" White Kitchen Cabinetry! Smart Home Package, Solid Surface Flooring, Tankless Water Heater, Covered Patio, & Sprinkler System! Outstanding Design - Home Office/Study/5th Bdrm with Walk-In Closet & Adjoining Half Bath, Privately Located First Floor Primary Suite with Walk-In Closet & Posh Bath, Gourmet Island Kitchen, Open Living & Dining Area, & Enormous Gameroom/Media Room Upstairs! Great Community with Pool, Playground, & Community Center! Conroe ISD/The Woodlands Schools!' ,`Acres` = '0.1442' ,`Area` = '15' ,`BuilderName` = 'Dr Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S516492 - FOSTERS RIDGE 20A, BLOCK 3, LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6280' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fosters Ridge' ,`TaxAmount` = '457' ,`TaxRate` = '3.1488' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675088321' WHERE `Matrix_Unique_ID` = '214130546' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T09:48:06.903' ,`MLSNumber` = '89970785' ,`ListAgentFullName` = 'Huongthao Do' ,`ListOfficeName` = 'Exceed Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.577947' ,`Longitude` = '-95.354727' ,`PhotoCount` = '10' ,`PostalCode` = '77584' ,`RoomCount` = '4' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Hillhouse Rd' ,`StreetNumber` = '633' ,`StreetSuffix` = '' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2.96 Acres land all fenced with a double wide mobile home 3 bedroom, 2 and 1/2 bath being leased with income, approximately 4000 sq ft barn/storage/horse stall. NO HOA. Come build your dream home on this cleared property with plenty of room for more houses, workshop or other accessory building. Buyer to verify use and restrictions with the City of Pearland.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'A0506 H T & B R R, TRACT 32A. ACRES 2.960' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'CHALLENGER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'BERRY MILLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'H T & B R R' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675088322' WHERE `Matrix_Unique_ID` = '214373261' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T09:56:00.660' ,`MLSNumber` = '87410358' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.504130' ,`Longitude` = '-95.720160' ,`PhotoCount` = '37' ,`PostalCode` = '77469' ,`RoomCount` = '8' ,`ListPrice` = '527124.00' ,`Status` = 'Active' ,`StreetName` = 'Pearl Hill' ,`StreetNumber` = '5814' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2842' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Sophisticated design and easy elegance combine in The Marcann new home plan. Enjoy the exquisite sanctuary of your Owner’s Retreat, which features a splendid en suite bathroom and a walk-in closet. Each guest suite and spare bedroom presents a uniquely appealing place for growing personalities to flourish. The breakfast nook, covered patio, kitchen island, and open dining area offer a streamlined variety of mealtime settings. Flex your interior design skills in the limitless lifestyle potential of the upstairs retreat, the welcoming living area, and the deluxe family room. Everyday refinements include soaring ceilings, a downstairs powder room, and a delightful selection of built-in features. Make each day beautiful in this exceptional #LivingWeekley masterpiece home plan.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 16 Block 2' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CARTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Stonecreek Estates' ,`TaxAmount` = '' ,`TaxRate` = '3.22' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675088322' WHERE `Matrix_Unique_ID` = '214513976' --> 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','214969301','1675088322','214969301','2022-12-07T10:11:43.293','77559482','Melissa Sanders','Coldwell Banker Realty, Cy-Fair Office','','','30.157477','-95.399702','21','77385','10','610000.00','Active','Sterling Heights','2707','Lane','Conroe','3','1','4','3382','Single-Family','Seller Concessions up to 10k! Elegance and beauty are what you will discover from the moment you step into the foyer. Beautiful lighting, lovely staircase with a landing that looks down from both sides, large open and spacious from the formal dining area to your large and open kitchen that flows to your family room. Your kitchen offers you stainless steel appliances, Silestone Countertops with a wraparound breakfast bar. The entire high traffic area is laminate wood flooring, even within the primary bedroom! Upstairs you will find a game room, a media room fit to call a movie theater, with stacked seating, a movie projector and a popcorn maker you are set for the big games or just an evening of relaxation. Just across the floor you will find three additional bedrooms and one includes its own private bathroom. Your backyard has covered patio with beautiful fenced in yard that is ready for entertaining and relaxation. Refrigerator, Washer and Dryer stays!','0.1679','15','Ashton Woods','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Spring Northeast','Central Gas,Zoned','1','S716707 - MEADOWS AT IMPERIAL OAKS 07, BLOCK 1, LOT 7','Subdivision Lot','7315','Appraisal District','','550','0','','2','Electric Oven,Single Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','KAUFMAN ELEMENTARY SCHOOL','OAK RIDGE HIGH SCHOOL','IRONS JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Builder','2','Contemporary/Modern','Meadows At Imperial Oaks 07','13466','3.3087','Public Sewer,Public Water','2018','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','215230433','1675088322','215230433','2022-12-07T10:00:59.283','58606352','Aaron Harris','Aaron Harris Realty','','','30.156433','-95.532658','48','77389','17','5550000.00','Active','Thornblade','39','Circle','The Woodlands','5','2','5','10118','Single-Family','New Modern Golf Front Estate in Carlton Woods Creekside along Hole #4 Tom Fazio Course! Pinnacle of Modern Luxury w/ Extravagant & Innovative Finish Level. Custom Walnut Arched Entry Doors Open to 27 Ft Ceilings, Venetian Plaster w/ Stunning Feature Walls of Diamond 3D Sculpture Murals, Italian Porcelain Floors, Bocci Blown Glass Art Installation Lighting, White Oak Staircase w/ Custom Iron Railings, Sophisticated Bar w/ Exotic Marble/Wine Towers/Ice/Frig/Sink. Wide Open Family, Kitchen & Dining Walk Out to Fazio Golf Through Western Slider Retractable Doors! Thermador Island Kitchen featuring Cabinetry State of Art Motorized Drawers & Doors, Sea Pearl Quartzite Counters in both Main Kitchen & Caterer Kitchen. Custom Walnut Entry Doors lead to Sanctuary, His & Her Ensuites w/ Micah Finish Ceilings, Tasso Marble Shower & Soaking Tub w/ Linear Fireplace. Expansive Estate boasts All 5/6 Bedrooms Down! Dedicated 2nd Floor Game Room & Study w/ Private Entry & Balconies! UP TO 14 CAR GARAGE!','1.04','14','K & C Classic Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','3','The Woodlands','Central Gas,Zoned','1','LT 10 BLK 2 THE WOODLANDS CARLTON WOODS CREEKSIDE 3 IN THE V','Cul-De-Sac,Greenbelt,In Golf Course Community,On Golf Course,Subdivision Lot,Wooded','45302','Other','','4750','1','To Be Built/Under Construction','7','Double Oven,Gas Oven','0','','','Gas Cooktop,Gas Range','','Tile','53 - Tomball','TIMBER CREEK ELEMENTARY SCHOOL (Tomball)','TOMBALL HIGH SCHOOL','CREEKSIDE PARK JUNIOR HIGH SCHOOL','Appointment Required,Controlled Access','Appraisal District','3','Contemporary/Modern','Carlton Woods Creekside','69297','2.6895','Water District','2023','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','215259908','1675088322','215259908','2022-12-07T09:14:53.920','93467307','Loren Miner','Eastwood Realty','','','29.740398','-95.333668','20','77023','1','435000.00','Active','Woodside','4429','Street','Houston','1','0','1','932','Single-Family','Fantastic opportunity to purchase a rare income-producing property in our favorite sliver of Eastwood proper - the gold standard in East End real estate. This garage apartment is beautifully situated on a massive 8,250 sqft corner lot with 360 degree views of Houston’s glimmering skyline and the majestic old growth trees Eastwood is known for. Currently occupied with tenant paying $1,500 per month and lease up for renewal shortly, this is the ideal situation to have rent covered while building your dream home! Or, if you\'re still saving, you can live here and watch your dream home be built right from your kitchen window. Call today for more info, as these unique properties don\'t come around often.','0.1894','4','','','Electric Dryer Connections,Washer Connections','','No Disclosures','0','','','East End Revitalized','Other Heating,Zoned','0','LT 12 & TR 13A BLK 25 EASTWOOD','Cleared,Corner,Subdivision Lot','8250','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','27 - Houston','LANTRIP ELEMENTARY SCHOOL','AUSTIN HIGH SCHOOL (HOUSTON)','NAVARRO MIDDLE SCHOOL (HOUSTON)','Appointment Required,Lockbox Front,No Supra Keybox,Request Online Appointment','Appraisal District','2','Traditional','Eastwood','','','Public Sewer,Public Water','1950','Appraisal District'); --> New record created successfully