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-18T19:29:51.947' ,`MLSNumber` = '43927599' ,`ListAgentFullName` = 'Krystal Bradford' ,`ListOfficeName` = 'Krystal Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.144791' ,`Longitude` = '-95.043987' ,`PhotoCount` = '36' ,`PostalCode` = '77554' ,`RoomCount` = '8' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Reeves' ,`StreetNumber` = '4010' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '891' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cute Beach Cottage....Desirable Sea Isle home offers a style that brings together cozy & casual elements to reflect an easy-going way of coastal life. Large open kitchen with ample counter & cabinet space. Living & dining has good space & fireplace with raised hearth. Downstairs offers almost 400 additional sq. footage of air conditioned bonus space; could be bedroom, game room or multipurpose room! Other features include luxury wood laminate floors, covered decks to enjoy the beautiful sunrise & sunsets & hear the waves, huge tandem sized garage with good space, washer & dryer as well as a toilet area . New AC 7-25-22. Doublewide drive offers great space for ample parking. Park a boat or RV Large backyard, outdoor shower & more! Sea Isle offers: pool, boat ramp, fishing pier, sports courts, Clay Walkers West End restaurants, Marina store & playground. New Beachside Bar & Grill at neighborhood entrance. Higher elevated than other surrounded homes & downstairs has NEVER flooded.' ,`Acres` = '0.1377' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Special Addendum' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 19 LOT 657 SEA ISLE' ,`LotDesciption` = 'Other,Subdivision Lot,Water View' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '236' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Lockbox Left Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman,Other Style,Traditional' ,`Subdivision` = 'Sea Isle Orig' ,`TaxAmount` = '5775' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1669040277' WHERE `Matrix_Unique_ID` = '207124275' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T19:11:02.757' ,`MLSNumber` = '33868890' ,`ListAgentFullName` = 'Famen Wolf' ,`ListOfficeName` = 'Wolf Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.022160' ,`Longitude` = '-95.114632' ,`PhotoCount` = '19' ,`PostalCode` = '77336' ,`RoomCount` = '9' ,`ListPrice` = '219900.00' ,`Status` = 'Active' ,`StreetName` = 'Cherry Valley' ,`StreetNumber` = '403' ,`StreetSuffix` = 'Drive' ,`City` = 'Huffman' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1736' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming property has recently been renovated with new roof, wood look tile, fresh paint in and out, removed galvanized sewer pipe in foundation and replaced with PVC, foundation repair with lifetime warranty, etc. Great location within walking distance to the elementary school and an easy drive to Atascocita. Neighborhood has a private pool, park and boat launch.' ,`Acres` = '0.2066' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LTS 409 & BLK 14 LAKEWOOD HEIGHTS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'HUFFMAN ELEMENTARY SCHOOL (HUFFMAN)' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakewood Heights Sec 02' ,`TaxAmount` = '4076' ,`TaxRate` = '2.4592' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040277' WHERE `Matrix_Unique_ID` = '209617025' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T20:22:26.347' ,`MLSNumber` = '35757399' ,`ListAgentFullName` = 'Tammy Downey' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.976091' ,`Longitude` = '-95.583524' ,`PhotoCount` = '49' ,`PostalCode` = '77070' ,`RoomCount` = '11' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Cypresswood' ,`StreetNumber` = '10819' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2982' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Incredible 2 story home w/ 4 bedrooms & 2 ½ baths nestled on a corner lot w/ a circle drive & 3 car garage. As you enter through the double door entry, you are greeted by the long light filled foyer w/ formal dining & formal living located on each side. The gourmet kitchen is complete w/ breakfast bar, custom cabinetry, granite countertops w/ built-in island & lots of storage & provides access to the enclosed courtyard. The family room is located right off the kitchen & breakfast room featuring tile flooring, gas log stone fireplace & double doors leading to a large flex space w/ endless possibilities. Primary suite is located on 1st floor w/ ensuite bath, 2 closets & private access to backyard. Custom wrought iron staircase leads to the 2nd floor game room w/ wet bar & 3 spacious bedrooms. 2022 updates: roof, flooring, cabinets, countertops, toilets & paint throughout. Take advantage of the community clubhouse, pool, tennis courts, low tax rates & highly acclaimed Cy-Fair ISD.' ,`Acres` = '0.2686' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 17 NORCHESTER SEC 2 R/P' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '11700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MATZKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Norchester' ,`TaxAmount` = '5545' ,`TaxRate` = '2.4817' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040277' WHERE `Matrix_Unique_ID` = '210624381' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T19:50:20.677' ,`MLSNumber` = '37491458' ,`ListAgentFullName` = 'Daniel Signorelli' ,`ListOfficeName` = 'The Signorelli Company' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.139208' ,`Longitude` = '-94.879880' ,`PhotoCount` = '10' ,`PostalCode` = '77535' ,`RoomCount` = '6' ,`ListPrice` = '364059.00' ,`Status` = 'Active' ,`StreetName` = 'Road 6616' ,`StreetNumber` = '426' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1845' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.705' ,`Area` = '52' ,`BuilderName` = 'First America Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ENCINO ESTATES, SEC 2, BLOCK 8, LOT 16, ACRES 0.7050' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '30710' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (DAYTON)' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Encino Estates' ,`TaxAmount` = '623' ,`TaxRate` = '1.7512' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669040277' WHERE `Matrix_Unique_ID` = '210716849' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T20:26:40.040' ,`MLSNumber` = '87845764' ,`ListAgentFullName` = 'Melissa Castro' ,`ListOfficeName` = 'Rose Above Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.272021' ,`Longitude` = '-94.823209' ,`PhotoCount` = '21' ,`PostalCode` = '77551' ,`RoomCount` = '12' ,`ListPrice` = '459990.00' ,`Status` = 'Active' ,`StreetName` = 'Ibis' ,`StreetNumber` = '5520' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2404' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Attention Investors and Galveston lovers alike! This 5 bedroom & THREE FULL bath is PRIME location for short term rentals or vacation home. Home boasts of an open concept, over-sized living area, tier 3 granite, flex room that can be used as movie room, formal dining, office space, or whatever your heart desires and TWO en-suites. \r\n A true diamond in the rough, come check out for yourself the beautifully crafted kitchen with large island facing the spacious living and dining area. All bedrooms are a generous size. Centrally located to grocery stores, shopping, and dining, this home is in pristine condition and turnkey ready. Pleasure pier, Moody Gardens, tours of Galveston’s rich history, and beach day memories are minutes away. Contact Agent for a private showing now to see this Galveston gem!' ,`Acres` = '0.184' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Midtown - Galveston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 PAGE 102 LOT 56 SURFSIDE SUB' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8016' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Surfside' ,`TaxAmount` = '5111' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1669040278' WHERE `Matrix_Unique_ID` = '211132429' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T20:34:13.397' ,`MLSNumber` = '10694922' ,`ListAgentFullName` = 'Darren Tidwell' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.407950' ,`Longitude` = '-95.000010' ,`PhotoCount` = '41' ,`PostalCode` = '77591' ,`RoomCount` = '8' ,`ListPrice` = '269900.00' ,`Status` = 'Active' ,`StreetName` = 'Aquamarine' ,`StreetNumber` = '2702' ,`StreetSuffix` = 'Court' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1825' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Completely new construction. You can own this wonderful brand new home. This model is a fully completed 3 bedroom/1 Study, 2 bath home with an open concept living area. Features included are stainless steel appliances, nice backsplash in kitchen with granite countertops, Central 16 SEER air conditioner, 42\" Wood cabinets, and more. Come to see these wonderful new homes at an affordable price. Pearlbrook community offers two nice ponds, with connected walking trails, sitting areas, including two build up playground parks. Conveniently located close to I-45, Hwy 3, and Expwy 1764. Close proximity to shopping areas, medical center, restaurants, and fun Galveston Beach. Visit the Model home to see all available new homes Wednesday through Sunday 10:00 am to 6:00 pm. Call today if you have any questions!!!' ,`Acres` = '0.1377' ,`Area` = '33' ,`BuilderName` = 'Stylecraft Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 24 BLK 5 PEARLBROOK SEC 8 (2021) ABST 180' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'HUGHES ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pearlbrook' ,`TaxAmount` = '877' ,`TaxRate` = '3.4928' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669040278' WHERE `Matrix_Unique_ID` = '211149749' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T20:47:29.173' ,`MLSNumber` = '47934505' ,`ListAgentFullName` = 'Darren Tidwell' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.409333' ,`Longitude` = '-95.001199' ,`PhotoCount` = '46' ,`PostalCode` = '77591' ,`RoomCount` = '7' ,`ListPrice` = '254900.00' ,`Status` = 'Active' ,`StreetName` = 'Amethyst' ,`StreetNumber` = '2725' ,`StreetSuffix` = 'Court' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1517' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Completely new construction. You can own this wonderful brand new home. This model is a fully completed 3 bedroom, 2 bath home with an open concept living area. Features included are stainless steel appliances, nice backsplash in kitchen, Central 16 SEER air conditioner, 42\" Wood cabinets, and more. Come to see these wonderful new homes at an affordable price. Pearlbrook community offers two nice ponds, with connected walking trails, sitting areas, including two build up playground parks. Conveniently located close to I-45, Hwy 3, and Expwy 1764. Close proximity to shopping areas, medical center, restaurants, and fun Galveston Beach. Visit the Model home to see all available new homes Wednesday through Sunday 10:00 am to 6:00 pm. Call today if you have any questions!!!' ,`Acres` = '0.1519' ,`Area` = '33' ,`BuilderName` = 'Stylecraft Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 26 BLK 5 PEARLBROOK SEC 8 (2021) ABST 180' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6617' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'HUGHES ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pearlbrook' ,`TaxAmount` = '901' ,`TaxRate` = '3.4928' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669040278' WHERE `Matrix_Unique_ID` = '211170252' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T20:05:19.507' ,`MLSNumber` = '98092557' ,`ListAgentFullName` = 'Brenda Pritchard' ,`ListOfficeName` = 'Prime Realty Group' ,`SellingAgentFullName` = 'Jennifer Bonano' ,`SellingOfficeName` = 'Keller Williams Hou Preferred' ,`Latitude` = '29.676171' ,`Longitude` = '-95.213556' ,`PhotoCount` = '35' ,`PostalCode` = '77502' ,`RoomCount` = '8' ,`ListPrice` = '170000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Queens' ,`StreetNumber` = '606' ,`StreetSuffix` = 'Road' ,`City` = 'Pasadena' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1092' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in well established active neighborhood. This home offers 3 bedrooms, 1 1/2 bath, and 1 car garage with double wide driveway. Home has original hardwood floors. Keep the cook company while sitting at the breakfast bar. The kitchen opens into the dining room. The tall kitchen cabinets, large deep drawers and a separate pantry provides lots of storage space. French doors lead to a covered patio in the sprawling back yard. Storage shed provides space for extra storage. Utility room is inside the garage. Add a little LTC and make this your very own Home Sweet Home!' ,`Acres` = '0.1625' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 446 VINCE HEIGHTS SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7080' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'L F SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PASADENA HIGH SCHOOL' ,`SchoolMiddle` = 'SOUTHMORE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Vince Heights' ,`TaxAmount` = '2770' ,`TaxRate` = '2.6514' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1954' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040278' WHERE `Matrix_Unique_ID` = '211672245' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T19:10:23.540' ,`MLSNumber` = '45332986' ,`ListAgentFullName` = 'Andrew Vong' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = 'Katrina Lively' ,`SellingOfficeName` = 'JLA Realty' ,`Latitude` = '29.611739' ,`Longitude` = '-95.549639' ,`PhotoCount` = '43' ,`PostalCode` = '77477' ,`RoomCount` = '8' ,`ListPrice` = '260000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Queens' ,`StreetNumber` = '203' ,`StreetSuffix` = 'Court' ,`City` = 'Stafford' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2077' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Back on the market with brand new roof installed Nov 2022!!!! Beautiful 4 bedroom 1 story home in the Kingsway neighborhood. This is one of the larger 1 story plans in the area and not only includes the 4 full sized bedrooms, but a formal dining area, spacious kitchen with breakfast area, and family room boasting high ceilings with recessed lighting and built-in cabinets surrounding the gas fireplace. The home sits on a large corner lot so there is plenty of yard for gardening or for the kids to play. This is your chance to get in and see why so many love to call Stafford home. It is located near all the thoroughfares providing easy access into and out of town for work or play. Also, don\'t forget about the low taxes because Stafford is the city with no city property taxes! Call to see this one today!' ,`Acres` = '0.1834' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Stafford Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'KINGSWAY, BLOCK 3, LOT 39' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7990' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '50 - Stafford' ,`SchoolElementary` = 'STAFFORD ELEMENTARY SCHOOL (STAFFORD MSD)' ,`SchoolHigh` = 'STAFFORD HIGH SCHOOL' ,`SchoolMiddle` = 'STAFFORD INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Lockbox Right Side,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kingsway' ,`TaxAmount` = '3891' ,`TaxRate` = '1.9342' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040279' WHERE `Matrix_Unique_ID` = '211676213' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T19:52:01.137' ,`MLSNumber` = '75800185' ,`ListAgentFullName` = 'Folorunso Akindoju' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.695033' ,`Longitude` = '-95.790286' ,`PhotoCount` = '42' ,`PostalCode` = '77406' ,`RoomCount` = '12' ,`ListPrice` = '394999.00' ,`Status` = 'Active' ,`StreetName` = 'Ibisco' ,`StreetNumber` = '12010' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2131' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS HOME WON\'T LAST LONG GET YOUR OFFERS IN TODAY! This beautiful home is fully upgraded with custom color scheme provides a fresh, clean, and elegant look. Charming barn sliding door to the office/study add a such amazing flair and characteristic. Spa like master bath with a luxurious shower for daily indulgence. Entertaining is a breeze with an outdoor kitchen for the grill master. Pre-wired for surround sound. Sprinkler system to keep your lawn looking great all year round and so much more. Lakes of Bella Terra offers a community pool, lakes, workout facility, nature trails, and so much more!' ,`Acres` = '0.1314' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKES OF BELLA TERRA SEC 35, BLOCK 1, LOT 31' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '5725' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUBENAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes Of Bella Terra Sec 35' ,`TaxAmount` = '8068' ,`TaxRate` = '3.0848' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040279' WHERE `Matrix_Unique_ID` = '211797913' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T19:51:37.567' ,`MLSNumber` = '85434549' ,`ListAgentFullName` = 'Robert Peltier' ,`ListOfficeName` = 'Bob Peltier & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.232993' ,`Longitude` = '-95.349746' ,`PhotoCount` = '21' ,`PostalCode` = '77534' ,`RoomCount` = '7' ,`ListPrice` = '324500.00' ,`Status` = 'Active' ,`StreetName` = 'Novak' ,`StreetNumber` = '5426' ,`StreetSuffix` = 'Court' ,`City` = 'Danbury' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1807' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SUPER LOCATION, BEAUTIFUL THREE BEDROOM TWO BATH, LARGE DEN OPEN TO KITCHEN AND DINING, GRANITE WITH LARGE PANTRY. INDOOR UTILITY SPLIT BEDROOMS, HUGE FENCED BACK YARD WITH STORAGE BUILDING,WOOD FENCED WITH WIRE FOR SMALL DOGS SAFETY, CARPET AND TILE. CROWN MOLDING AND LOTS OF EXTRAS, DON\'T MISS OUT ON THIS ONE.' ,`Acres` = '0.473' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Danbury' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'DANBURY HEIGHTS (DANBURY) BLK 1 LOT 9' ,`LotDesciption` = 'Cleared' ,`LotSize` = '20604' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '15 - Danbury' ,`SchoolElementary` = 'DANBURY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DANBURY HIGH SCHOOL' ,`SchoolMiddle` = 'DANBURY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Danbury Heights' ,`TaxAmount` = '6294' ,`TaxRate` = '2.8783' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040279' WHERE `Matrix_Unique_ID` = '212243544' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T20:58:59.470' ,`MLSNumber` = '37668024' ,`ListAgentFullName` = 'Erica Stietenroth' ,`ListOfficeName` = 'All City Real Estate, Ltd. Co.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.766596' ,`Longitude` = '-95.815919' ,`PhotoCount` = '43' ,`PostalCode` = '77494' ,`RoomCount` = '10' ,`ListPrice` = '410000.00' ,`Status` = 'Active' ,`StreetName` = 'Wiedner' ,`StreetNumber` = '1210' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2547' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming 4-bedroom, 2-bath ranch style home on a cul-de-sac has many updates with open/flowing living spaces and a private back yard with no rear neighbors! As you enter you\'ll notice the beautiful engineered wood flooring and crown molding flow throughout and the high ceilings give the home an airy feel. The walls are painted in modern colors and there\'s custom built-in shelving anchoring the fireplace. The kitchen is open to the living room and has stainless steel appliances and seamless granite counter tops. The primary bedroom has an on-suite bath that offers two walk-in closets. A screened-in back patio provides a great place to relax and enjoy the outdoors! There have been updates to the HVAC over time, spray insulation added in the attic, a full sprinkler system and French drains, and LED lighting added throughout the entire home. The garage is extended in the back and has a room that is great for a workshop! Low taxes and exemplary schools!' ,`Acres` = '0.2356' ,`Area` = '36' ,`BuilderName` = 'Perry' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PIN OAK VILLAGE SEC 3, BLOCK 3, LOT 31' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Wooded' ,`LotSize` = '10265' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '820' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'KATY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Pin Oak Village' ,`TaxAmount` = '7150' ,`TaxRate` = '2.3143' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040279' WHERE `Matrix_Unique_ID` = '212584710' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T20:44:14.977' ,`MLSNumber` = '37819629' ,`ListAgentFullName` = 'Morgan Marley' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.967205' ,`Longitude` = '-95.178623' ,`PhotoCount` = '47' ,`PostalCode` = '77346' ,`RoomCount` = '8' ,`ListPrice` = '409000.00' ,`Status` = 'Active' ,`StreetName` = 'Upper Ridge' ,`StreetNumber` = '17319' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2949' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Step into refined charm & luxury in this gorgeous 1.5 story Eagle Springs house and experience \"home\" like never before. 4 bed. down & 5th bed. & bath up + GAME ROOM up! Engineered hardwood throughout, new luxury carpet in bedrooms, LVP on stairs, whole-home WATER SOFTENER system, & accent painted doors all set this home apart. Formal dining/flex room down can be used in variety. Kitchen has new Bosch dishwasher, RO system, GAS cooking & window seating! Primary suite offers a seating area & luxury bath w/ seamless glass shower, soaking tub, walk-in closet. Peaceful covered & stamped-style patio w/ upgraded extension! Built 2014 means newer roof, PEX tubing, newer HVAC & more. 2.5-CAR GARAGE offers plenty of space for storage! Never flooded, per sellers. Zoned to top-rated schools! Community amenities include fitness center, competition & resort style pools, splash pad, baseball & soccer fields, tennis & sand volleyball courts, parks, & events planned by the full time event coordinator!' ,`Acres` = '0.1781' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 3 EAGLE SPRINGS SEC 47' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7760' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '825' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'ATASCOCITA SPRINGS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Eagle Springs' ,`TaxAmount` = '8909' ,`TaxRate` = '2.913' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040279' WHERE `Matrix_Unique_ID` = '212848273' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T20:25:29.530' ,`MLSNumber` = '85623782' ,`ListAgentFullName` = 'Jason Knebel' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.092877' ,`Longitude` = '-95.332040' ,`PhotoCount` = '33' ,`PostalCode` = '77386' ,`RoomCount` = '19' ,`ListPrice` = '1425000.00' ,`Status` = 'Active' ,`StreetName` = 'Summerton' ,`StreetNumber` = '27903' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '5715' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful custom home in Benders Landing Estates with all first-floor bedroom suites! Step inside to a two-story foyer with curved staircase and formal dining room. Family room with fireplace looks towards the backyard and greenbelt. Island kitchen includes a generous walk-in pantry, butler’s pantry, granite counters, and gas cooktop. A hidden room is perfect for a den, second office, or holiday storage. Primary suite features a fireplace and sitting area, soaking tub, double entry shower, and a dream closet. Three secondary bedrooms all have en-suite baths with granite counters, linen closets, tub/shower, and walk-in closets. Home office has bookcases and high ceiling. Upstairs you will find a game room with mini-kitchen, storage closet, full bath, and a media room. At just over an acre (per Appraisal District), the corner lot has an abundance of space for a pool and offers endless possibilities! Wonderful neighborhood amenities. Quick access to 99, I-45, and Hardy Toll Road.' ,`Acres` = '1.0952' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S257204 - BENDERS LANDING ESTATES 04, BLOCK 8, LOT 42' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '47709' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'ANN K. SNYDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Benders Landing Estates 04' ,`TaxAmount` = '13736' ,`TaxRate` = '1.8487' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040280' WHERE `Matrix_Unique_ID` = '212861191' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T20:41:42.040' ,`MLSNumber` = '43447224' ,`ListAgentFullName` = 'Enrique Rosales' ,`ListOfficeName` = 'AQUI Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.147621' ,`Longitude` = '-95.540674' ,`PhotoCount` = '31' ,`PostalCode` = '77389' ,`RoomCount` = '12' ,`ListPrice` = '620000.00' ,`Status` = 'Active' ,`StreetName` = 'Canoe Bend' ,`StreetNumber` = '18' ,`StreetSuffix` = 'Court' ,`City` = 'The Woodlands' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3406' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home for sale in The Woodlands Creekside Park subdivision in Harris County. 4 bedrooms, 3 1/2 bathrooms, in-house utility room, media room, fireplace, garden, and patio!' ,`Acres` = '' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 38 BLK 1 THE WOODLANDS VLG OF CREEKSIDE PARK 24' ,`LotDesciption` = 'Other' ,`LotSize` = '8496' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'CREEKSIDE FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Creekside Park' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040280' WHERE `Matrix_Unique_ID` = '212968291' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T19:13:51.107' ,`MLSNumber` = '67227364' ,`ListAgentFullName` = 'Farhan Shaikh' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = 'Leon Castro' ,`SellingOfficeName` = 'Compass RE Texas, LLC' ,`Latitude` = '30.123410' ,`Longitude` = '-95.244049' ,`PhotoCount` = '19' ,`PostalCode` = '77365' ,`RoomCount` = '4' ,`ListPrice` = '284000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Village Crossing' ,`StreetNumber` = '21375' ,`StreetSuffix` = 'Lane' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2380' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful 2 story home in Valley Ranch and is just minutes from 59, movie theater & grocery shopping. An abundance of natural light into the home. 4 bedrooms 2 full bathrooms, 1 half bathrooms, Dinning, and game room upstairs for entertaining. the kitchen with a breakfast bar and breakfast nook, open to the living room offering high ceilings and a fireplace. In the backyard, a covered patio with an extended concrete patio. The oversized car garage. Roof only 2 years old. Upgraded floor in the kitchen, master bedroom and all bathrooms and new carpet.' ,`Acres` = '0.1668' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S941203 - VALLEY RANCH 03, BLOCK 1, LOT 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7267' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'VALLEY RANCH ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'NEW CANEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Valley Ranch 03' ,`TaxAmount` = '7465' ,`TaxRate` = '3.2331' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040280' WHERE `Matrix_Unique_ID` = '213146936' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T19:34:02.367' ,`MLSNumber` = '3084631' ,`ListAgentFullName` = 'Elizabeth Pittman' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.173550' ,`Longitude` = '-95.593499' ,`PhotoCount` = '25' ,`PostalCode` = '77354' ,`RoomCount` = '8' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Hearthshire' ,`StreetNumber` = '114' ,`StreetSuffix` = 'Circle' ,`City` = 'The Woodlands' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3123' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ATTENTION INVESTORS! ABSOLUTELY STUNNING! - THIS IS IT! - BREATHTAKING M/I HOME W/ DESIRABLE ELIZABETH FLOORPLAN! - THIS HOME HAS IT ALL - WOOD FLOORS, GRANITE KITCHEN W/ LARGE ISLAND, ALL SS APPLIANCES, WASHER, DRYER, REFRIGERATOR INCLUDED, SOARING CEILINGS, OPEN & ENTERTAINING FLOORPLAN, GAMEROOM UP, STUDY W/ FRENCH DOORS, PLANTATION SHUTTERS, FORMAL DINING, HUGE MASTER CLOSET CONNECTS TO LAUNDRY ROOM W/ SINK, NO REAR NEIGHBORS - CLOSE TO PARKS, SCHOOLS, SHOPPING & RESTAURANTS! - THIS HOME IS A MUST SEE! - PLEASE DO NOT DISTURB THE TENANTS - APPOINTMENT REQUIRED! - TENANT OCCUPIED TILL JAN. 31, 2023' ,`Acres` = '0.1612' ,`Area` = '15' ,`BuilderName` = 'M/I HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Seller may be subject to foreign tax and Buyer withholding per IRS,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S969999 - WDLNDS VIL STERLING RIDGE 99, BLOCK 1, LOT 28' ,`LotDesciption` = 'Greenbelt,Subdivision Lot,Wooded' ,`LotSize` = '7020' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Sterling Ridge 99' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040280' WHERE `Matrix_Unique_ID` = '213187948' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T20:01:57.240' ,`MLSNumber` = '50811571' ,`ListAgentFullName` = 'Ana Patricia Torres' ,`ListOfficeName` = 'Winhill Advisors - Kirby' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.860721' ,`Longitude` = '-95.443610' ,`PhotoCount` = '38' ,`PostalCode` = '77091' ,`RoomCount` = '3' ,`ListPrice` = '220000.00' ,`Status` = 'Active' ,`StreetName` = 'BUNCHE' ,`StreetNumber` = '6702' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1508' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ABSOLUTELY BEAUTIFUL, 3 BEDROOM 2 BATH, ONE STORY HOME, NEW CONSTRUCTION, GRANITE THROUGHOUT THE KITCHEN AND BATHROOMS, OPEN CONCEPT WITH A LARGE ISLAND TABLE, AMPLE BACK YARD WITH PLENTY OF ROOM FOR PLAY OR PETS.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 195 BLK 6 CARVER ESTATES' ,`LotDesciption` = 'Other' ,`LotSize` = '4750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'ANDERSON ACADEMY' ,`SchoolHigh` = 'CARVER H S FOR APPLIED TECH/ENGINEERING/ARTS' ,`SchoolMiddle` = 'DREW ACADEMY' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'CARVER ESTATES' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040281' WHERE `Matrix_Unique_ID` = '213208628' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T19:38:40.833' ,`MLSNumber` = '66233946' ,`ListAgentFullName` = 'Brian Pruett' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.517273' ,`Longitude` = '-95.159683' ,`PhotoCount` = '45' ,`PostalCode` = '77546' ,`RoomCount` = '4' ,`ListPrice` = '389000.00' ,`Status` = 'Active' ,`StreetName` = 'Red Maple' ,`StreetNumber` = '3100' ,`StreetSuffix` = 'Drive' ,`City` = 'Friendswood' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2863' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Traditional-style, four-bedroom home, 2 1/2bathroom home is zoned for the award-winning CCISD and it is move-in ready! This open-floor home includes generous office space, a dining room, a kitchen, a breakfast bar, a spacious living room, a gas fireplace, a large media room, laundry room, and large bedrooms. Beautiful large windows in every room afford an ample amount of natural light. Nicely landscaped with a fenced-in yard. A touch of elegance is conveyed in the primary bedroom with recessed ceilings, a garden tub, and a glass block window. All bedrooms have ample closet space. Recent improvements include professionally painted exterior and interiors (2022), exterior light fixtures (2022), new air conditioning units (2022), a new water heater (2022), a newer roof (2016), and newer electric appliances (2019, with a new dishwasher in 2022). Located in the desirable Autumn Creek neighborhood, the home is located at the end of a cul-de-sac with plenty of well-tended green space.' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 4 AUTUMN CREEK SEC 4' ,`LotDesciption` = 'Corner,Cul-De-Sac,Greenbelt' ,`LotSize` = '7220' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'LANDOLT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'BROOKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Autumn Creek Sec 04' ,`TaxAmount` = '5964' ,`TaxRate` = '2.256' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040281' WHERE `Matrix_Unique_ID` = '213221863' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T20:49:09.230' ,`MLSNumber` = '47060080' ,`ListAgentFullName` = 'Beverly Hoeke' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.406765' ,`Longitude` = '-94.902369' ,`PhotoCount` = '31' ,`PostalCode` = '77590' ,`RoomCount` = '4' ,`ListPrice` = '269000.00' ,`Status` = 'Active' ,`StreetName` = '23rd' ,`StreetNumber` = '534' ,`StreetSuffix` = 'Avenue' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2045' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*Seller to give $5k to buyer. Welcome to this beautifully updated, corner lot home in Mainland Park! Upon entering the home, you will find crown molding accents, recessed lighting through out, modern updates & a great open floor plan. This home has 4 bedrooms where the 4th could be used as an office/flex room. The kitchen & bathrooms have sparkling white quartz countertops & black hardware accents. The kitchen has plenty of cabinet & counter space & comes with all stainless steel appliances that includes a 5 burner gas stove, a double oven, french door refrigerator, dishwasher & a single bin stainless steel sink. The dining room is perfect for a large table & the living room is also large perfect for gatherings. This home also comes with an enclosed sun room, patio with pergola & a huge barn style shed with electrical & plumbing connections. Book your showing today, this one will go soon! *New Pex Plumbing*New Water Heater*HVAC Replaced By Previous Owner*Roof Is 10 Yrs Old W/ WPI8*' ,`Acres` = '0.2209' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 167 PAGE 4 LOT 22 BLK 5 MAINLAND PARK SEC G' ,`LotDesciption` = 'Corner' ,`LotSize` = '9622' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'ROOSEVELT-WILSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TEXAS CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BLOCKER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Mainland Park' ,`TaxAmount` = '5963' ,`TaxRate` = '2.5335' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040281' WHERE `Matrix_Unique_ID` = '213234128' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T20:22:58.230' ,`MLSNumber` = '69312334' ,`ListAgentFullName` = 'Cheryl White' ,`ListOfficeName` = 'Avalon Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.557904' ,`Longitude` = '-95.754000' ,`PhotoCount` = '31' ,`PostalCode` = '77469' ,`RoomCount` = '0' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Bur Oak' ,`StreetNumber` = '2907' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1963' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fabulous over 55 community and a spectacular private greenbelt view with plenty of yard for garden and grandkids!\r\nOne of the most sought after plans the Tifton Walk with many upgrades including Custom closets and builtins. \r\nThe inviting entry features a guest bedroom and bath up front keeping the owners suite at the back with a stunning view. This kitchen has it all: spacious island, granite counters, gas range, stainless appliances, large corner pantry, water filter, and pull out trays in some cabinets. The family room adjoins the kitchen and dining area and features the inviting stone fireplace and raised hearth plus tray ceilings you will be right at home entertaining.' ,`Acres` = '0.2088' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Approved Seniors Project,Levee District' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'DEL WEBB RICHMOND SEC 1-C, BLOCK 2, LOT 6' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '9094' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'PHELAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Del Webb Richmond Sec 1-C' ,`TaxAmount` = '8301' ,`TaxRate` = '2.9548' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040281' WHERE `Matrix_Unique_ID` = '213443409' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T19:50:04.840' ,`MLSNumber` = '46045652' ,`ListAgentFullName` = 'Jeremy Fountain' ,`ListOfficeName` = 'Coldwell Banker Ultimate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.038796' ,`Longitude` = '-95.431475' ,`PhotoCount` = '30' ,`PostalCode` = '77566' ,`RoomCount` = '7' ,`ListPrice` = '245000.00' ,`Status` = 'Active' ,`StreetName` = 'Wisteria' ,`StreetNumber` = '309' ,`StreetSuffix` = 'Street' ,`City` = 'Lake Jackson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1884' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Lovely home is newly updated and move in ready. Centrally located in Lake Jackson and located minutes from all amenities. The home has a newly remodeled kitchen and bathrooms. New tile throughout the home. Brand new HVAC system installed as well has a tankless water heater. The kitchen has a brand new oven with gas cook top, hand hammered copper sink and a separate pantry for storage. The oversized lot has parking in the back and a huge two car garage with a covered patio perfect for entertaining. You have to see this home in person to get the full feel of the space and potential this home possesses.' ,`Acres` = '0.2667' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Jackson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'PARKWOOD TERRACE (LAKE JACKSON) BLK 5 LOT 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11617' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'BEUTEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE JACKSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkwood Terrace Lake Jackson' ,`TaxAmount` = '5120' ,`TaxRate` = '2.3371' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040281' WHERE `Matrix_Unique_ID` = '213474200' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T19:00:02.553' ,`MLSNumber` = '29263759' ,`ListAgentFullName` = 'Lizz Sansone' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.073000' ,`Longitude` = '-95.229563' ,`PhotoCount` = '50' ,`PostalCode` = '77365' ,`RoomCount` = '13' ,`ListPrice` = '485000.00' ,`Status` = 'Active' ,`StreetName` = 'Autumn Water' ,`StreetNumber` = '25231' ,`StreetSuffix` = 'Street' ,`City` = 'Porter' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2846' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning one-story Westin home on cul-de-sac street is just steps away from the community lake and features an open floor plan with high ceilings & tile floors throughout the living areas. Extended foyer opens to living room with cathedral ceiling, stack-stoned gas log fireplace flanked by windows & flows seamlessly to kitchen, dining & study with French doors. Gourmet T-shaped island kitchen with breakfast bar & pendant lighting touts 42” cabinetry, quartz counters with tiled back splash & lighting, S/S appliances including gas cook top, walk-in pantry & refrigerator stays. Owner’s suite with space for sitting area has luxurious bath with dual dressing areas, make-up vanity, free-standing tub, separate shower & two walk-in closets. Secondary bedrooms with en-suite and Jack & Jill bath and utility room with washer/dryer. Spacious backyard has 12x18 covered patio, cedar pergola & travertine flooring. Air conditioned garage is the perfect man cave w/upgraded electrical & epoxy floor.' ,`Acres` = '0.2168' ,`Area` = '40' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S973608 - WOODRIDGE FOREST 08, BLOCK 1, LOT 11' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Wooded' ,`LotSize` = '9443' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '790' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'KINGS MANOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodridge Forest' ,`TaxAmount` = '7549' ,`TaxRate` = '3.3931' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040282' WHERE `Matrix_Unique_ID` = '213495762' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T19:30:44.890' ,`MLSNumber` = '82769992' ,`ListAgentFullName` = 'Tinsley Alexander' ,`ListOfficeName` = 'RE/MAX Signature' ,`SellingAgentFullName` = 'Kendra Larson' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.660408' ,`Longitude` = '-95.934138' ,`PhotoCount` = '50' ,`PostalCode` = '77441' ,`RoomCount` = '13' ,`ListPrice` = '1050000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Wentworth' ,`StreetNumber` = '4007' ,`StreetSuffix` = 'Drive' ,`City` = 'Fulshear' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4753' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fabulous 1.5 STORY by J. Hunter Homes on HUGE GOLF COURSE lot with Pool/ Spa* Stunning Tumbled Marble Flooring* Kitchen with Double Island, SS appliances, built in Refrigerator, Stunning Cook top with Grill* Utility Room in house that measures 12 x 12 complete with built in cabinets *0.813 Acre lot between 9th & 10th Fairways*Panoramic View of Golf Course & Pond*Located in Riverwood Forest Section*LOW TAX RATE*NO MUD TAX*This Home has a WATER WELL for Irrigation*Ideal Floor Plan*Master Bedroom Down with Huge Closet with Built ins, Dual Sink/ vanity areas and Car Wash Shower. 2 other secondary Bedrooms Down, one with En=Suite, Study and Family Room have Stunning Wood beamed ceilings, Study with Built in office. Total of 3 1/2 baths downstairs. Upstairs includes GameRm+Media Rm+4th BdRm & Bath Up *Custom Quality/Features*High Ceilings*Crown Molding*Wood/Tile/Carpet*Open Plan*3-Car Gar*Huge Covered Patio+Fireplace+ outdoor kitchen*Great Location*Long Driveway with additional parking' ,`Acres` = '0.813' ,`Area` = '30' ,`BuilderName` = 'J. Hunter Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RIVERWOOD FOREST AT WESTON LAKES SEC 1, BLOCK 3, LOT 4, ACRE' ,`LotDesciption` = 'In Golf Course Community,On Golf Course,Water View' ,`LotSize` = '35414' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1966' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Grill' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MORGAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,No Photos/No Videos,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Weston Lakes' ,`TaxAmount` = '11770' ,`TaxRate` = '1.7948' ,`WaterSewer` = 'Other Water/Sewer,Well' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669040282' WHERE `Matrix_Unique_ID` = '213550919' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T19:41:39.323' ,`MLSNumber` = '57404812' ,`ListAgentFullName` = 'Jacob George' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.546033' ,`Longitude` = '-95.406921' ,`PhotoCount` = '41' ,`PostalCode` = '77584' ,`RoomCount` = '9' ,`ListPrice` = '679000.00' ,`Status` = 'Active' ,`StreetName` = 'Linden Walk' ,`StreetNumber` = '12007' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4040' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful lake front home in the exclusive Magnolia Lake Estates section of Southern Trails! This home boasts 4 bedrooms with amazing backyard lake views, 4.5 bathrooms, and a 3-car garage! Media room (being used for storage) adjacent to a large game-room! Hidden bookshelf in game-room with additional storage space. Spacious backyard with large extended covered patio and access to walking trail surrounding the gorgeous lake. Neighborhood access to fully equipped recreation center, swimming pool, and community hall! Quiet neighborhood just miles away from Medical Center, Downtown Houston, and major universities. Call to schedule a showing soon! This one won\'t stay on the market long!' ,`Acres` = '0.2634' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SOUTHERN TRAILS SEC 14 (A0564 HT&BRR)(PEARLAND) BLK 3 LOT 5' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '11474' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '908' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'BROTHERS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHADOW CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MCNAIR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Southern Trails Sec 14' ,`TaxAmount` = '19371' ,`TaxRate` = '3.5109' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040282' WHERE `Matrix_Unique_ID` = '213556830' --> 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','213607711','1669040282','213607711','2022-11-18T20:08:39.740','32099697','Beverly Bradley','Weekley Homes','','','29.975200','-95.745276','21','77433','8','499526.00','Active','Paseo De La Paz','13814','Place','Cypress','3','0','4','2550','Single-Family','Dunham Pointe has arrived! This master planned community is perfectly situated near distinctive restaurants, local and national brands, select services, and curated retail to offer a rich and varied lifestyle. Inspired by Romanesque architecture, this stunning community celebrates the zest for life, designed to create a close-knit community. David Weekly is introducing its spacious and comfortable Edgehill home. Entertaining is a breeze in this 1-story open plan as your family gathers around the over-sized kitchen island. Even the outdoor living offers plenty of space for grilling and summer fun. Plenty of space in the over-sized garage for storing all the riding toys, or golf cart. Inviting amenities like walking trails,clubhouse, pool and Cy-Fair I.S.D schools, will help neighbors become fast friends. Join us!!','','25','David Weekley Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Home Protection Plan,Mud','1','','','Cypress South','Central Gas','1','Lot 39 Block 01','Subdivision Lot','6965','Other','','1000','1','To Be Built/Under Construction','2','Electric Oven,Single Oven','0','','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','AULT ELEMENTARY SCHOOL','BRIDGELAND HIGH SCHOOL','SALYARDS MIDDLE SCHOOL','Appointment Required,No Supra Keybox','Builder','1','Traditional','Dunham Pointe','','','Water District','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T19:00:18.357' ,`MLSNumber` = '9523305' ,`ListAgentFullName` = 'Amy Hendrix' ,`ListOfficeName` = 'RE/MAX American Dream' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.335454' ,`Longitude` = '-95.293829' ,`PhotoCount` = '38' ,`PostalCode` = '77511' ,`RoomCount` = '4' ,`ListPrice` = '383900.00' ,`Status` = 'Active' ,`StreetName` = 'Finetta' ,`StreetNumber` = '12' ,`StreetSuffix` = 'Lane' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2521' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 12 Finetta! This private estate is located off the beat\'n path down a dead end road. This home has it all, sunroom, pool with no back neighbors, multiple covered pergolas, newly remodeled kitchen, detached garage, storage shed, primary bedroom has a nook that can be a bedroom/nursery or office, water filtering system...this one has it ALL!\r\nCall today for your private showing.' ,`Acres` = '0.3712' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'COUNTRY MANOR INC (A0006 A H & B R R) LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '16169' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'NELSON ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRVIEW JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Colonial' ,`Subdivision` = 'Country Manor Inc' ,`TaxAmount` = '8426' ,`TaxRate` = '2.7907' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040282' WHERE `Matrix_Unique_ID` = '213642859' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T20:20:42.313' ,`MLSNumber` = '46654370' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.427660' ,`Longitude` = '-95.453594' ,`PhotoCount` = '48' ,`PostalCode` = '77583' ,`RoomCount` = '8' ,`ListPrice` = '299990.00' ,`Status` = 'Active' ,`StreetName` = 'Sequoia Grove' ,`StreetNumber` = '2414' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1982' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LAKE LOT!\r\nColina Homes- Single Story: bedrooms full bathrooms and Study. Tons of Beautiful Finishes included!!Gorgeous kitchen with stunning cabinets, granite and designer tled backsplash . Covered back patio ready for weekend BBQ\'s, You\'re going to Love it! Situated in one of Rosharon\'s best communities, Sierra Vista. Family \r\nfriendly community, with current Amenities such as the splashpad, fitness center, Basketball Court, Lakes, Parks in Sterling Lakes. The New Crystal Lagoon which is coming soon are all included for you!! Close to Pearland, Alvin, Manvel, Lake Jackson, 30 minutes from Downtown Houston. SHOP AND WORK IN THE CITY AND COME HOME TO A QUIET PEACEFUL COMMUNITY @ SIERRA VISTA! PHOTOS ARE REPRESENTATIVE. Est. Completion February 2023' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1 Block 1 Section 6' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '7133' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista West' ,`TaxAmount` = '' ,`TaxRate` = '3.6' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669040283' WHERE `Matrix_Unique_ID` = '213728701' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T20:18:49.950' ,`MLSNumber` = '41530044' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.427469' ,`Longitude` = '-95.454204' ,`PhotoCount` = '42' ,`PostalCode` = '77583' ,`RoomCount` = '8' ,`ListPrice` = '414990.00' ,`Status` = 'Active' ,`StreetName` = 'Sequoia Grove' ,`StreetNumber` = '2421' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2349' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful one story with four bedrooms, three full baths plus study/dining room, 2 sinks in primary bath with garden Tub and large standalone shower. utility room connect to spaces primary closet. Additional closet in primary off primary bath. High ceiling granite kitchen with deep vinderman sink 42 inch cabinets. Stainless steel five burner gas range and With microwave and dishwasher 2\" blinds along with windstorm panels. Est completion: February 2023' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Colina Homes' ,`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` = 'Lot 8 BLK 1 Sec 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7197' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista West' ,`TaxAmount` = '' ,`TaxRate` = '3.606' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669040283' WHERE `Matrix_Unique_ID` = '213740656' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T20:19:53.470' ,`MLSNumber` = '7136689' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.427362' ,`Longitude` = '-95.453243' ,`PhotoCount` = '29' ,`PostalCode` = '77583' ,`RoomCount` = '10' ,`ListPrice` = '359990.00' ,`Status` = 'Active' ,`StreetName` = 'Sequoia Grove' ,`StreetNumber` = '2409' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2050' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Colina Homes- Single Story: Elegant entry with coffered tall ceilings, 4 bedrooms, 3 baths location in our gated section of Sierra Vista! Spacious master closet with his/her sinks and sep. tub\r\nand shower. Tons of Beautiful Finishes included!!Gorgeous kitchen with stunning cabinets, granite\r\nand tiled backslash , Perfect backyard and a Large covered back patio ready for weekend BBQ\'s.\r\nYou\'re going to Love it! Situated in one of Rosharon\'s best communities. and offers everything your\r\nare looking in a family friendly community- amenities located in Sterling Lakes - the spashpad, fitness\r\ncenter, Basketball Court, Lakes & Parks. Crystal Lagoon coming soon! Close to Pearland, Alvin,\r\nManvel, Lake Jackson, 30 minutes from Downtown Houston. SHOP AND WORK IN THE CITY AND\r\nCOME HOME TO A QUIET PEACEFUL COMMUNITY @ SIERRA VISTA! PHOTOS ARE REPRESENTATIVE.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 5 Block 1 Sec 6' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7156' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista West' ,`TaxAmount` = '' ,`TaxRate` = '3.6' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669040283' WHERE `Matrix_Unique_ID` = '213740949' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T19:51:33.307' ,`MLSNumber` = '51789793' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.835660' ,`Longitude` = '-95.852970' ,`PhotoCount` = '26' ,`PostalCode` = '77493' ,`RoomCount` = '8' ,`ListPrice` = '351990.00' ,`Status` = 'Active' ,`StreetName` = 'Aurora Creek' ,`StreetNumber` = '434' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2102' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SUNTERRA IS NOW OPEN!! KATY ISD- Colina Homes believes in building your dream 2-Story w/ 4Bedrooms (2 bed down & 2 bed up) + 3 Full Baths + LOFT at a price you CAN afford! Come see this open-concept home.This beautiful Kitchen features Maple Slate 42” Cabinets + Fantasy Brown Granite + Biscuit Matte Tile Backsplash on Subway Pattern + Stainless \"Farmhouse\" Single-Bowl Sink +Stainless Frigidaire Dishwasher, Vented Microwave & 5-BURNER GAS RANGE! Wood-like Flooring at Entry, Kitchen, Dining, Family Rm, Hallways, Utility & ALL Baths. Spacious Master Suite that boasts a walk-in Closet, 42\"-High Cabinets with Double Sinks, & 5’Spacious Separate Shower, 4 Sides Acme Brick, 2” Faux Wood Blinds,16 SEER Lennox Air System, Covered Back Patio much more! This Energy Efficient home will SAVE you $$$! CALL & MAKE YOUR APPOINTMENT TO VISIT TODAY. Come visit the model home located at 105 Eliana Shores.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 25 Block 3 Sec 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6465' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.67' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669040283' WHERE `Matrix_Unique_ID` = '213798778' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T20:13:14.183' ,`MLSNumber` = '12042958' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.072302' ,`Longitude` = '-95.768449' ,`PhotoCount` = '46' ,`PostalCode` = '77447' ,`RoomCount` = '10' ,`ListPrice` = '358840.00' ,`Status` = 'Active' ,`StreetName` = 'Capri Shores' ,`StreetNumber` = '19838' ,`StreetSuffix` = 'Lane' ,`City` = 'Hockley' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2365' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COLINA HOMES CYPRESS GREEN 635 acre, idyllic lifestyle master-planned Land Tejas community. 365 DAY RATE LOCKS WITH FLOAT DOWN OPTION AVAILABLE. 50\' wide homesites with our popular plans. Just released. 2365SF, 4 Bed/ Gameroom, 3.5 Bath, great features with an unbeatable value. Besides the large country kitchen island that welcomes you home, the features you come to expect from Colina Homes are included: Extensive tile/vinyl planking in all the wet areas/entry and LIVING ROOM, All gas heat, granite in the kitchen, 42\" cabinets, stainless appliances to include our premium 5 burner range, 9\" farm sink, 2\" blinds, Garden Tub and separate shower, Pex Plumbing, Lennox 16- Seer A/C, Taexx Pest Control. All this included for you. Easy access from 2920 near 290, 249 and TX-99. Close to shopping, dining, parks and golf. Offsite sales office at 20107 Sedona Park Dr. Hockley Tx 77447. PHOTOS ARE REPRESENTATIVE' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 21 Block 2 Sec 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6350' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'EVELYN TURLINGTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Green' ,`TaxAmount` = '' ,`TaxRate` = '3.371348' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669040284' WHERE `Matrix_Unique_ID` = '213857024' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T20:10:12.713' ,`MLSNumber` = '96832403' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.072230' ,`Longitude` = '-95.768165' ,`PhotoCount` = '50' ,`PostalCode` = '77447' ,`RoomCount` = '6' ,`ListPrice` = '324465.00' ,`Status` = 'Active' ,`StreetName` = 'Capri Shores' ,`StreetNumber` = '19914' ,`StreetSuffix` = 'Lane' ,`City` = 'Hockley' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2121' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COLINA HOMES CYPRESS GREEN 635 acre, idyllic lifestyle master-planned Land Tejas community. 365 DAY RATE LOCKS WITH FLOAT DOWN OPTION AVAILABLE. 50\' wide homesites with our popular plans. 3-sides brick w/ stone accent. Just released. 1816 SF, 4 Bed/3 Bath, great features with an unbeatable value. Besides the large country kitchen island that welcomes you home, the features you come to expect from Colina Homes are included: Extensive tile/vinyl planking in all the wet areas/entry and LIVING ROOM, All gas heat, granite in the kitchen, 42\" cabinets, stainless appliances to include our premium 5 burner range, 9\" farm sink, 2\" blinds, Garden Tub and separate shower, Pex Plumbing, Lennox 16- Seer A/C, Taexx Pest Control. All this included for you. Easy access from 2920 near 290, 249 and TX-99. Close to shopping, dining, parks and golf. Onsite sales office at 20107 Sedona Park Dr. Hockley Tx 77447.' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 14 Block 1 Sec 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6350' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'EVELYN TURLINGTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Green' ,`TaxAmount` = '' ,`TaxRate` = '3.713438' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669040284' WHERE `Matrix_Unique_ID` = '213857105' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T20:00:22.943' ,`MLSNumber` = '67086408' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.072607' ,`Longitude` = '-95.768186' ,`PhotoCount` = '50' ,`PostalCode` = '77447' ,`RoomCount` = '5' ,`ListPrice` = '288390.00' ,`Status` = 'Active' ,`StreetName` = 'Capri Shore' ,`StreetNumber` = '19906' ,`StreetSuffix` = 'Lane' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COLINA HOMES CYPRESS GREEN 635 acre, idyllic lifestyle master-planned Land Tejas community. 365 DAY RATE LOCKS WITH FLOAT DOWN OPTION AVAILABLE. 50\' wide homesites with our popular plans. 3-sides brick with stone accent, Just released. 1816 SF, 4 Bed/3 Bath, great features with an unbeatable value. Besides the large country kitchen island that welcomes you home, the features you come to expect from Colina Homes are included: Extensive tile/vinyl planking in all the wet areas/entry and LIVING ROOM, All gas heat, granite in the kitchen, 42\" cabinets, stainless appliances to include our premium 5 burner range, 9\" farm sink, 2\" blinds, Garden Tub and separate shower, Pex Plumbing, Lennox 16- Seer A/C, Taexx Pest Control. All this included for you. Easy access from 2920 near 290, 249 and TX-99. Close to shopping, dining, parks and golf. Onsite sales office 20107 Sedona Park Dr. Hockley Tx 77447.' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 16 Block 1 Sec 5' ,`LotDesciption` = 'Greenbelt' ,`LotSize` = '6350' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'EVELYN TURLINGTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Cypress Green' ,`TaxAmount` = '' ,`TaxRate` = '3.71438' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669040284' WHERE `Matrix_Unique_ID` = '213857118' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T20:07:48.153' ,`MLSNumber` = '93700573' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.072351' ,`Longitude` = '-95.768239' ,`PhotoCount` = '50' ,`PostalCode` = '77447' ,`RoomCount` = '8' ,`ListPrice` = '321730.00' ,`Status` = 'Active' ,`StreetName` = 'Capri Shores' ,`StreetNumber` = '19830' ,`StreetSuffix` = 'Lane' ,`City` = 'Hockley' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1816' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COLINA HOMES CYPRESS GREEN 635 acre, idyllic lifestyle master-planned Land Tejas community. 365 DAY RATE LOCKS WITH FLOAT DOWN OPTION AVAILABLE. 50\' wide homesites with our popular plans. 3-sides brick w/ stone accent. Just released. 1816 SF, 4 Bed/3 Bath, great features with an unbeatable value. Besides the large country kitchen island that welcomes you home, the features you come to expect from Colina Homes are included: Extensive tile/vinyl planking in all the wet areas/entry and LIVING ROOM, All gas heat, granite in the kitchen, 42\" cabinets, stainless appliances to include our premium 5 burner range, 9\" farm sink, 2\" blinds, Garden Tub and separate shower, Pex Plumbing, Lennox 16- Seer A/C, Taexx Pest Control. All this included for you. Easy access from 2920 near 290, 249 and TX-99. Close to shopping, dining, parks and golf. Onsite sales office at 20107 Sedona Park Dr. Hockley Tx 77447.' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 19 Block 1 Sec 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6350' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'EVELYN TURLINGTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Cypress Green' ,`TaxAmount` = '' ,`TaxRate` = '3.713438' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669040284' WHERE `Matrix_Unique_ID` = '213857216' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T20:12:28.710' ,`MLSNumber` = '7182447' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.072230' ,`Longitude` = '-95.768165' ,`PhotoCount` = '39' ,`PostalCode` = '77447' ,`RoomCount` = '6' ,`ListPrice` = '343740.00' ,`Status` = 'Active' ,`StreetName` = 'Capri Shores' ,`StreetNumber` = '19842' ,`StreetSuffix` = 'Lane' ,`City` = 'Hockley' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2121' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COLINA HOMES CYPRESS GREEN 635 acre, idyllic lifestyle master-planned Land Tejas community. 365 DAY RATE LOCKS WITH FLOAT DOWN OPTION AVAILABLE. 50\' wide homesites with our popular plans. 3-sides brick w/ stone accent. Just released. 1816 SF, 4 Bed/3 Bath, great features with an unbeatable value. Besides the large country kitchen island that welcomes you home, the features you come to expect from Colina Homes are included: Extensive tile/vinyl planking in all the wet areas/entry and LIVING ROOM, All gas heat, granite in the kitchen, 42\" cabinets, stainless appliances to include our premium 5 burner range, 9\" farm sink, 2\" blinds, Garden Tub and separate shower, Pex Plumbing, Lennox 16- Seer A/C, Taexx Pest Control. All this included for you. Easy access from 2920 near 290, 249 and TX-99. Close to shopping, dining, parks and golf. Onsite sales office at 20107 Sedona Park Dr. Hockley Tx 77447.' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 22 Block 2 Sec 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6350' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'EVELYN TURLINGTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Green' ,`TaxAmount` = '' ,`TaxRate` = '3.713438' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669040285' WHERE `Matrix_Unique_ID` = '213857348' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T20:11:34.923' ,`MLSNumber` = '63930362' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.072230' ,`Longitude` = '-95.768165' ,`PhotoCount` = '50' ,`PostalCode` = '77447' ,`RoomCount` = '6' ,`ListPrice` = '344835.00' ,`Status` = 'Active' ,`StreetName` = 'Capri Shores' ,`StreetNumber` = '19826' ,`StreetSuffix` = 'Lane' ,`City` = 'Hockley' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2121' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COLINA HOMES CYPRESS GREEN 635 acre, idyllic lifestyle master-planned Land Tejas community. 365 DAY RATE LOCKS WITH FLOAT DOWN OPTION AVAILABLE. 50\' wide homesites with our popular plans. 3-sides brick w/ stone accent. Just released. 1816 SF, 4 Bed/3 Bath, great features with an unbeatable value. Besides the large country kitchen island that welcomes you home, the features you come to expect from Colina Homes are included: Extensive tile/vinyl planking in all the wet areas/entry and LIVING ROOM, All gas heat, granite in the kitchen, 42\" cabinets, stainless appliances to include our premium 5 burner range, 9\" farm sink, 2\" blinds, Garden Tub and separate shower, Pex Plumbing, Lennox 16- Seer A/C, Taexx Pest Control. All this included for you. Easy access from 2920 near 290, 249 and TX-99. Close to shopping, dining, parks and golf. Onsite sales office at 20107 Sedona Park Dr. Hockley Tx 77447.' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 14 Block 1 Sec 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6350' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'EVELYN TURLINGTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Green' ,`TaxAmount` = '' ,`TaxRate` = '3.713438' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669040285' WHERE `Matrix_Unique_ID` = '213857457' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T20:09:24.543' ,`MLSNumber` = '70547975' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.072351' ,`Longitude` = '-95.768239' ,`PhotoCount` = '50' ,`PostalCode` = '77447' ,`RoomCount` = '8' ,`ListPrice` = '323426.00' ,`Status` = 'Active' ,`StreetName` = 'Capri Shores' ,`StreetNumber` = '19902' ,`StreetSuffix` = 'Lane' ,`City` = 'Hockley' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1816' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COLINA HOMES CYPRESS GREEN 635 acre, idyllic lifestyle master-planned Land Tejas community. 365 DAY RATE LOCKS WITH FLOAT DOWN OPTION AVAILABLE. 50\' wide homesites with our popular plans. 3-sides brick w/ stone accent. Just released. 1816 SF, 4 Bed/3 Bath, great features with an unbeatable value. Besides the large country kitchen island that welcomes you home, the features you come to expect from Colina Homes are included: Extensive tile/vinyl planking in all the wet areas/entry and LIVING ROOM, All gas heat, granite in the kitchen, 42\" cabinets, stainless appliances to include our premium 5 burner range, 9\" farm sink, 2\" blinds, Garden Tub and separate shower, Pex Plumbing, Lennox 16- Seer A/C, Taexx Pest Control. All this included for you. Easy access from 2920 near 290, 249 and TX-99. Close to shopping, dining, parks and golf. Onsite sales office at 20107 Sedona Park Dr. Hockley Tx 77447.' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 17 Block 1 Sec 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6350' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'EVELYN TURLINGTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Cypress Green' ,`TaxAmount` = '' ,`TaxRate` = '3.713438' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669040285' WHERE `Matrix_Unique_ID` = '213857575' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T20:08:35.373' ,`MLSNumber` = '45867044' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.072351' ,`Longitude` = '-95.768239' ,`PhotoCount` = '50' ,`PostalCode` = '77447' ,`RoomCount` = '8' ,`ListPrice` = '322926.00' ,`Status` = 'Active' ,`StreetName` = 'Capri Shores' ,`StreetNumber` = '19918' ,`StreetSuffix` = 'Lane' ,`City` = 'Hockley' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1816' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COLINA HOMES CYPRESS GREEN 635 acre, idyllic lifestyle master-planned Land Tejas community. 365 DAY RATE LOCKS WITH FLOAT DOWN OPTION AVAILABLE. 50\' wide homesites with our popular plans. 3-sides brick w/ stone accent. Just released. 1816 SF, 4 Bed/3 Bath, great features with an unbeatable value. Besides the large country kitchen island that welcomes you home, the features you come to expect from Colina Homes are included: Extensive tile/vinyl planking in all the wet areas/entry and LIVING ROOM, All gas heat, granite in the kitchen, 42\" cabinets, stainless appliances to include our premium 5 burner range, 9\" farm sink, 2\" blinds, Garden Tub and separate shower, Pex Plumbing, Lennox 16- Seer A/C, Taexx Pest Control. All this included for you. Easy access from 2920 near 290, 249 and TX-99. Close to shopping, dining, parks and golf. Onsite sales office at 20107 Sedona Park Dr. Hockley Tx 77447.' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 13 Block 1 Sec 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6350' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'EVELYN TURLINGTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Cypress Green' ,`TaxAmount` = '' ,`TaxRate` = '3.713438' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669040285' WHERE `Matrix_Unique_ID` = '213857622' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T19:31:54.900' ,`MLSNumber` = '17647411' ,`ListAgentFullName` = 'Michelle Feltrop' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.033739' ,`Longitude` = '-95.180985' ,`PhotoCount` = '38' ,`PostalCode` = '77339' ,`RoomCount` = '15' ,`ListPrice` = '1170000.00' ,`Status` = 'Active' ,`StreetName` = 'Club Oak' ,`StreetNumber` = '5' ,`StreetSuffix` = 'Court' ,`City` = 'Kingwood' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '5120' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Indoor-outdoor living & designer interiors in this beautifully updated home. Stunning wide entry double metal doors adds sophistication to the brick facade.This home exudes serenity and peace with beautiful 7\" white oak wood floors, high-end finishes & open floorplan. Downstairs offers high ceilings, open kitchen/living/dining space + primary bedroom with luxurious bathroom including dual sinks, large walk-in shower, freestanding tub & incredible walk-in closet. The chefs kitchen includes DBL ovens, gas cooktop, ice maker, walk-in pantry & storage space/mudroom area. Upstairs brings you to 3 BR,3 BA, game room, reading/computer nook, large flex room or 5th bedroom & 2nd Flr Lndry room. The backyard is finished with a beautiful pool/spa/fountains, large green space & covered patio. 3 car garage. Whole home restoration 2020. New roof 9/22, New generator 9/22, New paint 9/22. New large finished flex room 9/22. Upstairs white oak WD FLRS added to BRs 9/22. Garage floor 9/22. Lndscp 9/22' ,`Acres` = '0.363' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 43 BLK 2 KINGWOOD GREENS' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community' ,`LotSize` = '15812' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '840' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GREENTREE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kingwood Greens' ,`TaxAmount` = '17349' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040285' WHERE `Matrix_Unique_ID` = '213911634' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T19:36:04.417' ,`MLSNumber` = '14140638' ,`ListAgentFullName` = 'Ana Maldonado' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.882060' ,`Longitude` = '-95.667745' ,`PhotoCount` = '14' ,`PostalCode` = '77095' ,`RoomCount` = '5' ,`ListPrice` = '259000.00' ,`Status` = 'Active' ,`StreetName` = 'Summer Dew' ,`StreetNumber` = '17015' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1924' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOW property taxes, great location, easy access to Katy Freeway and Hwy 290. Magnificent Cypress School district. Bussy business district , nice neighborhood house in great condition. \r\n X tra insulation in attic and storm windows will keep your electric bill low. Ac. System is from 2018 .\r\nAll 4 bedrooms have fans. Oversized master bedroom. Large living room with recessed lights . \r\nFresh paint inside and outside. \r\nMain bathroom and a double zinc granite counter top.\r\nG r a n I t e stone in Breakfast bar AND kitchen counters. KITCHEN has space for a set of breakfast table . Refrigerator included all appliances working perfectly. Garden with pines , roses and safe \r\n\r\ntrees and green bushes. House has 3 brick walls back wall is wood. NEWER SINGLE GARAGE DOOR FOR TWO VEHICLES AND LONG OUTSIDE PARKING. T HANK YOU.' ,`Acres` = '0.1543' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 66 BLK 8 SOMMERALL SEC 4' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6720' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '493' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HOLMSLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LANGHAM CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'ARAGON MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Sommerall Sec 04' ,`TaxAmount` = '4782' ,`TaxRate` = '2.596' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040286' WHERE `Matrix_Unique_ID` = '214012652' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T20:00:10.167' ,`MLSNumber` = '77044091' ,`ListAgentFullName` = 'Suzanne Estrada' ,`ListOfficeName` = 'Leopold & Strahan Realty Group' ,`SellingAgentFullName` = 'Lesley Fontenot' ,`SellingOfficeName` = 'JPAR - The Sears Group' ,`Latitude` = '29.277998' ,`Longitude` = '-94.839159' ,`PhotoCount` = '15' ,`PostalCode` = '77551' ,`RoomCount` = '4' ,`ListPrice` = '299000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Maple' ,`StreetNumber` = '31' ,`StreetSuffix` = 'Lane' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1418' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Darling one story 3 bedroom 2 bath / 2 car garage brick home the well established Driftwood Subdivision. The home is nestled in a serene cul-de-sac lined with mature trees. The kitchen features granite countertops, an island with breakfast bar, recessed lighting and a custom built in office desk. Spacious bedrooms & addtional storage in the hallway. The primary bedroom features an en-suite bathroom and fully enclosed glass shower. The laminate wood flooring features warm rich tones perfect for any decor. The back porch serves as the perfect place to relax and unwind after a long day. MAKE AN APPOINTMENT TO VIEW TODAY!' ,`Acres` = '0.1445' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Near West End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 50 DRIFTWOOD' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6293' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Driftwood' ,`TaxAmount` = '4084' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040286' WHERE `Matrix_Unique_ID` = '214051951' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T20:14:04.070' ,`MLSNumber` = '14969365' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.072302' ,`Longitude` = '-95.768449' ,`PhotoCount` = '45' ,`PostalCode` = '77447' ,`RoomCount` = '10' ,`ListPrice` = '360740.00' ,`Status` = 'Active' ,`StreetName` = 'Capri Shores' ,`StreetNumber` = '19910' ,`StreetSuffix` = 'Lane' ,`City` = 'Hockley' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2365' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COLINA HOMES CYPRESS GREEN 635 acre, idyllic lifestyle master-planned Land Tejas community. 365 DAY RATE LOCKS WITH FLOAT DOWN OPTION AVAILABLE. 50\' wide homesites with our popular plans. Just released. 2365SF, 4 Bed/ Gameroom, 3.5 Bath, great features with an unbeatable value. Besides the large country kitchen island that welcomes you home, the features you come to expect from Colina Homes are included: Extensive tile/vinyl planking in all the wet areas/entry and LIVING ROOM, All gas heat, granite in the kitchen, 42\" cabinets, stainless appliances to include our premium 5 burner range, 9\" farm sink, 2\" blinds, Garden Tub and separate shower, Pex Plumbing, Lennox 16- Seer A/C, Taexx Pest Control. All this included for you. Easy access from 2920 near 290, 249 and TX-99. Close to shopping, dining, parks and golf. Onsite sales office at 20107 Sedona Park Dr. Hockley Tx 77447. PHOTOS ARE REPRESENTATIVE' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 15 Block 1 Sec 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6350' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'EVELYN TURLINGTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Green' ,`TaxAmount` = '' ,`TaxRate` = '3.371348' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669040286' WHERE `Matrix_Unique_ID` = '214153165' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T20:06:44.977' ,`MLSNumber` = '49825754' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.072607' ,`Longitude` = '-95.768186' ,`PhotoCount` = '50' ,`PostalCode` = '77447' ,`RoomCount` = '5' ,`ListPrice` = '290890.00' ,`Status` = 'Active' ,`StreetName` = 'Capri Shore' ,`StreetNumber` = '19834' ,`StreetSuffix` = 'Lane' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COLINA HOMES CYPRESS GREEN 635 acre, idyllic lifestyle master-planned Land Tejas community. 365 DAY RATE LOCKS WITH FLOAT DOWN OPTION AVAILABLE. 50\' wide homesites with our popular plans. 3-sides brick with stone accent, Just released. 1816 SF, 4 Bed/3 Bath, great features with an unbeatable value. Besides the large country kitchen island that welcomes you home, the features you come to expect from Colina Homes are included: Extensive tile/vinyl planking in all the wet areas/entry and LIVING ROOM, All gas heat, granite in the kitchen, 42\" cabinets, stainless appliances to include our premium 5 burner range, 9\" farm sink, 2\" blinds, Garden Tub and separate shower, Pex Plumbing, Lennox 16- Seer A/C, Taexx Pest Control. All this included for you. Easy access from 2920 near 290, 249 and TX-99. Close to shopping, dining, parks and golf. onsite sales office at 20107 Sedona Park Dr. Hockley Tx 77447 .' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 20 Block 2 Sec 5' ,`LotDesciption` = 'Greenbelt' ,`LotSize` = '6350' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'EVELYN TURLINGTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Cypress Green' ,`TaxAmount` = '' ,`TaxRate` = '3.71438' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669040286' WHERE `Matrix_Unique_ID` = '214153350' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T19:47:14.370' ,`MLSNumber` = '61004027' ,`ListAgentFullName` = 'Anthony Blissett' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.521976' ,`Longitude` = '-95.479744' ,`PhotoCount` = '28' ,`PostalCode` = '77545' ,`RoomCount` = '4' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Twin Timber Ct' ,`StreetNumber` = '4506' ,`StreetSuffix` = '' ,`City` = 'Fresno' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2587' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come fall in love with this beautiful remodeled property located in a cul-de-sac within the Fresno-Teal Run community! This home comes with professionally refinished cabinets, new flooring throughout with modern black fixtures and hardware! This home also comes with stainless steel appliances in the kitchen with quartz countertops! UPDATED A/C! BRAND NEW LVP flooring! NEW CARPET IN BEDROOMS! RENOVATED BATHROOMS! LARGE GAME ROOM UPSTAIRS! BRAND NEW DECK in the very spacious back yard! You will feel right at home after visiting this quiet community featuring TWO POOLS and a TENNIS COURT! This place has it all with a highly rated elementary school close by and beautiful walking park! They are also currently building a new fire station just one block away! This home won\'t last long!!!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TEAL RUN SEC 02, BLOCK 4, LOT 11, PHASE 2, 50.000000% UDI' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '12670' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '430' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BURTON ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'HIGHTOWER HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Teal Run' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040287' WHERE `Matrix_Unique_ID` = '214241782' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T20:07:12.460' ,`MLSNumber` = '65857057' ,`ListAgentFullName` = 'Latisha Bradshaw' ,`ListOfficeName` = 'Texas Diamond Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.537562' ,`Longitude` = '-95.122646' ,`PhotoCount` = '34' ,`PostalCode` = '77598' ,`RoomCount` = '6' ,`ListPrice` = '480000.00' ,`Status` = 'Active' ,`StreetName` = 'Hubert' ,`StreetNumber` = '323' ,`StreetSuffix` = 'Street' ,`City` = 'Webster' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '2575' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the heart of Webster! This home boasts so much potential with 2 bedrooms and 3 baths (two inside the home and one located in garage) Sitting on a double corner lot, this classic comes with custom built-in cabinets and china cabinets through out the entire home. Huge open living room to entertain your guests. Light the fire and relax by the gorgeous fireplace. The back yard is completely fenced with a small shed in the back. It has an attached sunroom which could be a green house. Comes with an on site generator. Completely fenced with custom gates. Fruit bearing tree in the front yard with different foliage all over the property. The storage area above the garage is large enough to convert to another room if you wanted. There’s 2 carports on each side of the property , one is for an RV with complete hookups. There is a 2 car double garage, and a one car separate garage. This home won’t last long. Schedule your showing now.' ,`Acres` = '0.4304' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 7 & 8 BLK 38 WEBSTER' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '18750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range,Grill' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'MCWHIRTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CLEAR CREEK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Webster' ,`TaxAmount` = '7765' ,`TaxRate` = '2.1594' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040287' WHERE `Matrix_Unique_ID` = '214467114' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T19:44:59.013' ,`MLSNumber` = '74003780' ,`ListAgentFullName` = 'Joel Medina' ,`ListOfficeName` = 'C.R.Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.771586' ,`Longitude` = '-95.737472' ,`PhotoCount` = '26' ,`PostalCode` = '77450' ,`RoomCount` = '3' ,`ListPrice` = '280000.00' ,`Status` = 'Active' ,`StreetName` = 'Cimarron' ,`StreetNumber` = '21011' ,`StreetSuffix` = 'Parkway' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2125' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home is in a nice area close to schools, stores and shopping centers. Homes sits on a nice size lot. Spacious inside. Call me for any questions or a private tour of the home. Please verify schools and rooms dimensions.' ,`Acres` = '0.1795' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 & TR 27B BLK 12 MEMORIAL PARKWAY SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7820' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MEMORIAL PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MEMORIAL PARKWAY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Pkwy Sec 02' ,`TaxAmount` = '4567' ,`TaxRate` = '2.3283' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669040287' WHERE `Matrix_Unique_ID` = '214530797' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T20:47:49.830' ,`MLSNumber` = '36640412' ,`ListAgentFullName` = 'Valerie Conchola-Cruz' ,`ListOfficeName` = 'AroundTown Properties Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.607396' ,`Longitude` = '-95.354796' ,`PhotoCount` = '37' ,`PostalCode` = '77048' ,`RoomCount` = '8' ,`ListPrice` = '259500.00' ,`Status` = 'Active' ,`StreetName` = 'Deerbriar Run' ,`StreetNumber` = '4107' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2268' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Highly desired 2 story home with an oversized backyard. NEVER FLOODED! You don\'t want to miss out on an opportunity to call this home yours. Open kitchen with island and breakfast bar. Tons of natural lighting. No back neighbors. Spacious secondary bedrooms. Large primary bedroom with garden tub and walk in closet. Enjoy entertaining? This home has tons of space to enjoy company including a massive covered patio, spacious living area and a game room that\'s ready to host game night. Easily accessible to Beltway 8, I-45 & 288.' ,`Acres` = '0.1423' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 1 AUTUMN GLEN SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LAW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Autumn Glen' ,`TaxAmount` = '6377' ,`TaxRate` = '2.9307' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040287' WHERE `Matrix_Unique_ID` = '214567713' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T19:53:37.120' ,`MLSNumber` = '7662471' ,`ListAgentFullName` = 'Kimberly Davila' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.881104' ,`Longitude` = '-94.832336' ,`PhotoCount` = '30' ,`PostalCode` = '77535' ,`RoomCount` = '3' ,`ListPrice` = '205000.00' ,`Status` = 'Active' ,`StreetName` = 'Danny' ,`StreetNumber` = '4805' ,`StreetSuffix` = 'Lane' ,`City` = 'Old River-Winfree' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1442' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 3 bedroom home in Woodland Acres is ready for your custom touch! Great investment potential or starter home on a oversized lot! Located in Barber\'s Hill ISD and minutes from Mont Belvieu shopping, restaurants, golf course, and parks!' ,`Acres` = '0.7' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '40 SEC 1 WOODLAND ACRES' ,`LotDesciption` = 'Corner' ,`LotSize` = '30492' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`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` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodland Acres' ,`TaxAmount` = '2523' ,`TaxRate` = '1.656' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040288' WHERE `Matrix_Unique_ID` = '214579408' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T19:36:29.720' ,`MLSNumber` = '49245116' ,`ListAgentFullName` = 'Linda Bovasso' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.795755' ,`Longitude` = '-95.478307' ,`PhotoCount` = '35' ,`PostalCode` = '77055' ,`RoomCount` = '8' ,`ListPrice` = '462000.00' ,`Status` = 'Active' ,`StreetName` = 'Woodvine' ,`StreetNumber` = '1420' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2698' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fabulous residence nestled behind a private gate in a secluded & serene community. Gorgeous New Orleans style light fixtures adorn the front & patio. Ideally located approx 8 miles from DT in highly desired SB. This exquisite 2 story 3BR 2.5 BATH is move-in ready with many of upgrades. Rich hardwood floors/tile downstairs, Anderson French doors, plantation shutters, custom BO drapes, gas fireplace. Kitchen showcases newly painted cabinets/new hardware, new Carrara quartz countertops, new undercounter sink/fixtures, GE Profile elite appliances include 6-burner stove/double oven. Additional improvements include interior paint, remote outdoor lighting, new flooring/tile in secondary bath. Spacious primary BR features tray ceilings w/recessed lighting, built-ins and leads to large primary bath w/Kohler designed remote jet tub & designer shower w/multiple water heads. Side garden surrounded by mature oaks is unique to this hm and perfect place for relaxing. Dual zone ACs replaced 2015/2022' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'TR 51B BLK 9 WHISPERING PINES ESTATES SEC 2' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '2223' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HOUSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodvine Place' ,`TaxAmount` = '9571' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040288' WHERE `Matrix_Unique_ID` = '214634740' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T19:31:32.250' ,`MLSNumber` = '56394413' ,`ListAgentFullName` = 'Marly Freeman' ,`ListOfficeName` = 'Freeman Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.480124' ,`Longitude` = '-94.941382' ,`PhotoCount` = '34' ,`PostalCode` = '77539' ,`RoomCount` = '3' ,`ListPrice` = '925000.00' ,`Status` = 'Active' ,`StreetName` = 'Edwards' ,`StreetNumber` = '1327' ,`StreetSuffix` = 'Drive' ,`City` = 'San Leon' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2880' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come make this Beautifully updated Miami style home with boat slip and oasis style pool yours today! This oversized master suite will have you feeling like your on vacation every day! \r\nYou have your pool in the backyard with an amazing view of Galveston Bay & your own boat house with lift on the other side on the canal. \r\nUpgrades include:\r\nAll new flooring \r\nCustom stair case\r\nCustom built cabinets \r\nQuartz countertops\r\nAll bathrooms fully remodeled\r\nFireplace was updated with new tile\r\nAll new kitchen appliances\r\nInterior all new baseboards, paint, lighting, doors and door hardware, exterior lights. Painted shutters, dock & porches.' ,`Acres` = '0.194' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 10 A EDWARDS SUR LOT 21 & 21A PT ADJ CANAL EDWARDS LAND' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '8451' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SAN LEON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Edwards Landing' ,`TaxAmount` = '9272' ,`TaxRate` = '2.521' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040288' WHERE `Matrix_Unique_ID` = '214695884' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T19:57:28.023' ,`MLSNumber` = '18884684' ,`ListAgentFullName` = 'Germaine Johnson' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.021722' ,`Longitude` = '-95.799944' ,`PhotoCount` = '22' ,`PostalCode` = '77447' ,`RoomCount` = '8' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Jumping Jay' ,`StreetNumber` = '24014' ,`StreetSuffix` = 'Lane' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1539' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Visionaries are discovering this growing community in Hockley, TX. This cozy home comes with 3 comfortable-sized bedrooms, 2 full baths, having ceiling fans throughout, a 2-car attached garage and is situated on the largest lot in the well-established neighborhood of Ranch Country! This home also offers a plethora of recent updates with a stunning new wood and glass chestnut door that looks very welcoming at the entry. The living area floor plan boasts a warm feel as it opens up to the wood burning fireplace...just perfect for the holidays! New flooring, fresh paint throughout, remodeled kitchen with adorable subway tile backsplash, stainless steel appliances, convenient in-house utility room, covered backyard porch, and more! No carpet anywhere, yes! Solar panels a plus! Enjoy access to the neighborhood clubhouse, swimming pool, and playground. Only minutes from 99 Grand Parkway and shopping.' ,`Acres` = '0.3372' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Electric,Solar Assisted' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 10 BLK 4 RANCH COUNTRY SEC' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14688' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ranch Country Sec 03' ,`TaxAmount` = '3849' ,`TaxRate` = '2.7956' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040288' WHERE `Matrix_Unique_ID` = '214756797' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T19:21:23.447' ,`MLSNumber` = '74979888' ,`ListAgentFullName` = 'Fafu Zeng' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.828840' ,`Longitude` = '-95.052692' ,`PhotoCount` = '20' ,`PostalCode` = '77562' ,`RoomCount` = '7' ,`ListPrice` = '165000.00' ,`Status` = 'Active' ,`StreetName` = 'Del Monte' ,`StreetNumber` = '111' ,`StreetSuffix` = 'Lane' ,`City` = 'Highlands' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1150' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful cozy house with 4 bedrooms and 1 full bath. Recently updated with new paint throughout both inside and outside. New central AC, new flooring, new bathroom, new lights/fans, new water heater, etc. Great layout and cozy feeling! Fully fenced and gated back yard for a RV parking! Great neighborhood. Schedule your show today as it won\'t last at this price!' ,`Acres` = '0.1826' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 113 BLK 6 HIGHLAND PARK SEC 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7952' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'HOPPER/HIGHLANDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,No Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Park Sec 02' ,`TaxAmount` = '1670' ,`TaxRate` = '2.575' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040289' WHERE `Matrix_Unique_ID` = '214797294' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T20:00:37.263' ,`MLSNumber` = '30041905' ,`ListAgentFullName` = 'Graciela Barrera' ,`ListOfficeName` = 'Engel & Volkers Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.522521' ,`Longitude` = '-95.187979' ,`PhotoCount` = '47' ,`PostalCode` = '77546' ,`RoomCount` = '16' ,`ListPrice` = '2200000.00' ,`Status` = 'Active' ,`StreetName` = 'Whispering Pines' ,`StreetNumber` = '260' ,`StreetSuffix` = '' ,`City` = 'Friendswood' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '5560' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing Mediterranean Home with too many updates to mention! Beautifully kept inside and out, recent new\r\npaint through out. This beauty sits on a little over 2 acres and completely fenced with a 6400 sq ft\r\nbarn/shed/workshop for your storage needs. Beautiful swimming pool with rock waterfall.\r\nGourmet Kitchen, walk in pantry, High Ceilings with panoramic windows through out the home, beautiful crown\r\nmolding, custom cabinets in family room, primary bedroom, dry bar area. Office is a masterpiece with wood\r\npaneling through out and custom cabinetry. This a much see home there is plenty of room for all to enjoy, a\r\nwonderful place for all your gatherings.' ,`Acres` = '2.3' ,`Area` = '33' ,`BuilderName` = 'Sterling Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 151 S MCKISSICK SUR PT OF LOT 5 (5-7) BLK 11 FRIENDSWOO' ,`LotDesciption` = 'Cleared' ,`LotSize` = '99316' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Gas 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` = 'Lockbox Back,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Friendswood Sub Lts 1 To 12' ,`TaxAmount` = '1784' ,`TaxRate` = '2.2832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040289' WHERE `Matrix_Unique_ID` = '214805532' --> 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','214809317','1669040289','214809317','2022-11-18T19:20:52.730','43709141','Jay Mac Sanders','Mustard Seed, Realtors','','','30.049745','-95.365833','32','77373','7','239500.00','Active','Chestergate','4539','Drive','Spring','2','0','4','1644','Single-Family','Location and Open Floor Plan. Covered Back Patio ready for family and friends. New vanities, Sinks and hardware. Finishing touches throughout. Convenient 1 story with ample storage throughout. Not in the 100 or 500 year flood plain! Mature trees in the Birnam Wood neighborhood. Come take a look.','0.1501','12','','','Electric Dryer Connections,Gas Dryer Connections','','Mud,Sellers Disclosure','1','Wood Burning Fireplace','1','Spring East','Central Gas','1','LT 15 BLK 1 BIRNAM WOOD SEC 4','Subdivision Lot','6540','Appraisal District','','350','0','','2','Gas Oven','0','','','Gas Range','','Composition','48 - Spring','MILDRED JENKINS ELEMENTARY SCHOOL','SPRING HIGH SCHOOL','DUEITT MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Ranch,Traditional','Birnam Wood Sec 04','3573','2.6068','Public Sewer,Public Water','1980','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214813014','1669040289','214813014','2022-11-18T19:58:13.263','91293777','Rocio Gutierrez','RE/MAX 5 Star Realty','','','29.686937','-95.107029','34','77536','9','349900.00','Active','Yellowstone','1621','Drive','Deer Park','2','0','3','1877','Single-Family','This beautifully maintained one story home is ready for a new owner! Exquisite 3 bed /2 bath home.\r\nLocated on a quiet street ,in the much sought after Deer Park with no HOA.\r\nThis home is centrally located to mayor business in the area and easy access to Hwy 225.\r\nAs soon as you walk in you will immediately feel right at home.\r\nThe living room area is very well complimented with a cozy gas log fireplace and a buit in entertainer center . Updated bathrooms are beautiful.\r\nCome and see this amazing house today!','0.1791','6','','','Electric Dryer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Deer Park','Central Gas','0','LT 5 BLK 11 PARK PLACE SEC 6 R/P','Subdivision Lot','7800','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','16 - Deer Park','DEER PARK ELEMENTARY SCHOOL','DEER PARK HIGH SCHOOL','DEER PARK JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Park Place Sec 06 R P','7517','2.8239','Public Sewer,Public Water','2003','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214901243','1669040289','214901243','2022-11-18T19:28:16.273','2632070','Vanessa Crain','Quest Real Estate','','','29.924809','-95.447832','17','77038','3','225000.00','Active','Wildbrook','1610','Drive','Houston','2','0','3','1492','Single-Family','Charming 3 Bedroom/ 2 baths home featuring New Granite in Kitchen, New Carpet, and New Interior Paint! The family room features high ceilings with lots of natural lighting! The backyard has plenty of space for all your family gatherings and cookouts! Also, enjoy the covered patio along with the mature trees providing even more shaded areas! This home won\'t last long, Make your appointment today!','0.1472','11','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Freestanding,Wood Burning Fireplace','1','Aldine Area','Central Gas','0','LT 1119 BLK 31 FALLBROOK SEC 3','Subdivision Lot','6412','Appraisal District','','','0','','2','Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','1 - Aldine','STEHLIK ELEMENTARY SCHOOL','DAVIS HIGH SCHOOL (ALDINE)','PLUMMER MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','2','Traditional','Fallbrook Sec 03','3872','2.4008','Public Sewer,Public Water','1983','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','214901378','1669040289','214901378','2022-11-18T19:15:18.700','74679288','Emily Pickens','Keller Williams Realty','','','31.450586','-96.056584','46','75831','8','224900.00','Active','Bridget','348','Avenue','Buffalo','2','0','3','1064','Single-Family','Buffalo, Tx - located halfway between Houston and Dallas - 3 bed/2 bath w/ bonus building. Two separate lots total to 3.55 acres. Great investment property in a quiet location just minutes from both Buffalo and Centerville. The interior has been thoroughly cleaned and has been repainted. The large covered front porch is great for relaxing or entertaining. A large add on adjacent to the front porch is perfect for storage, while the bonus building with a full kitchen has endless possibilities. The cleared upper lot is the perfect site for a forever home.','3.55','63','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','','Wood Burning Fireplace','1','Buffalo Area','Window Unit','0','JENNIFER LAND CO TRACT 28 and 29 3.55 AC AB 999 ROB','Cleared,Wooded','','Appraisal District','','','0','','0','','0','','','','','Aluminum','194 - Buffalo','BUFFALO ELEMENTARY SCHOOL','BUFFALO HIGH SCHOOL','BUFFALO JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Jennifer Land Co','1790','2.0777','Public Sewer,Public Water','1980','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T19:39:16.620' ,`MLSNumber` = '10989894' ,`ListAgentFullName` = 'Maurey Bell' ,`ListOfficeName` = 'Bell Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.087100' ,`Longitude` = '-96.202901' ,`PhotoCount` = '34' ,`PostalCode` = '77871' ,`RoomCount` = '5' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'FAIRWAY' ,`StreetNumber` = '122' ,`StreetSuffix` = '' ,`City` = 'Hilltop Lakes' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '43995' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A Golf lover\'s dream on the 17th Tee. All the golf you can play - no green fee - just two minutes from the clubhouse. Hilltop Lakes is an Amenity-rich Resort-like community. Sitting on 3 lots totaling 1.01 acres -This beautifully maintained 5 bedroom, 3 bathroom home boasts over 3,000 SqFt of living space. Downstairs offers 3 bedrooms, 2 bathrooms with an open concept floor plan, Large kitchen with stainless appliances with a bar that open to the dining and living areas. Upstairs is a flex space that would be the perfect mother-in-law suite or just extra room for the kids to spread out offering 2 beds, 1 bath, a large living, a kitchenette and a large game room! Updates include newer HVAC -July 2019, newer water heater in Oct 2018, Fresh flooring, paint, blinds, ceiling fans and countertops in 2017. Enjoy the many amenities at Hilltop Lakes such as their remarkable 18 hole golf course, private airport, lodging, camping, hunting, tennis, equestrian stables and more. Gorgeous Lakes!!!' ,`Acres` = '' ,`Area` = '63' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Normangee/Marquez Area' ,`HeatSystem` = 'Butane' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 19,20 & 21, Block 1' ,`LotDesciption` = 'Cleared,In Golf Course Community' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '126' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '131 - Normangee' ,`SchoolElementary` = 'NORMANGEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORMANGEE HIGH SCHOOL' ,`SchoolMiddle` = 'NORMANGEE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = '3295- Hilltop' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040289' WHERE `Matrix_Unique_ID` = '214916887' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T20:34:38.230' ,`MLSNumber` = '58853614' ,`ListAgentFullName` = 'Patricia Rivera' ,`ListOfficeName` = 'Cornerstone Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.163746' ,`Longitude` = '-95.634545' ,`PhotoCount` = '43' ,`PostalCode` = '77486' ,`RoomCount` = '11' ,`ListPrice` = '455000.00' ,`Status` = 'Active' ,`StreetName` = 'Amherst' ,`StreetNumber` = '423' ,`StreetSuffix` = 'Drive' ,`City` = 'West Columbia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully designed NEWLY CONSTRUCTED home in the Columbia Lakes Subdivision. This home features enhanced upgrades which include: Smart Home audio; farmhouse sinks w/custom faucets; pot filler above stove; custom front door; oversized windows; panoramic electric fireplace; free standing soaking tub; 11\' foot ceilings; stone exterior; 6\" wood baseboards; quartz countertops; and custom tile throughout. Other features include: LED recessed lights, open concept, split bedrooms, oversized custom master shower, self closing cabinets, SS appliances, and covered patio. Columbia Lakes Subdivision NEVER FLOODED. UNDER CONSTRUCTION. Estimated Completion date: JANUARY 2023. PICTURES ARE FROM BUILDERS STOCK AND ONLY FOR REFERENCE. SQUARE FEET IS APPROXIMATE. OPTIONAL UPGRADES AVAILABLE.' ,`Acres` = '0.2663' ,`Area` = '5' ,`BuilderName` = 'HomeStar Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'COLUMBIA LAKES SEC 3 (A0133 M VARNER), BLOCK 28, LOT 44' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '11600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '105' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Columbia Lakes Sec 1-2-3-4-5' ,`TaxAmount` = '391' ,`TaxRate` = '2.2487' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669040289' WHERE `Matrix_Unique_ID` = '214917946' --> 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','214935505','1669040290','214935505','2022-11-18T19:35:40.113','48485558','Will Puente','SavvyWay Realty, Inc.','','','29.747540','-94.826245','31','77523','5','470000.00','Active','Walker','10018','Street','Beach City','2','1','3','2124','Single-Family','Wake up to morning sun on your deck overlooking Trinity Bay. Barbers Hill ISD and low property tax rate. No HOA. Main house open n bright with 2bed 1 1/2bath. Comfy 1bed apartment over garage, great for in-law, grown-up kids or rent. Recent updates and paint. Main house has tiles down and carpet up. Apt has luxury vinyl floor. Stainless steel appliances. Refrigerators and flat screen TV convey. 3 car garage plus storage room and fenced in courtyard. A MUST SEE! Motivated seller. Bring all offers.','0.37','53','','','','','Sellers Disclosure','','','','Chambers County West','Central Electric','0','3 TR 41-15 S BARROW LT 7 BARTON CLARK S/D','Subdivision Lot','16117','Appraisal District','','','0','','3','','0','','','','','Composition','6 - Barbers Hill','BARBERS HILL SOUTH ELEMENTARY SCHOOL','BARBERS HILL HIGH SCHOOL','BARBERS HILL SOUTH MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Traditional','Barton Clark Sub','4362','1.656','Septic Tank,Well','1997','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','214938830','1669040290','214938830','2022-11-18T20:47:25.620','15405363','Julio Valenzuela','Intero Real Estate Services','','','30.310911','-95.123778','29','77328','9','249999.00','Active','County Road 381','1900','','Cleveland','2','0','3','1574','Single-Family','Beautiful newly remodel home!This home offers three bedrooms plus a bonus office/study room including two full baths, walk in closets and title throughout. You will love the open floor plan that the kitchen, dinning and family room share. Perfect for all of your of family gatherings. This property sits on a fully gated lot, extensive driveway plus a three car port including a shed/storage area. Perfectly situated within minutes from highways and shopping. The possibilities on for this property are endless! Schedule your private tour today!','0.898','52','','','Electric Dryer Connections','','Sellers Disclosure','','','1','Cleveland Area','Central Electric','0','000404 T J WILLIAMS, TRACT 171, ACRES 0.898','Subdivision Lot','39117','Appraisal District','','','0','','2','Electric Oven','0','','','','','Aluminum','100 - Cleveland','NORTHSIDE ELEMENTARY SCHOOL (CLEVELAND)','CLEVELAND HIGH SCHOOL','CLEVELAND MIDDLE SCHOOL','Appointment Required,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','T J Williams','3109','1.6917','Septic Tank','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','214940845','1669040290','214940845','2022-11-18T19:46:15.433','13603311','Penny Adams','Coldwell Banker Southern Homes','','','29.969632','-95.072397','13','77532','8','160000.00','Active','Stroker','908','Road','Crosby','2','0','4','1498','Single-Family','The house, which sits on 2 acres, is livable as is and includes downstairs kitchen, dining room, living room, two bedrooms, a full bath and a utility entry for laundry and storage. The upstairs has a single bedroom plus a second large bedroom with a full bath. The well and septic system are serviceable, but the conditions are unknown. The large upstairs bedroom could be used as a game room or media room. There is a water tower and storage tank that is no longer in use. The home is on a septic and water well system. House and two acres are to be purchased as is, no repairs will be made. Additional acreage may be purchased, if interested. Although some of the property is in a flood plain, the home did not flood during Harvey and Imelda.','2','1','','','Electric Dryer Connections,Washer Connections','','Estate,Sellers Disclosure','0','','','Crosby Area','Propane,Space Heater','0','PT TR 10 (HOMESITE) & PT TR 10 ABST 811 D D CULP ABST 810 T','Cleared','87120','Appraisal District','','','0','','1','Electric Oven,Freestanding Oven','0','','','Electric Range','','Composition','12 - Crosby','BARRETT ELEMENTARY SCHOOL','CROSBY HIGH SCHOOL','CROSBY MIDDLE SCHOOL (CROSBY)','Appointment Required,Leave Business Card,Lockbox Back,Vacant/Unoccupied','Appraisal District','2','Traditional','D D Culp ABST 810 T TOBY','2454','2.0943','Septic Tank,Well','1940','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','214953677','1669040290','214953677','2022-11-18T20:01:00.663','85038553','Darnell Fuller','eXp Realty, LLC','','','29.570340','-95.745778','20','77469','8','325000.00','Active','Long Canyon','127','Lane','Richmond','2','0','4','2320','Single-Family','The search is over! This Lovely 4 bedroom 2 bath awaits you! Formal dining room features crown molding, chair railing, picture trim & manufactured wood flooring! The large open family room that open up to kitchen is perfect for entertaining! Whip up meals in the gorgeous island kitchen boasting tile flooring, a walk-in pantry, warm wood cabinets, granite countertops & a serving bar! Spacious master suite w/master bath showcasing a walk-in closet, double sinks, tile & a garden tub with a separate shower! 3 secondary bedrooms! Utility room in the house. Relax outside on the open back patio! Enjoy Low taxes and Easy access to 59 and Grand Parkway. Call today!','0.1752','30','DAvid Weekly','','','','Sellers Disclosure','1','','','Fort Bend South/Richmond','Central Electric,Central Gas','1','FOUNTAINS AT JANE LONG FARMS SEC 1, BLOCK 1, LOT 20','Subdivision Lot','7630','Appraisal District','','350','0','','2','','0','','','Electric Range','','Composition','33 - Lamar Consolidated','PHELAN ELEMENTARY SCHOOL','LAMAR CONSOLIDATED HIGH SCHOOL','WESSENDORF/LAMAR JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Fountains At Jane Long Farms Sec 1','6219','2.3748','Public Sewer,Public Water','2013','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','214954544','1669040290','214954544','2022-11-18T19:30:11.087','87007423','Rachel Jones','RE/MAX Metro','','','29.855853','-95.608560','31','77041','8','275000.00','Active','Malcomboro','5803','Drive','Houston','2','0','3','1855','Single-Family','New roof, new AC, new flooring, fresh paint, EXCELLENT schools, NO FLOODING! Nestled in the Concord Bridge subdivision, this updated, open floorplan offers two living areas, open, updated kitchen, new windows, gorgeous backyard space, perfect for entertaining with a brand new deck in back.','0.1756','8','','','','','Sellers Disclosure','1','','1','Eldridge North','Central Gas','1','LT 10 BLK 4 CONCORD BRIDGE SEC 7','Subdivision Lot','7650','Appraisal District','','370','0','','2','','0','','','','','Composition','13 - Cypress-Fairbanks','LEE ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','CYPRESS RIDGE HIGH SCHOOL','TRUITT MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Concord Bridge Sec 07','5662','2.471','Public Sewer,Public Water','1990','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','214958196','1669040290','214958196','2022-11-18T19:47:42.183','55038565','Brent Forster','Texas United Realty','','','29.809742','-95.280848','22','77028','8','309900.00','Active','Eastland','5330','Street','Houston','2','0','3','1790','Single-Family','This is a must see completely remodeled 3 bed 2 bath home. Everything on the inside is brand new!! Excellent location!!','0.1148','2','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','0','Northeast Houston','Central Gas','0','LT 57 BLK 35 HOLLEMAN','Subdivision Lot','5000','Appraisal District','','','0','','0','Gas Oven','0','','','Gas Cooktop','','Composition','27 - Houston','ELMORE ELEMENTARY SCHOOL','KASHMERE HIGH SCHOOL','KEY MIDDLE SCHOOL','Appointment Required,Supra Keybox','Seller','1','Traditional','Holleman','1851','2.3307','Public Sewer,Public Water','1960','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','214958246','1669040290','214958246','2022-11-18T19:13:32.620','48583020','Lacy Glaspie','Mainstream Realty','','','29.763830','-94.991131','14','77521','3','247000.00','Active','Canadian Goose','2815','Lane','Baytown','2','0','3','1507','Single-Family','Three bedroom, 2-bathroom starter home with potential. Home features, open living area, covered patio and large backyard. Close to Spur 330, schools, shopping, hospital, park, and restaurants. Sold As Is.','0.188','2','','','','','Special Addendum','','','','Baytown/Harris County','Central Gas','1','LT 4 BLK 1 GOOSE CREEK RESERVE SEC 1B','Subdivision Lot','8188','Appraisal District','','800','0','','2','','0','','','','','Composition','23 - Goose Creek Consolidated','TRAVIS ELEMENTARY SCHOOL (GOOSE CREEK)','LEE HIGH SCHOOL (GOOSE CREEK)','BAYTOWN JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','Goose Crk Reserve','7882','3.63','Public Sewer,Public Water','2017','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','214959633','1669040290','214959633','2022-11-18T20:33:17.987','18277124','Lunguang Wat','RealtyOne Plus, LLC','','','29.496589','-95.776054','30','77469','8','329000.00','Active','Snowbell','6514','Court','Richmond','2','1','5','2703','Single-Family','Come view this gorgeous freshly updated/upgraded 5-bedroom home built in 2015! Situated in large corner lot of cul-de-sac, great floor plan, kitchen open to large family room, primary suite downstairs and game room upstairs! Fresh paint throughout, new floor of hardwood looking vinyl plank in family/dining, new carpet & cushion in bedrooms, new chandelier and vanity lights, new ceiling fan, new mirror frames in bathrooms! Kitchen features granite counter tops, breakfast bar and over-the-range microwave! Primary suite w/ large walk-in close, his & her sinks, separate shower and garden tub! Guest bathroom upstairs w/ vanity area and double sinks! Brazos Town Center and Sugar Land Town Center are nearby, very convenient to shop and commute! Low tax rate and HOA fee!','0.1764','30','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Fort Bend South/Richmond','Central Electric','1','SUNRISE MEADOW SEC 6, BLOCK 1, LOT 6','Corner,Cul-De-Sac,Subdivision Lot','7682','Appraisal District','','330','0','','2','Electric Oven','0','','','Electric Range','','Composition','33 - Lamar Consolidated','MEYER ELEMENTARY SCHOOL (LAMAR)','RANDLE HIGH SCHOOL','WRIGHT JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox,Vacant/Unoccupied','Appraisal','2','Traditional','Sunrise Meadow','8521','2.8148','Water District','2015','Appraisal District'); --> New record created successfully