Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T11:36:21.203' ,`MLSNumber` = '30550943' ,`ListAgentFullName` = 'Sherry Lynn Krenek' ,`ListOfficeName` = 'Round Top Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.054738' ,`Longitude` = '-96.914604' ,`PhotoCount` = '18' ,`PostalCode` = '78960' ,`RoomCount` = '3' ,`ListPrice` = '415000.00' ,`Status` = 'Active' ,`StreetName` = 'Hwy 77' ,`StreetNumber` = '5606' ,`StreetSuffix` = '' ,`City` = 'Warda' ,`BathsFull` = '0' ,`BathsHalf` = '4' ,`BedsTotal` = '0' ,`SqFtTotal` = '4080' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located between La Grange and Giddings on the well-traveled Highway 77, strategically lies 4.51 acres that can serve as a multi-purpose property! Possibly an antique venue, retail office space and/or restaurant? Originally known as \"The Warda General Store and Blacksmith Shop\", just adds historical charm to this potential income producing venture. There is a large gathering area with a long serving bar/station and a game room that could accommodate several game tables or desks. There is a kitchen/prep area, complete with the original walk-in cooler. The outdoor pavilion is ideal for live entertainment with room for additional seating. Outdoor restrooms are handicap accessible and there is plenty of room for parking. With the additional acreage, one could install RV hookups for another income producing source. This property has many great features and is ready to go as-is, or could be further developed. Come see for yourself the potential this property has to offer!' ,`Acres` = '4.51' ,`Area` = '69' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABS A179 ELLENDER J,4.51 ACRES,COMM-WARDA STORE,OLD BS SHOP' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '196456' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '205 - La Grange' ,`SchoolElementary` = 'HERMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA GRANGE HIGH SCHOOL' ,`SchoolMiddle` = 'LA GRANGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'None' ,`TaxAmount` = '3691' ,`TaxRate` = '1.6209' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '1900' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675221165' WHERE `Matrix_Unique_ID` = '203712267' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T12:52:44.727' ,`MLSNumber` = '26807076' ,`ListAgentFullName` = 'Somarajan Nair' ,`ListOfficeName` = 'ABI Enterprises' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.530609' ,`Longitude` = '-95.298721' ,`PhotoCount` = '26' ,`PostalCode` = '77584' ,`RoomCount` = '10' ,`ListPrice` = '1000000.00' ,`Status` = 'Active' ,`StreetName` = 'Bailey' ,`StreetNumber` = '7006' ,`StreetSuffix` = 'Road' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2780' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated Home on a 2.08 Acres. No restrictions, MUD or Home owners fee.Country living minutes away from Hospitals, Grocery and department stores. Huge 4200 Sq. Ft workshop with loft and offices ready for personal use or lease. Beautiful Pecan and Oak trees. Recent updates include Tiles , water heater, A/C , Silestone counter top, Water well and many more.' ,`Acres` = '2.0885' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0549 H T & B R R, TRACT 1C, ACRES 2.470' ,`LotDesciption` = 'Wooded' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'MAGNOLIA ELEMENTARY SCHOOL (PEARLAND)' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH SOUTH' ,`ShowInstructions` = 'Appointment Required,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'H T & B R R' ,`TaxAmount` = '8506' ,`TaxRate` = '2.69' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675221166' WHERE `Matrix_Unique_ID` = '204086863' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T12:10:03.157' ,`MLSNumber` = '74334346' ,`ListAgentFullName` = 'Allen Aydogdu' ,`ListOfficeName` = 'J. Lindsey Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.659446' ,`Longitude` = '-95.806946' ,`PhotoCount` = '15' ,`PostalCode` = '77406' ,`RoomCount` = '11' ,`ListPrice` = '1195000.00' ,`Status` = 'Active' ,`StreetName` = 'Huntington' ,`StreetNumber` = '2010' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '4648' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION, LOCATION, LOCATION GORGEOUS CUSTOM NEW CONSTRUCTION HOME. This impressive Custom MAGNOLIA HOMES is located on 1.2 ACRE. NEW CONSTRUCTION. 2 Story. Features 4 BEDROOMS & 4 FULL BATHROOMS with 2 HALF BATH. Study, Game Room and more. Minutes from Houston, Katy and Fulshear. Oversized 3 Car Garage with Triple Wide Driveway. CUSTOM finishes from Floor to Ceiling. Open Kitchen to the FAMILY ROOM and LARGE Central Island with Custom Cabinets. The PRIVATE Master Suite features a HUGE walk-in shower and Separate Dual Vanities. This Master Closet is a ABSOLUTELY GORGEOUS. Located in the Wonderful Country Neighborhood of HUNTINGTON OAKS. AMAZING Outdoor Covered Patio. Zoned to FOSTER High School. Low TAX, No MUD.' ,`Acres` = '1.22' ,`Area` = '37' ,`BuilderName` = 'Magnolia Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'HUNTINGTON OAKS, LOT 12, ACRES 1.22' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '53143' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '265' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Huntington Oaks' ,`TaxAmount` = '2468' ,`TaxRate` = '1.7948' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675221166' WHERE `Matrix_Unique_ID` = '207018549' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T11:42:49.227' ,`MLSNumber` = '50814381' ,`ListAgentFullName` = 'Priscilla Gallegos' ,`ListOfficeName` = 'Sierra Vista Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.702624' ,`Longitude` = '-95.498076' ,`PhotoCount` = '27' ,`PostalCode` = '77074' ,`RoomCount` = '8' ,`ListPrice` = '334900.00' ,`Status` = 'Active' ,`StreetName` = 'Scribner' ,`StreetNumber` = '6614' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2189' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful and cozy 4 bedroom, 3 full bath home with a bonus room, perfect to use as an office or mother in law suite, located in the Sharpstown Subdivision. Features include, new flooring throughout, 2 primary bedrooms with fully renovated bathrooms, spacious kitchen, a game room, and so much more. As you walk out to the back you\'re immediately greeted by an oversized lot, perfect for your pets and hosting family gatherings. Schedule your appointment today, this home won\'t last!' ,`Acres` = '0.4362' ,`Area` = '21' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sharpstown Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 17 BLK 24 SHARPSTOWN SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '19000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SUTTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHARPSTOWN HIGH SCHOOL' ,`SchoolMiddle` = 'LONG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sharpstown Sec 01' ,`TaxAmount` = '5298' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675221166' WHERE `Matrix_Unique_ID` = '207410889' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T11:35:51.517' ,`MLSNumber` = '41951914' ,`ListAgentFullName` = 'Toleda Wright' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.015834' ,`Longitude` = '-95.286936' ,`PhotoCount` = '27' ,`PostalCode` = '77338' ,`RoomCount` = '7' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Aurora Park' ,`StreetNumber` = '9003' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2384' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Make this charming 4 bedroom 2.5 bathroom house your brand new home! Located in a family oriented neighborhood with Deerbrook Mall, and Medical facilities located nearby. Quick access to I-59/69..This home features a spacious kitchen with an island , a Gas Range, Granite countertops and Deep Double Stainless Steel Sinks. A Water softening System has been added to enhance the water supply. A storage shed is located in the backyard to be used to store any items that can not be stored in the oversized garage. The inviting living room offers ample room to enjoy a quiet evening with family and friends. The upstairs Game room has wiring in place to add speakers for a surround sound for movie watching and music listening that will be envied by your friends. Come and see this jewel! Reduction in price has been created to sell this well taken care of home quickly!!!' ,`Acres` = '0.1158' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 6 DEERBROOK ESTATES SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5044' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'JONES ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Deerbrook Estates Sec 6' ,`TaxAmount` = '6194' ,`TaxRate` = '2.7433' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675221166' WHERE `Matrix_Unique_ID` = '209293968' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T11:44:31.530' ,`MLSNumber` = '75822702' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.432529' ,`Longitude` = '-95.452829' ,`PhotoCount` = '44' ,`PostalCode` = '77583' ,`RoomCount` = '8' ,`ListPrice` = '347012.00' ,`Status` = 'Active' ,`StreetName` = 'Darwin Cedar' ,`StreetNumber` = '1613' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2034' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HOME OF THE MONTH! Enjoy the comforts of this wonderful home which boasts a stone elevation, luxury vinyl plank flooring, and an extended covered patio. Try a new recipe in the kitchen, fully equipped with granite countertops, a tile backsplash, a 30” slide-in gas range, and stainless-steel appliances. Get some much-needed rest in the primary suite, complete with a walk-in closet, dual vanities, a tub, and a separate shower. Residents in the gated Sierra Vista community enjoy the 4-acre Crystal Clear Lagoon and beach club. Located along the Highway 288 corridor and just 20 minutes from Downtown Houston, residents love the quick access to the Texas Medical Center and NRG Stadium. A selection of restaurants and shops can be found only minutes away. Schools in the area are zoned to Alvin ISD.' ,`Acres` = '0.1545' ,`Area` = '5' ,`BuilderName` = 'Liberty Home Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIERRA VISTA WEST SEC 1 (A0329 LAV NAV CO) BLK 4 LOT 24' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6730' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.6007' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675221166' WHERE `Matrix_Unique_ID` = '209348059' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T11:44:00.250' ,`MLSNumber` = '20842816' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.433839' ,`Longitude` = '-95.452407' ,`PhotoCount` = '4' ,`PostalCode` = '77583' ,`RoomCount` = '11' ,`ListPrice` = '402280.00' ,`Status` = 'Active' ,`StreetName` = 'Mount Conness' ,`StreetNumber` = '1617' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2627' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy the comforts of this wonderful home in the community of Sierra Vista. Resting on a spacious lot, this home boasts a stone elevation, luxury vinyl plank flooring, a media room, and an extended covered patio. Try a new recipe in the kitchen, fully equipped with granite countertops, a tile backsplash, a 30” slide-in gas range, and stainless-steel appliances. Get some much-needed rest in the primary suite, complete with a walk-in closet, dual vanities, a tub, and a separate shower. Residents in the gated Sierra Vista community enjoy the 4-acre Crystal Clear Lagoon and beach club. Located along the Highway 288 corridor and just 20 minutes from Downtown Houston, residents love the quick access to the Texas Medical Center and NRG Stadium. A selection of restaurants and shops can be found only minutes away. Schools in the area are zoned to Alvin ISD. Don’t miss this home – call now!' ,`Acres` = '0.2624' ,`Area` = '5' ,`BuilderName` = 'Liberty Home Builder' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIERRA VISTA WEST SEC 1 (A0329 LAV NAV CO) BLK 4 LOT 35' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '11430' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista West Sec 1' ,`TaxAmount` = '' ,`TaxRate` = '3.6007' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675221167' WHERE `Matrix_Unique_ID` = '209349912' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T11:43:43.543' ,`MLSNumber` = '15572908' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.433936' ,`Longitude` = '-95.451861' ,`PhotoCount` = '5' ,`PostalCode` = '77583' ,`RoomCount` = '12' ,`ListPrice` = '376405.00' ,`Status` = 'Active' ,`StreetName` = 'Lemberd Dome' ,`StreetNumber` = '10310' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2659' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Feel at ease in this charming Liberty Home Builders house on a spacious lot in Sierra Vista, boasting a brick façade, luxury vinyl plank flooring, sprinkler system, wrought iron spindles, a study, and a covered patio. Cook up new cuisines in the island kitchen, equipped with granite countertops, mosaic backsplash, stainless steel appliances, and a dining nook. Unwind in the serene primary suite, featuring a bay window, walk-in closet, dual vanities, a tub, and a separate shower. Residents in the gated Sierra Vista community enjoy the 4-acre Crystal Clear Lagoon and beach club. Located along the Highway 288 corridor and just 20 minutes from Downtown Houston, commuters benefit from easy access to the Texas Medical Center and NRG Stadium. A selection of restaurants and shops can be found only minutes away. Schools in the area are zoned to Alvin ISD. This could be your dream home – call now!' ,`Acres` = '0.1691' ,`Area` = '5' ,`BuilderName` = 'Liberty Home Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIERRA VISTA WEST SEC 1 (A0329 LAV NAV CO) BLK 4 LOT 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7366' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista West Sec 1' ,`TaxAmount` = '' ,`TaxRate` = '3.6007' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675221167' WHERE `Matrix_Unique_ID` = '209351495' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T11:43:04.310' ,`MLSNumber` = '49765323' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.434222' ,`Longitude` = '-95.453582' ,`PhotoCount` = '5' ,`PostalCode` = '77583' ,`RoomCount` = '13' ,`ListPrice` = '378527.00' ,`Status` = 'Active' ,`StreetName` = 'Muir Bend' ,`StreetNumber` = '10310' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2659' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Make lifelong memories in this gorgeous Liberty Home Builders house in Sierra Vista, boasting a brick façade, luxury vinyl plank flooring, sprinkler system, wrought iron spindles, faux wood blinds, a study, and a covered patio. Imagine up new recipes in the island kitchen, equipped with granite countertops, tile backsplash, and stainless-steel appliances. Spend evenings relaxing in the primary suite, featuring a bay window, walk-in closet, dual vanities, a tub, and a separate shower. Residents in the gated Sierra Vista community enjoy the 4-acre Crystal Clear Lagoon and beach club. Located along the Highway 288 corridor and just 20 minutes from Downtown Houston, commuters benefit from easy access to the Texas Medical Center and NRG Stadium. A selection of restaurants and shops can be found only minutes away. Schools in the area are zoned to Alvin ISD. Don\'t miss this home - call now!' ,`Acres` = '0.1527' ,`Area` = '5' ,`BuilderName` = 'Liberty Home Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIERRA VISTA WEST SEC 1 (A0329 LAV NAV CO) BLK 3 LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6652' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista West Sec 1' ,`TaxAmount` = '' ,`TaxRate` = '3.6007' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675221167' WHERE `Matrix_Unique_ID` = '209352472' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T12:01:31.333' ,`MLSNumber` = '14448322' ,`ListAgentFullName` = 'Matthew Traylor' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.002419' ,`Longitude` = '-95.223584' ,`PhotoCount` = '37' ,`PostalCode` = '77541' ,`RoomCount` = '9' ,`ListPrice` = '1600000.00' ,`Status` = 'Active' ,`StreetName` = 'Bluewater Hwy County Road' ,`StreetNumber` = '5334' ,`StreetSuffix` = '' ,`City` = 'Freeport' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '2817' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**STUNNING MODERN BEACHFRONT HOME** w/unobstructed BAY VIEW and PRIVATE BEACH ACCESS** Newly REMODELED to PERFECTION and completely FURNISHED; this 6 BED/4 BATH VACATION HOME has a BRIGHT OPEN CONCEPT LIVING/DINING/KITCHEN GREAT ROOM WITH SPECTACULAR VIEWS and multiple access to two expansive DECKS. Boasting a MODERN BEACH VIBE, this 2-level home is equipped to sleep up to 28 people and is located in the highly sought after neighborhood of Seahorse Estates, the most luxurious neighborhood in Freeport. WONDERFUL FINISHES THROUGHOUT! Too many features and details to share; please review the PROPERTY FEATURES & INFORMATION SHEET attached to this listing. The HOME is sitting on nearly an ACRE LOT on the BEACH, and provides PLENTY of PARKING. Truly a beach sanctuary on the Texas Gulf Coast. There is no traffic, just the beauty of a quiet beach open to your needs. A retreat for recreational sportsmen, sun-lovers, nature-enthusiast, and Gulf adventurers. Currently a thriving vacation rental!' ,`Acres` = '0.893' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SEAHORSE ESTATES (A0029 S F AUSTIN) LOT 24' ,`LotDesciption` = 'Cleared,Water View,Waterfront' ,`LotSize` = '38899' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Seahorse Estates' ,`TaxAmount` = '9680' ,`TaxRate` = '1.9981' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675221167' WHERE `Matrix_Unique_ID` = '210353238' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T11:38:11.697' ,`MLSNumber` = '91670276' ,`ListAgentFullName` = 'Kathleen Bucher' ,`ListOfficeName` = 'Keller Williams Realty Austin' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.680166' ,`Longitude` = '-97.695979' ,`PhotoCount` = '32' ,`PostalCode` = '78628' ,`RoomCount` = '9' ,`ListPrice` = '899000.00' ,`Status` = 'Active' ,`StreetName` = 'Lucinda' ,`StreetNumber` = '1012' ,`StreetSuffix` = 'Terrace' ,`City` = 'Georgetown' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2835' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled on a quiet street in the esteemed Estrella Crossing Neighborhood, this home boasts four bedrooms, three full bathrooms, 3 car garage, and is situated on a beautiful tree lined lot that has been immaculately maintained. Expansive open concept living, dining, and kitchen areas are an entertainer’s dream! Spacious Owner’s Suite boasts trey ceilings and an enormous walk-in closet allowing for ample storage. En-suite bathroom is outfitted with exquisite travertine tile and granite countertops, furnished with double vanity, soaking tub, and walk-in shower granting a spa-like experience. The home also hosts three additional bedrooms and two full baths lending endless configurations to fit any need. Supplementally functional space is provided by home study allowing for even more space to accommodate any lifestyle.' ,`Acres` = '1.0082' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S9421 - ESTRELLA CROSSING, BLOCK A, LOT 23' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '43917' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '223 - Georgetown' ,`SchoolElementary` = 'RAYE MCCOY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GEORGETOWN HIGH SCHOOL' ,`SchoolMiddle` = 'CHARLES A. FORBES MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Estrella Crossing' ,`TaxAmount` = '10349' ,`TaxRate` = '2.0728' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675221168' WHERE `Matrix_Unique_ID` = '210507516' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T11:02:21.187' ,`MLSNumber` = '77755345' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.021789' ,`Longitude` = '-95.327917' ,`PhotoCount` = '11' ,`PostalCode` = '77338' ,`RoomCount` = '11' ,`ListPrice` = '329990.00' ,`Status` = 'Active' ,`StreetName` = 'Cypress Overlook' ,`StreetNumber` = '21042' ,`StreetSuffix` = 'Trail' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1869' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. Cherish lasting memories in this amazing Lake Ridge Builders home in Cypresswood point. Resting on a lot without neighboors behind, this 3-sided brick home boasts a premium elevation, no back neighbors, tile flooring, full gutters, a sprinkler system, an open great room, and a covered patio. Entertain guests in the kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, 42” upper cabinets, and undercabinet lighting. The spa-like primary suite features a 42” tub and a separate shower. Community comforts include a recreation area with a park, pool, and playground. Commuters will love the easy access to U.S. 59 and Hardy Toll Road. Residents enjoy close proximity to the popular Deerbrook Mall, Bush Intercontinental Airport, and Cypresswood Golf Club. Schools are a part of Aldine ISD. Don’t miss out on this stunning home – call today!' ,`Acres` = '' ,`Area` = '12' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7 Block 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '310' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CYPRESSWOOD ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypresswood Point' ,`TaxAmount` = '' ,`TaxRate` = '2.93' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675221168' WHERE `Matrix_Unique_ID` = '210997121' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T11:17:35.027' ,`MLSNumber` = '60532334' ,`ListAgentFullName` = 'Tarandeep Singh' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = 'Kristin Berry' ,`SellingOfficeName` = 'Keller Williams Metropolitan' ,`Latitude` = '29.661029' ,`Longitude` = '-95.466860' ,`PhotoCount` = '44' ,`PostalCode` = '77035' ,`RoomCount` = '10' ,`ListPrice` = '325000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Redstart' ,`StreetNumber` = '5018' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2327' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fall in love at first sight! This recently updated 3 bedroom, 2 bath Houston home is ready for you to make your own. Offering warmth and elegance the moment your guests step inside! The formal living room features a bright open space with French doors leading into a cozy family room and another set leading to a bonus room that can easily be used as a home office, studio, hobby room, or game room. Inviting family room with access to the backyard and breakfast nook is the heartbeat of this home. The updated eat-in kitchen boasts built-in stainless steel appliances, sleek counters, a tiled backsplash, and a pantry. Serene primary suite with charming ensuite bathroom. You\'ll appreciate the small details throughout! Amazing backyard oasis with a shed and a large covered patio with a ceiling fan provides additional outdoor living and entertaining space. Don\'t miss your opportunity to call this versatile space your own! 3D tour is available online!' ,`Acres` = '0.1928' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK 11 WESTBURY SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KOLTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westbury' ,`TaxAmount` = '5762' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675221168' WHERE `Matrix_Unique_ID` = '211102329' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T12:03:38.360' ,`MLSNumber` = '22661170' ,`ListAgentFullName` = 'Denise McLarty' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = 'Sade Farmer' ,`SellingOfficeName` = 'Coldwell Banker Realty' ,`Latitude` = '29.637283' ,`Longitude` = '-95.741176' ,`PhotoCount` = '50' ,`PostalCode` = '77406' ,`RoomCount` = '11' ,`ListPrice` = '549000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Spanish Forest' ,`StreetNumber` = '2206' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4338' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Pride of Ownership shows in this Stunning 5 Bedroom + Study and 3.5 bath home in Pecan Grove! 3 Car Detached Garage with Ample Parking, Recent updates include Roof 2019, Exterior Paint 2019, New Roof Dormers 2019.l Enter into the Elegant Foyer with the Spacious Formal Dining Room to the Right and a Private Study to your Left, Wine Connoisseurs will definitely enjoy the Beautiful Custom CHILLED Wine cellar. Open and Inviting Family room with Built-ins and a Wall of Windows overlooking the backyard pool. Updated kitchen with Stainless Steel appliances, lots of counter space and storage. Huge Rooms throughout, Hollywood Baths and Gameroom Upstairs with Pool table that remains with the Home. Enjoy the backyard oasis with Sparking pool, spa and Outdoor Kitchen. ALL THIS on a Quiet Tree-Lined Street in Established Country Club Neighborhood. Top Rated Fort Bend Schools and Walk to Exemplary Pecan Grove Elementary. Conveniently located between Sugar Land and Katy. Low taxes and low HOA!' ,`Acres` = '0.2256' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PECAN GROVE PLANTATION SEC 17, BLOCK 3, LOT 7' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '9829' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '209' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PECAN GROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'BOWIE MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pecan Grove Plantation' ,`TaxAmount` = '8538' ,`TaxRate` = '2.2979' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675221168' WHERE `Matrix_Unique_ID` = '211165011' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T11:12:40.600' ,`MLSNumber` = '89913613' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Jared Turner' ,`SellingOfficeName` = 'Turner Mangum,LLC' ,`Latitude` = '30.183036' ,`Longitude` = '-95.147473' ,`PhotoCount` = '13' ,`PostalCode` = '77357' ,`RoomCount` = '5' ,`ListPrice` = '344740.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Titus' ,`StreetNumber` = '3015' ,`StreetSuffix` = '' ,`City` = 'New Caney' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2294' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'AMAZING NEW DR HORTON HOME!!! Over 25,000 square foot wooded lot and 3 car garage! This 4 bedroom 3 full bathroom, has two beds and two full baths downstairs! The open kitchen features shaker cabinets, granite countertops and stainless-steel appliances. The spacious Primary Suite is tucked away for your own private retreat with separate shower and garden tub. The home has front sprinklers and a home automation system! You will appreciate the great storage and energy efficient features throughout! Hurry and call today!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 5 Block 13 Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '25238' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'DOGWOOD ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Estates at Roman Forest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675221168' WHERE `Matrix_Unique_ID` = '211604037' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T12:00:42.210' ,`MLSNumber` = '65955318' ,`ListAgentFullName` = 'Myrna Sharpe' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.666726' ,`Longitude` = '-95.227867' ,`PhotoCount` = '26' ,`PostalCode` = '77587' ,`RoomCount` = '5' ,`ListPrice` = '156000.00' ,`Status` = 'Active' ,`StreetName` = 'Volney' ,`StreetNumber` = '104' ,`StreetSuffix` = 'Street' ,`City` = 'South Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1117' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful cozy 3 bedroom house with a large backyard in a quiet neighborhood. Located close to Hobby Airport and many shopping and entertainment areas. A good first home buyer or investment property.' ,`Acres` = '0.1515' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'South Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 MERILYN PLACE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'L F SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SOUTH HOUSTON HIGH SCHOOL' ,`SchoolMiddle` = 'SOUTHHOUSTON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Merilyn Place Sec 01' ,`TaxAmount` = '2227' ,`TaxRate` = '2.8255' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1949' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675221169' WHERE `Matrix_Unique_ID` = '211807020' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T11:06:48.407' ,`MLSNumber` = '18071460' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'JaQuita Montgomery' ,`SellingOfficeName` = 'Braden Real Estate Group, LLC' ,`Latitude` = '30.232176' ,`Longitude` = '-95.242484' ,`PhotoCount` = '16' ,`PostalCode` = '77357' ,`RoomCount` = '3' ,`ListPrice` = '238990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Starry Night' ,`StreetNumber` = '21546' ,`StreetSuffix` = '' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1412' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FANTASTIC NEW D. R. HORTON BUILT HOME! Amazing 1 story plan!!! Great Open Concept Interior Layout! Lovely Foyer Opens Onto Gourmet Island Kitchen with Corner Walk-In Pantry, Light & Bright Breakfast Area, & Spacious Living Area! Privately Located Primary Suite Offers Great Bath with Large Shower & Walk-In Closet! Indoor Utility Room! Game Room!! Covered Patio Overlooks Wonderful Backyard! Incredible Community with Trails, Rec Center, SplashPad, Pool, AND Elementary School in Subdivision! WOW!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6/ Block 4/ Section 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'TIMBER LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harrington Trails' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675221169' WHERE `Matrix_Unique_ID` = '211844669' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T11:09:16.290' ,`MLSNumber` = '95925849' ,`ListAgentFullName` = 'Shakeib Baradhi' ,`ListOfficeName` = 'Baradhi Real Estate' ,`SellingAgentFullName` = 'Carolyn Olshovsky' ,`SellingOfficeName` = 'Ambassador Realty' ,`Latitude` = '29.042491' ,`Longitude` = '-95.423563' ,`PhotoCount` = '40' ,`PostalCode` = '77566' ,`RoomCount` = '3' ,`ListPrice` = '340000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Waterlily' ,`StreetNumber` = '114' ,`StreetSuffix` = 'Street' ,`City` = 'Lake Jackson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2001' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION LOCATION LOCATION!!! NO FLOOD RISK!!!BEAUTIFUL HOME ON 1/4 ACRE ACROSS FROM PECAN LAKE!!! DEAD-END STREET--NO TRAFFIC!!! NEW TRANE AC WITH 10YR WARRANTY!!! NEW REFRIGERATOR!!!VERY WELL KEPT WITH HIGH CEILINGS!! PLENTY STORAGE AND A VERY SPACIUOS KITCHEN!! UPDATED SPRINKLER SYSTEM!!! AMPLE LIVING ROOM SPACE WITH BRICK FIREPLACE, AND BEDROOMS WILL NOT DISSAPOINT!! PRIMARY BATH WITH CUSTOM TILED TUB AND SHOWER!!! MASSIVE SCREENED IN BACK PATIO AREA OVERLOOKING THE BACK YARD!! HUGE DISTANCE TO BACK NEIGHBORS!!! THIS HOME IS A MUST SEE!! CALL OR TEXT FOR YOUR SHOWING TODAY!!' ,`Acres` = '0.2431' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Jackson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'PECAN LAKE ESTATES (LAKE JACKSON), BLOCK 6, LOT 8 REPLAT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10589' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'BEUTEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE JACKSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Pecan Lake Estates Lake Jacks' ,`TaxAmount` = '6238' ,`TaxRate` = '2.3371' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675221169' WHERE `Matrix_Unique_ID` = '211985242' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T11:10:38.330' ,`MLSNumber` = '66362406' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Gustavo Andrade Fuentes' ,`SellingOfficeName` = 'Central Metro Realty' ,`Latitude` = '29.832673' ,`Longitude` = '-95.855734' ,`PhotoCount` = '14' ,`PostalCode` = '77493' ,`RoomCount` = '4' ,`ListPrice` = '338495.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Sunrise Gables' ,`StreetNumber` = '1508' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1867' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = '3/2/15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6875' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675221169' WHERE `Matrix_Unique_ID` = '212030032' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T11:26:30.980' ,`MLSNumber` = '21945772' ,`ListAgentFullName` = 'Mark Dimas' ,`ListOfficeName` = 'Mark Dimas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.868878' ,`Longitude` = '-95.699200' ,`PhotoCount` = '47' ,`PostalCode` = '77449' ,`RoomCount` = '9' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Bailey Oaks' ,`StreetNumber` = '19014' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2761' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely 2-story home in the Barker Village subdivision! This home offers 4 bedrooms, 2.5 baths, attached 2-car garage, neutral paint, ceiling fans, and carpet & tile throughout! The 1st floor features an in-house utility room, half bath, & formal living room! The main living room is open to the kitchen, which boasts a breakfast bar island with pendant lighting, granite countertops, & tile backsplash! The primary bedroom includes an attached closet and an en-suite bath with dual sinks & tub/shower combo! The 2nd floor opens to a gameroom, 3 secondary bedrooms, and a full bath! The backyard offers a modest patio! Zoned to Cy-Fair, this home is within proximity to TX-99, Hwy 6, and Hwy 290!' ,`Acres` = '0.119' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 3 BARKER VILLAGE SEC 2 3RD PAR R/P & EXTN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5185' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '625' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'JOWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'KAHLA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Barker Village Sec 2 Pt Rep 3' ,`TaxAmount` = '6878' ,`TaxRate` = '2.69' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675221170' WHERE `Matrix_Unique_ID` = '212115859' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T11:27:10.383' ,`MLSNumber` = '88246378' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Marjorie Lucero' ,`SellingOfficeName` = 'RE/MAX Grand' ,`Latitude` = '29.852738' ,`Longitude` = '-95.742516' ,`PhotoCount` = '9' ,`PostalCode` = '77493' ,`RoomCount` = '4' ,`ListPrice` = '334690.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Sunrise Gables Dr' ,`StreetNumber` = '1556' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1779' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOVELY NEW CONSTRUCTION! Beautiful brick and stone exterior. 4 bedroom!! High Ceilings, Luxury Hard Surface Flooring, Stainless Appliances with 5 Burner Cooktop, Grey Quartz countertops, white ceramic tile backsplash & 42\" White Kitchen Cabinetry with Under Cabinet Lighting, Primary Bath with Separate Tub & Shower, Tankless Water Heater, Oversized Covered Patio, & Full Sprinkler System! WOW! Open Concept Interior Design with Island Kitchen Open to Spacious Dining & Living Areas! Privately Located Primary Suite with Pretty Garden Bath & Walk-In Closet! Indoor Utility Room! Zoned to Katy ISD Schools! Unbelievable Community with Crystal Lagoon & Amenity Center with Clubhouse, Playground, Trails, Pool, PLUS MORE! Easy Access to the Grand Parkway! Estimated Completion - February 2023' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = '15/2/15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'GOLBOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'MCDONALD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675221170' WHERE `Matrix_Unique_ID` = '212317958' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T11:01:13.423' ,`MLSNumber` = '15994750' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.018619' ,`Longitude` = '-95.329282' ,`PhotoCount` = '7' ,`PostalCode` = '77338' ,`RoomCount` = '14' ,`ListPrice` = '385990.00' ,`Status` = 'Active' ,`StreetName` = 'Leaning Cypress' ,`StreetNumber` = '6410' ,`StreetSuffix` = 'Trail' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2657' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. You’ll love everything this Lake Ridge Builders home in Cypresswood Point has to offer. Nestled on a spacious lot, this 3-side brick home boasts a premium elevation, no back neighbors, open ceilings, tile flooring, full gutters, a sprinkler system, wrought iron spindles, a guest suite, and a covered patio. Learn new recipes in the kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, 42” upper cabinets, and undercabinet lighting. Spend evenings relaxing in the primary suite, featuring dual vanities, a 42” tub, and a separate shower. Community comforts include a recreation area with a park, pool, and playground. Commuters will love the easy access to U.S. 59 and the Hardy Toll Road. Residents enjoy close proximity to the popular Deerbrook Mall, Bush Intercontinental Airport, and Cypresswood Golf Club. Schools are a part of Aldine ISD. Don’t miss out on this stunning home – call today!' ,`Acres` = '' ,`Area` = '12' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 39 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '310' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CYPRESSWOOD ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypresswood Point' ,`TaxAmount` = '' ,`TaxRate` = '2.93' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675221170' WHERE `Matrix_Unique_ID` = '212341787' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T11:02:40.220' ,`MLSNumber` = '59766749' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.021714' ,`Longitude` = '-95.327792' ,`PhotoCount` = '12' ,`PostalCode` = '77338' ,`RoomCount` = '14' ,`ListPrice` = '370990.00' ,`Status` = 'Active' ,`StreetName` = 'Running Moon' ,`StreetNumber` = '20918' ,`StreetSuffix` = 'Trail' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2620' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. Enjoy peace and quiet in this beautiful Lake Ridge Builders home in Cypresswood Point. Resting on a spacious lot, this 3-sided brick home boasts a premium elevation, tile flooring, full gutters, a sprinkler system, wrought iron spindles, and a covered patio. Master new recipes in the kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, 42” upper cabinets, and undercabinet lighting. Complete with dual vanities, a 42” tub, and a separate shower, the primary suite is ideal for relaxation. Community comforts include a recreation area with a park, pool, and playground. Commuters will love the easy access to U.S. 59 and the Hardy Toll Road. Residents enjoy close proximity to the popular Deerbrook Mall, Bush Intercontinental Airport, and Cypresswood Golf Club. Schools are a part of Aldine ISD. Don’t miss out on this stunning home – call today!' ,`Acres` = '' ,`Area` = '12' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 12 Block 5' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '310' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CYPRESSWOOD ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypresswood Point' ,`TaxAmount` = '' ,`TaxRate` = '2.93' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675221170' WHERE `Matrix_Unique_ID` = '212351832' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T11:25:35.477' ,`MLSNumber` = '92640070' ,`ListAgentFullName` = 'Amanda Howton-Mitchell' ,`ListOfficeName` = 'CyHou Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.621780' ,`Longitude` = '-95.172722' ,`PhotoCount` = '39' ,`PostalCode` = '77331' ,`RoomCount` = '4' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'State Highway 156' ,`StreetNumber` = '10211' ,`StreetSuffix` = '' ,`City` = 'Coldspring' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2676' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this beautiful rustic oasis nestled down your private drive. This amazing Log home is 4-5 bedrooms. Newly renovated to match its country charm. Flex space is spacious and could be used as an additional room or game room. The open concept living/dining is adorned with vaulted ceilings and rustic wooden beams throughout. Expansive island offers room for additional dining and prep space. In this entertainers dream home your eye will immediately gravitate to the breathtakingly gorgeous rock fireplace upon entry. The 9+ acres is fully fenced and cross fenced to allow for a multitude of livestock capabilities. Home has a large enclosed barn with stalls. Large carport to store your vehicles and equipment. Property boasts a pond that adds to the long list of rustic beauty. Property is equipped with RV hookup. Lake Livingston is just a few short miles down the road and you’ll be enjoying all the water recreation it has to offer. You’ll love this southern country beauty.' ,`Acres` = '9.131' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A028 DRURY MCGEE, TRACT 212.3, ACRES 9.131' ,`LotDesciption` = 'Cleared,Other,Wooded' ,`LotSize` = '397746' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style,Ranch' ,`Subdivision` = 'N/A' ,`TaxAmount` = '4952' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675221171' WHERE `Matrix_Unique_ID` = '212397553' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T12:57:23.193' ,`MLSNumber` = '92947618' ,`ListAgentFullName` = 'April Maki' ,`ListOfficeName` = 'Gehan Homes Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.879128' ,`Longitude` = '-94.886139' ,`PhotoCount` = '45' ,`PostalCode` = '77535' ,`RoomCount` = '7' ,`ListPrice` = '389990.00' ,`Status` = 'Active' ,`StreetName` = 'St Augustine' ,`StreetNumber` = '11815' ,`StreetSuffix` = 'Drive' ,`City` = 'Mont Belvieu' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2483' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Willow is a very popular 1 story, 2,483 Sq Ft. home with a tandem 2 car garage. 4 bedroom bath with a gameroom and extended Owner\'s Suite. Kitchen features built-in appliances and a chef\'s island that overlooks a huge family room. 42\" Linen cabinets, 36\" gas cooktop & Coastal white granite countertops! Enjoy outdoor living with a covered patio! This home is a must see and will be ready for a January move in!' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1 Block 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11717' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '455' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric 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` = 'Accompany,Appointment Required,Call Occupant,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'St. Augustine Meadows' ,`TaxAmount` = '' ,`TaxRate` = '2.23' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675221171' WHERE `Matrix_Unique_ID` = '212431549' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T12:58:17.527' ,`MLSNumber` = '64019813' ,`ListAgentFullName` = 'April Maki' ,`ListOfficeName` = 'Gehan Homes Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.876963' ,`Longitude` = '-94.884984' ,`PhotoCount` = '44' ,`PostalCode` = '77535' ,`RoomCount` = '7' ,`ListPrice` = '399990.00' ,`Status` = 'Active' ,`StreetName` = 'Autumn Leaf' ,`StreetNumber` = '11802' ,`StreetSuffix` = 'Drive' ,`City` = 'Mont Belvieu' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2672' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come Home to St. Augustine Meadows in Mont Belvieu!! This Extraordinary Magnolia Floor Plan is a 2,672 sq ft. 2-Story, 4 bedrooms, 3 Baths, Game Room with 2-Car Garage. This Open Concept home has an Impressive Entry with Soaring Ceilings, Gorgeous Kitchen with Chef\'s Island, Omegastone Countertops & Plenty of Cabinet Space. The Primary Bath has an Oversized Tub, Walk-in Shower, Double Sinks & a Massive Walk-in Closet. Enjoy the Outdoors featuring a Stunning Covered Patio, Full Sprinkler System & Landscape Package. Eagle Pointe Golf Club & Recreation Complex is Located 2 miles from the Community. Come out today and see this gorgeous home for yourself!' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 23 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10402' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '455' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`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` = 'Accompany,Appointment Required,Call Occupant,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'St. Augustine Meadows' ,`TaxAmount` = '' ,`TaxRate` = '2.23' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675221171' WHERE `Matrix_Unique_ID` = '212435016' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T11:01:59.130' ,`MLSNumber` = '54749190' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.024590' ,`Longitude` = '-95.328845' ,`PhotoCount` = '8' ,`PostalCode` = '77338' ,`RoomCount` = '12' ,`ListPrice` = '314990.00' ,`Status` = 'Active' ,`StreetName` = 'Leaning Cypress' ,`StreetNumber` = '6418' ,`StreetSuffix` = 'Trail' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2172' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. Escape the city to this lovely Pride Builders home in Cypresswood Point. Situated on a spacious lot, this 3-sided brick home boasts a premium elevation, no back neighbors, tile flooring, full gutters, a sprinkler system, wrought iron spindles, and a covered patio. Spend all day in the kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, 42” upper cabinets, and undercabinet lighting. Relax in the serene primary suite, featuring dual vanities, a 42” tub, and a separate shower. Community comforts include a recreation area with a park, pool, and playground. Commuters will love the easy access to U.S. 59 and the Hardy Toll Road. Residents enjoy close proximity to the popular Deerbrook Mall, Bush Intercontinental Airport, and Cypresswood Golf Club. Schools are a part of Aldine ISD. Don’t miss out – call today!' ,`Acres` = '' ,`Area` = '12' ,`BuilderName` = 'Pride Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 28 Block 3' ,`LotDesciption` = 'Corner,Greenbelt,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '310' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CYPRESSWOOD ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,