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-16T07:29:23.253' ,`MLSNumber` = '23031574' ,`ListAgentFullName` = 'Ximena Anderson' ,`ListOfficeName` = 'Resident Realty, Ltd.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.474801' ,`Longitude` = '-95.673905' ,`PhotoCount` = '26' ,`PostalCode` = '77356' ,`RoomCount` = '3' ,`ListPrice` = '209900.00' ,`Status` = 'Active' ,`StreetName` = 'Sycamore' ,`StreetNumber` = '15715' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1250' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction-with high ceilings.Fall in love with this beautiful single story home featuring a huge front covered porch, open floor plan, granite counters, kitchen island, self closing drawers/cabinets, 42\" upper cabinets, great pantry and stainless steel package. Lovely primary bedroom with private bath and large walk-in shower. too! The primary bath has a large shower that gives it a spa like feel. Laundry room is also nice sized too! Brand new beautiful home at this very affordable price. Come take a look soon, it\'s being built and you can still make color and cabinet selections. Close to Lake Conroe and the city of Montgomery, perfect location for shopping dining and fishing! Completion Sept. 1' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'De Volada' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'HIDDEN FOREST EST 03, LOT 79' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6493' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '36' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hidden Forest Estate' ,`TaxAmount` = '149' ,`TaxRate` = '1.8698' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663711195' WHERE `Matrix_Unique_ID` = '206785620' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T07:33:24.973' ,`MLSNumber` = '50977165' ,`ListAgentFullName` = 'Jeffrey Shaddix' ,`ListOfficeName` = 'The Virtual Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.782021' ,`Longitude` = '-95.626204' ,`PhotoCount` = '32' ,`PostalCode` = '77414' ,`RoomCount` = '7' ,`ListPrice` = '474970.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 201' ,`StreetNumber` = '88' ,`StreetSuffix` = '' ,`City` = 'Sargent' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2125' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WOW! If you’re looking for an investment property in Sargent, you’ve found it! EXCELLENT AIRBNB POTENTIAL, with room to sleep AT LEAST 20 people with 2 large bedrooms and 2 remodeled bathrooms upstairs and 845 sf enclosed downstairs in 2 rooms plus a full bathroom. All new paint inside and out! The existing home is centered on the property leaving plenty of room on both sides to build additional homes or RV sites for additional income! Roof, AC and bulkhead are all recent to ensure low maintenance. Property boasts a 2-slip boathouse, a large 30x40 garage with wide concrete driveway and two additional electric poles with 200A service already connected and ready for development. So close to the beach you can often hear the waves from your spacious wrap-around deck on three sides of the house and within 200 feet of restaurants. So much potential with this home! Don\'t let this one get away!' ,`Acres` = '0.9975' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'AB 0004, WILLIAM BAXTER, ACRES 1' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '43451' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '134 - Van Vleck' ,`SchoolElementary` = 'VAN VLECK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'VAN VLECK HIGH SCHOOL' ,`SchoolMiddle` = 'O H HERMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'William Baxter' ,`TaxAmount` = '7170' ,`TaxRate` = '2.3895' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711196' WHERE `Matrix_Unique_ID` = '207649738' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T07:57:16.367' ,`MLSNumber` = '90217997' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.472949' ,`Longitude` = '-95.528063' ,`PhotoCount` = '12' ,`PostalCode` = '77459' ,`RoomCount` = '8' ,`ListPrice` = '759889.00' ,`Status` = 'Active' ,`StreetName` = 'Pleasant Grove' ,`StreetNumber` = '1934' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '2973' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 90217997 - Built by Highland Homes - September completion! ~ Popular 1.5 story w/19\' ceilings in family and dining rooms. Double door entrance from front porch. Custom kitchen cabinet upgrade w/ built-in Hutch. Quartz tops, 5 burner gas cooktop, dbl ovens. Primary suite w/bay window, spa bath w/rectangular freestanding tub. Upstairs game room w/ lots of natural light and en-suite guest room. Ever so popular painted white brick for gorgeous curb appeal. No back neighbors!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = '19/1' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '8777' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna' ,`TaxAmount` = '' ,`TaxRate` = '3.14' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663711196' WHERE `Matrix_Unique_ID` = '207921344' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T06:23:03.470' ,`MLSNumber` = '56015926' ,`ListAgentFullName` = 'Kelly Kelley' ,`ListOfficeName` = 'RE/MAX Leading Edge' ,`SellingAgentFullName` = 'Michael Evans' ,`SellingOfficeName` = 'Coldwell Banker Realty' ,`Latitude` = '29.218233' ,`Longitude` = '-94.943209' ,`PhotoCount` = '48' ,`PostalCode` = '77554' ,`RoomCount` = '9' ,`ListPrice` = '1699000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Doubloon' ,`StreetNumber` = '13820' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3130' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One of a kind new construction in HIGHLY sought after Pirates Cove with BAY VIEWS! Ready for move in approximately July 1 this home will offer BEAUTIFUL COASTAL EXTERIOR CONSISTING OF VERTICAL SHIPLAP, IRONWOOD DETAILS & HARDIE SIDING. 12 x 12 CONCRETE PILINGS. 2 PRIMARY BEDROOMS, BUNK ROOM, SITTING ROOM & A GAME ROOM LEADING TO BALCONY WITH 180 DEGREE VIEWS OF GALVESTON BAY. LARGE FAMILY ROOM WITH HUGE 14’ X 8’ MULTI-SLIDE GLASS WALL TO MAXIMIZE VIEWS. ENORMOUS CHEF’S KITCHEN AND WINE BAR WITH BUILT-IN APPLIANCES AND QUARTZ COUNTERTOPS. BEAUTIFUL 7 ½” WIDE LARGE PLANK ENGINEERED HARDWOOD WIREBRUSHED OAK FLOORS. DRY DECKS OFFERING ADDTIONAL OUTDOOR LIVING SPACE. HIGH EFFICIENCY MECHANICALS INCLUDE 16 SEER MULTI-STAGE AC SYSTEMS, SPRAY FOAM INSULATION, TANKLESS GAS WATER HEATERS WITH RECIRCULATION SYSTEM, HIGH END IMPACT RATED WINDOWS & DOORS. INTERIOR DESIGN BY LAUREN ELIZABETH INTERIORS IN CONJUNCTION WITH KAI CUSTOM HOMES. Look for more details in associated documents.' ,`Acres` = '0.1148' ,`Area` = '33' ,`BuilderName` = 'Kai Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 T&L & HALL & JONES SUR LOT 22 BLK 2 PIRATES COVE SE' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '168' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Pirates Cove' ,`TaxAmount` = '1062' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663711196' WHERE `Matrix_Unique_ID` = '207957649' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T07:58:09.360' ,`MLSNumber` = '91371163' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.704457' ,`Longitude` = '-95.888264' ,`PhotoCount` = '28' ,`PostalCode` = '77441' ,`RoomCount` = '4' ,`ListPrice` = '619216.00' ,`Status` = 'Active' ,`StreetName` = 'Smoky Ridge' ,`StreetNumber` = '29723' ,`StreetSuffix` = '' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 91371163 - Built by Highland Homes - December completion! ~ Located in Cross Creek Ranch, a master planned community! Just inside this home your eye is drawn to the dramatic high ceilings and arched entry. Secondary bedrooms are tucked away off of the entry, which leads the way to the open formal dining room. The study is closed off by glass French doors, providing a quiet escape to work from home. The extended family room & breakfast feature bright picture windows, offering peaceful views of the outdoors. Open concept kitchen, family, breakfast. Chef\'s kitchen has quartz counter tops, custom shaker style cabinets & eat-in island. Built-in planning desk provides great work space & additional storage. Escape to the secluded over-sized master suite with a sitting area. En-suite master bath includes a vanity space, dual sinks, separate tub & shower with stunning tile upgrades. Huge master closet! Wood floors throughout common living areas. Large covered patio!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'lot/block' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6839' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cross Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.2' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663711196' WHERE `Matrix_Unique_ID` = '208063986' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T07:32:33.713' ,`MLSNumber` = '848707' ,`ListAgentFullName` = 'Clinton Butler' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.777795' ,`Longitude` = '-95.359975' ,`PhotoCount` = '24' ,`PostalCode` = '77009' ,`RoomCount` = '4' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Chestnut' ,`StreetNumber` = '1917' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2056' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This immaculate bungalow situated in Allen A C is ready for your personal touch! The property is completely fenced and even has a separate Guest bedroom quaters in the back! The home has been fully restored. Stunning chef\'s kitchen equipped with stainless steel appliances, granite countertops and an island. This open floor plan has windows that were carefully placed allowing lots of natural lighting and ample storage throughout. Due to its fantastic location, access to all levels of schooling, public transportation and trails are all less than 5 min away. Easy access to I-45 and I-10. You will enjoy being just minutes of Houston’s most popular coffee shops, restaurants, weekend spots, and night life. Give us a call today for a tour of this beautiful home in one of Houston\'s hottest neighborhoods!This property is lease to own eligible.' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 15 BLK 46-A ALLEN A C' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KETELSEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Allen A C' ,`TaxAmount` = '9315' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1920' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711196' WHERE `Matrix_Unique_ID` = '208280443' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T07:58:54.990' ,`MLSNumber` = '77882200' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.471688' ,`Longitude` = '-95.527516' ,`PhotoCount` = '39' ,`PostalCode` = '77459' ,`RoomCount` = '9' ,`ListPrice` = '759985.00' ,`Status` = 'Active' ,`StreetName` = 'Pleasant Grove' ,`StreetNumber` = '1906' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3050' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 77882200 - Built by Highland Homes - October completion! ~ Popular model plan w/ no back neighbors! Double door entry w/ 13\' tall ceilings. Sliding glass doors at family & dining. Chef\'s dream kitchen cabinet elevation w/ double ovens & two islands w/ upgraded finishes throughout. Cozy fireplace at keeping room! Extended master suite w/ freestanding tub & walk in closet. Private guest bedroom w/ en-suite bath. Texas sized patio!!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = '26/1' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '8430' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna' ,`TaxAmount` = '' ,`TaxRate` = '3.14' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663711196' WHERE `Matrix_Unique_ID` = '208418920' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T07:28:29.357' ,`MLSNumber` = '60843010' ,`ListAgentFullName` = 'Ximena Anderson' ,`ListOfficeName` = 'Resident Realty, Ltd.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.473194' ,`Longitude` = '-95.666479' ,`PhotoCount` = '41' ,`PostalCode` = '77356' ,`RoomCount` = '6' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'HICKORY' ,`StreetNumber` = '15514' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction-with high ceilings.Fall in love with this beautiful 2 story home featuring an open floor plan, granite counters, soft closing drawers/cabinets, 42\" upper cabinets, great walk in pantry and stainless steel package. Lovely primary bedroom with private bath and large walk-in shower. Laundry room is also nice sized too! The primary bath has an large shower that gives it a spa like feel. This spacious floor plan offers a 2nd bedroom/study downstairs and a half bath for guests. Beautiful ceramic tiled floors downstairs, and laminate upstairs for easy cleaning. Upstairs you\'ll find 2 secondary bedrooms and a full bath. Don\'t miss this gorgeous new home with all these features at a very affordable price. Finishes are similar. Serene setting with lakes and community pool. Enjoy fishing the community lakes and Lake Conroe. Room dimensions should be verified.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = '3-G Construction' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'HIDDEN FOREST ESTATE BLOCK 5 LOT 139' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '36' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'HIDDEN FOREST ESTATE' ,`TaxAmount` = '149' ,`TaxRate` = '1.8698' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663711196' WHERE `Matrix_Unique_ID` = '208694951' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T07:30:08.650' ,`MLSNumber` = '61484586' ,`ListAgentFullName` = 'Ximena Anderson' ,`ListOfficeName` = 'Resident Realty, Ltd.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.361208' ,`Longitude` = '-95.621718' ,`PhotoCount` = '29' ,`PostalCode` = '77316' ,`RoomCount` = '3' ,`ListPrice` = '189900.00' ,`Status` = 'Active' ,`StreetName` = 'Kempwood' ,`StreetNumber` = '16891' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1060' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction-with high ceilings. Fall in love with this beautiful single story 3 bedroom 2 bath home featuring an open floor plan, granite counters, kitchen island, soft closing drawers/cabinets, 42\" upper cabinets, great pantry and stainless steel package. Lovely primary bedroom with private bath and large walk-in shower. The primary bath has a large shower that gives it a spa like feel. Laundry room is also nice sized too!!! All this at a very affordable price. Come take a look. Close to Lake Conroe and the city of Montgomery, perfect location for shopping dining and fishing! Construction already started and expected to be finished by 8/19/2022' ,`Acres` = '0.0482' ,`Area` = '39' ,`BuilderName` = '3-G Construction Grp' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE CONROE VILLAGE, BLOCK 18, LOT 24' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2100' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '51' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Conroe Village' ,`TaxAmount` = '149' ,`TaxRate` = '1.8698' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663711196' WHERE `Matrix_Unique_ID` = '208741309' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T07:56:13.330' ,`MLSNumber` = '68897782' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.704080' ,`Longitude` = '-95.888968' ,`PhotoCount` = '28' ,`PostalCode` = '77441' ,`RoomCount` = '4' ,`ListPrice` = '599818.00' ,`Status` = 'Active' ,`StreetName` = 'Gentle Blossom' ,`StreetNumber` = '5915' ,`StreetSuffix` = '' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2952' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 68897782 - Built by Highland Homes - January completion! ~ Located in Cross Creek Ranch, a master planned community! Just inside this home your eye is drawn to the dramatic high ceilings and arched entry. Secondary bedrooms are tucked away off of the entry, which leads the way to the open formal dining room. The study is closed off by glass French doors, providing a quiet escape to work from home. The extended family room & breakfast feature bright picture windows, offering peaceful views of the outdoors. Open concept kitchen, family, breakfast. Chef\'s kitchen has quartz counter tops, custom shaker style cabinets & eat-in island. Built-in planning desk provides great work space & additional storage. Escape to the secluded over-sized master suite with a sitting area. En-suite master bath includes a vanity space, dual sinks, separate tub & shower with stunning tile upgrades. Huge master closet! Wood floors throughout common living areas. Large covered patio.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot Block' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6700' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cross Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.2' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663711197' WHERE `Matrix_Unique_ID` = '210356862' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T07:19:52.380' ,`MLSNumber` = '33640952' ,`ListAgentFullName` = 'Nicole Shaw' ,`ListOfficeName` = 'Hardee & Company Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.900691' ,`Longitude` = '-95.567424' ,`PhotoCount` = '27' ,`PostalCode` = '77064' ,`RoomCount` = '10' ,`ListPrice` = '447000.00' ,`Status` = 'Active' ,`StreetName` = 'Dallam' ,`StreetNumber` = '8710' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3634' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic 4 Bedroom, 2 full and 2 half bath home located in the ammenity filled neighborhood of Willowbridge. This lovely home has an entry that leads to a formal dining and a two-story formal living with floor to ceiling windows. Further into the home is the impressive Light and Bright open concept kitchen. The large island kitchen features a breakfast bar, built-in appliances, plenty of counter space and a pantry. From the kitchen you can see right into the inviting Den with its high ceiling and cozy fireplace. The downstairs primary suite offers a spacious bedroom, a substanial walk in closet, an opulent 1.5 bathrooms with 2 sides seperated by a massive walk in shower, one side has a sink with separate vanity, the jetted tub and a water closet the other has its own large sink area and water closet. Up the stairs there is a half bath, a game room, 3 spacious secondary bedrooms and a full bath. Don\'t forget to check out the back yard paradise and large covered patio.' ,`Acres` = '0.2011' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Jersey Village' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 9 WILLOWBRIDGE SEC 4 AMEND' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8762' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '635' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'GLEASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JERSEY VILLAGE HIGH SCHOOL' ,`SchoolMiddle` = 'COOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Willowbridge Sec 04 Amd' ,`TaxAmount` = '8801' ,`TaxRate` = '2.521' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711197' WHERE `Matrix_Unique_ID` = '210776460' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T07:24:13.737' ,`MLSNumber` = '61266972' ,`ListAgentFullName` = 'Amy Lippincott' ,`ListOfficeName` = 'Keller Williams Platinum' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.935312' ,`Longitude` = '-95.739156' ,`PhotoCount` = '48' ,`PostalCode` = '77433' ,`RoomCount` = '10' ,`ListPrice` = '825000.00' ,`Status` = 'Active' ,`StreetName` = 'Big Pine' ,`StreetNumber` = '16210' ,`StreetSuffix` = 'Trail' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4339' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'STUNNING, SIMPLY STATED. This gorgeous 5 bedroom/4.5 bathroom home is looking for the next family to fall in love with it! The beautiful front door opens to the bright entrance with the spiral staircase and oversized dining room to the right of it. The family room welcomes you with high ceilings and a wall of windows. You can not miss the beautiful white kitchen with gorgeous black and white granite countertops, stainless steel appliances, large sink, great size pantry, and double ovens complete this stunning kitchen. Between the family room and dining room there is a showcase cabinet with a granite countertop. The master retreat has a large sitting area, tray ceiling and a ceiling fan. The master bathroom is a spa in itself with a large jetted tub, and large walk-in shower. Upstairs you will find a media room, large game room, three secondary bedrooms. Mother-in-law suite downstairs, backyard with a fire pit and putting green. This is a MUST SEE! Welcome home to Bridgeland!' ,`Acres` = '0.2991' ,`Area` = '25' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 2 BRIDGELAND PARKLAND VILLAGE SEC 3' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '13028' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MCGOWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '21068' ,`TaxRate` = '3.4929' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711197' WHERE `Matrix_Unique_ID` = '211042317' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T07:25:55.387' ,`MLSNumber` = '43017427' ,`ListAgentFullName` = 'Kathryn Jean' ,`ListOfficeName` = 'TexasLife Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.286021' ,`Longitude` = '-95.732311' ,`PhotoCount` = '49' ,`PostalCode` = '77316' ,`RoomCount` = '4' ,`ListPrice` = '1049900.00' ,`Status` = 'Active' ,`StreetName` = 'Lost Oak' ,`StreetNumber` = '23511' ,`StreetSuffix` = 'Court' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3828' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1.59 acres on one of the best, cul-de-sac lots in the neighborhood. 4/5 bedroom. This home is beautiful - high ceilings, amazing design/decor, lots of natural light and windows galore. Upon entry you are greeted with grand ceilings, a beautiful staircase and walls of windows. The dining room has an amazing brick wall that leads to the butler\'s pantry and amazing living room. The living room features floor to ceiling brick fireplace overlooking amazing views of the backyard/patio. The kitchen is a chef\'s dream with a double oven, industrial refrigerator, walk in pantry, fabulous island, lots of cabinet space and completely open for entertaining. Upstairs has 3 bedrooms, 2 bathrooms, a pool room and game room for a great layout. High Meadow Estates is a highly sought-after neighborhood located conveniently to The Woodlands, the Aggie Expressway, 249, and 99 and offers walking trails, neighborhood fishing ponds, pool, recreation center, tennis courts, b-ball courts, playground, etc.' ,`Acres` = '1.589' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S580104 - HIGH MEADOW ESTATES 04, BLOCK 2, LOT 8' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot,Wooded' ,`LotSize` = '69217' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'High Meadow Estates' ,`TaxAmount` = '12251' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711197' WHERE `Matrix_Unique_ID` = '211397289' --> 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','211453537','1663711197','211453537','2022-09-16T07:53:30.840','79063171','Alejandra Gonzalez','Jane Byrd Properties INTL.','','','29.728815','-95.356704','10','77004','5','140000.00','Active','Simmons','3261','Street','Houston','1','0','3','1346','Single-Family','Located in Houston\'s Third Ward just 7 Minutes from University of Houston, 4 minutes from Texas Southern University and just 9 minutes from Down Town Houston! Great location and easy access to 45! Home needs some work and TLC but great opportunity for someone looking to put in the work to fix. Home has great potential! Contact me if you have any more questions or for a showing.','0.1204','4','','','','','No Disclosures','','','1','University Area','Window Unit','0','LT 15 & TR 16A BLK 2 FOREST HOME','Other','4400','Appraisal District','','','0','','1','','0','','','','','Other','27 - Houston','BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)','YATES HIGH SCHOOL','CULLEN MIDDLE SCHOOL (HOUSTON)','Accompany,Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','1','Other Style','Forest Home','2899','2.3307','Public Sewer,Public Water','1936','Appraisal'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T07:01:13.887' ,`MLSNumber` = '18414964' ,`ListAgentFullName` = 'Jeff Denning' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.070563' ,`Longitude` = '-95.187739' ,`PhotoCount` = '36' ,`PostalCode` = '77345' ,`RoomCount` = '9' ,`ListPrice` = '319900.00' ,`Status` = 'Active' ,`StreetName` = 'Echo Falls' ,`StreetNumber` = '4426' ,`StreetSuffix` = 'Drive' ,`City` = 'Kingwood' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2508' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Major updates have been done at this Family-friendly home in the last 3 years including both HVAC systems, Kitchen cabinets, both full and the half bath, Luxury Vinyl Plank flooring downstairs and on the stairs, upstairs carpet, hot water heater, 95% of the fence, & the sprinkler system. The home is ideally located close to schools, playground, community pool, shopping, & easy access to Highway 59. All bedrooms are upstairs + a small play area. The secondary bedrooms are larger than normal with nice closet space. The spacious Family room downstairs has a corner fireplace and a separate sitting room approx. 14x12\r\n. The kitchen, breakfast area and Family room all flow together. The Kitchen itself is a chef\'s delight boasting amply counter space & cabinets. Updates include granite counters, tile backsplash, SS appliances, Gas stove/range, newer cabinets plus the Luxury Vinyl Plank flooring. The back yard is private with plenty of room for possible future pool & play equipment.' ,`Acres` = '0.1701' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLK 7 MILLS BRANCH VILLAGE SEC 2 AMD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7410' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '440' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'HIDDEN HOLLOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mills Branch' ,`TaxAmount` = '5915' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711197' WHERE `Matrix_Unique_ID` = '211589109' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T07:57:33.543' ,`MLSNumber` = '62467943' ,`ListAgentFullName` = 'Christopher Garcia' ,`ListOfficeName` = 'Oak Story Realty, LLC.' ,`SellingAgentFullName` = 'Omolara Osemene' ,`SellingOfficeName` = 'Triad One Realty' ,`Latitude` = '29.694394' ,`Longitude` = '-95.698808' ,`PhotoCount` = '28' ,`PostalCode` = '77407' ,`RoomCount` = '3' ,`ListPrice` = '284900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Brightwood Park' ,`StreetNumber` = '18134' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1616' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*Home is no longer tenant occupied, ready for immediate move in* Gorgeous home with 3 bedrooms and 2 baths in the beautiful subdivision of Twin Oaks Village. An open concept floorplan, this home features a spacious kitchen with a breakfast bar and area, and ample counter & cabinet space! Enjoy the relaxing primary bedroom with an abundance of natural light and space, and the bathroom is complete with dual sinks. Your secondary bedrooms are spacious with ample closet space. You will find amazing details throughout this home.' ,`Acres` = '0.1426' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TWIN OAKS VILLAGE SEC 6, BLOCK 2, LOT 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6212' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '575' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'JORDAN ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Twin Oaks Village Sec 6' ,`TaxAmount` = '4689' ,`TaxRate` = '2.4887' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711197' WHERE `Matrix_Unique_ID` = '211604578' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T06:11:41.993' ,`MLSNumber` = '7193025' ,`ListAgentFullName` = 'Christy Davis' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.794754' ,`Longitude` = '-95.209766' ,`PhotoCount` = '31' ,`PostalCode` = '77364' ,`RoomCount` = '5' ,`ListPrice` = '215000.00' ,`Status` = 'Active' ,`StreetName` = 'Hanging Tree' ,`StreetNumber` = '531' ,`StreetSuffix` = 'Trail' ,`City` = 'Point Blank' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming 3-bedroom 2-bath home features an open floor plan perfect for entertaining guests. The primary is large enough for a king bed, and the primary bath has a large walk-in closet with shelving. The home is situated on a little over 3 lots! The well shed is on a slab, has electricity, and plenty of room for extra storage. The neighborhood offers a community park with picnic tables and boat ramp with access to Lake Livingston. This home would make a perfect starter home!' ,`Acres` = '0.601' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'Outlaw Ridge Estates #1, Lot 254, 255, 273, p 273, Acres .6' ,`LotDesciption` = 'Cleared' ,`LotSize` = '26136' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Outlaw Ridge Estates' ,`TaxAmount` = '17' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663711198' WHERE `Matrix_Unique_ID` = '211637795' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T07:41:48.690' ,`MLSNumber` = '78614671' ,`ListAgentFullName` = 'Belinda Hyland' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.361179' ,`Longitude` = '-95.200590' ,`PhotoCount` = '43' ,`PostalCode` = '77328' ,`RoomCount` = '2' ,`ListPrice` = '338000.00' ,`Status` = 'Active' ,`StreetName` = 'Lee Turner Rd' ,`StreetNumber` = '3225' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1704' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming home outside of the city but close enough to get to Cleveland, Kingwood, or Conroe in less than 20 mins! 5.5 well-maintained acres with an Updated 2 bedroom 2 bath home. Large front porch for sitting and a huge back patio to watch the wildlife right in your backyard! This property also offers your very own \"ManCave\" or \"SheShed\" with full bathroom & bedroom loft and an additional nice-sized Workshop with water & power, perfect for creating all those crafty ideas! There\'s also a storage shed with a covered area for your yard equipment. Great Location....Quiet property just waiting for you to make it yours today!' ,`Acres` = '' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Coldspring/South San Jacinto County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'A304 PETER WHITAKER, TRACT 4.7A, ACRES 5.5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'NORTHSIDE ELEMENTARY SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cleveland' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711198' WHERE `Matrix_Unique_ID` = '211721517' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T06:01:57.233' ,`MLSNumber` = '44407310' ,`ListAgentFullName` = 'Nancy Andrade' ,`ListOfficeName` = 'AAA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.028170' ,`Longitude` = '-95.447873' ,`PhotoCount` = '21' ,`PostalCode` = '77090' ,`RoomCount` = '4' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Redleaf' ,`StreetNumber` = '727' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3170' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifull Home! Never Flooded. This house has a great floor plan with spacious 4-bedroom, 2.5 baths, with formal dining area, and an office/study room. Brick front porch elevation with great curve appeal, tile floors on the first floor, and carpet on the second floor. Brand new roof. A/C is 4 years old. Granite counter tops both in the kitchen and bathrooms. Big back yard with detached garage. Quiet community, close to I-45 and shopping area. Come see it; you won\'t be disappointed!' ,`Acres` = '0.2152' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 59 BLK 2 WESTADOR SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9375' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '590' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'BAMMEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westador Sec 05' ,`TaxAmount` = '5897' ,`TaxRate` = '2.3072' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711198' WHERE `Matrix_Unique_ID` = '211835734' --> 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','212017400','1663711198','212017400','2022-09-16T07:55:05.767','54513977','Frank Seymore','Century 21 Olympian Galleria','','','29.886403','-95.476996','22','77088','9','250000.00','Active','Bihia Forest','5803','Drive','Houston','2','0','3','1945','Single-Family','No showings until October 8th. \r\n\r\nConveniently located home in the Geater Inwood area, close to major transportation throughfares such as 249, 290, and Beltway 8. Renovated kitchen with new countertops and cabinets. Stainless steel appliances included. New hard wood floors throughout the home. Large primary bedroom with beautifully renovated en suite bathroom. Secondary bathroom has been beautifully renovated as well. Large formal dining room. New hot water heater. Ample Storage.','0.2571','11','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Estate','','','1','Northwest Houston','Central Gas','1','LT 9 BLK 1 017*I5645955-001-001-009 INWOOD NORTH SEC 1','Cul-De-Sac,Subdivision Lot','11200','Appraisal District','','300','0','','1','Single Oven','0','','','Gas Cooktop','','Composition','32 - Klein','NITSCH ELEMENTARY SCHOOL','KLEIN FOREST HIGH SCHOOL','KLEIN INTERMEDIATE SCHOOL','Appointment Required,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Inwood North Sec 01','3727','2.6055','Public Sewer,Public Water','1977','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212027035','1663711198','212027035','2022-09-16T07:55:55.950','51659839','Dan McCarver','BHGRE Gary Greene','Huongthao Do','Exceed Realty','29.543818','-95.076645','50','77573','8','899000.00','Option Pending','Plantation','928','Drive','League City','2','1','3','3206','Single-Family','This home is a rare find in Clear Lake! Custom built three bedroom offers a two story Great Room with\r\na wall of windows to the panoramic view! Well maintained and inviting. The property has an updated\r\nkitchen with Corian countertops and cooking island, Sub Zero refrigerator, tile flooring. Dual fireplace in\r\nliving area/breakfast room. Formal dining for entertaining and family gatherings. Owner\'s retreat has a\r\nspacious bath, fireplace and balcony for morning coffee. The outdoor features are two 41 ft boat slips\r\nplus lift, concrete bulkhead, extensive decking and terraced patio. Double paned windows, concrete tile\r\nroof, pea gravel driveway and front covered patio. Well landscaped with swaying palms. Enjoy the\r\never- changing backdrop of the lake, boat parades from this secluded setting.','0.2958','33','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','2','League City','Central Electric,Zoned','1','ABST 18 M MULDOON SUR LOT 4 CLEAR LAKE PLANTATION PATIO HOME','Water View','12882','Appraisal District','','400','0','','2','Electric Oven','0','','','Electric Cooktop','','Tile','9 - Clear Creek','FERGUSON ELEMENTARY SCHOOL','CLEAR CREEK HIGH SCHOOL','CLEAR CREEK INTERMEDIATE SCHOOL','Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Clear Lake Plantation Patio Ho','11359','2.0697','Public Water,Septic Tank','1986','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212108747','1663711198','212108747','2022-09-16T07:34:05.237','38020680','Novalyn Barnett','Walzel Properties','','','30.321732','-95.466063','21','77301','8','199000.00','Active','Thomas','903','Avenue','Conroe','1','0','3','1266','Single-Family','Fantastic opportunity to own an UNRESTRICTED property in a great location. Can be used as a residential, investment, or commercial property. This gem is on a large lot with mature trees, fully fenced in backyard with double gate access to back alleyway. Lots of potential to make this home your own or use it to generate income. Fresh paint, no carpet. Close proximity to Candy Cane Park with fun waterpark amenities for the family.','0.2324','19','','','','','Sellers Disclosure','1','','','Conroe Northeast','Central Gas','0','LAWNDALE PARK, BLOCK 10, LOT 2','Subdivision Lot','10125','Appraisal District','','','0','','0','','0','','','','','Composition','11 - Conroe','HOUSTON ELEMENTARY SCHOOL (CONROE)','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Right Side,Supra Keybox,Vacant/Unoccupied','Seller','1','Ranch','Lawndale Park','2147','2.1863','Public Sewer,Public Water','1952','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','212139054','1663711198','212139054','2022-09-16T06:46:21.000','11441650','Sandy Brabham','Keller Williams RealtyNortheast','Patrina White','Sucre Realty INC','29.984061','-95.173246','44','77346','9','419900.00','Option Pending','Timber Edge','7002','Lane','Humble','3','1','4','3256','Single-Family','Beautiful Perry Home situated on an oversized cul-de-sac lot. Conveniently located just a few minutes away from IAH Airport and a short commute to Downtown Houston. Surrounded by shopping, dining and family entertainment. Home features stunning engineered wood floors, high ceilings and plenty of space for a large group. The kitchen has been updated with stainless appliances and gorgeous granite counter tops. Work from home in your private office. Enjoy a large primary bedroom with huge windows for natural light. Primary bathroom has double sinks, a vanity area, jetted tub, seamless glass shower and large walk in closet with built- ins. Good size formal dining room for family dinners or holiday parties. Upstairs you will find a game room and 3 additional bedrooms; one has it\'s own private bathroom; the other two share a Jack & Jill bathroom. The pool size backyard offers plenty of room for children and pets to play.','0.3158','1','Perry Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Atascocita South','Central Gas','1','LT 23 BLK 4 ATASCA WOODS SEC 4 AMEND','Cul-De-Sac,Subdivision Lot','13755','Appraisal District','','550','0','','3','Electric Oven,Single Oven','0','','','Gas Cooktop','','Composition','29 - Humble','TIMBERS ELEMENTARY SCHOOL','ATASCOCITA HIGH SCHOOL','ATASCOCITA MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Traditional','Atasca Woods','7408','2.3974','Public Sewer,Water District','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','212311267','1663711198','212311267','2022-09-16T06:05:53.057','76352891','Michele Flory','Point Real Estate','','','30.151607','-95.532672','49','77389','15','1695000.00','Active','Badger Lodge','46','Circle','The Woodlands','4','1','4','5207','Single-Family','Love, love love! You will find everything you love in this impeccably maintained custom home with a resort feel in this gated community! Enjoy the Carlton Woods lifestyle living with golfing, tennis, dining in or on a patio, music venues, walking, bike rides...all at your fingertips! Gorgeous views of recent built pool & private backyard! If you work from home, you will find the views of the pond from the study peaceful & relaxing, even in the most stressful times. Entertaining is natural in this home w/large foyer that flows into formal dining, living area, kitchen, wet bar & out to the pool...so inviting for guests & yet so comfortable for the family. Enjoy nature w/wildlife around the pond, including a bald eagle! Primary suite offers views of pool & gardens & the bath is luxurious w/a closet that offers space for stackable washer & dryer. Upstairs bedrooms are great size for guests or children. Just a few minutes to John Cooper & several shopping areas. Life just became easier!','0.3549','14','Kingman Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Exclusions,Mud,Sellers Disclosure','1','Gaslog Fireplace','2','The Woodlands','Central Gas,Zoned','1','LT 12 BLK 1 THE WOODLANDS CARLTON WOODS CREEKSIDE 4 IN THE V','Greenbelt,In Golf Course Community,Water View','15461','Appraisal District','','4750','0','','3','Double Oven,Electric Oven','1','Gunite,Heated','','Gas Cooktop','','Tile','53 - Tomball','TIMBER CREEK ELEMENTARY SCHOOL (Tomball)','TOMBALL HIGH SCHOOL','CREEKSIDE PARK JUNIOR HIGH SCHOOL','Accompany,Appointment Required','Appraisal','2','Traditional','The Woodlands Carlton Woods Creekside','28768','2.6895','Water District','2009','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','212357129','1663711198','212357129','2022-09-16T07:42:17.833','74502406','Yolanda McCraw Cunningham','Realty Associates','','','29.709106','-95.360074','43','77021','10','1200000.00','Active','Macgregor','3620','Way','Houston','2','1','3','3420','Single-Family','This stately home is one of the original Historic Homes on South MacGregor. The home is distinctly situation from the street with a circular driveway. It has a wood burning fireplace and beautifully maintained hardwood flooring. Granite counter tops in the kitchen and 2 built-in granite top serving cabinets in the breakfast/morning room. Plenty of cabinet storage space in the kitchen and utility room conveniently off the kitchen. A sizable sunroom off the Primary suite, separated with French doors that can be used as an office, exercise room or a nursery. The home is situated on a sizable lot with ample space for a pool. Book an appointment today.','0.4632','4','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','','Freestanding,Wood Burning Fireplace','1','Riverside','Central Gas','0','TR 26 ABST 75 H TIERWESTER','Subdivision Lot','20177','Appraisal District','','','0','','3','Electric Oven','0','','','Gas Range','','Composition','27 - Houston','LOCKHART ELEMENTARY SCHOOL','YATES HIGH SCHOOL','CULLEN MIDDLE SCHOOL (HOUSTON)','Accompany,Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Riverside Terrance','13806','2.3307','Public Sewer,Public Water','1945','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','212362006','1663711198','212362006','2022-09-16T07:00:42.280','32961521','Lisa Marshall','eXp Realty, LLC','','','29.853944','-95.683961','11','77084','4','260000.00','Active','Calm Ct','5546','','Houston','2','0','3','1547','Single-Family','Welcome BACK Home!!Behold this stunning 3 beds, 2 baths one-story Long Lake home located in a nice well- established cul-de-sac in Windsong Pl. NEW carpet, NEW paint. Easy access to Sam Houston toll considering the location of this home you will not have to drive very far to your favorite shopping mall and eatery’s. This Home has NEVER flooded!! It’s a MUST SEE!!','','25','','','','','Sellers Disclosure','','','','Bear Creek South','Central Electric,Central Gas','1','Lt 39 blk 2','Cul-De-Sac','4880','Appraisal District','','450','0','','2','','0','','','','','Composition','13 - Cypress-Fairbanks','SHERIDAN ELEMENTARY SCHOOL','CYPRESS LAKES HIGH SCHOOL','WATKINS MIDDLE SCHOOL','Supra Keybox','Appraisal District','1','Traditional','Windsong place','','','Public Water','2005','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','212521337','1663711198','212521337','2022-09-16T07:32:42.853','60675940','Pat Bean','RE/MAX Suburbia','','','29.635675','-95.200221','27','77504','5','309000.00','Active','Winding','733','Road','Houston','1','0','3','1812','Single-Family','Two Homes, Workshop & Land! A diamond in the rough. The main home is 3 bedroom 1 bath indoor utility room, A very nice family room with beautiful built-ins, There are 3 additional areas attached to home that were workshops. There is a 25x40 metal shop (estimated) w/cement floor and electricity. The second home has 2 bedrooms 1 bath and a detached garage. Both homes need work but so much potential. There are Pecan, Oak and Sycamore trees on the property. Some tree\'s are 70+ years old.','1.5997','3','','','Gas Dryer Connections,Washer Connections','','Estate,No Disclosures','1','Wood Burning Fireplace','1','Southbelt/Ellington','Central Gas','0','TRS 7B & 7C HIGHLAND ACRES','Subdivision Lot','69682','Appraisal District','','','0','','0','','0','','','Gas Range','','Other','41 - Pasadena','YOUNG ELEMENTARY SCHOOL (PASADENA)','MEMORIAL HIGH SCHOOL (PASADENA)','MILLER INTERMEDIATE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Highland Acres','5373','2.6863','Public Sewer,Public Water','1957','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','212543499','1663711198','212543499','2022-09-16T06:59:11.613','34810795','Chuck Miller','Compass RE Texas, LLC','','','29.733819','-95.448824','25','77027','12','2350000.00','Active','Bash','22','Place','Houston','4','1','4','5602','Single-Family','This is where neighborhood charm meets modern luxury in the enchanting Highland Village area. Fall in love with the exquisite finishes by this custom home builder including, Dacor luxury kitchen appliances, custom cabinetry, a glass wine cellar, a Stiltz Trio glass elevator (wheelchair accessible), covered Lanai, private pool, Mont Alpi black stainless steel outdoor kitchen with refrigerator and beverage center, home generator, and an EV charging station. This spacious property, surrounded by majestic trees, is now home to this newly constructed modern residence. Enjoy a welcoming and walkable neighborhood which is a quiet gem in the midst of the city. The location is within walking distance of the prestigious River Oaks District Shops and multiple elegant restaurants. You will appreciate close proximity to the Galleria, Texas Medical Center, Downtown Houston, and major intersecting freeways. Schedule an appointment to view this masterpiece and buy this home in time for the Holidays.','0.1377','16','1','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','Gaslog Fireplace','1','Highland Village/Midlane','Central Gas','0','LT 11 BLK 1 WEST LANE PLACE SEC 3','Subdivision Lot','6000','Appraisal District','','','1','To Be Built/Under Construction','2','Gas Oven','1','In Ground','','Gas Cooktop','','Composition','27 - Houston','SCHOOL AT ST GEORGE PLACE','LAMAR HIGH SCHOOL (HOUSTON)','LANIER MIDDLE SCHOOL','Accompany,Appointment Required,No Supra Keybox','Builder','2','Contemporary/Modern','West Lane Place Sec 03','8871','2.3307','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212557136','1663711198','212557136','2022-09-16T07:59:44.300','20006735','David Gutierrez','Prime Realty Group','','','29.108471','-95.096752','42','77554','6','699999.00','Active','Bay Breeze','25818','Drive','Galveston','2','1','3','1859','Single-Family','Luxurious New Construction Home in highly sought-after Pointe West community. Home is still under construction with a targeted completion date of 10/20/2022. Home features an open concept living, dining, and kitchen space. Perfect for entertaining. Primary bedroom is located on the first floor. Loft space is a perfect area for bunk beds. Two additional bedrooms are on the second floor along with an additional bath. Community feature a lazy river pool, club house with an infinite pool, fitness center, grilling areas, cabanas, game room, fishing piers, wading areas, and a restaurant and bar. Pointe West is the premier community in Galveston with the best beaches on Galveston Island. Proven Vacation Rental income area. Seller has 2 additional lots available to build your dream vacation home.','0.2199','33','McDaniel Homes','','','','Sellers Disclosure','','','','West End','Central Electric','1','POINTE WEST SEC 3-C PH 2 (2009) ABST 121, BLOCK 1, LOT 8, AC','Cleared','9578','Appraisal District','','750','1','To Be Built/Under Construction','2','','0','','','','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Accompany,Appointment Required','Builder','2','Traditional','Pointe West Sec 3-C Ph 22009','526','2.0324','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212557832','1663711198','212557832','2022-09-16T06:04:03.733','56001944','Jared Turner','Turner Mangum,LLC','','','29.984105','-96.318009','33','77418','9','829990.00','Active','Hillview','2260','Road','Bellville','2','1','3','2621','Single-Family','Amazing and rare opportunity in the highly sought-after Sycamore Hills community. This beautiful home is nestled on just over 3 acres of land. Stunning stone front elevation with large wrap-around covered porch. Welcoming entry, family room with spectacular floor-to-ceiling stone fireplace and a sunroom perfect for taking in the view. The kitchen features a custom tile backsplash, Italian marble farm sink facing an oversized picture window, stainless steel appliances, and a breakfast nook overlooking the sprawling backyard. Luxurious primary suite with, soaking tub, and large walk-in shower. 2 bedrooms and home office or den upstairs! Porcelain tile and engineered wood. Large Barn and workshop with wood interior and balcony. At the end of the street is the private 37.5 acre wildlife preserve & recreational park for Sycamore Hill property owners & guests with walking trails, 3.5 acre catch & release lake, pavilion, fireplace & restrooms. Low Tax Rate! 5 min to Bellville, 10 to Brenham.','3.07','57','','','Electric Dryer Connections,Washer Connections','','Exclusions,Other Disclosures,Sellers Disclosure','1','Gaslog Fireplace','1','','Central Electric','1','SYCAMORE HILL LOT 18','Subdivision Lot,Water View,Wooded','133729','Other','','210','0','','2','Electric Oven','0','','','Gas Range','','Composition','136 - Bellville','WEST END ELEMENTARY SCHOOL','BELLVILLE HIGH SCHOOL','BELLVILLE JUNIOR HIGH','Appointment Required,Leave Business Card,Lockbox Front','Seller','2','Traditional','Sycamore Hill','9655','1.8096','Public Water,Septic Tank','2013','Appraisal'); --> New record created successfully