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-21T19:55:48.797' ,`MLSNumber` = '73210576' ,`ListAgentFullName` = 'Arleen Murillo' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.734320' ,`Longitude` = '-95.315546' ,`PhotoCount` = '6' ,`PostalCode` = '77023' ,`RoomCount` = '3' ,`ListPrice` = '799900.00' ,`Status` = 'Active' ,`StreetName` = 'Hughes' ,`StreetNumber` = '610' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1315' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location, Location, Location, Home is selling for Lot Value Only. Tenant Occupied please do not disturb tenants.\r\nInvestor Special, no restrictions. Builder\'s Dream with Lots of Opportunity to Build. Call today!' ,`Acres` = '0.514' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 12 & 13 LUNNON' ,`LotDesciption` = 'Cleared' ,`LotSize` = '22391' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CARRILLO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lunnon' ,`TaxAmount` = '6315' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669640966' WHERE `Matrix_Unique_ID` = '205434079' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T19:41:43.673' ,`MLSNumber` = '18109568' ,`ListAgentFullName` = 'Rocio Guajardo' ,`ListOfficeName` = 'RE/MAX 5 Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.079816' ,`Longitude` = '-95.031144' ,`PhotoCount` = '30' ,`PostalCode` = '77535' ,`RoomCount` = '5' ,`ListPrice` = '332000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 6242' ,`StreetNumber` = '265' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1840' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your dream new built Home sitting on 1 ACRE!\r\nCustom Kitchen cabinets, massive custom built kitchen island with beautiful granite, huge master bathroom with separate shower and tub, large size closets, luxury vinyl floors, brick on all 4 sides of the house, rain gutters... just to mention a few of the many great features this lovely Home has to offer.\r\nYou don\'t want to miss this one out. Call today to schedule a viewing and make this house your new Home!' ,`Acres` = '1' ,`Area` = '52' ,`BuilderName` = 'Private Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '000764 A G PENN #1006, TRACT 40, ACRES 3.46' ,`LotDesciption` = 'Cleared,Other' ,`LotSize` = '43560' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition,Wood Shingle' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (DAYTON)' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'A G Penn' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669640966' WHERE `Matrix_Unique_ID` = '207593330' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T20:01:45.463' ,`MLSNumber` = '70600293' ,`ListAgentFullName` = 'Will Puente' ,`ListOfficeName` = 'SavvyWay Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.556956' ,`Longitude` = '-95.534869' ,`PhotoCount` = '37' ,`PostalCode` = '77459' ,`RoomCount` = '9' ,`ListPrice` = '529999.00' ,`Status` = 'Active' ,`StreetName` = 'Flamingo Landing' ,`StreetNumber` = '7' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3820' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Showpiece home on waterfront site in gated, exclusive Flamingo Island. Enjoy water views from both floors on covered patio or private Master Suite balcony upstairs. Luxury amenities throughout: stone surround fireplace, wood flooring, granite throughout, built-ins throughout. Three bedrooms up with 4th bedroom down. Beautiful and HUGE walk in master bedroom closet-must see - gorgeous!' ,`Acres` = '0.1826' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'FLAMINGO ISLAND AT LAKE OLYMPIA, BLOCK 1, LOT 110, R/P' ,`LotDesciption` = 'Cul-De-Sac,Waterfront' ,`LotSize` = '7955' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PALMER ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Flamingo Island At Lake Olympia Sec 1' ,`TaxAmount` = '13732' ,`TaxRate` = '2.81' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669640966' WHERE `Matrix_Unique_ID` = '208547999' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T19:55:29.577' ,`MLSNumber` = '87486325' ,`ListAgentFullName` = 'Arleen Murillo' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.731595' ,`Longitude` = '-95.326515' ,`PhotoCount` = '25' ,`PostalCode` = '77023' ,`RoomCount` = '10' ,`ListPrice` = '374900.00' ,`Status` = 'Active' ,`StreetName` = 'Lindsay' ,`StreetNumber` = '5019' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1324' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location, Location, Location.. This 1926 3/1 Bungalow w/ 2 bed/1bath Gar apt located in the Heart of The East End Revitalized Area has it all. With much of it\'s original hardware throughout gives this home the Old Characteristics of East End Bungalows that it\'s known for. \r\nEnclosed porch great for enjoying your morning cup of coffee before starting your day. Recently laid engineered wood flooring & newly painted throughout. Also recently installed state of the art irrigation system under the house. \r\nYou will be pleasantly surprised on the layout of this spacious living room & roomy 2 bedroom & 1 bathroom Garage Apt. Although it has a window unit, the apt is very energy efficient. This can be used as an office or an income bearing unit. Although Gar Apt doesn\'t have a kitchen, a mini one can easily be added in. \r\nHome is centrally located with easy access to I-45/I-59/610/I-10/I-225, mins from Downtown, UH, Medical Center, The Rail, The Metro even down the st from the Amazon Ctr.' ,`Acres` = '0.1148' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 18 BLK 19 EASTLAWN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CAGE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Eastlawn' ,`TaxAmount` = '5822' ,`TaxRate` = '2.5494' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1925' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669640966' WHERE `Matrix_Unique_ID` = '209076777' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T19:58:33.030' ,`MLSNumber` = '23492630' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.223743' ,`Longitude` = '-95.703468' ,`PhotoCount` = '21' ,`PostalCode` = '77354' ,`RoomCount` = '9' ,`ListPrice` = '365296.00' ,`Status` = 'Active' ,`StreetName` = 'Goldeneye' ,`StreetNumber` = '40564' ,`StreetSuffix` = 'Place' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1931' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Epsom floorplan with 3 Bedroom, 2 Bath, with attached 2 car garage. This floor plan boasts High Ceilings and a spacious OPEN CONCEPT FLOOR PLAN with the Family Room, Kitchen, Breakfast Room, Dining room, Study/Flex Room, and 3 spacious bedrooms. Tile and Carpet throughout. You will love the Kitchen with lots of cabinets and granite countertops with under the cabinet lighting, SS appliances, and even a USB outlet. Fenced Backyard & Covered Patio. Blinds Throughout. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Programmable Thermostat, Pex Hot & Cold Water Lines, Radiant Barrier, Rheem® Tankless Gas Water Heater, and Vinyl Double Pane Low E Windows that open to the inside of the home for Cleaning. Located in Magnolia, TX the new master-planned community Audubon will be conveniently on both sides of FM-1488 near Mill Creek Road, just along the TX-249 Toll Road. Magnolia ISD. Do not wait! Call now for your private tour.' ,`Acres` = '0.1377' ,`Area` = '15' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S221291 - AUDUBON CREEKSIDE NORTH 03B, BLOCK 1, LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Audubon' ,`TaxAmount` = '539' ,`TaxRate` = '3.3087' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669640967' WHERE `Matrix_Unique_ID` = '210359778' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T20:14:55.847' ,`MLSNumber` = '2687309' ,`ListAgentFullName` = 'Ceasar Moreno' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.522630' ,`Longitude` = '-95.445699' ,`PhotoCount` = '50' ,`PostalCode` = '77545' ,`RoomCount` = '4' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Teakwood' ,`StreetNumber` = '522' ,`StreetSuffix` = 'Avenue' ,`City` = 'Fresno' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2149' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning one-story home features 4 bedrooms, 2 full baths, and a Island Kitchen. The home is gated and contains a beautiful spacious front and back yard. Features that make the home extremely unique is the modern spacious country kitchen with quartz counters, high ceilings/door entrance foyer, laminate/tile flooring, crown molding, formal dining, and a spacious garages. NO RESTRICTIONS!' ,`Acres` = '0.2202' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'RIDGEWOOD ESTATES, BLOCK 13, LOT 6' ,`LotDesciption` = 'Other' ,`LotSize` = '9592' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Ridgewood Estates' ,`TaxAmount` = '7087' ,`TaxRate` = '2.7629' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1669640967' WHERE `Matrix_Unique_ID` = '210453562' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T19:47:06.507' ,`MLSNumber` = '9712688' ,`ListAgentFullName` = 'Hoora Zaid' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.118618' ,`Longitude` = '-95.537959' ,`PhotoCount` = '20' ,`PostalCode` = '77389' ,`RoomCount` = '11' ,`ListPrice` = '1575000.00' ,`Status` = 'Active' ,`StreetName` = 'Trull Brook' ,`StreetNumber` = '24739' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '5349' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous 5 Bedroom 5/2 bath and 3 car garage home is located in the gated community of Retreat at Augusta Pines.This home features an open floor plan with modern finishes and designer details in every corner!! Spacious living room with two story ceiling, 2 bedrooms down, study, gym and formal dining. 3 secondary bedrooms, loft and a media room upstairs. Family room has a gas log fireplace, modern cabinetry in kitchen with soft closing drawers, pots & pans drawers, stainless steel appliances including the refrigerator. Walk-in pantry and a Secondary Kitchen loaded with appliances for easy entertainment. Enjoy large covered porch for outside entertainment and a huge backyard with plenty of room for a pool. Quick access to HWY 99, Exxon Mobil Campus, minutes from The Woodlands, and close to the best shopping, dining, and entertainment! Zoned to the renowned Klein ISD.' ,`Acres` = '0.315' ,`Area` = '14' ,`BuilderName` = 'JD Alan Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 1 RETREAT AT AUGUSTA PINES' ,`LotDesciption` = 'Corner,In Golf Course Community,Water View' ,`LotSize` = '13450' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'FRENCH ELEMENTARY SCHOOL (KLEIN)' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HOFIUS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Controlled Access' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Retreat/Augusta Pines' ,`TaxAmount` = '3905' ,`TaxRate` = '3.065' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669640967' WHERE `Matrix_Unique_ID` = '210528393' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T19:46:16.450' ,`MLSNumber` = '10591008' ,`ListAgentFullName` = 'Hoora Zaid' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.119536' ,`Longitude` = '-95.535934' ,`PhotoCount` = '23' ,`PostalCode` = '77389' ,`RoomCount` = '11' ,`ListPrice` = '1685000.00' ,`Status` = 'Active' ,`StreetName` = 'Pacific Dunes' ,`StreetNumber` = '24814' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '5349' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location, location, location!! Ideal for enjoying the arts and culture, parks, trails, fine dining, shopping, and award-winning schools. Enjoy Augusta Pines Golf Club with a wonderful golf course and amenities. Close to fine dining, shopping, and entertainment. Environment for living gold certified, energy-efficient LED light fixtures, Trane 16 SEER HVAC w/programmable thermostat, radiant barrier roof deck, 1/2/10 year warranty included. Klein ISD, Community pool, tennis courts, and gym.' ,`Acres` = '0.3328' ,`Area` = '14' ,`BuilderName` = 'JDAllen' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 1 RETREAT AT AUGUSTA PINES' ,`LotDesciption` = 'In Golf Course Community,On Golf Course,Subdivision Lot' ,`LotSize` = '14496' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'FRENCH ELEMENTARY SCHOOL (KLEIN)' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HOFIUS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Controlled Access' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Retreat/Augusta Pines' ,`TaxAmount` = '5022' ,`TaxRate` = '3.065' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669640967' WHERE `Matrix_Unique_ID` = '210533845' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T20:12:28.820' ,`MLSNumber` = '7136897' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.223270' ,`Longitude` = '-95.702388' ,`PhotoCount` = '6' ,`PostalCode` = '77354' ,`RoomCount` = '7' ,`ListPrice` = '336448.00' ,`Status` = 'Active' ,`StreetName` = 'Berylline' ,`StreetNumber` = '40531' ,`StreetSuffix` = 'Lane' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2066' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2 Story Addington Floor Plan with 4 Bedrooms, 2 ½ Baths, with attached 2 car Garage. This home boasts a SPACIOUS OPEN CONCEPT FLOOR PLAN with the Family Room, Kitchen, Breakfast Room, Half Bath, Utility Room, and Owner’s Retreat downstairs. Upstairs you will find a Flex Space with Tech Center, 3 Bedrooms with walk in closets, and another Full Bath. The Kitchen has lots of cabinets, granite countertops with under the cabinet lighting, stainless steel appliances, and even a USB outlet. COVERED PATIO, SPRINKLER SYSTEM, and fenced backyard. COST AND ENERGY EFFICIENT FEATURES: 16 Seer HVAC System, Honeywell Programmable Thermostat, Pex Hot and cold Water Lines, Radiant Barrier, Rheem® Tankless Gas Water Heater, and Vinyl Double Pane Low E Windows that open to the inside of the home for easy cleaning. Located in Magnolia, TX the new master-planned community Audubon will be conveniently located on both sides of FM-1488 near Mill Creek Road, just along the TX-249 Toll Road.' ,`Acres` = '0.1056' ,`Area` = '15' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S221202 - AUDUBON CREEKSIDE NORTH 02A, BLOCK 4, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Audubon' ,`TaxAmount` = '539' ,`TaxRate` = '3.3087' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669640968' WHERE `Matrix_Unique_ID` = '210589319' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T20:14:08.533' ,`MLSNumber` = '66187294' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.225686' ,`Longitude` = '-95.701963' ,`PhotoCount` = '6' ,`PostalCode` = '77354' ,`RoomCount` = '7' ,`ListPrice` = '339445.00' ,`Status` = 'Active' ,`StreetName` = 'Bay Warbler' ,`StreetNumber` = '40346' ,`StreetSuffix` = 'Way' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2066' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2 Story Addington Floor Plan with 4 Bedrooms, 2 ½ Baths, with attached 2 car Garage. This home boasts a SPACIOUS OPEN CONCEPT FLOOR PLAN with the Family Room, Kitchen, Breakfast Room, Half Bath, Utility Room, and Owner’s Retreat downstairs. Upstairs you will find a Flex Space with Tech Center, 3 Bedrooms with walk in closets, and another Full Bath. The Kitchen has lots of cabinets, granite countertops with under the cabinet lighting, stainless steel appliances, and even a USB outlet. COVERED PATIO, SPRINKLER SYSTEM, and fenced backyard. COST AND ENERGY EFFICIENT FEATURES: 16 Seer HVAC System, Honeywell Programmable Thermostat, Pex Hot and cold Water Lines, Radiant Barrier, Rheem® Tankless Gas Water Heater, and Vinyl Double Pane Low E Windows that open to the inside of the home for easy cleaning. Located in Magnolia, TX the new master-planned community Audubon will be conveniently located on both sides of FM-1488 near Mill Creek Road, just along the TX-249 Toll Road.' ,`Acres` = '0.1056' ,`Area` = '15' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S221202 - AUDUBON CREEKSIDE NORTH 02A, BLOCK 4, LOT 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Audubon' ,`TaxAmount` = '539' ,`TaxRate` = '3.3087' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669640968' WHERE `Matrix_Unique_ID` = '210589447' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T19:35:24.810' ,`MLSNumber` = '16473620' ,`ListAgentFullName` = 'Jessica LaForce' ,`ListOfficeName` = 'Tricia Turner Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.540014' ,`Longitude` = '-95.800851' ,`PhotoCount` = '23' ,`PostalCode` = '77471' ,`RoomCount` = '10' ,`ListPrice` = '420000.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar' ,`StreetNumber` = '2634' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2133' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Recently updated... New Roof, Pex Plumbing, Air Conditioning, Garage Doors, and Appliances! 4 bedrooms 2 bathroom home situated on approximately half an acre corner lot. Located in the well-established Piney Post Subdivision of Rosenberg. Easy access to I-69 for Daily/Shopping needs entertainment and dining. Check out the virtual walkthrough and schedule your private showing today!' ,`Acres` = '0.495' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PINEY POST S/D, LOT 41' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '21563' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MEYER ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'TERRY HIGH SCHOOL' ,`SchoolMiddle` = 'NAVARRO/GEORGE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Piney Post S/D' ,`TaxAmount` = '3764' ,`TaxRate` = '2.0748' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669640968' WHERE `Matrix_Unique_ID` = '210742330' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T19:49:10.570' ,`MLSNumber` = '83552267' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.226283' ,`Longitude` = '-95.703767' ,`PhotoCount` = '6' ,`PostalCode` = '77354' ,`RoomCount` = '10' ,`ListPrice` = '433522.00' ,`Status` = 'Active' ,`StreetName` = 'Heron Heights' ,`StreetNumber` = '15134' ,`StreetSuffix` = 'Way' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2455' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2 Story, The Sandown Floor Plan with 4 Bedrooms, 3 ½ Baths, with a 2 CAR GARAGE. This floor plan boasts a SPACIOUS OPEN CONCEPT FLOOR PLAN with the Family Room, Kitchen, Breakfast Room, Dining Room, Half Bath, and the Master Bedroom & Bath downstairs. Upstairs you will find a Game Room, 3 Bedrooms, and 2 Full Bath. You will love the Kitchen with lots of cabinets and granite countertops with under the cabinet lighting, SS appliances, and even a USB outlet. Window blinds throughout. SPRINKLER SYSTEM and fenced backyard. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Thermostat, Pex Hot and cold Water Lines, Radiant Barrier, Rheem® Tankless Gas Water Heater, and Vinyl Double Pane Low E Windows that open to the inside of the home for Cleaning. Located in Magnolia, TX the new master-planned community Audubon will be conveniently on both sides of FM-1488 near Mill Creek Road, just along the TX-249 Toll Road. Magnolia ISD.' ,`Acres` = '0.1783' ,`Area` = '15' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S221203 - AUDUBON CREEKSIDE NORTH 03A, BLOCK 1, LOT 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7765' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Audubon' ,`TaxAmount` = '539' ,`TaxRate` = '3.3087' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669640968' WHERE `Matrix_Unique_ID` = '211230495' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T20:07:40.713' ,`MLSNumber` = '83039095' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.225898' ,`Longitude` = '-95.702700' ,`PhotoCount` = '6' ,`PostalCode` = '77354' ,`RoomCount` = '7' ,`ListPrice` = '347602.00' ,`Status` = 'Active' ,`StreetName` = 'Bay Warbler' ,`StreetNumber` = '40403' ,`StreetSuffix` = 'Way' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2066' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2 Story Addington Floor Plan with 4 Bedrooms, 2 ½ Baths, with attached 2 car Garage. This home boasts a SPACIOUS OPEN CONCEPT FLOOR PLAN with the Family Room, Kitchen, Breakfast Room, Half Bath, Utility Room, and Owner’s Retreat downstairs. Upstairs you will find a Flex Space with Tech Center, 3 Bedrooms with walk in closets, and another Full Bath. The Kitchen has lots of cabinets, quartz countertops with under the cabinet lighting, stainless steel appliances, and even a USB outlet. COVERED PATIO, SPRINKLER SYSTEM, and fenced backyard. COST AND ENERGY EFFICIENT FEATURES: 16 Seer HVAC System, Honeywell Programmable Thermostat, Pex Hot and cold Water Lines, Radiant Barrier, Rheem® Tankless Gas Water Heater, and Vinyl Double Pane Low E Windows that open to the inside of the home for easy cleaning. Located in Magnolia, TX the new master-planned community Audubon will be conveniently located on both sides of FM-1488 near Mill Creek Road, just along the TX-249 Toll Road.' ,`Acres` = '0.1056' ,`Area` = '15' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S221202 - AUDUBON CREEKSIDE NORTH 02A, BLOCK 2, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4601' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Audubon' ,`TaxAmount` = '539' ,`TaxRate` = '3.3087' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669640968' WHERE `Matrix_Unique_ID` = '211734114' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T19:50:32.950' ,`MLSNumber` = '77819980' ,`ListAgentFullName` = 'Laura Ruple' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.972689' ,`Longitude` = '-95.391358' ,`PhotoCount` = '46' ,`PostalCode` = '77073' ,`RoomCount` = '7' ,`ListPrice` = '340000.00' ,`Status` = 'Active' ,`StreetName` = 'Stock' ,`StreetNumber` = '19010' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2969' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2-story home with charming brick & stone elevation & lush landscaping that creates beautiful curb appeal! Built in 2020, this like-new home includes over 45K in builder upgrades & can include appliances upon request. Step inside High ceilings, arched doorways, recessed lighting, tiled flooring throughout the first floor & an open concept floorplan. Prepare meals in the kitchen adorned with granite countertops, black & stainless steel appliances, a center island with breakfast bar, breakfast area and formal dining room. Entertaining will be breeze, with the spacious living room, game room & media room! Entire downstairs and garage are equipped with speakers or wiring for sound throughout. The primary suite is the perfect setting for relaxation, split from the guest bedrooms & graced with a large shower with dual shower heads. Easy access to major freeways & close proximity to the airport & tons of shopping & dining amenities. Schedule your showing today!' ,`Acres` = '0.1096' ,`Area` = '12' ,`BuilderName` = 'Longlake' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 1 REMINGTON CREEK RANCH SEC 5' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '4775' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '401' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'PARKER ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'DAVIS HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'TEAGUE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Remington Creek Ranch' ,`TaxAmount` = '7867' ,`TaxRate` = '2.8445' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669640969' WHERE `Matrix_Unique_ID` = '212062825' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T20:25:44.867' ,`MLSNumber` = '23055077' ,`ListAgentFullName` = 'Teniqual Tolbert' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = 'Teniqual Tolbert' ,`SellingOfficeName` = 'HomeSmart' ,`Latitude` = '29.926365' ,`Longitude` = '-95.243970' ,`PhotoCount` = '12' ,`PostalCode` = '77396' ,`RoomCount` = '4' ,`ListPrice` = '499900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Emma Springs' ,`StreetNumber` = '14511' ,`StreetSuffix` = 'Court' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3135' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Seller is offering the 3/2/1 buy down interest rate points on This gorgeous Westin Home. It is located in the beautiful Fall Creek Community. This ready to move in property has upgraded fixtures, custom electric blinds, home surveillance and much more.' ,`Acres` = '0.1569' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fall Creek Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 2 FALL CREEK SEC 44' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6833' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'AUTUMN CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fall Crk Sec 44' ,`TaxAmount` = '10724' ,`TaxRate` = '3.0673' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669640969' WHERE `Matrix_Unique_ID` = '212218258' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T20:38:39.837' ,`MLSNumber` = '37360126' ,`ListAgentFullName` = 'Christa Lay' ,`ListOfficeName` = 'Vylla Home' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.123822' ,`Longitude` = '-95.807377' ,`PhotoCount` = '50' ,`PostalCode` = '77447' ,`RoomCount` = '8' ,`ListPrice` = '699000.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Ridge' ,`StreetNumber` = '24807' ,`StreetSuffix` = 'Road' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Motivated seller! Beautiful 2.31 Acre Lot with Custom Home and a Huge Shop located in Hockley! This home features Ceramic TILE flooring, oversized kitchen open to the living room, and a large primary bedroom with en suite bathroom. Great size for all secondary bedrooms and have custom build in cabinets in the closets! Peaceful covered patio that is perfect for grilling or lounging, while enjoying a scenic country atmosphere. Spacious shop with studio apartment/office. property fully fenced and gated!' ,`Acres` = '2.31' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'S433100 CLEAR CREEK FOREST 1 LOT 4 ACRES 2.31' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '100624' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '6' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'EVELYN TURLINGTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Clear Creek Forest' ,`TaxAmount` = '6699' ,`TaxRate` = '2.0243' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669640969' WHERE `Matrix_Unique_ID` = '212236812' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T19:45:18.700' ,`MLSNumber` = '55998825' ,`ListAgentFullName` = 'Tina Murphy' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.213895' ,`Longitude` = '-95.590530' ,`PhotoCount` = '34' ,`PostalCode` = '77354' ,`RoomCount` = '5' ,`ListPrice` = '369900.00' ,`Status` = 'Active' ,`StreetName` = 'Cimarron Canyon' ,`StreetNumber` = '10088' ,`StreetSuffix` = 'Lane' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2487' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'STOP THE CAR! You will be glad you did. 3 BR W STUDY.Lovely 1 story KB home will not disappoint. Split floor plan. Washer dryer and 2 fridges INCLUDED! Primary retreat in the back of the home. Foyer has high ceilings w wide hall leading to back of home.Easy to maintain LVP flooring in main areas.Granite countertops in kitchen with large eat at bar for 6 and 42\" black cabinets, SS appliances. You\'ll love the lighting from Fredricksburg,TX. Primary bath boast dual granite vanities, toilet closet, separate shower/tub. Closet has plenty of Space w custom shelving. Formal dinning large enough to seat 12!(drumset not included- has been moved out) Office delights with double doors for privacy,cat 5 cable.Could be 4th bdrm.250sqft covered back porch has cat 5 cable and gas connection for grill.Close to The Woodlands shops,medical & entertainment.Fishing pond has bass, trails & community has nice pool. WELCOME HOME' ,`Acres` = '0.1683' ,`Area` = '15' ,`BuilderName` = 'KB HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S341103 - CIMARRON CREEK 03, BLOCK 2, LOT 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7330' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '965' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'BEAR BRANCH ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cimarron Creek 03' ,`TaxAmount` = '8144' ,`TaxRate` = '3.1887' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669640969' WHERE `Matrix_Unique_ID` = '212278272' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T19:55:03.417' ,`MLSNumber` = '27078289' ,`ListAgentFullName` = 'Thurayah McBride' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.956064' ,`Longitude` = '-95.469793' ,`PhotoCount` = '19' ,`PostalCode` = '77067' ,`RoomCount` = '5' ,`ListPrice` = '220000.00' ,`Status` = 'Active' ,`StreetName` = 'Ironstone' ,`StreetNumber` = '11815' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2090' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is a rear find in this market. The home features 4 nice size bedrooms and optional 5th room attached to one of the bedrooms which can be used as a 5th bedroom, Office space, or media room. The owners took good care of this property. The home features a a new roof, fence and covered patio area. The kitchen was updated with beautiful backsplash and granite counter tops. The dinning room and living area flows together. Creating the perfect space to have gatherings. The home has water softener put in as well as new paint and flooring in some areas. A new roof was added in September. This home is a must see!' ,`Acres` = '0.1446' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 65 BLK 2 CAMDEN PARK SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '6300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'JOAN LINK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'STELLE CLAUGHTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Camden Park Sec 01' ,`TaxAmount` = '4905' ,`TaxRate` = '2.7467' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1669640970' WHERE `Matrix_Unique_ID` = '212325053' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T20:34:10.900' ,`MLSNumber` = '15309127' ,`ListAgentFullName` = 'Evelyn Kahlden' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.181553' ,`Longitude` = '-95.424593' ,`PhotoCount` = '31' ,`PostalCode` = '77515' ,`RoomCount` = '6' ,`ListPrice` = '245000.00' ,`Status` = 'Active' ,`StreetName` = 'Newman' ,`StreetNumber` = '709' ,`StreetSuffix` = 'Street' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1605' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious 3/2 on beautiful large lot with mature trees. Interior offers new carpet and custom paint, walk in closet in 2 bedrooms, primary bed is large enough for big furniture, gas fireplace in living room, utility room attached to kitchen. Recent plumbing, windows, HVAC. The exterior offers covered back patio, generous sized fenced backyard, 20x21 workshop/hobby room connected to garage, front porch. Foundation with life time warranty October 2022. Conveniently located to shopping, I-35, and schools.' ,`Acres` = '0.3098' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'NORTHRIDGE 2 (ANGLETON) BLK 1 LOT 23' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13495' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'NORTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Northridge 2 Angleton' ,`TaxAmount` = '5062' ,`TaxRate` = '2.6102' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669640970' WHERE `Matrix_Unique_ID` = '212484601' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T19:08:22.220' ,`MLSNumber` = '87912637' ,`ListAgentFullName` = 'Brandon Dunbar' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = 'Daynier Sanchez' ,`SellingOfficeName` = 'Keller Williams Signature' ,`Latitude` = '29.887828' ,`Longitude` = '-95.606979' ,`PhotoCount` = '30' ,`PostalCode` = '77041' ,`RoomCount` = '8' ,`ListPrice` = '208000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Fountaincrest' ,`StreetNumber` = '7510' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS ONE-OF-A-KIND PATIO HOME IS A MUST-SEE!! This 2-3/2 home is nestled into the prestigious Chimney Hill subdivision. The home has high ceilings and a large living room area that you and your family could enjoy. The home has a unique upstairs bedroom/home office/game room adding more living space and possibilities! Super easy access to HWY 290. The furniture seen in the home is all negotiable with the sale of the home. A refrigerator/Washer/Dryer comes with the home!' ,`Acres` = '0.1188' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 2 CHIMNEY HILL SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5175' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '381' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HAIRGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'LABAY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Left Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Mediterranean' ,`Subdivision` = 'Chimney Hill Sec 05' ,`TaxAmount` = '4174' ,`TaxRate` = '2.811' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669640970' WHERE `Matrix_Unique_ID` = '212666702' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T20:18:47.950' ,`MLSNumber` = '2684733' ,`ListAgentFullName` = 'Sanjeev Bhardwaj' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = 'Thuat Pham' ,`SellingOfficeName` = 'CTMORE, Inc.' ,`Latitude` = '29.898677' ,`Longitude` = '-95.725477' ,`PhotoCount` = '49' ,`PostalCode` = '77433' ,`RoomCount` = '11' ,`ListPrice` = '429995.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Kerby' ,`StreetNumber` = '20614' ,`StreetSuffix` = 'Place' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3095' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning former model 4 bedroom, 3.5 bath Cypress home graciously welcomes you the moment you step inside the grand foyer. French doors lead to the home office. Formal dining. Inviting living room with large windows sits at the heart of the home. The open-concept floor plan is ideal for hosting friends and family. The eat-in kitchen boasts a bright breakfast nook, large island, built-in appliances with double Oven, tiled back splash, ample storage. Serene downstairs primary suite with crown moldings, separate shower and tub, separate vanities, and walk-in closet. Spacious secondary bedrooms, baths, and large game room Upstairs. The home has wood flooring all over. Amazing backyard with water views, covered patio, Brand new outdoor kitchen and lush landscaping provides additional outdoor living and entertaining space. Home is equipped with security cameras , water Softener and 5 stage RO water filtration system.New roof installed in February 2022.' ,`Acres` = '0.2258' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 3 PINE CREEK AT CANYON LAKES WEST SEC 2' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '9838' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ANDRE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Pine Crk/Canyon Lakes West Sec 2' ,`TaxAmount` = '10146' ,`TaxRate` = '3.041' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669640970' WHERE `Matrix_Unique_ID` = '212734490' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T19:23:14.033' ,`MLSNumber` = '95485313' ,`ListAgentFullName` = 'Kathleen Ruby' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.157207' ,`Longitude` = '-95.473879' ,`PhotoCount` = '49' ,`PostalCode` = '77380' ,`RoomCount` = '11' ,`ListPrice` = '985000.00' ,`Status` = 'Active' ,`StreetName` = 'Colonial Row' ,`StreetNumber` = '3' ,`StreetSuffix` = 'Drive' ,`City` = 'The Woodlands' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3450' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This spectacular Brownstone, in the highly desireable neighborhood of The Woodlands East Shore has the look and feel of modern luxury in Manhattan\'s Upper East Side. This corner lot provides privacy and natural light throughout the day. Completely renovated by architect David Baker of AD Top 100 McAlpine House and Kevin Spearman Design, featured in Veranda Magazine.Poggenpohl kitchen with Miele and Sub Zero appliances,elevator, french oak custom flooring, high end plumbing and lighting, custom millwork and much more. Nothing was compromised. The upstairs gameroom on the 4th floor has it\'s own balcony and wet bar. Walking distance to Town Center. Market Street, Cynthia Woods Pavillion, Hughes Landing and The Woodlands Mall. Gated access to garages.' ,`Acres` = '0.0644' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S774100 - PARK PLACE BROWNSTONES, BLOCK 2, LOT 13' ,`LotDesciption` = 'Corner' ,`LotSize` = '2806' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2344' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'LAMAR ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '4' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Park Place Brownstones' ,`TaxAmount` = '11568' ,`TaxRate` = '2.1319' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669640970' WHERE `Matrix_Unique_ID` = '212747387' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T19:55:07.410' ,`MLSNumber` = '84528802' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.222624' ,`Longitude` = '-95.702405' ,`PhotoCount` = '6' ,`PostalCode` = '77354' ,`RoomCount` = '10' ,`ListPrice` = '443533.00' ,`Status` = 'Active' ,`StreetName` = 'Goldeneye' ,`StreetNumber` = '40546' ,`StreetSuffix` = 'Place' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2653' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2 Story, The Winchester floor Plan with 4 Bedrooms, 3 1/2 Baths, with a 2 Car Garage. This home boasts a SPACIOUS OPEN CONCEPT FLOOR PLAN with the Family Room, Kitchen, Breakfast Room, Study, & Primary Bedroom downstairs. Upstairs you will find a Game Room, Bedroom with ensuite Full Bath, 2 Secondary Bedrooms, & another Full Bath. You will love the Kitchen with lots of cabinets & granite countertops with under the cabinet lighting, stainless steel appliances, even a USB outlet. COVERED PATIO w/ Gas Stub Out, SPRINKLER SYSTEM, Full Gutters & fenced backyard. Blinds throughout. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Programmable Thermostat, Pex Hot & Cold Water Lines, Radiant Barrier, Rheem® Tankless Gas Water Heater, & Vinyl Double Pane Low E Windows that open to the inside of the home for Cleaning. Located in Magnolia, TX the new master-planned community Audubon will be conveniently on both sides of FM-1488 near Mill Creek Road.' ,`Acres` = '0.1749' ,`Area` = '15' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S221203 - AUDUBON CREEKSIDE NORTH 03A, BLOCK 3, LOT 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7619' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Audubon' ,`TaxAmount` = '539' ,`TaxRate` = '3.3087' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669640971' WHERE `Matrix_Unique_ID` = '212877259' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T20:38:28.417' ,`MLSNumber` = '93924347' ,`ListAgentFullName` = 'Mark Dimas' ,`ListOfficeName` = 'Mark Dimas Properties' ,`SellingAgentFullName` = 'Jonathan Patrick' ,`SellingOfficeName` = 'Francais Realty' ,`Latitude` = '29.498203' ,`Longitude` = '-95.408978' ,`PhotoCount` = '48' ,`PostalCode` = '77578' ,`RoomCount` = '10' ,`ListPrice` = '514950.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Poppy Hills' ,`StreetNumber` = '5' ,`StreetSuffix` = 'Court' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3079' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PRICE REDUCTION! New Construction in the gated community of Rodeo Palms! The beautiful Aurora floor plan is a 2-story home with 4 bedrooms, 3.5 baths, & attached 2-car garage! The 1st floor features high ceilings, study, dining room, family room with fireplace, half bath, & in-house utility room! The eat-in kitchen is sure to be a crowd pleaser with soon-to-be installed granite countertops, tile backsplash, farmhouse sink, stainless steel appliances, & shaker-style cabinets! The primary bedroom features an en-suite bath with dual sinks, vanity, soaking tub, separate shower, & walk-in closet! The second floor opens to 3 secondary bedrooms with a shared full bath, including a guest bedroom room, full bath & a gameroom! The backyard offers a covered patio! Zoned to Alvin ISD, this home is located in the Rodeo Palms subdivision within proximity to FM-288 & Hwy 6!' ,`Acres` = '0.2604' ,`Area` = '5' ,`BuilderName` = 'Saratoga Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RODEO PALMS THE LAKES SEC 4 (A0299) (MANVEL) BLK 2 LOT 17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11343' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'DON JETER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'RODEO PALMS THE LAKES SEC 4' ,`TaxAmount` = '1664' ,`TaxRate` = '3.6694' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669640971' WHERE `Matrix_Unique_ID` = '213010769' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T20:32:24.120' ,`MLSNumber` = '20568830' ,`ListAgentFullName` = 'Rebecca Nelson' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.789507' ,`Longitude` = '-95.501557' ,`PhotoCount` = '36' ,`PostalCode` = '77055' ,`RoomCount` = '4' ,`ListPrice` = '1599000.00' ,`Status` = 'Active' ,`StreetName` = 'Burkhart' ,`StreetNumber` = '8702' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2698' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rare opportunity to build your custom home on this 28,421 sq ft lot (per HCAD) in highly sought after Spring Valley Village!! Approx. 180\' of frontage on Burkhart Rd. Plenty of space for your custom home design, outdoor living/kitchen, pool, sports court, and more. Great central location with no through traffic to Bingle Rd. Easy access to Memorial City, Galleria, Heights, Downtown, Energy Corridor, & City Centre shopping/dining. Mid century 4-3-2 is approx 2,600 sq ft (per HCAD) and will be conveyed AS-IS in current condition. Pool also located on the property. Zoned to acclaimed Spring Branch ISD schools including Valley Oaks Elementary, Spring Branch Middle School, & Memorial High School. Out of flood zone per current FEMA map. Make sure to view the HD video tour that shows aerial views of the property and all it\'s possibilities.' ,`Acres` = '0.6525' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 2 TR 5C BINGLE C H SPRING VALLEY SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '28421' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'VALLEY OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Spring Valley Sec 02' ,`TaxAmount` = '28684' ,`TaxRate` = '2.3056' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1953' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669640971' WHERE `Matrix_Unique_ID` = '213151276' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T19:41:13.710' ,`MLSNumber` = '12299352' ,`ListAgentFullName` = 'Rocio Guajardo' ,`ListOfficeName` = 'RE/MAX 5 Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.080339' ,`Longitude` = '-95.031132' ,`PhotoCount` = '31' ,`PostalCode` = '77535' ,`RoomCount` = '8' ,`ListPrice` = '377000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 6242' ,`StreetNumber` = '303' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your dream new built Home sitting on 1 ACRE!\r\nCustom Kitchen cabinets, massive custom built kitchen island with beautiful granite, huge master bathroom with separate shower and tub, large size closets, luxury vinyl floors, brick on all 4 sides of the house, rain gutters... just to mention a few of the many great features this lovely Home has to offer.\r\nYou don\'t want to miss this one out. Call today to schedule a viewing and make this house your new Home!' ,`Acres` = '1' ,`Area` = '52' ,`BuilderName` = 'Private Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '000764 A G PENN #1006, TRACT 40, ACRES 3.46 (1 Acre)' ,`LotDesciption` = 'Cleared,Other' ,`LotSize` = '43560' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition,Wood Shingle' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (DAYTON)' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'A G Penn' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669640971' WHERE `Matrix_Unique_ID` = '213206928' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T19:26:57.997' ,`MLSNumber` = '44690436' ,`ListAgentFullName` = 'Ryan Culbertson' ,`ListOfficeName` = '5th Stream Realty' ,`SellingAgentFullName` = 'Philip Alter' ,`SellingOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`Latitude` = '29.804410' ,`Longitude` = '-95.444371' ,`PhotoCount` = '44' ,`PostalCode` = '77008' ,`RoomCount` = '4' ,`ListPrice` = '799900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Brooktree' ,`StreetNumber` = '2442' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2504' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Hip modern reno in Lazybrook! Contemporary selections, stylish design. Located on a very quiet dead end block, this property is just a short walk from the White Oak Bayou Trail and great restaurants. The front elevation features modern lines, dark paint, wood stain accents, black windows and new step stone sidewalk! Frame to finish peace of mind with the following major items redone; roof, underslab PVC sewer lines, PEX water supply lines, grounded copper wiring, electrical panel & service weatherhead, HVAC including insulation and ducting, energy efficient windows and doors, 36\" professional dual fuel GAS range, OVERSIZED 16’ wide OXXO sliding patio doors, an outdoor covered and tiled patio, and so much more! House has 4 bedrooms/2.5 bath. The HUGE primary suite is conveniently SEPARATED from all of the other guest bedrooms. If you or your clients desire a mid-century/modern, this is ONE OF THE FEW in Timbergrove/Lazybrook, so schedule a showing NOW to truly appreciate this home!' ,`Acres` = '0.2459' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Timbergrove/Lazybrook' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 18A & 19 BLK 2 LAZYBROOK SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10710' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch' ,`Subdivision` = 'Lazybrook Sec' ,`TaxAmount` = '10875' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669640972' WHERE `Matrix_Unique_ID` = '213264885' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T20:36:33.027' ,`MLSNumber` = '37758199' ,`ListAgentFullName` = 'Roxanna Saldana' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.589316' ,`Longitude` = '-96.332474' ,`PhotoCount` = '25' ,`PostalCode` = '77434' ,`RoomCount` = '5' ,`ListPrice` = '130000.00' ,`Status` = 'Active' ,`StreetName` = 'Church' ,`StreetNumber` = '200' ,`StreetSuffix` = 'Street' ,`City` = 'Eagle Lake' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1134' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a great property as a starter home, investment or looking to downsize. Great location in Eagle lake close to downtown and no neighbors to left of property. This 2 bedroom 1 bath home is ready for their new owners to make it their own. The home has an additional room that can be used as an office/play room or what fits your needs. A cute shed in the back yard ready to convert into your own little spot or for additional storage. The last pictures show the home virtually staged so that you can imagine the endless possibilities. Come take a look!' ,`Acres` = '0.12' ,`Area` = '56' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'BLK 37 LT 11 EAGLE LAKE HOUSE & BLDG' ,`LotDesciption` = 'Other' ,`LotSize` = '5227' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '161 - Rice Consolidated' ,`SchoolElementary` = 'EAGLE LAKE INTERMEDIATE SCHOOL' ,`SchoolHigh` = 'RICE HIGH SCHOOL (RICE CISD)' ,`SchoolMiddle` = 'RICE JUNIOR HIGH SCHOOL (RICE CISD)' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Eagle Lake' ,`TaxAmount` = '1446' ,`TaxRate` = '2.5343' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669640972' WHERE `Matrix_Unique_ID` = '213604752' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T20:39:38.677' ,`MLSNumber` = '9679481' ,`ListAgentFullName` = 'Jay Richardson' ,`ListOfficeName` = 'Register Real Estate Advisors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.979293' ,`Longitude` = '-95.224849' ,`PhotoCount` = '28' ,`PostalCode` = '77396' ,`RoomCount` = '10' ,`ListPrice` = '310000.00' ,`Status` = 'Active' ,`StreetName` = 'Seco Creek' ,`StreetNumber` = '18023' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2390' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this amazing 4-bedroom, 2.5-bathroom home. Pride of ownership is on display here. Perfect for families, the Primary bedroom and ensuite bath with dual sinks, a garden tub, sep shower, and a big walk-in closet are downstairs. Upstairs is the extra-large junior suite and 2 more bedrooms, all have walk-in closets. Perfect for entertaining, the kitchen is sure to please the most discerning chefs, with loads of counter space and a kitchen island, loads of storage in 42-inch oak cabinets and pantry, and best of all, the recently upgraded, matching Samsung stainless steel appliances. Formal Dining or keep it casual at the breakfast bar. The big Gameroom with a vaulted ceiling is upstairs. Enjoy the great outdoors in the shade of the covered patio in the backyard. Recent improvements include interior paint, a video security system, upgraded carpet, and custom-built shelves in the garage. Arrange your showing today, you will be glad you did!' ,`Acres` = '0.1215' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Humble Area East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 1 LAUREL PLACE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5291' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '525' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'LAKELAND ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'ROSS STERLING MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Laurel Place' ,`TaxAmount` = '6272' ,`TaxRate` = '2.933' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669640972' WHERE `Matrix_Unique_ID` = '213661721' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T19:19:59.600' ,`MLSNumber` = '98118096' ,`ListAgentFullName` = 'Pamela Smartt' ,`ListOfficeName` = 'Keller Williams Realty - Memor' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.836372' ,`Longitude` = '-98.092498' ,`PhotoCount` = '47' ,`PostalCode` = '78132' ,`RoomCount` = '10' ,`ListPrice` = '795000.00' ,`Status` = 'Active' ,`StreetName` = 'Shady' ,`StreetNumber` = '1053' ,`StreetSuffix` = 'Hollow' ,`City` = 'New Braunfels' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2183' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home on 4.68 acres, come & step back in time! Interior rock walls hugging a beautiful wood burning fireplace & stained concrete floors greet you. The kitchen, amassed w/ cabinets, recalls the grand days of the past w/antique styled appliances & crystal knobs & pulls. Wood flooring is found in the half bath, kitchen, & master bedroom. The master suite includes its own exit to the large wooden deck, a rock faced, gas fireplace, & spacious bathroom w/ walk-in closet. The other two bedrooms feature stained concrete floors, walk-in closets, & a Jack & Jill style bathroom. Other features of this gem include an 1890 sq ft shop w/ 3 roll up doors, sizable laundry room, multiple mature trees, low maintenance yard, wide rock walkway around the front of the house, 1 auto gate, & 1 double gate, a driveway that wraps around the house, & of course the splendid views of the Texas Hill Country from every angle. Additionally, is a detached 800 sq. ft casita for all your guest needs!' ,`Acres` = '4.68' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Propane' ,`HOAMandatory` = '1' ,`Legal` = 'RIVER CHASE 8, LOT 1323R' ,`LotDesciption` = 'Other,Wooded' ,`LotSize` = '155074' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '141 - Comal' ,`SchoolElementary` = 'HOFFMANN LANE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CANYON HIGH SCHOOL (COMAL)' ,`SchoolMiddle` = 'CHURCH HILL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'River Chase 8' ,`TaxAmount` = '8617' ,`TaxRate` = '1.7949' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669640972' WHERE `Matrix_Unique_ID` = '213825037' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T20:12:35.310' ,`MLSNumber` = '60316433' ,`ListAgentFullName` = 'Janeth Valenzuela' ,`ListOfficeName` = 'Intero Real Estate Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.940265' ,`Longitude` = '-95.224282' ,`PhotoCount` = '22' ,`PostalCode` = '77396' ,`RoomCount` = '8' ,`ListPrice` = '299999.00' ,`Status` = 'Active' ,`StreetName` = 'Sun River Falls' ,`StreetNumber` = '10830' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2294' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 10830 Sun River Falls! As you walk in you will be greeted by a foyer that opens up through the second floor. In the first floor you will find the spacious family room with an open concept through the kitchen and breakfast area. The spacious kitchen includes an island, counter height peninsula, two pantry spaces and stainless steel appliances. You will also have a separate dinning area that has tons of natural lighting as well as a chandelier ready for all of your special family dinners. In the second floor you will find the primary bedroom with a walk-in closet and a double sink bathroom. As well as three other spacious rooms with a full bath. Contact us to schedule your private showing!' ,`Acres` = '0.1171' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Humble Area East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 34 BLK 3 SUNSET RIDGE WEST SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5101' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'RIDGE CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunset Rdg East' ,`TaxAmount` = '6891' ,`TaxRate` = '3.0673' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669640973' WHERE `Matrix_Unique_ID` = '213932160' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T20:48:37.267' ,`MLSNumber` = '67524436' ,`ListAgentFullName` = 'Shane Terry' ,`ListOfficeName` = 'RE/MAX Northwest, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.344476' ,`Longitude` = '-95.436006' ,`PhotoCount` = '14' ,`PostalCode` = '77303' ,`RoomCount` = '4' ,`ListPrice` = '199999.00' ,`Status` = 'Active' ,`StreetName` = 'Bedford' ,`StreetNumber` = '300' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1541' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GREAT OVERSIZED CORNER LOT! Featuring an Updated Kitchen with white subway tile backsplash, granite countertops and Stainless Steel appliances! Light fixtures and ceiling fans are also recent. The refrigerator, Washer & Dryer are included along with the hanging wine rack & mini fridge in the wet bar area. The backyard is fenced with an above ground pool, wood decking, and covered seating area. Just minutes away from the Robinwood community center, Lions Park, and many great shopping and dining destinations.' ,`Acres` = '0.1664' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ROBINWOOD 01, BLOCK 8, LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7247' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'ANDERSON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Robinwood 01' ,`TaxAmount` = '3787' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669640973' WHERE `Matrix_Unique_ID` = '213933651' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T19:38:04.470' ,`MLSNumber` = '80883931' ,`ListAgentFullName` = 'Dan Klawer' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.529940' ,`Longitude` = '-95.728245' ,`PhotoCount` = '34' ,`PostalCode` = '77469' ,`RoomCount` = '6' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Rock Creek' ,`StreetNumber` = '715' ,`StreetSuffix` = 'Court' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2390' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! Beautiful 2390 Sq Ft, 4 bedrooms, 2 1/2 bathrooms is ready for its new owner(s). Upon entering, you are greeted with a freshly painted interior, high ceilings, laminate flooring in the main living areas with tile in the wet areas. An elegant formal dining area is the the right of the entry leading to the kitchen featuring black appliances, light wood cabinets, tile backsplash, granite countertops, breakfast bar and large pantry. Beautiful living room boasts a fireplace! Stunning primary retreat features modern sliding door leading to the updated ensuite bathroom. Bathroom features fully tiled walk-in shower with dual rain shower heads with handheld, vanity with dual sinks and anti-fog lighted mirrors, and access to the walk-in closet with organization system. Upstairs boasts brand new carpet, spacious loft area that could be used for a variety of purposes, and 3 large secondary bedrooms! Large backyard has extended patio and tons of space to create a backyard oasis!' ,`Acres` = '0.1784' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BONBROOK PLANTATION SOUTH SEC 1, BLOCK 2, LOT 22' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '7771' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CARTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bonbrook Plantation South Sec 1' ,`TaxAmount` = '6950' ,`TaxRate` = '2.6948' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669640973' WHERE `Matrix_Unique_ID` = '214040468' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T20:03:44.100' ,`MLSNumber` = '73152270' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.223263' ,`Longitude` = '-95.704738' ,`PhotoCount` = '6' ,`PostalCode` = '77354' ,`RoomCount` = '9' ,`ListPrice` = '442462.00' ,`Status` = 'Active' ,`StreetName` = 'Heron Heights' ,`StreetNumber` = '40240' ,`StreetSuffix` = 'Way' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2653' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2 Story, The Winchester floor Plan with 4 Bedrooms, 3 1/2 Baths, with a 2 Car Garage. This home boasts a SPACIOUS OPEN CONCEPT FLOOR PLAN with the Family Room with direct vent Fireplace, Kitchen, Breakfast Room, Study, & Primary Bedroom downstairs. Upstairs you will find a Game Room, Bedroom with ensuite Full Bath, 2 Secondary Bedrooms, & another Full Bath. You will love the Kitchen with lots of cabinets & quartz countertops with under the cabinet lighting, SS appliances, even a USB outlet. COVERED PATIO, GAS STUBOUT, SPRINKLER SYSTEM, & fenced backyard. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Programmable Thermostat, Pex Hot & Cold Water Lines, Radiant Barrier, Rheem® Tankless Gas Water Heater, & Vinyl Double Pane Low E Windows that open to the inside of the home for Cleaning. Located in Magnolia, TX the new master-planned community Audubon will be conveniently on both sides of FM-1488 near Mill Creek Road, just along the TX-249 Toll Road.' ,`Acres` = '0.1666' ,`Area` = '15' ,`BuilderName` = 'Anglia Homes LP' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S221205 - AUDUBON CREEKSIDE NORTH 05, BLOCK 2, LOT 15' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '7259' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Audubon' ,`TaxAmount` = '722' ,`TaxRate` = '3.3087' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669640973' WHERE `Matrix_Unique_ID` = '214268635' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T19:44:26.613' ,`MLSNumber` = '35452021' ,`ListAgentFullName` = 'Michele Cummings' ,`ListOfficeName` = 'Heritage Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.045568' ,`Longitude` = '-95.687485' ,`PhotoCount` = '22' ,`PostalCode` = '77480' ,`RoomCount` = '7' ,`ListPrice` = '155000.00' ,`Status` = 'Active' ,`StreetName` = 'Hickory' ,`StreetNumber` = '209' ,`StreetSuffix` = 'Street' ,`City` = 'Sweeny' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '925' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 209 Hickory St in Sweeny, Texas. This newly remodeled three-bedroom home offers luxury vinyl plank, quartz countertops and fresh paint throughout. As you walk into your home, the living room is spacious with an open concept floor plan. The kitchen provides a gas range and plenty of counterspace. You can enjoy meals in the dining room with a great view of the large backyard. The bedrooms offer spacious closets. Enjoy evenings on the front or back porch. If you have an RV this home has a carport and electric outlets to accommodate.' ,`Acres` = '0.225' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'MCKINNEY (SWEENY), BLOCK 2, LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9801' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '51 - Sweeny' ,`SchoolElementary` = 'SWEENY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SWEENY HIGH SCHOOL' ,`SchoolMiddle` = 'SWEENY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mckinney Sweeny' ,`TaxAmount` = '2662' ,`TaxRate` = '2.8427' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669640973' WHERE `Matrix_Unique_ID` = '214277721' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T20:05:35.900' ,`MLSNumber` = '44867236' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.225629' ,`Longitude` = '-95.703521' ,`PhotoCount` = '6' ,`PostalCode` = '77354' ,`RoomCount` = '7' ,`ListPrice` = '316778.00' ,`Status` = 'Active' ,`StreetName` = 'Berylline' ,`StreetNumber` = '40518' ,`StreetSuffix` = 'Lane' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1614' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 1 story home, Paisley Floor Plan with 3 Bedrooms, 2 Baths, with attached 2 car garage. This floor plan boasts a spacious OPEN CONCEPT FLOOR PLAN with the Family Room, Kitchen, Breakfast/Dining Room, 3 Bedrooms and 2 Baths. Tile and Carpet throughout. You will love the Kitchen with lots of cabinets and granite countertops with under the cabinet lighting, black appliances, and even a USB outlet. Fenced Backyard. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Programmable Thermostat, Pex Hot & Cold Water Lines, Radiant Barrier, Rheem® Tankless Gas Water Heater, and Vinyl Double Pane Low E Windows that open to the inside of the home for Cleaning. Located in Magnolia, TX the new master-planned community Audubon will be conveniently on both sides of FM-1488 near Mill Creek Road, just along the TX-249 Toll Road. Magnolia ISD. Do not wait! Call now for your private tour.' ,`Acres` = '0.1056' ,`Area` = '15' ,`BuilderName` = 'Anglia Homes LP' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S221202 - AUDUBON CREEKSIDE NORTH 02A, BLOCK 1, LOT 5' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '4600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Audubon' ,`TaxAmount` = '722' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669640974' WHERE `Matrix_Unique_ID` = '214321582' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T20:06:08.630' ,`MLSNumber` = '58426719' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.225679' ,`Longitude` = '-95.703625' ,`PhotoCount` = '6' ,`PostalCode` = '77354' ,`RoomCount` = '6' ,`ListPrice` = '306893.00' ,`Status` = 'Active' ,`StreetName` = 'Berylline' ,`StreetNumber` = '40558' ,`StreetSuffix` = 'Lane' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1464' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 1 Story Darlington Floor Plan with 3 Bedrooms, 2 Baths, with a 2 Car Garage. This floor plan boasts a SPACIOUS OPEN CONCEPT FLOOR PLAN and HIGH CEILINGS with the Family Room, Kitchen, Breakfast Room, and 3 Bedrooms with 2 full Baths. Tile and Carpet. You will love the Kitchen with lots of cabinets and granite countertops with under the cabinet lighting, stainless steel appliances, and even a USB outlet. SPRINKLER SYSTEM & fenced backyard! COST AND ENERGY EFFICIENT FEATURES: 16 Seer HVAC System, Honeywell Programmable Thermostat, Pex Hot and cold Water Lines, Radiant Barrier, Rheem® Tankless Gas Water Heater, and Vinyl Double Pane Low E Windows that open to the inside of the home for easy cleaning. Located in Magnolia, TX the new master-planned community Audubon will be conveniently located on both sides of FM-1488 near Mill Creek Road, just along the TX-249 Toll Road. Magnolia ISD.' ,`Acres` = '0.1289' ,`Area` = '15' ,`BuilderName` = 'Anglia Homes LP' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S221202 - AUDUBON CREEKSIDE NORTH 02A, BLOCK 1, LOT 15' ,`LotDesciption` = 'Greenbelt' ,`LotSize` = '5616' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Audubon' ,`TaxAmount` = '722' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669640974' WHERE `Matrix_Unique_ID` = '214324247' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T19:22:11.667' ,`MLSNumber` = '65072651' ,`ListAgentFullName` = 'Norma Jasso' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.822782' ,`Longitude` = '-95.521849' ,`PhotoCount` = '23' ,`PostalCode` = '77080' ,`RoomCount` = '4' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Lazy Spring' ,`StreetNumber` = '3115' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1459' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing one- story 3 bedrooms, two full baths with a 2 car garage residential home. Located in the Holley Terrace Subdivision in the Spring Branch area! Very well maintained and is ready to move in.. This home offers fresh paint throughout the interior and exterior, stainless steel appliances, high ceilings, covered back patio and much more! Come see this beauty and call it yours. Minutes away and Easy access to shopping centers, grocery stores, US Highway 290, W Sam Houston Tollway, 15 minutes to Memorial Herman Hospital and Memorial City Mall. What are you waiting for ?! Call to schedule your appointment today!!!' ,`Acres` = '0.1742' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 17 BLK 1 HOLLEY TERRACE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7590' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'BUFFALO CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'NORTHBROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Holley Terrace Sec 01' ,`TaxAmount` = '6493' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669640974' WHERE `Matrix_Unique_ID` = '214325589' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T20:02:55.910' ,`MLSNumber` = '44099891' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.223263' ,`Longitude` = '-95.704738' ,`PhotoCount` = '6' ,`PostalCode` = '77354' ,`RoomCount` = '8' ,`ListPrice` = '399150.00' ,`Status` = 'Active' ,`StreetName` = 'Heron Heights' ,`StreetNumber` = '40232' ,`StreetSuffix` = 'Way' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2070' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SEE SAMPLE 3D VIRTUAL TOUR!!! Beautiful all 1 story home with 4 Bedroom, 2 Bath, with attached 3 car garage. This floor plan boasts High Ceilings and a spacious OPEN CONCEPT FLOOR PLAN with the Family Room, Kitchen, Breakfast Room, Study/Flex Room, and 4 spacious bedrooms. Tile and Carpet throughout. You will love the Kitchen with lots of cabinets and granite countertops with under the cabinet lighting, black appliances, and even a USB outlet. Covered Patio, Sprinkler System, & Fenced Backyard. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Programmable Thermostat, Pex Hot & Cold Water Lines, Radiant Barrier, Rheem® Tankless Gas Water Heater, and Vinyl Double Pane Low E Windows that open to the inside of the home for Cleaning. Located in Magnolia, TX the new master-planned community Audubon will be conveniently on both sides of FM-1488 near Mill Creek Road, just along the TX-249 Toll Road. Magnolia ISD. Do not wait! Call now for your private tour.' ,`Acres` = '0.1785' ,`Area` = '15' ,`BuilderName` = 'Anglia Homes LP' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S221205 - AUDUBON CREEKSIDE NORTH 05, BLOCK 2, LOT 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7774' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Audubon' ,`TaxAmount` = '722' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669640974' WHERE `Matrix_Unique_ID` = '214327350' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T20:58:29.317' ,`MLSNumber` = '47400394' ,`ListAgentFullName` = 'Nicole Pool' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.789799' ,`Longitude` = '-95.329379' ,`PhotoCount` = '20' ,`PostalCode` = '77026' ,`RoomCount` = '2' ,`ListPrice` = '229000.00' ,`Status` = 'Active' ,`StreetName` = 'Lucille' ,`StreetNumber` = '4045' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1100' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home will have an open concept kitchen overlooking the large living-dining combo, which makes it perfect for entertaining. Vinyl plank flooring in living areas and plush carpet in the bedrooms. Moen fixtures in a timeless chrome finish are placed throughout the home. The Energy efficient features in the home will be reflected in your utility bills. Beautiful black appliance package included, home is engineered and inspected by a third-party engineer, has a seer HVAC system, double pane insulated Low-E windows, ENERGY EFFICIENT! Property is expected to be completed before the end of the year.' ,`Acres` = '0.1148' ,`Area` = '2' ,`BuilderName` = 'Carter Builders' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 9 BLK 1 COLONIA WEISENBERGER SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DOGAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'FLEMING MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'English' ,`Subdivision` = 'Colonia Weisenberger 1' ,`TaxAmount` = '1013' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669640975' WHERE `Matrix_Unique_ID` = '214328476' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T19:42:48.147' ,`MLSNumber` = '53022747' ,`ListAgentFullName` = 'Quan Nguyen' ,`ListOfficeName` = 'B & W Realty Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.821014' ,`Longitude` = '-95.538403' ,`PhotoCount` = '27' ,`PostalCode` = '77080' ,`RoomCount` = '4' ,`ListPrice` = '383000.00' ,`Status` = 'Active' ,`StreetName` = 'Shadybrook Meadow' ,`StreetNumber` = '2705' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2411' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this stunning property located in Spring Branch district. The property has 3beds & 3.5baths with an open living concept on the 2nd floor where you can get access to the balcony from the kitchen. Both 1st & 2nd floors were upgraded to hardwood flooring. From the spacious breakfast bar to a beautifully set-up island and a dining area where you can overlook the neighborhood through the balcony French doors, the kitchen is truly the heart of this property. Primary bedroom? We have 2, with en-suite bathroom in each. Spacious and convenient are best to describe this property. The builder carefully placed the 3rd bedroom on the 1st floor, to provide the owner suites a complete privacy. The property has been carefully cleaned so it\'s move in ready. The neighborhood park that has 24/7 access for the community residents.' ,`Acres` = '0.0413' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 4 PARK AT SPRING SHADOWS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '984' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'SPRING SHADOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING WOODS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Park/Spg Shadows' ,`TaxAmount` = '8118' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1669640975' WHERE `Matrix_Unique_ID` = '214408702' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T20:21:27.987' ,`MLSNumber` = '51259796' ,`ListAgentFullName` = 'Darrell Cooper' ,`ListOfficeName` = 'Metro Plus Realty PLLC' ,`SellingAgentFullName` = 'Brandon Leyva' ,`SellingOfficeName` = 'Home Run Realty' ,`Latitude` = '30.237077' ,`Longitude` = '-95.143887' ,`PhotoCount` = '15' ,`PostalCode` = '77372' ,`RoomCount` = '3' ,`ListPrice` = '180000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Diamond C' ,`StreetNumber` = '27042' ,`StreetSuffix` = '' ,`City` = 'Splendora' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1256' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come home to this gorgeous new construction home. This 3 bedroom 2 bath home wont last long. The home sits on a raised lot with a new septic and well. The yard slopes into the land next to it for better drainage. The kitchen has real wood cabinets. Each bedroom closet has a light in it.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'NA' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'NA' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'PEACH CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Holiday Oaks' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1669640975' WHERE `Matrix_Unique_ID` = '214442162' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T20:43:46.693' ,`MLSNumber` = '40905616' ,`ListAgentFullName` = 'Erin Rothchild' ,`ListOfficeName` = 'Erin Rothchild RealtyGroup LLC' ,`SellingAgentFullName` = 'James Skelton' ,`SellingOfficeName` = 'REALM Real Estate Professional' ,`Latitude` = '29.753913' ,`Longitude` = '-95.779378' ,`PhotoCount` = '38' ,`PostalCode` = '77494' ,`RoomCount` = '10' ,`ListPrice` = '357000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Ocotillo' ,`StreetNumber` = '1714' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2148' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UPDATED PHOTOGRAPHY COMING 11/15/2022. Desirable GATED COMMUNITY of 99 + 10. ONE STORY CULDESAC HOME. High Ceilings.WOOD LOOK +TILE FLOORING throughout with the exception of the secondary bedrooms with neutral/more recent carpet (2020). TEXAS SIZE FAMILY ROOM w GAS LOG FIREPLACE. Study/HOME OFFICE with French Doors + Wood Look Flooring. LARGE ISLAND KITCHEN w GRANITE + STAINLESS APPLIANCES. Ample CABINETS+COUNTER SPACE. Exquisite Formal Dining Room. MAGNIFICENT MASTER RETREAT w SITTING AREA, Tray Ceiling + WOOD LOOK FLOORING.PRIMARY BATH w Privacy Glass Window, GRANITE COUNTERS, DOUBLE SINKS, GLASS SHOWER + JETTED TUB. TWO nice sized WALK IN CLOSETS. Gorgeous Granite Counter in 2nd Bathroom. Utility Room with Stained Glass Window. Tool/workshop area in garage. Large Back Patio perfect for outdoor entertaining/relaxing. SELLERS ADDED $16K in IMPROVEMENTS SINCE 2016 including TRANE XR 16 Seer (per model number) AC 2020.Roof 2015.Water Heater + extended Wood Floors 2012. FOUR SIDES BRICK' ,`Acres` = '' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Falcon Landing Sec 1, Block 1, Lot 24' ,`LotDesciption` = 'Cleared,Cul-De-Sac' ,`LotSize` = '8322' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '965' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'FIELDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'CINCO RANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Falcon Landing' ,`TaxAmount` = '' ,`TaxRate` = '2.2545' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669640975' WHERE `Matrix_Unique_ID` = '214506714' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T19:09:38.207' ,`MLSNumber` = '50157257' ,`ListAgentFullName` = 'Lemorra Carter' ,`ListOfficeName` = 'Priority One Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.647230' ,`Longitude` = '-95.138382' ,`PhotoCount` = '14' ,`PostalCode` = '77505' ,`RoomCount` = '5' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Heathfield' ,`StreetNumber` = '4210' ,`StreetSuffix` = 'Drive' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1596' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful one story 3/2 home is in the sought-out Pasadena neighborhood of Village Grove. Zoned to Deer Park ISD with the elementary school within walking distance. The kitchen is spacious and open to the dining and family room. The primary suite has recently updated flooring and bathroom complete with granite countertops his/her sinks plenty of storage separate shower and jet tub. Bedrooms two and three are mirror images of each other with large bay windows and new flooring. The backyard is large with plenty of room for a pool and also has a storage building. The deck has a covered area along with an open area perfect for entertaining relaxing. A new roof and gutters were installed in 2018. The pipes and water heater in 2019 and the attic stairs were replaced in 2022 along with new flooring. It’s excellent location makes it convenient for shopping and ease of access to Beltway 8. This home has never flooded. schedule your showing today to see this beautiful home. ' ,`Acres` = '0.1663' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 3 VILLAGE GROVE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7245' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '280' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'FAIRMONT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRMONT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Village Grove Sec 01' ,`TaxAmount` = '6053' ,`TaxRate` = '2.8798' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669640976' WHERE `Matrix_Unique_ID` = '214514125' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T19:56:29.700' ,`MLSNumber` = '71950225' ,`ListAgentFullName` = 'Lea Ann Dorsett' ,`ListOfficeName` = 'Living Texas Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.585351' ,`Longitude` = '-97.301689' ,`PhotoCount` = '25' ,`PostalCode` = '76578' ,`RoomCount` = '3' ,`ListPrice` = '333500.00' ,`Status` = 'Active' ,`StreetName` = 'Lydia' ,`StreetNumber` = '504' ,`StreetSuffix` = 'Lane' ,`City` = 'Thrall' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1433' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come experience small town living in this three bedroom, two bath, split bedroom floor plan home that is turnkey ready for you. The primary bedroom is spacious, and the attached bath has large closets. This home has been recently updated with new paint, flooring, lighting, plumbing fixtures, hardware, landscaping, granite countertops, blinds, and architectural roof. There is no HOA. Enjoy sunrises and sunsets on the covered back patio. Thrall is a highly sought-after community with acclaimed schools within walking distance of this home. You\'ll be minutes from shopping and restaurants- including a mix of specialty shops, arts and entertainment- and less than ten miles from the new Samsung plant. Parks and recreation abound in the area, which is still within an easy commute to Austin and surrounding communities.' ,`Acres` = '0.1525' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Reports Available,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S6725 - KELM ESTATES SEC 1, BLOCK C, LOT 5' ,`LotDesciption` = 'Other' ,`LotSize` = '6643' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '974 - Thrall' ,`SchoolElementary` = 'THRALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THRALL HIGH SCHOOL' ,`SchoolMiddle` = 'THRALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kelm Estates Sec 1' ,`TaxAmount` = '6298' ,`TaxRate` = '2.3568' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669640976' WHERE `Matrix_Unique_ID` = '214543152' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T19:10:15.583' ,`MLSNumber` = '64716412' ,`ListAgentFullName` = 'Karen Davis' ,`ListOfficeName` = 'KLD Premier Realty' ,`SellingAgentFullName` = 'Edward Wang' ,`SellingOfficeName` = 'EW & Associates Realty, LLC' ,`Latitude` = '29.723568' ,`Longitude` = '-95.862052' ,`PhotoCount` = '46' ,`PostalCode` = '77441' ,`RoomCount` = '10' ,`ListPrice` = '879000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Enchanted Shores' ,`StreetNumber` = '28315' ,`StreetSuffix` = 'Lane' ,`City` = 'Fulshear' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4327' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION, LOCATION, LOCATION! This stunning waterfront home in the award-winning subdivision of Cross Creek Ranch has breathtaking views and incredible sunsets. Inside features \"wood like\' tile floors, Plantation Shutters, upgraded Berber carpet, high ceilings and open floorplan. Huge Island Kitchen with granite, GE stainless steel appliance package, lots of cabinets, recessed and pendent lights. Family Room with wall of windows, sliding glass door, gas log Fireplace, beamed ceiling. Large Primary Suite with tray ceiling. Primary Bath with double sinks, groin ceiling, chandelier, standalone MAAX soaker tub and oversized walk-in closet. The second floor has a huge Game Room, Media Room, 2 secondary Bedrooms and 2 Full Baths. Close to private pocket park and walking distance to a Day Care and KISD Elementary, Junior High and High School. Convenient to grocery stores, restaurants, and retail stores. The subdivision also has a waterpark, pools, restaurant, dog park and workout facility.' ,`Acres` = '0.2321' ,`Area` = '36' ,`BuilderName` = 'Trendmaker' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CREEK COVE AT CROSS CREEK RANCH SEC 10, BLOCK 1, LOT 21' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '10109' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cross Creek Ranch' ,`TaxAmount` = '18126' ,`TaxRate` = '3.3425' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669640976' WHERE `Matrix_Unique_ID` = '214554641' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T19:17:08.270' ,`MLSNumber` = '12605624' ,`ListAgentFullName` = 'Barett Engelhardt' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Patricia Negrich' ,`SellingOfficeName` = 'JLA Realty' ,`Latitude` = '30.054440' ,`Longitude` = '-95.384254' ,`PhotoCount` = '18' ,`PostalCode` = '77373' ,`RoomCount` = '6' ,`ListPrice` = '199900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Pebworth' ,`StreetNumber` = '23627' ,`StreetSuffix` = 'Place' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1153' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Move-in ready single story home LOADED w/ upgrades in the popular Cypress Trails community offering a gated pool, & quick access to Timber Lane Hike/Bike trail, Mercer Botanic Gardens, Cypresswood Golf Club & more! Great open floorplan connects the modernized kitchen with the family room. Living room boasts soaring ceilings and lots of natural light. New paint inside and out, new lighting, and NO HISTORY OF FLOODING! Superb access to I-45 N Corridor and Hardy Toll Road! Make an appointment today!' ,`Acres` = '0.1162' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TRS 8B & 9B BLK 11 CYPRESS TRAILS OF TIMBERLANE 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5060' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'GLORIA MARSHALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Trails of Timberlane' ,`TaxAmount` = '4555' ,`TaxRate` = '3.0268' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669640976' WHERE `Matrix_Unique_ID` = '214631290' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T20:09:21.843' ,`MLSNumber` = '94202175' ,`ListAgentFullName` = 'Lisa Sawyer' ,`ListOfficeName` = 'Sawyer Realty Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.357613' ,`Longitude` = '-95.469789' ,`PhotoCount` = '18' ,`PostalCode` = '77303' ,`RoomCount` = '7' ,`ListPrice` = '272500.00' ,`Status` = 'Active' ,`StreetName` = 'Summit' ,`StreetNumber` = '212' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2116' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great opportunity for home owners or investment property. Nice 3/4 bedroom brick home with 2/3 full bathrooms with a separate garage apartment with it\'s own bathroom and kitchen, there\'s is also a single carport available for this space. This is great for a mother-in-law quarters or rental income, the potential is there. The roof, water heater complete HVAC including duct work was replaced within the last 2 years. Laminate and tile floors throughout. Centrally located close to downtown Conroe, shopping, dining just minutes away from I-45. This won\'t last long don\'t let this one slip away.' ,`Acres` = '0.3444' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'SUNSET RIDGE 02, BLOCK 8, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'REAVES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunset Ridge 02' ,`TaxAmount` = '3891' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669640977' WHERE `Matrix_Unique_ID` = '214696640' --> 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','214754838','1669640977','214754838','2022-11-21T19:06:22.840','12286351','De Juanna Pulcher','REALM Real Estate Professional','','','29.385265','-94.762749','37','77650','3','795000.00','Active','Laguna Harbor Cove','1816','Boulevard','Port Bolivar','2','1','3','1894','Single-Family','STUNNING! This Modern style Bay House is EASY on the eyes and is nestled in a private gated community. This beauties curb appeal is spot on. Come see the 3 br 2.5 bth stunner. You can sit on your choice of 2 balconies relaxing, enjoying the breeze, the views and maybe spot the local dolphins visiting from time to time. If you feel like taking a swim, well this BEAUTY has its own private pool. Do you have a boat? This property has you covered with its own private slip. The canal gives easy access to the Bay and the Gulf of Mexico, so bring your water sport gear. Guess what else? COMING SOON! Bolivar Beach Club & RV Resort will become CAMP MARGARITAVILLE. The new facility will feature a concert venue, \"Texas-sized\" pool with swim-up bar, pool-side cabanas, and a turf playing field. Upgrades will include the addition of the Fins Bar & Grill restaurant and a bar called License to Chill. It\'s 5 O\'clock somewhere! This brings a whole new attraction to the area. Priced to sell. Don\'t delay!','0.216','33','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Port Bolivar','Central Electric','1','LAGUNA HARBOR (2005), ABST 162, BLOCK 2, LOT 30, ACRES 0.216','Water View,Waterfront','9409','Appraisal District','','456','0','','2','Electric Oven','1','Gunite','','Electric Range','','Aluminum','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required,Controlled Access,Leave Business Card,Request Online Appointment','Appraisal District','2','Contemporary/Modern,Traditional','Laguna Harbor 2005,','9040','1.6103','Public Sewer,Public Water','2006','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','214765003','1669640977','214765003','2022-11-21T20:15:02.290','58919604','Beverly Bradley','Weekley Homes','','','29.975033','-95.745362','42','77433','9','552296.00','Active','Paseo De La Paz','13826','Place','Cypress','4','0','5','3073','Single-Family','Location! Location! Location! The highly anticipated Dunham Pointe community is open! NEW DAVID WEEKLEY HOME! Admire this stunning David Weekley Homes 5-bedroom two story brick and stone home with a relaxing front porch. Right off the entry is a spacious study perfect for work at home or the home classroom, you decide. You will be WOWED by the spacious kitchen and island where this open concept makes it easy to converse with guests as they relax in the airy Dining & Family rooms. With direct access to the outdoors, entertaining inside or outside is easy with plenty of space for family and friends. The upstairs retreat is perfect for homework, family game night, sleep overs and movie night. Quick and easy access to 290 & 99. CY-Fair ISD','','25','David Weekley Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Home Protection Plan,Mud','1','','','Cypress South','Central Gas','1','Lot 42 Block 01','Subdivision Lot','6737','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','2','Traditional','Dunham Pointe','','','Water District','2023','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T20:07:46.157' ,`MLSNumber` = '82066518' ,`ListAgentFullName` = 'Shawn Baksh' ,`ListOfficeName` = 'Trotwood Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.824578' ,`Longitude` = '-95.515780' ,`PhotoCount` = '38' ,`PostalCode` = '77080' ,`RoomCount` = '7' ,`ListPrice` = '379900.00' ,`Status` = 'Active' ,`StreetName` = 'Theysen' ,`StreetNumber` = '9018' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1579' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic rambling ranch in stellar Spring Branch location!! You must see this home to believe how large it really is! This wonderful sprawling and spacious ranch sits on a private level lot where there are no back neighbors. This home was meticulously updated with pride. Updated electrical, roof, HVAC, plumbing, fixtures and finishes. This house boasts large inspiring rooms, fantastic closets, real hardwood floors and an exceptional amount of outdoor space. The sizable updated windows allow an abundance of bright natural sunlight to light up the space. Authentic quality craftmanship and finishes like no other home.' ,`Acres` = '0.3482' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 135 BLK 13 BINGLEWOOD SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15168' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'EDGEWOOD ELEMENTARY SCHOOL (SPRING BRANCH)' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'NORTHBROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Binglewood Sec 02' ,`TaxAmount` = '6600' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669640977' WHERE `Matrix_Unique_ID` = '214915628' --> 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','214917483','1669640977','214917483','2022-11-21T20:02:00.847','40734689','Diana Durham','Regal, Realtors','','','30.001902','-95.465673','21','77014','7','188000.00','Active','Kiplands Bend','15566','Drive','Houston','2','1','3','1630','Single-Family','Lovely Brick Two Story Home in Houston, Covered front porch, Features 3 Bedrooms and 2.5 Bathrooms. Living room, Kitchen and half bath downstairs. The kitchen has beautiful floors, Newer style cabinets, countertops and appliances. The bedrooms and laundry are upstairs, The Master has beautiful flooring and The master bath with walk in closet. Attached Two Car Garage with driveway. Close to Shopping, Schools and more.','0.0722','13','','','','','Mud,Other Disclosures','','','','1960/Cypress Creek South','Central Electric','1','LT 52 BLK 2 BAMMEL VILLAGE SEC 02 R/P','Subdivision Lot','3143','Appraisal District','','366','0','','2','','0','','','','','Composition','48 - Spring','MAJOR ELEMENTARY SCHOOL','WESTFIELD HIGH SCHOOL','BAMMEL MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Traditional','Bammel Village Sec 02 Rep 01','5361','2.8192','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','214986311','1669640977','214986311','2022-11-21T20:26:59.993','65444059','Karen Gandy','BHGRE Gary Greene','','','29.511176','-95.415698','29','77578','9','459000.00','Active','Blue Canoe','5102','Road','Manvel','3','0','4','2577','Single-Family','Stunning in gated Newport Lake Estates! One-Story open floor plan is great for entertaining or being a part of everything going on around you, yet the Bedrooms and Flex Room enjoy privacy away from the hustle and bustle of everyday life. Five-light French doors allow natural light to fill the Flex Room (Study, Dining, Bonus room) while providing a quiet space. The Great Room perfectly describes the heart of the home! The Kitchen is fit for a chef, including stainless appliances, gas cooktop, abundant cabinetry, granite island with bar stools for friends, ample storage space, recessed lights and rich flooring throughout the home. An area for table seating and the Family Room enjoy the same open feeling and natural light. Primary Bedroom Suite is large and private from the other rooms. A Secondary Bedroom also enjoys an en-suite full bathroom. The pie-shaped Lot provides a LOT of yard and the covered Patio provides shade while grilling outdoors. Come Enjoy this beautiful Perry Home.','0.2907','5','Perry Homes','','Electric Dryer Connections,Washer Connections','','Exclusions,Mud,Sellers Disclosure','1','','','Alvin North','Central Gas','1','NEWPORT LAKE ESTATES SEC 1 (A0299 HT&BRR) (MANVEL) BLK 1 LOT','Subdivision Lot','12663','Appraisal District','','935','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','3 - Alvin','DON JETER ELEMENTARY SCHOOL','MANVEL HIGH SCHOOL','RODEO PALMS JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Newport Lake Estates','12484','3.6694','Public Sewer,Public Water,Water District','2018','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','214995581','1669640977','214995581','2022-11-21T20:57:36.900','86960729','Bethany Ehret','Keller Williams Hou Preferred','','','29.448772','-95.090384','29','77539','6','234900.00','Active','Capella Oaks','339','Lane','Dickinson','2','1','3','1702','Single-Family','This super cute townhome is perfectly positioned on a Cul-de-sac and oversized lot. This home boasts an open floor plan concept with high ceilings, and tons of kitchen counter space, cabinets and two pantries. Relax in the large, shaded backyard that is perfect for enjoying the outdoors. Upstairs includes an area perfect for play, a study or a reading nook. Many updates such as Fresh Exterior Paint, New Water Heater (2021), New Roof, Fence and Garbage Disposal (2022). Home has never flooded. Community amenities include walking trails equipped with pet stations, Bay Colony Park and Pool Access. HOA covers windstorm, roof and siding.','0.1067','33','Lennar','','','','Mud,Sellers Disclosure','1','','','League City','Central Gas','1','ABST 19 PERRY & AUSTIN SUR LOT 40 BLK 4 RETREAT IN BAY COLON','Cul-De-Sac','4650','Appraisal District','','575','0','','2','Convection Oven,Electric Oven','0','','','','','Composition','17 - Dickinson','CALDER ROAD ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','LOBIT MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Retreat In Bay Colony 2004','5655','2.7847','Public Sewer,Public Water','2005','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215017075','1669640977','215017075','2022-11-21T20:06:21.170','50235602','Stephen Kendrick','Kendrick Realty','','','29.816608','-95.716492','10','77449','8','315000.00','Active','Sedgeborough','3126','Drive','Katy','2','1','3','2055','Single-Family','Come see this beautifully renovated home. Kitchen and baths are all completely remodeled with new solid plywood cabinets in a soft grey color, beautiful marble-looking quartz countertops and all new tile on the floors, walls and backsplash. Kitchen was finished off with new stainless steel appliances. All light fixtures, fans, plugs and switches have been changed out as well as all bath plumbing fixtures. Come see the walk in primary shower with overhead shower head. Formal living room updated to a new home office/ study with 2 sets of glass french doors to allow for optimal flexibility. Fresh neutral paint and new flooring throughout. Beautiful water resistant laminate flooring in all the main rooms, tile in the 2 bathrooms and carpet only in the bedrooms. All new 5 1/2\" baseboards with new 2 panel doors and 3 1/2\" door trim. Oil rubbed bronze lever handles are the finishing touches on this magnificent home. The air conditioner and all ductwork was recently replaced.','0.1495','25','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections','1','Katy - North','Central Gas','1','LT 41 BLK 4 WESTFIELD SEC 1','Subdivision Lot','6512','Appraisal District','','437','0','','2','Freestanding Oven,Gas Oven','0','','','Gas Cooktop','','Composition','30 - Katy','MCROBERTS ELEMENTARY SCHOOL','MAYDE CREEK HIGH SCHOOL','CARDIFF JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Westfield Sec 01','4512','2.387','Public Sewer,Public Water,Water District','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','215017461','1669640977','215017461','2022-11-21T20:14:18.330','17544777','Rita Vera','Texas Ally Real Estate Group,','','','29.406853','-98.692918','9','78245','8','255000.00','Active','Dalhart','2336','Pass','San Antonio','2','1','4','2278','Single-Family','Location and Price and a great deal this 4 bedroom with 2 and a half baths on a corner lot has all the space you need. The home has 3 living areas and a big game room and deck overlooking the master and game room. Priced and ready 1604/NW corner lot with a big yard. The home is being remolded call for details!','0.1754','83','','','','','Sellers Disclosure','','','','','Central Electric','1','CB 4332A BLK 78 LOT 71 SUNSET UT-1','Corner','7642','Appraisal District','','200','0','','1','','0','','','','','Composition','247 - Northside (Bexar)','MICHAEL ELEMENTARY SCHOOL','STEVENS HIGH SCHOOL','VALE MIDDLE SCHOOL','Request Online Appointment','Appraisal District','2','Other Style','Sunset Sub Un 1','5552','2.1019','Public Sewer,Public Water','2001','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','215017798','1669640977','215017798','2022-11-21T20:46:30.613','69388387','Candice Harris','CA Modern Realty, LLC','','','30.026331','-95.802876','10','77447','7','205999.00','Active','Bullis Gap','17838','Drive','Hockley','2','0','3','1229','Single-Family','The Neighborhood, The Trees, The Great convenient Location only minutes from HWY 290, Shopping, the hospital and so much more!!!. The primary bathroom has been updated and the flooring is tile throughout!!! The living room is very spacious and the large backyard is great for entertaining. Not to mention the roof, water heater and fence are less than 5 years old!!! Come take a look! It\'s 1229 square feet of just pure \'\'cuteness\'\'! It\'s open, bright, has great curb appeal, well laid out, and I\'ll bet it\'s just what you have been looking for. Has never flooded!!Pack your bags, THIS is IT!','0.149','35','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','','','','Hockley','Central Electric','1','LT 10 BLK 2 RANCH COUNTRY SEC 5','Subdivision Lot','6490','Appraisal District','','250','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','55 - Waller','ROBERTS ROAD ELEMENTARY SCHOOL','WALLER HIGH SCHOOL','WALLER JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','Ranch Country Sec 05','4344','2.7956','Public Sewer,Water District','2004','Appraisal District'); --> New record created successfully