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-11-25T07:40:00.343' ,`MLSNumber` = '43619634' ,`ListAgentFullName` = 'Michael Johnson' ,`ListOfficeName` = 'Evans and Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.139847' ,`Longitude` = '-95.389763' ,`PhotoCount` = '35' ,`PostalCode` = '75851' ,`RoomCount` = '9' ,`ListPrice` = '519900.00' ,`Status` = 'Active' ,`StreetName` = 'FM 1280 E' ,`StreetNumber` = '6615' ,`StreetSuffix` = '' ,`City` = 'Lovelady' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2904' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for the perfect country setting , this is newly remodeled home boost 5 bedrooms and 3 bathrooms with a huge Great room for family gatherings , everything is brand new, A/C , roof, plumbing , windows, flooring , lighting, paint, and much much more, A Must See' ,`Acres` = '2.86' ,`Area` = '41' ,`BuilderName` = 'N/A' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crockett Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WM Cruz AB 26 2.86 acres' ,`LotDesciption` = 'Cleared' ,`LotSize` = '124582' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '62 - Lovelady' ,`SchoolElementary` = 'LOVELADY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LOVELADY J H HIGH SCHOOL' ,`SchoolMiddle` = 'LOVELADY J H HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'N/A' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642342' WHERE `Matrix_Unique_ID` = '208366093' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T08:56:18.900' ,`MLSNumber` = '62088761' ,`ListAgentFullName` = 'Lee DeForke Jr.' ,`ListOfficeName` = 'Lee DeForke Jr.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.324230' ,`Longitude` = '-94.941619' ,`PhotoCount` = '40' ,`PostalCode` = '77563' ,`RoomCount` = '7' ,`ListPrice` = '542000.00' ,`Status` = 'Active' ,`StreetName` = 'Warsaw' ,`StreetNumber` = '619' ,`StreetSuffix` = 'Street' ,`City` = 'Bayou Vista' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1684' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ready for summer fun and boating, this wonderful home has all you need for family and friends. Large open concept with living room, dining room and kitchen open to one another. Granite countertops, large pantry and lots of cabinet space. Plenty of windows for water views. Large party deck as well as pergola with bench seating for a number of guests and entertaining. Master suite has its own private balcony, private full bath and walk in closets. Enjoy the sunrises and sunsets from your private balcony off the master. Boat dock, lift and fish cleaning station, while the garage is set up for workshop and benches. . Do not miss this one.' ,`Acres` = '0.1056' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bayou Vista' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 7 PAGE 7 LOT 619 NEW BAYOU VISTA ADDN 4B' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '4600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HIGHLANDS ELEMENTARY SCHOOL (LA MARQUE)' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'New Bayou Vista 4b' ,`TaxAmount` = '8916' ,`TaxRate` = '2.635' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642342' WHERE `Matrix_Unique_ID` = '208728533' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T07:51:56.270' ,`MLSNumber` = '24850023' ,`ListAgentFullName` = 'Dionne Kubin' ,`ListOfficeName` = 'Jane Byrd Properties INTL.' ,`SellingAgentFullName` = 'Christy Naponic' ,`SellingOfficeName` = 'The Reyna Group' ,`Latitude` = '29.798820' ,`Longitude` = '-95.479650' ,`PhotoCount` = '23' ,`PostalCode` = '77055' ,`RoomCount` = '9' ,`ListPrice` = '800000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Early' ,`StreetNumber` = '1544' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2942' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This exceptional never-lived-in designer home by Imperial Builders is at the end of the street providing privacy and serenity, with lockable gate access, and private double driveway. All located on the 1st floor is the living room w/ fireplace and custom built-ins; gourmet kitchen w/ quartz countertops, hardwoods, 20ft planked ceilings w/ banquette, island seating and stainless steel appliances-double ovens, microwave and 5-burner stove; separate dining area, primary bedroom and bath, laundry room w/ sink and 1/2 bath. This exquisite home also has an ELEVATOR leading to the 2nd-floor game room, 3 secondary bedrooms, and two full bathrooms. iVision+ wireless remote camera/doorbell included.' ,`Acres` = '0.0867' ,`Area` = '24' ,`BuilderName` = 'Imperial Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 CRAIG WOODS 14TH PAR R/P' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '3775' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'TREASURE FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Craig Woods Reserve B Pt' ,`TaxAmount` = '16717' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642343' WHERE `Matrix_Unique_ID` = '209581705' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T08:52:13.363' ,`MLSNumber` = '97010943' ,`ListAgentFullName` = 'Rhonda Delany' ,`ListOfficeName` = 'CB&A, Realtors- Southeast' ,`SellingAgentFullName` = 'Brandon Walsh' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.528551' ,`Longitude` = '-95.193126' ,`PhotoCount` = '44' ,`PostalCode` = '77546' ,`RoomCount` = '6' ,`ListPrice` = '499900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Whittier' ,`StreetNumber` = '15' ,`StreetSuffix` = 'Drive' ,`City` = 'Friendswood' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3350' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated 4 bedroom, 3 bath home in the quiet Quaker’s Landing neighborhood in the highly coveted Friendswood ISD. This home features two primary suites: one boasts high ceilings, an oversized master closet, a deep soaking tub, and a large walk-in shower with bench seat. Primary bedroom overlooks the pool with its water wall and sundeck with built-in water features. The house has tile floors to resemble hardwood and carpet in living room and bedrooms; an updated kitchen with granite countertops and professional grade appliances which includes a warming drawer; and a large sunroom. This home is located on a cul-de-sac on a large oversized lot. The lot includes a pool and spa with outdoor changing room/bathroom and a 12 x 20 shed with electricity. Low Flood Insurance!!! Schedule your appointment today!!!' ,`Acres` = '0.5762' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 151 PAGE 5 LOT 61 QUAKERS LANDING' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '25099' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'WESTWOOD ELEMENTARY SCHOOL (FRIENDSWOOD)' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Quakers Landing' ,`TaxAmount` = '7863' ,`TaxRate` = '2.2832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642343' WHERE `Matrix_Unique_ID` = '210014226' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T08:32:24.380' ,`MLSNumber` = '3604607' ,`ListAgentFullName` = 'Shara Hymowitz' ,`ListOfficeName` = 'Houston Home Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.756701' ,`Longitude` = '-95.389547' ,`PhotoCount` = '13' ,`PostalCode` = '77019' ,`RoomCount` = '9' ,`ListPrice` = '755000.00' ,`Status` = 'Active' ,`StreetName` = 'Crocker' ,`StreetNumber` = '1203' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3085' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'From award-winning homebuilder, ROC Homes, this incredible plan has 4 Bedrooms 3.5 baths and features \"First Floor Lifestyle\" with a private driveway and attached two-car garage for comfort and convenience. \r\n\r\nWhat\'s also hard to find is along with this being a 4/3.5, it ALSO includes a study and game room! \r\n\r\nAvailable for move-in NOW!\r\n\r\n***AVAILABLE TO TOUR ANYTIME! \r\n\r\nIt features a lovely chef\'s kitchen equipped with Shaker cabinetry, quartz countertops and premium Whirlpool stainless steel appliances. The living & dining areas boast abundant natural light & fully fenced in backyard\r\n\r\nUpstairs, you\'ll find a master suite with a huge walk-in closet, & a suite spa bathroom. 2 additional beds, a bath, a laundry room & a private study complete the second floor, and a bed, bath and large secondary living space the third floor.' ,`Acres` = '' ,`Area` = '16' ,`BuilderName` = 'ROC Homes Texas Ltd' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Montrose' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'na' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '2500' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WILLIAM WHARTON K-8 DUAL LANGUAGE ACADEMY' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'GREGORY-LINCOLN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Montrose' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669642343' WHERE `Matrix_Unique_ID` = '210765790' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T07:48:48.217' ,`MLSNumber` = '21279586' ,`ListAgentFullName` = 'Suyapa Jedeh' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = 'Nikkie Huber' ,`SellingOfficeName` = 'Keller Williams Realty -SW' ,`Latitude` = '29.745650' ,`Longitude` = '-95.301664' ,`PhotoCount` = '24' ,`PostalCode` = '77011' ,`RoomCount` = '2' ,`ListPrice` = '140000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Avenue' ,`StreetNumber` = '6821' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '642' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great Investment opportunity in the East End district! Being SOLD \'AS-IS\' WHERE IS- No repairs. PLEASE NOTE: LOT SIZE AND HOUSE SF IS INCORRECT IN APPRAISAL DISTRICT. Lot SIZE 2,500 AND HOUSE 642 SF. Buyer to verify all information including room dimensions, taxes, schools etc. Lot size and square footage per HCAD. Buyer to purchase a Survey. Great potential as new construction is being built in the area. Property has not flooded, prime location with easy access to Medical Center, Southeast of downtown and the Port Of Houston. Please call with any questions.' ,`Acres` = '0.1148' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 13 & 14 BLK 133 CENTRAL PARK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2500' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'FRANKLIN ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'EDISON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Central Park' ,`TaxAmount` = '2762' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642343' WHERE `Matrix_Unique_ID` = '211331275' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T07:47:29.283' ,`MLSNumber` = '51680493' ,`ListAgentFullName` = 'Suyapa Jedeh' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = 'Nikkie Huber' ,`SellingOfficeName` = 'Keller Williams Realty -SW' ,`Latitude` = '29.745652' ,`Longitude` = '-95.301491' ,`PhotoCount` = '6' ,`PostalCode` = '77011' ,`RoomCount` = '2' ,`ListPrice` = '140000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Avenue' ,`StreetNumber` = '6825' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '642' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great Investment opportunity in the East End district! Being SOLD \'AS-IS\' WHERE IS- No repairs. Drive by only for now- Please do not disturb tenants!. Buyer to verify all information including room dimensions, taxes, schools etc. Lot size and square footage per HCAD. Buyer to purchase a Survey. Great potential as new construction is being built in the area. Property has not flooded, prime location with easy access to Medical Center, Southeast of downtown and the Port Of Houston. Please call with any questions.' ,`Acres` = '0.0574' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 12 BLK 133 CENTRAL PARK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'FRANKLIN ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'EDISON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Central Park' ,`TaxAmount` = '1536' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642344' WHERE `Matrix_Unique_ID` = '211660464' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T07:50:13.280' ,`MLSNumber` = '92718805' ,`ListAgentFullName` = 'Suyapa Jedeh' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = 'Nikkie Huber' ,`SellingOfficeName` = 'Keller Williams Realty -SW' ,`Latitude` = '29.745615' ,`Longitude` = '-95.301419' ,`PhotoCount` = '6' ,`PostalCode` = '77011' ,`RoomCount` = '2' ,`ListPrice` = '140000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Avenue' ,`StreetNumber` = '6827' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '642' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great Investment opportunity in the East End district! Being SOLD \'AS-IS\' WHERE IS- No repairs. Drive by only for now- Please do not disturb tenants!. Buyer to verify all information including room dimensions, taxes, schools etc. Lot size and square footage per HCAD. Buyer to purchase a Survey. Great potential as new construction is being built in the area. Property has not flooded, prime location with easy access to Medical Center, Southeast of downtown and the Port of Houston. Please call with any questions.' ,`Acres` = '0.0574' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 11 BLK 133 CENTRAL PARK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'FRANKLIN ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'EDISON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Central Park' ,`TaxAmount` = '1683' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642344' WHERE `Matrix_Unique_ID` = '211670618' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T07:14:48.000' ,`MLSNumber` = '58118955' ,`ListAgentFullName` = 'Erika Hernandez' ,`ListOfficeName` = 'HOUSTON TOP REALTY' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.874052' ,`Longitude` = '-95.629628' ,`PhotoCount` = '39' ,`PostalCode` = '77084' ,`RoomCount` = '5' ,`ListPrice` = '299999.00' ,`Status` = 'Active' ,`StreetName` = 'Hertford Park' ,`StreetNumber` = '6803' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! This lovely & unique Hertford Home features 2 stories (1st floor has common areas- kitchen, living, dining & half bath) & 2nd floor has primary bedroom plus 2 bedrooms, Laundry and access to garage apartment via walkway outdoors. The Studio Garage Apartment is perfect for a quiet WORK FROM HOME space, maybe an extended stay by a friend/family member, maybe a second small group. The choice is all yours. Also, new paint and ALL NEW carpet upstairs and recently updated flooring in living room. DO NOT PASS THIS UP !!! Call for appointment today. Hablamos espanol, llama hoy para tu cita.' ,`Acres` = '' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 44 BLK 1 HEARTHSTONE PLACE SEC 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6285' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '387' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HORNE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hearthstone Place Sec 01' ,`TaxAmount` = '5524' ,`TaxRate` = '3.171' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642344' WHERE `Matrix_Unique_ID` = '212040400' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T08:14:59.607' ,`MLSNumber` = '51933198' ,`ListAgentFullName` = 'Joe Applewhite' ,`ListOfficeName` = 'CB&A, Realtors- Southeast' ,`SellingAgentFullName` = 'Stacie Hoyt' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.040429' ,`Longitude` = '-95.737052' ,`PhotoCount` = '39' ,`PostalCode` = '77480' ,`RoomCount` = '10' ,`ListPrice` = '298000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'County Road 321' ,`StreetNumber` = '9761' ,`StreetSuffix` = '' ,`City` = 'Sweeny' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2005' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 3/2 Plus Flex Room Home In The Peaceful Country That Sits On Over 1 Acre! This Beautiful Home Features 2 Living Areas or Large Dining Area For Get Togethers, Open Floor Plan Perfect For Entertaining & Beautifully Updated Kitchen. Large Kitchen Has Beautiful Quartz Counters, All Matching Stainless Appliances, Dry/Coffee Bar, Undermounted Farm Sink, Tons Of Storage & A Breakfast Bar To Socialize. Spacious Family Room Features A Stunning Stone Fireplace With Floating Fredericksburg Mantle Perfect For Those Cold Nights, Stained Concrete Floor & Lovely French Doors Leading Out To The Backyard. Double Pane Low-E Vinyl Double-Hung Windows Will Help Keep This Home Cool Or Warm For Every Season. Meticulously Maintained Property Is Move In Ready. Located On Corner Lot, The Property Also Features A 12X16 Foot Shed And A Large Patio Area 24x23, Great For Entertaining. Huge, Fully Fenced, Private Backyard Will Be The Place To Hang Out Complete w/Firepit! New Roof, AC & Water Softener Stays' ,`Acres` = '1.09' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'POWERS (A0046 CHAS BREEN), LOT 41, ACRES 1.090' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot' ,`LotSize` = '47480' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '51 - Sweeny' ,`SchoolElementary` = 'SWEENY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SWEENY HIGH SCHOOL' ,`SchoolMiddle` = 'SWEENY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Powers' ,`TaxAmount` = '4149' ,`TaxRate` = '2.0957' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642344' WHERE `Matrix_Unique_ID` = '212457025' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T08:32:03.320' ,`MLSNumber` = '56024106' ,`ListAgentFullName` = 'Ryan Adams' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.505583' ,`Longitude` = '-95.524612' ,`PhotoCount` = '50' ,`PostalCode` = '77459' ,`RoomCount` = '12' ,`ListPrice` = '519900.00' ,`Status` = 'Active' ,`StreetName` = 'Caulder' ,`StreetNumber` = '4110' ,`StreetSuffix` = 'Way' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3736' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'TRANQUIL & TRADITIONAL - Nestled in the Highly sought after Steep Bank West section of Sienna and traditional in style, this spacious 5BR/3.5BA, 3,736sqft abode sits on an attractive cul-de-sac lot with gorgeous landscaping and a stately front brick exterior. Enter to find a soaring two-story foyer, an organically flowing floorplan, hardwood flooring, luminous natural light, and a living room w/fireplace. Discover a gourmet kitchen with stainless-steel appliances, ample cabinetry, granite countertops, center island w/ gas cooktop. The fully fenced-in expansive backyard is made for entertaining with a beautiful \"Swim Spa\". Sleep easy in the master bedroom which has an en suite w/jetted tub, separate shower, and dual sinks. Other features: detached 3-car garage w/walkway to home, laundry room, office/flex space w/rustic barn door, backing up to a multiple mile walking trail, close to schools and shopping, and so much more! Call now for your tour!' ,`Acres` = '0.3081' ,`Area` = '38' ,`BuilderName` = 'Perry' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIENNA STEEP BANK VILLAGE SEC 2-A, BLOCK 1, LOT 2' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '13421' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SIENNA CROSSING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna Steep Bank Village' ,`TaxAmount` = '9977' ,`TaxRate` = '2.5729' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642344' WHERE `Matrix_Unique_ID` = '212474246' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T08:34:01.693' ,`MLSNumber` = '76407133' ,`ListAgentFullName` = 'Michael Nassif' ,`ListOfficeName` = 'NRE Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.586464' ,`Longitude` = '-95.243866' ,`PhotoCount` = '18' ,`PostalCode` = '77089' ,`RoomCount` = '7' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Kirksage' ,`StreetNumber` = '10518' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2640' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing Riverstone Ranch house. Move-in ready. Enormous and open two story floor plan. Beautiful ceramic throughout most of the first floor. Beautiful granite counter tops in the gourmet kitchen. Magnificent cabinets. Gourmet kitchen appliance package including dishwasher, gas range, and new OTR microwave. Recessed lighting and ceiling fans. Beautiful over-sized master bathroom and lots of closets. Spacious game room. Awesome neighborhood. Excellent schools. Nice fenced backyard. Home sweet home.' ,`Acres` = '0.172' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 35 BLK 3 RIVERSTONE RANCH SEC 9' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7493' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'SOUTH BELT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'THOMPSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverstone Ranch' ,`TaxAmount` = '6814' ,`TaxRate` = '2.7255' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642345' WHERE `Matrix_Unique_ID` = '212690741' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T08:09:06.837' ,`MLSNumber` = '97840344' ,`ListAgentFullName` = 'Nicole Handy' ,`ListOfficeName` = 'Braden Real Estate Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.714640' ,`Longitude` = '-95.428055' ,`PhotoCount` = '42' ,`PostalCode` = '77005' ,`RoomCount` = '13' ,`ListPrice` = '3500000.00' ,`Status` = 'Active' ,`StreetName` = 'University' ,`StreetNumber` = '3201' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '7040' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Seize the opportunity to own the most iconic home in Houston, nestled behind breathtaking majestic oak trees on a primer 18K sqft corner lot in the heart of the prestigious West University. Internationally renowned, with over 7K sqft of spacious living, this unique design features 2 grand floating staircases with towering floor-to-ceiling windows lining the entire rear of the home. The backyard oasis is seen from every room in the home. Significant upgrades and features include a state-of-the-art lighting system, 3 new AC units, new water heater, 2 new ice makers, new dishwasher, new oven, 72\' sub zero fridge, wet bar, stunning wine room, a home study with a 360 view of the 1st floor, 4 car show garage, & security camera system. Delight on the 2nd story balcony that overlooks the brand new pool & spa. This home was built to entertain. Located minutes from the world-renowned Texas Medical Center, Rice University, Rice U Elementary, & Rice Village premier shopping and dining.' ,`Acres` = '0.4132' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 6A 7 & 8B BLK 21 WEST UNIVERSITY PLACE SEC 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '18000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'West University Place Sec 01' ,`TaxAmount` = '66863' ,`TaxRate` = '2.0584' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642345' WHERE `Matrix_Unique_ID` = '212917104' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T08:57:47.867' ,`MLSNumber` = '20413695' ,`ListAgentFullName` = 'Luis Ramirez' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.732995' ,`Longitude` = '-95.281496' ,`PhotoCount` = '32' ,`PostalCode` = '77012' ,`RoomCount` = '3' ,`ListPrice` = '248500.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue F' ,`StreetNumber` = '7933' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1370' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'What a charming property for sale! This one-story beauty provides a garage with an extended driveway for all your convenience. Inside, you\'ll discover a light & bright open layout featuring neutral palette, wood-look flooring, and a spacious living room. Impeccable kitchen has stainless steel appliances, plenty of white cabinetry with crown molding, and granite counters for all your cooking needs. Continue into the large hallway, where you find the sizable bedrooms. The cozy primary suite includes a private bathroom and a walk-in closet for added comfort. Adorable backyard is ideal for unwinding after a hard day\'s work. You can\'t miss out on this fantastic property!' ,`Acres` = '0.0574' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 42 MAGNOLIA PARK SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DE ZAVALA ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'MILBY HIGH SCHOOL' ,`SchoolMiddle` = 'EDISON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Magnolia Park Sec 02' ,`TaxAmount` = '2396' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1936' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642345' WHERE `Matrix_Unique_ID` = '213118104' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T08:30:45.860' ,`MLSNumber` = '48678453' ,`ListAgentFullName` = 'Jason Jones' ,`ListOfficeName` = 'Wild Oak Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.828578' ,`Longitude` = '-95.447368' ,`PhotoCount` = '49' ,`PostalCode` = '77018' ,`RoomCount` = '9' ,`ListPrice` = '1395000.00' ,`Status` = 'Active' ,`StreetName` = 'Chantilly' ,`StreetNumber` = '1854' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4429' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1854 Chantilly combines elegance and functionality to bring you this newly constructed home. This home, built by Stone Throw Builders and meticulously crafted by Creole Designs, raises the bar in Oak Forest. An extensive fiberglass Marvin Windows and Door package allows an abundant amount of natural light to fill this near 4500 sf home. The magnificent open kitchen is equipped with luxurious Fisher & Paykel appliance package, an extensive amount of storage, gorgeous quartz island, stained maple millwork. From the moment you arrive, the lush landscaping will greet you, and features such as the setback garage and outdoor kitchen will differentiate this home. The oversized sliding patio doors provide a view of the large back porch for relaxing or entertaining. Builder upgrades such as poly foam insulation, and 1 1/8 inch decking on the 2nd floor come standard in this timeless move in ready home. Wired inside and out for alarm, cameras, data, and cable. Schedule your showing today.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Stone Throw Builders' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 29 BLK 74 OAK FOREST SEC 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7080' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'STEVENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Oak Forest' ,`TaxAmount` = '10525' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669642345' WHERE `Matrix_Unique_ID` = '213293522' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T07:55:39.903' ,`MLSNumber` = '59118451' ,`ListAgentFullName` = 'Scott Schwandt' ,`ListOfficeName` = 'RE/MAX River Cities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.767621' ,`Longitude` = '-98.214847' ,`PhotoCount` = '41' ,`PostalCode` = '78132' ,`RoomCount` = '4' ,`ListPrice` = '695000.00' ,`Status` = 'Active' ,`StreetName` = 'Fallen Oak' ,`StreetNumber` = '361' ,`StreetSuffix` = '' ,`City` = 'New Braunfels' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '4203' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*UNRESTRICTED & NO HOA on 5-ACRES* The stars do come out at night at this scenic Hill Country home, or Bed & Breakfast, in New Braunfels. Close to Canyon Lake and only minutes to Gruene and Downtown New Braunfels. This fully fenced gem offers a charming 2-story home complete with fireplace, hardwood floors, dual pantries, granite countertops, custom cabinets, 3 bed & 3.5 baths. The attached garage apartment has a full bath, space for kitchenette and upstairs loft. All-in-all the property boasts 4,203 SF of living space that\'s ready to fulfill your dreams of living the hill country lifestyle. Outside you\'ll find a pond, RV hookups, rock fireplace, large patio, garden, storage shed, outdoor workshop, and plenty of room for a pool. Make this rare property yours today before it\'s gone!' ,`Acres` = '5.01' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BEAR CREEK HILLS 3, LOT 6' ,`LotDesciption` = 'Greenbelt' ,`LotSize` = '218236' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '142 - New Braunfels' ,`SchoolElementary` = '' ,`SchoolHigh` = 'NEW BRAUNFELS HIGH SCHOOL' ,`SchoolMiddle` = 'OAKRUN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1.5' ,`Style` = 'Ranch' ,`Subdivision` = 'Bear Creek Hills 3' ,`TaxAmount` = '14978' ,`TaxRate` = '1.7007' ,`WaterSewer` = 'Aerobic,Septic Tank' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642346' WHERE `Matrix_Unique_ID` = '213438456' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T08:01:51.797' ,`MLSNumber` = '62649866' ,`ListAgentFullName` = 'Stephen Marshall' ,`ListOfficeName` = 'Pivot Up Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.989581' ,`Longitude` = '-95.255740' ,`PhotoCount` = '22' ,`PostalCode` = '77338' ,`RoomCount` = '3' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Carolyn' ,`StreetNumber` = '1301' ,`StreetSuffix` = 'Court' ,`City` = 'Humble' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1768' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A rare find! So much potential in this charming one-story home on quarter-acre corner lot in the City of Humble! This 3-bedroom home has a dining area, formal living room and den with custom built-in cabinetry and lovely exposed beams. The screen-in patio is perfect for gardening or simply enjoying the privacy of the shady, fully-fenced backyard. Outside you\'ll find a carport plus an attached 2-car garage with plenty of room for tools or projects! An absolute MUST-SEE, this hidden gem is located in the City of Humble with easy access to 59 and no HOA fees or MUD taxes. NO FLOODING OR BURST PIPES. Awaiting new loving owner...schedule your private tour today!' ,`Acres` = '0.2799' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Humble Area East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 1 BLK 1 LAKELAND SEC 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '12191' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'LAKELAND ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'ROSS STERLING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakeland' ,`TaxAmount` = '3277' ,`TaxRate` = '2.2965' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642346' WHERE `Matrix_Unique_ID` = '213518313' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T08:59:40.430' ,`MLSNumber` = '75495397' ,`ListAgentFullName` = 'Luis Ramirez' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.777123' ,`Longitude` = '-95.329079' ,`PhotoCount` = '32' ,`PostalCode` = '77020' ,`RoomCount` = '3' ,`ListPrice` = '288000.00' ,`Status` = 'Active' ,`StreetName` = 'New Orleans' ,`StreetNumber` = '4105' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1230' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home looking for a new owner! This single-story gem features a grassy front yard, a lovely curb appeal, and an inviting porch where you can enjoy your morning coffee. Come inside to find a bright living room perfect for entertaining your guests, soothing palette, and wood-look flooring throughout the house. The eat-in kitchen showcases stainless steel appliances, white cabinets, and plenty of counter space for your cooking needs. In the main retreat, you\'ll discover fantastic views, a walk-in closet, and a spotless bathroom with dual sinks & tub/shower combination. Peaceful & serene backyard offers a cozy deck, convenient storage, and so much space to grow & play. This is a \"must-see\" home!' ,`Acres` = '0.1297' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 2 BRITTON SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5650' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ATHERTON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'FLEMING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Britton Sec 01' ,`TaxAmount` = '2501' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642346' WHERE `Matrix_Unique_ID` = '213769574' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T07:41:55.920' ,`MLSNumber` = '3467283' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '29.548910' ,`Longitude` = '-95.726043' ,`PhotoCount` = '50' ,`PostalCode` = '77469' ,`RoomCount` = '17' ,`ListPrice` = '3500000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Sovereign' ,`StreetNumber` = '21' ,`StreetSuffix` = 'Circle' ,`City` = 'Richmond' ,`BathsFull` = '7' ,`BathsHalf` = '1' ,`BedsTotal` = '7' ,`SqFtTotal` = '7555' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Sovereign Shores is tucked away just off 59 and Williams Way in Richmond TX. This private gated community is sure to impress! 21 Sovereign Circle sits on one of the biggest homesites in the subdivision at 6.44 acres. With gated drive access this estate features a winding drive to the circular front drive, 4 car garage with 1,052 sf living quarters over the garage and a 2 bedroom 1,190 sq ft guest house just through the rose garden at the back of the estate. This old world New Orleans style home boasts 100+ yr old pine wood floors, hand-painted wallpaper in the foyer, repurposed antique gasolier lighting, geothermal cooling and heating, sub zero refrigerator and stainless steel appliances, formal living, dining and study, extended butlers pantry, a 2nd floor private study with spiral stairs to 3rd floor. Full estate sprinkler system. The primary suite has a separate soaking tub in the executive bath. Relax on the full wraparound porch and enjoy plenty of shade from pecan and oak trees.' ,`Acres` = '6.4379' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Mock Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '4' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SOVEREIGN SHORES ESTATES SEC 1, BLOCK 4, LOT 1 & 2, ACRES 6.' ,`LotDesciption` = 'Corner,Subdivision Lot,Wooded' ,`LotSize` = '280435' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '7986' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'WILLIAMS ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,No Photos/No Videos' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Colonial' ,`Subdivision` = 'Sovereign Shores Estates Sec 1' ,`TaxAmount` = '48450' ,`TaxRate` = '1.6948' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642346' WHERE `Matrix_Unique_ID` = '213831718' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T08:32:32.070' ,`MLSNumber` = '89290718' ,`ListAgentFullName` = 'Daniel Dominguez' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.382049' ,`Longitude` = '-94.992610' ,`PhotoCount` = '35' ,`PostalCode` = '77591' ,`RoomCount` = '7' ,`ListPrice` = '186999.00' ,`Status` = 'Active' ,`StreetName` = 'Hummingbird' ,`StreetNumber` = '7318' ,`StreetSuffix` = 'Lane' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1288' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous three-bedroom two-bath corner house is one not to pass over. This home is minutes from local beaches and schools. This corner lot has a large back yard great for family gatherings, and kids play. This beautiful house has been fully remodeled. It radiates both modern taste with a handful of southern hospitality. You can feel the warmth and coziness as you spend the days with family and friends. The features include redesigned living room space with open concept, and includes new flooring and new paint. The kitchen has new cabinets, new granite countertops with plenty of space for cooking on a newly installed cooking gas range. Further, to include new HVAC, new plumbing and new remodeled restrooms. This illustrious property also has an attached garage space, which features a washroom with a new water heater. Further, as you walk though out this home you will see new light \r\nfixtures and stainless still appliances. Schedule your appointment today.' ,`Acres` = '0.1615' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 2 PAGE 6 LOT 18 BLK 3 SOUTH ACRE MANOR' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7035' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'SIMMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'South Acre Manor' ,`TaxAmount` = '1892' ,`TaxRate` = '2.582' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1669642346' WHERE `Matrix_Unique_ID` = '213909866' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T08:00:38.200' ,`MLSNumber` = '16465038' ,`ListAgentFullName` = 'Dondtray Thomas' ,`ListOfficeName` = 'Home Journey Realtors, LLC' ,`SellingAgentFullName` = 'Dami Olatunde' ,`SellingOfficeName` = 'Discovered Homes Inv. Inc.' ,`Latitude` = '29.938743' ,`Longitude` = '-95.173655' ,`PhotoCount` = '50' ,`PostalCode` = '77044' ,`RoomCount` = '12' ,`ListPrice` = '489000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Waterside View' ,`StreetNumber` = '14918' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4051' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 5-bedroom and 4.5 bath stucco and brick home built by Taylor Morrison in a gated community located on Lake Houston! Master, Guest Suite, and Home Office/Study are on the first floor. Three Bedrooms are upstairs, along with a Media Room and Game Room. All Bedrooms have walk-in closets! The home features a spacious kitchen with upgraded granite countertops, a large island open to the family/living area to host family and friends, high ceilings, 8 ft. doors, a formal dining, a bay window in the breakfast area, butler\'s pantry, upgraded tile, carpet and ceiling fans. This stunning home also has custom Plantation Shutters in the office, dining room and side-light of front entry. The guest suite on the first floor has a custom wall feature. Did I forget to mention that the media room upstairs also has a projector, surround sound and large movie screen in order to enjoy late night movies with the family! Also, this home includes a back yard storage shed. Seller is listing agent.' ,`Acres` = '0.1644' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 STILLWATER ON LAKE HOUSTON SEC 4' ,`LotDesciption` = 'Other' ,`LotSize` = '7161' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'CENTENNIAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stillwater/Lk Houston Sec 4' ,`TaxAmount` = '12797' ,`TaxRate` = '3.4539' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642347' WHERE `Matrix_Unique_ID` = '213969611' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T08:45:53.627' ,`MLSNumber` = '19515889' ,`ListAgentFullName` = 'Michelle Cannon' ,`ListOfficeName` = 'RE/MAX Distinction' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.299136' ,`Longitude` = '-95.420567' ,`PhotoCount` = '31' ,`PostalCode` = '77301' ,`RoomCount` = '9' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Ancient Oak' ,`StreetNumber` = '1562' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1843' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 1 story with 3 bedrooms PLUS a study in the very popular subdivision of Ladera Creek zoned to the exemplary Conroe ISD! This home features wood tile floors throughout, gorgeous kitchen open to the family room and dining room, split floorplan with large primary bedroom and bath, amazing study with french doors, wonderful covered patio and large backyard.' ,`Acres` = '0.1395' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S646904 - LADERA CREEK 04, BLOCK 1, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6077' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '660' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'RUNYAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ladera Creek' ,`TaxAmount` = '7749' ,`TaxRate` = '2.7863' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642347' WHERE `Matrix_Unique_ID` = '214018109' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T07:59:10.577' ,`MLSNumber` = '39410181' ,`ListAgentFullName` = 'Anita Cameron' ,`ListOfficeName` = 'EOC Realty Associates LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.820881' ,`Longitude` = '-94.975896' ,`PhotoCount` = '50' ,`PostalCode` = '77521' ,`RoomCount` = '13' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Bay Leaf' ,`StreetNumber` = '5614' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2818' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This a great home with a fantastic floor plan*So much flexibility*All bedrooms are on the 1st floor*Game room on the 2nd floor with a full bathroom, which is what could easily be a 5th bedroom or home office or workout rm*One more full bathroom on the 1st floor and a half bath on the 1st floor*Split bedroom floor plan*Primary bedroom w/private ensuite bathroom. Double sinks, separate shower & jacuzzi soaking tub*Large walk in closet*Formal dining room*Family room with fireplace*Roomy kitchen, gas stove, solid surface counter tops*big pantry*Kitchen is open to the family room*Breakfast room*Covered Patio off the kitchen*Fully fenced backyard. 2 car attached garage*Convenient location for schools, shopping, restaurants & commuting*Come see in person*Call for your private showing.' ,`Acres` = '0.1515' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 75 SPRINGFIELD ESTATES SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '340' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'VICTORIA WALKER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Springfield Estates Sub Sec 5' ,`TaxAmount` = '7721' ,`TaxRate` = '3.095' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642347' WHERE `Matrix_Unique_ID` = '214038228' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T08:09:41.873' ,`MLSNumber` = '61712978' ,`ListAgentFullName` = 'Rose Jensen' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.451953' ,`Longitude` = '-95.867682' ,`PhotoCount` = '12' ,`PostalCode` = '77461' ,`RoomCount` = '7' ,`ListPrice` = '232500.00' ,`Status` = 'Active' ,`StreetName` = 'Rhoda' ,`StreetNumber` = '4625' ,`StreetSuffix` = 'Lane' ,`City` = 'Needville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1216' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rare find !! Move in ready 3 bedroom 2 bath on 3+ Acres in cul-de-sac in Needville ISD. Open family room with Kitchen dinning combo has breakfast bar and tons of storage. Primary has walk-in closet, large tub, separate shower, and double sinks. Split floorplan with 2 bedrooms and bath on other side of home. Laminate floor through out, no carpet. Washer, Dryer and Refrigerator included. Enjoy country living on 3.057 acres of wooded land. Bring your horse or farm animals no restrictions or HOA\r\n Call your your appointment today.' ,`Acres` = '3.057' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '0242 H AND TC RY, TRACT 70, ACRES 3.057' ,`LotDesciption` = 'Cul-De-Sac,Wooded' ,`LotSize` = '133163' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '38 - Needville' ,`SchoolElementary` = 'NEEDVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEEDVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'NEEDVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'H&Tc Ry' ,`TaxAmount` = '1856' ,`TaxRate` = '1.8957' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642347' WHERE `Matrix_Unique_ID` = '214101664' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T08:52:02.227' ,`MLSNumber` = '48225241' ,`ListAgentFullName` = 'Scarlett Snell' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = 'Orlando Godoy' ,`SellingOfficeName` = 'Realty Right' ,`Latitude` = '30.128656' ,`Longitude` = '-95.743133' ,`PhotoCount` = '30' ,`PostalCode` = '77355' ,`RoomCount` = '4' ,`ListPrice` = '560000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Country Mile' ,`StreetNumber` = '17520' ,`StreetSuffix` = '' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2452' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come live in the serenity of Magnolia Ranch Estates! This gorgeous home boasts a 1 acre lot and highly sought after 3 car garage. Nestled amongst the trees you\'ll enjoy the peace and quiet while being just minutes from shopping and dining. While this home is stunning, its the unique features that set this home apart from the others. On the inside you\'ll find special features like arched doorways, crown molding, and upgraded baseboards. The open floor plan makes it easy to entertain and the stunning finishes make it easy to show off. The On the exterior you\'ll find additional features like the large shed, huge deck, hot and cold water available outside, gutters with leaf guards, plugs all around the outside of the home for lighting, zoned sprinkler system, and even great wi-fi in the garage. Come see this home for yourself because it\'s too good to wait!' ,`Acres` = '1' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S710600 - MAGNOLIA RANCH ESTATES, BLOCK 1, LOT 20' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'NICHOLS SAWMILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Magnolia Ranch Estates' ,`TaxAmount` = '7109' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642348' WHERE `Matrix_Unique_ID` = '214129990' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T08:14:08.640' ,`MLSNumber` = '58951112' ,`ListAgentFullName` = 'Dorothy Mitchell' ,`ListOfficeName` = 'Kingdom Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.832974' ,`Longitude` = '-94.852935' ,`PhotoCount` = '31' ,`PostalCode` = '77523' ,`RoomCount` = '10' ,`ListPrice` = '497000.00' ,`Status` = 'Active' ,`StreetName` = 'White Lndg' ,`StreetNumber` = '9527' ,`StreetSuffix` = '' ,`City` = 'Mont Belvieu' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3009' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home sits on oversize lot with green space on the side, in cal de sac. Solar panels on back of home and solar screens will decrease utility bills. How about the upgrades in this wonderful home. Iron decorative stairwell enhances the entryway from bottom to top with the so in demand walk way that makes this so grand. Upstairs guest bedroom with full bath. All bedrooms have large walk-in closets. Many upgrades makes this house a home. Floor plugs in game room and upstairs entry view perfect for holiday decorations . Kitchen has GE gas cooktop with grill. and dishwasher. A Water softener comes with the home also. Breakfast area has wiindow seats. There is so much to see and love about your future home. Back yard is large enough for pool and enclosed patio. Excellent school district' ,`Acres` = '0.293' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Electric,Solar Assisted' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 51 BK 3 MAGNOLIA LANDING SEC 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '12763' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL NORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL NORTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Magnoua Lndg Sub Sec 1' ,`TaxAmount` = '7645' ,`TaxRate` = '2.0895' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642348' WHERE `Matrix_Unique_ID` = '214574266' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T08:38:27.210' ,`MLSNumber` = '84154390' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.105295' ,`Longitude` = '-95.407352' ,`PhotoCount` = '35' ,`PostalCode` = '77386' ,`RoomCount` = '3' ,`ListPrice` = '299999.00' ,`Status` = 'Active' ,`StreetName` = 'Magnolia Fair' ,`StreetNumber` = '2680' ,`StreetSuffix` = 'Way' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1830' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! Outstanding home on a quiet cul-de-sac mins from 99 & I-45! NO BACKYARD NEIGHBORS! This 3 bedroom, 2 bathroom home has recent upgrades around every corner. Light & bright kitchen w/ white cabinetry, quartz countertops, soft-close drawers, & upgraded backsplash. Recent stainless appliances! Open family room w/ upgraded stone fireplace & ample natural light. Formal sitting/dining room off the kitchen, & a large breakfast room. The primary bedroom overlooks the backyard & features a fully remodeled en-suite bath w/ double sinks, vanity, & large walk-in shower. Bedrooms 2 & 3 both have walk-in closets. Secondary bath is also completely upgraded. A useful folding area & cabinets in utility room. Locking storm doors on all entry doors. Extra large covered patio overlooking the manicured green space behind. Sellers added access gates to enjoy the view & deer! Lush landscaping & wonderful curb appeal. Home also features full gutters & sprinkler system! Schedule your tour today!' ,`Acres` = '0.1141' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S515907 - FOREST VILLAGE 07, BLOCK 2, LOT 31' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '4972' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '424' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'FORD ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Forest Village 07' ,`TaxAmount` = '5954' ,`TaxRate` = '2.8187' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642348' WHERE `Matrix_Unique_ID` = '214629143' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T07:33:29.950' ,`MLSNumber` = '47124075' ,`ListAgentFullName` = 'Rhonda Roch-Davis' ,`ListOfficeName` = 'Target Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.332258' ,`Longitude` = '-95.239657' ,`PhotoCount` = '37' ,`PostalCode` = '77328' ,`RoomCount` = '3' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Duck Creek' ,`StreetNumber` = '687' ,`StreetSuffix` = 'Road' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1120' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the country, 3 Bedroom 2 bathroom manufactured home sitting on 3.13 UNRESTRICTED acres of land with beautiful mature trees. You can enjoy sitting on the front porch watching the wildlife. Tons of room to build your dream home or bring your horses. It has 2 carports. This property is UNRESTRICED with NO HOA and LOW TAXES! Schedule your showing today!' ,`Acres` = '3.134' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S858002 - SECURITY SUBDIVISION REPLAT NO 1, BLOCK 1, LOT 2,' ,`LotDesciption` = 'Cleared' ,`LotSize` = '136517' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Security Sub Rep 1' ,`TaxAmount` = '1582' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642348' WHERE `Matrix_Unique_ID` = '214631841' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T08:47:00.563' ,`MLSNumber` = '49463274' ,`ListAgentFullName` = 'Estevan Velasquez' ,`ListOfficeName` = 'Coldwell Banker RealtyREALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.400330' ,`Longitude` = '-95.504801' ,`PhotoCount` = '28' ,`PostalCode` = '77318' ,`RoomCount` = '9' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Scarlet Maple' ,`StreetNumber` = '123' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2353' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is your opportunity to scoop up a beautifully built David Weekley Home. Featuring Brick on all sides, next level landscaping and a huge front porch, this home really stands out. Located in the highly sought after Woodlands Hills subdivision which includes miles of walking trails, parks, pools, a gym and community center. Just a few minutes away from Lake Conroe and a quick drive into town. Once inside, you’ll be greeted with high ceiling and a flex room, perfect for a home office. The main living space and kitchen is completely open concept and offers granite countertops, and stainless steel appliances. The Primary suite is located downstairs, offering a view of the backyard, with matching tile and large walk in shower. This home will not last long! Book your showing today!' ,`Acres` = '0.1417' ,`Area` = '39' ,`BuilderName` = 'David Weekley' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S927109 - THE WOODLANDS HILLS 09, BLOCK 1, LOT 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6171' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Hills' ,`TaxAmount` = '10164' ,`TaxRate` = '3.2823' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642349' WHERE `Matrix_Unique_ID` = '214653331' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T08:16:45.527' ,`MLSNumber` = '95836957' ,`ListAgentFullName` = 'Mike Livingston' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = 'Ryan Tejeda' ,`SellingOfficeName` = 'Urban Living' ,`Latitude` = '29.703718' ,`Longitude` = '-95.460204' ,`PhotoCount` = '50' ,`PostalCode` = '77401' ,`RoomCount` = '16' ,`ListPrice` = '1299000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'LAUREL' ,`StreetNumber` = '4704' ,`StreetSuffix` = '' ,`City` = 'Bellaire' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4748' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'In the Heart of Bellaire: this lovely modern home was completed and first occupied two years ago- A quiet and elegant retreat! A welcoming space for entertaining but also a warm and functional setting for the family. White oak floors throughout the house. Large windows to the wide covered patio and large back yard ready for a pool, gardening, and play. Elevator installed (garage and both floors). Mud room in from the garage. Well-appointed kitchen with Wolf and Subzero appliances. SEE the attached Floor Plan and Video Tour and more complete details in the photo captions. Well-maintained by this original owner. Zoned to nearby Condit Elem and the newly built Bellaire High School. Never flooded.' ,`Acres` = '0.188' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bellaire Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 10 HEART OF BELLAIRE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8190' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CONDIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Heart Bellaire Sec 02' ,`TaxAmount` = '26503' ,`TaxRate` = '2.2271' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669642349' WHERE `Matrix_Unique_ID` = '214692644' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T08:45:50.727' ,`MLSNumber` = '17822726' ,`ListAgentFullName` = 'Najla Waters' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.460093' ,`Longitude` = '-95.926660' ,`PhotoCount` = '23' ,`PostalCode` = '77417' ,`RoomCount` = '9' ,`ListPrice` = '389000.00' ,`Status` = 'Active' ,`StreetName` = 'Cardinal' ,`StreetNumber` = '9610' ,`StreetSuffix` = 'Road' ,`City` = 'Beasley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1896' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Serene country living about 20 minutes from Sugar Land! This ranch style home sits on 2 acres of beautiful land. This spacious 4-5 bedroom home has some nice upgrades. A possible 5th bedroom is being used as an arts and crafts room and could also be turned into a home office. The primary bedroom has an ensuite bath with double sinks and huge tub. There\'s a nice covered front porch to sit and enjoy your morning coffee. The 25x40x14 foot tall workshop is perfect for storage,working space, or a garage. 20x8 dog run. Above ground pool! The home was repiped with PEX piping so the pipes won\'t freeze! Seller will need a 30 day lease back. There\'s so much that could be done on this property! Schedule your tour today!' ,`Acres` = '2' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '0722 L F ASHLEY, TRACT 19, ACRES 2.0, CARDINAL ESTATE' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '38 - Needville' ,`SchoolElementary` = 'NEEDVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEEDVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'NEEDVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'L F Ashley' ,`TaxAmount` = '4113' ,`TaxRate` = '1.9957' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642349' WHERE `Matrix_Unique_ID` = '214698387' --> 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','214794641','1669642349','214794641','2022-11-25T08:36:12.700','34750909','Maria Moreno','Walzel Properties','','','29.599823','-95.745599','21','77406','8','339999.00','Active','Riverway Bluff','306','Lane','Richmond','2','0','3','2078','Single-Family','We\'re back!!! Priced to sell.\r\nLet\'s get you in this lovely updated one- story home that offers three spacious bedrooms, two full sixe bathrooms. You will fall in love with the cozy open floor plan as you step inside. The study is perfect for home office or an extra room. The kitchen of your dreams features plenty of storage space and beauty granite countertops. The primary bedroom has a huge double sink vanity and relaxing jetted tub with a separate standing shower. The backyard is perfect for those that enjoy the outdoors. The community is central located near major highway, shops restaurant , amenities, baseball, and soccer fields.','0.1384','37','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','0','','','Fort Bend County North/Richmond','Central Gas','1','RIVERS EDGE SEC 1, BLOCK 5, LOT 5','Subdivision Lot','6027','Appraisal District','','695','0','','2','Gas Oven','0','','','Gas Range','','Composition','33 - Lamar Consolidated','AUSTIN ELEMENTARY SCHOOL (LAMAR)','LAMAR CONSOLIDATED HIGH SCHOOL','WESSENDORF/LAMAR JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox','Appraisal District','1','Traditional','Rivers Edge','5680','2.8948','Water District','2005','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T08:55:23.023' ,`MLSNumber` = '76348407' ,`ListAgentFullName` = 'Bian Hu' ,`ListOfficeName` = 'KingFay Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.577162' ,`Longitude` = '-95.601494' ,`PhotoCount` = '39' ,`PostalCode` = '77479' ,`RoomCount` = '8' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Lazy Brook' ,`StreetNumber` = '3122' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2072' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A cozy home in the heart of Sugar Land. New carpet! New Painting! New cabinets and upgraded kitchen; Walking distance to community pool, tennis court and elementary! Excellent schools! Easy access to Hwy 6 & US 59! Must See!' ,`Acres` = '' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SETTLERS PARK SEC 2, BLOCK 16, LOT 47' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7035' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SETTLERS WAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'SETTLERS PARK SEC 2' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642349' WHERE `Matrix_Unique_ID` = '214959613' --> 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','214965804','1669642350','214965804','2022-11-25T08:28:47.240','71893015','Bonnie McDaniel','Bonnie McDaniel Real Estate','','','29.507634','-95.409498','27','77578','7','287000.00','Active','Garden Ridge','5','Court','Manvel','2','1','3','2080','Single-Family','Home is where the heart is, and this home has heart! The entry invites you to a formal living area with view of an art niche, then to an open living area. The family room ceiling height reaches the 2nd floor, and the kitchen is very functional with large island/bar. Customized stainless sink is recent and there is a reverse osmosis filter. Upstairs is an area for a game room or office. Spacious back yard to enjoy the outdoors at home or spend recreational time in the community\'s pool, splash pad, club house, walking trails and playgrounds. Great location, take a look!','0.1328','5','Castle Rock','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Alvin North','Central Gas','1','RODEO PALMS THE COLONY SEC 4 (A0299 HT&BRR)(MANVEL) BLK 1 LO','Subdivision Lot','5785','Appraisal District','','600','0','','2','Single Oven','0','','','Gas Range','','Composition','3 - Alvin','DON JETER ELEMENTARY SCHOOL','MANVEL HIGH SCHOOL','RODEO PALMS JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front','Appraisal','2','Traditional','Rodeo Palms, The Colony Sec 4','8462','3.6694','Public Sewer,Public Water','2012','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','215036175','1669642350','215036175','2022-11-25T08:28:14.590','46960505','Daniel DiPetta','Bayou City Realty, LLC','','','29.392691','-94.935763','25','77590','7','174999.00','Active','8th','2806','Avenue','Texas City','1','1','4','1390','Single-Family','Great starter home property for a young family! Property comes with a backyard pool and room to add decking and or a shed. Home includes granite countertops, new vanities, repainted, with new appliances. Spacious 2 car garage for plenty of storage. Come take a look at your new home before it\'s gone!','0.1594','33','','','','','Sellers Disclosure','1','','','Texas City','Central Gas','0','ABST 142 R LOGAN SUR W 63 FT OF LOT 23 (23-1) RIDGEMONT SEC','Subdivision Lot','6943','Appraisal District','','','0','','2','','1','Gunite','','','','Composition','52 - Texas City','HEIGHTS ELEMENTARY SCHOOL (TEXAS CITY)','TEXAS CITY HIGH SCHOOL','BLOCKER MIDDLE SCHOOL','Lockbox Front','Appraisal District','1','Traditional','Ridgemont 2','4858','2.5335','Public Sewer,Public Water','1970','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','215079492','1669642350','215079492','2022-11-25T07:54:44.870','10482201','Andre Guillory','Opendoor Brokerage, LLC','','','29.505245','-95.048777','19','77573','7','545000.00','Active','San Remo','1370','Lane','League City','4','0','3','3576','Single-Family','Welcome to this immaculate home in Tuscan Lakes which has community amenities such as a resort style pool, hike and bike trails and neighborhood parks. This home has an open floor plan with beautiful features throughout. Large bedrooms with walk in closets. The master is lovely with a custom built out closet, custom tile from Spain, and beautifully selected granite from India. The downstairs study can easily be converted to a fourth bedroom. All the rooms are extra large and spacious here! This home is ready for a new family who will enjoy it as much as the current owners, as well as a worry-free ownership with recent hot-water heater, and a/c replacement. Make your appointment today!','0.2859','33','Highland Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','League City','Central Gas','1','TUSCAN LAKES SEC SF 70-2 (2006) ABST 18, BLOCK 1, LOT 16, AC','Cul-De-Sac','12454','Appraisal District','','1000','0','','3','Gas Oven','0','','','Gas Cooktop,Gas Range','','Wood Shingle','9 - Clear Creek','GOFORTH ELEMENTARY SCHOOL','CLEAR CREEK HIGH SCHOOL','LEAGUECITY INTERMEDIATE SCHOOL','Appointment Required','Builder','2','Contemporary/Modern','Tuscan Lakes Sec Sf 70-2','12550','2.6697','Public Sewer,Public Water,Water District','2007','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','215081483','1669642350','215081483','2022-11-25T08:12:36.730','36511842','Travis Pryor','All Day Realty','','','29.703224','-95.656192','24','77083','9','277000.00','Active','La Paloma','15227','Drive','Houston','2','1','4','2304','Single-Family','Motivated Seller. Enjoy this Newly Renovated and Upgraded Lovely Four Bedroom + Two Bathroom Home. Full of Upgrades & Newly constructed open floor plan. New Doors, Windows, Appliances etc provides a lovely modern touch. The Beautiful Kitchen Is The Heart Of The Home Complete With Large Customized Granite Island & Stainless Steel Appliances. Updated Lighting Throughout The Entire Home with New Security Cameras. Great Neighborhood with Walking Distances to Elementary & Middle Schools. Indulge in Suburban living with the comforts of a 25 Min Drive to Downtown.','0.1928','37','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','','Wood Burning Fireplace','1','Mission Bend Area','Central Gas','1','LT 7 BLK 15 MISSION BEND SEC 10','Subdivision Lot','8400','Appraisal District','','400','0','','2','Freestanding Oven,Gas Oven','0','','','Gas Range','','Composition','2 - Alief','PETROSKY ELEMENTARY SCHOOL','AISD DRAW','ALBRIGHT MIDDLE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Mission Bend Sec 10','5980','2.437','Public Sewer,Public Water','1981','Appraisal District'); --> New record created successfully