Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T12:22:14.187' ,`MLSNumber` = '64138989' ,`ListAgentFullName` = 'Philip Alter' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.708399' ,`Longitude` = '-95.408319' ,`PhotoCount` = '27' ,`PostalCode` = '77030' ,`RoomCount` = '10' ,`ListPrice` = '2350000.00' ,`Status` = 'Active' ,`StreetName` = 'McClendon' ,`StreetNumber` = '2117' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '5572' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Another exceptional home planned by Sherpa Builders. Currently under construction. This soft contemporary brick and stucco home offers an exciting opportunity. The floorplan features a first floor primary bedroom, additional three or four bedrooms plus gameroom on the second floor, and three car garage. Large lot with room for a pool. 2117 McClendon is in the charming Southgate neighborhood, convenient to The Medical Center, Rice University, and Downtown. Zoned to Roberts Elementary.' ,`Acres` = '0.1928' ,`Area` = '17' ,`BuilderName` = 'Sherpa Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rice/Museum District' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 12 & 13A BLK 6 SOUTHGATE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ROBERTS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Southgate' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705949' WHERE `Matrix_Unique_ID` = '200707688' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T12:42:57.210' ,`MLSNumber` = '26807076' ,`ListAgentFullName` = 'Somarajan Nair' ,`ListOfficeName` = 'ABI Enterprises' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.530609' ,`Longitude` = '-95.298721' ,`PhotoCount` = '26' ,`PostalCode` = '77584' ,`RoomCount` = '10' ,`ListPrice` = '1000000.00' ,`Status` = 'Active' ,`StreetName` = 'Bailey' ,`StreetNumber` = '7006' ,`StreetSuffix` = 'Road' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2780' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated Home on a 2.08 Acres. No restrictions, MUD or Home owners fee.Country living minutes away from Hospitals, Grocery and department stores. Huge 4200 Sq. Ft workshop with loft and offices ready for personal use or lease. Beautiful Pecan and Oak trees. Recent updates include Tiles , water heater, A/C , Silestone counter top, Water well and many more.' ,`Acres` = '2.0885' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0549 H T & B R R, TRACT 1C, ACRES 2.470' ,`LotDesciption` = 'Wooded' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'MAGNOLIA ELEMENTARY SCHOOL (PEARLAND)' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Appointment Required,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'H T & B R R' ,`TaxAmount` = '8506' ,`TaxRate` = '2.69' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705949' WHERE `Matrix_Unique_ID` = '204086863' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T13:44:15.290' ,`MLSNumber` = '43676738' ,`ListAgentFullName` = 'Jennifer Zweiacker' ,`ListOfficeName` = 'Zweiacker & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.739523' ,`Longitude` = '-96.241639' ,`PhotoCount` = '37' ,`PostalCode` = '77808' ,`RoomCount` = '14' ,`ListPrice` = '968000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 1179' ,`StreetNumber` = '10601' ,`StreetSuffix` = '' ,`City` = 'Bryan' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2114' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Improved 25 acres, nestled just outside the city limits & offers the serenity of country living…close to town. Open grassland, ideal for grazing or hay production, offers the perfect combination of cattle or equine options. Step inside this wonderful 3 bed, 2.5 bath home, your eyes are immediately drawn upwards to the cathedral ceiling accented by wood beams that span the open great room. 14” designer ceramic tile floors lead you to a spacious kitchen; with w/granite countertops & wood cabinets for tons of storage. Detailed wood millwork adorns each window. An oversized utility room, located off the mudroom, also provides a ½-bath for convenience. The front/back yards are fully fenced, with an amazing covered back porch overlooking the south acreage. A fully functional 37X50 barn includes additional covered storage 30X50 for implements, hay, and livestock. Currently, a working cattle operation, the opportunity to own this piece of Brazos Valley doesn’t come along very often.' ,`Acres` = '25' ,`Area` = '61' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A011700, W L ELLIS, TRACT 2, 25. ACRES' ,`LotDesciption` = 'Cleared,Other' ,`LotSize` = '1089000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '148 - Bryan' ,`SchoolElementary` = 'SAM HOUSTON ELEMENTARY SCHOOL (BRYAN)' ,`SchoolHigh` = 'JAMES EARL RUDDER HIGH SCHOOL' ,`SchoolMiddle` = 'ARTHUR L. DAVILA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'A011700, W L ELLIS, TRACT 2, 25. ACRES' ,`TaxAmount` = '9750' ,`TaxRate` = '1.7488' ,`WaterSewer` = 'Aerobic,Other Water/Sewer' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705949' WHERE `Matrix_Unique_ID` = '205285352' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T13:52:37.433' ,`MLSNumber` = '5847234' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = 'Michele Harmon' ,`SellingOfficeName` = 'RE/MAX Universal' ,`Latitude` = '30.065257' ,`Longitude` = '-95.722230' ,`PhotoCount` = '21' ,`PostalCode` = '77377' ,`RoomCount` = '13' ,`ListPrice` = '588177.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Trotting Green' ,`StreetNumber` = '19206' ,`StreetSuffix` = 'Trail' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3160' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Your dream home awaits! This gorgeous Beazer home in the desirable community of Amira features tile flooring, stone fireplace, energy efficient features, private study with French doors, spacious primary suite with dual vanities and a mud set shower, game room, and extended covered patio. The impressive kitchen is complete with quartz countertops, mosaic backsplash, large cove molding, double wall oven, 36” built-in gas cooktop, stainless steel appliances, 42” upper cabinets, and pendant and under-counter lighting. Nestled among 100-year-old oak trees are Amira’s world-class comforts, including a glistening infinity-edge pool, clubhouse, dog park, and full fitness center. Located off the Grand Parkway and Hwy 249, residents are minutes from popular restaurants, shops, and parks in central Tomball and Cypress. Zoned to the top-rated Tomball ISD.' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 5 Block 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Amira' ,`TaxAmount` = '' ,`TaxRate` = '3.551993' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705950' WHERE `Matrix_Unique_ID` = '205999591' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T12:11:28.087' ,`MLSNumber` = '21720517' ,`ListAgentFullName` = 'Joe Lucia' ,`ListOfficeName` = 'Douglas Elliman Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.699550' ,`Longitude` = '-95.429082' ,`PhotoCount` = '35' ,`PostalCode` = '77025' ,`RoomCount` = '9' ,`ListPrice` = '1759000.00' ,`Status` = 'Active' ,`StreetName` = 'Underwood' ,`StreetNumber` = '3327' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '4044' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Architecturally sophisticated classic contemporary design nestled at the end of a cul-de-sac with only one neighbor. 2 home offices, one in the front of the house with a full library and built-in cabinets and drawers and other off the primary bedroom at the rear of home with cabinets. Perfect for those working from home needing separate offices or could also be a 4th bedroom due to shower in 1/2 bathroom. Open concept, free flowing floor plan that cultivates a social atmosphere. Expansive gourmet kitchen with oversized center island. High ceilings. Walls of windows allowing for an abundance of natural lighting that brings the outdoors in. Unique construction with house, garage and pool built on elevated house pad mitigating flooding. No need to walkup steps to your 1st floor. 41-foot pool on approximately .5-acre lot. Pitched metal roof. Multiple upgrades. By appointment only.' ,`Acres` = '' ,`Area` = '17' ,`BuilderName` = 'Covington Custom' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Braeswood Place' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6 & TR 5 Block 11 Southern Oaks Sec 1' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '21036' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '254' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'TWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Southern Oaks' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705950' WHERE `Matrix_Unique_ID` = '206146167' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T13:27:22.210' ,`MLSNumber` = '69126334' ,`ListAgentFullName` = 'Phillippa Stiner' ,`ListOfficeName` = 'Doug Erdy Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.034605' ,`Longitude` = '-94.868949' ,`PhotoCount` = '27' ,`PostalCode` = '77535' ,`RoomCount` = '5' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Ford' ,`StreetNumber` = '915' ,`StreetSuffix` = 'Avenue' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1734' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your beautiful home in sought after FORDLAND ESTATES. \r\nIf you are looking for an open floor plan this house is for you! There is a formal dining room and the living area has a fireplace and windows that are great for natural lighting! The living area is open to the kitchen as well! The kitchen has ample cabinets and countertop space with black appliances! The primary bedroom is spacious and will accommodate your king size furniture! The master bathroom has dual sinks, large soaking tub and separate shower! Schedule now to see this amazing home because it won\'t last long!' ,`Acres` = '0.2661' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'FORDLAND ESTATES, SEC 1, LOT 28, ACRES .2661' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11591' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'KIMMIE M. BROWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Fordland Estates,' ,`TaxAmount` = '5510' ,`TaxRate` = '2.4832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705950' WHERE `Matrix_Unique_ID` = '206208253' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T13:05:04.523' ,`MLSNumber` = '90132636' ,`ListAgentFullName` = 'Anthony Williams' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.742114' ,`Longitude` = '-95.386698' ,`PhotoCount` = '34' ,`PostalCode` = '77006' ,`RoomCount` = '12' ,`ListPrice` = '1100000.00' ,`Status` = 'Active' ,`StreetName` = 'Audubon' ,`StreetNumber` = '3404' ,`StreetSuffix` = 'Place' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2614' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL 1928 HISTORIC MONTROSE BUNGALOW ON OAK LINED AUDUBON PLACE. HDWD FLOORS, HIGH CEILING, CRWN MOLDING, AUTO GATE WITH PRIVATE COVERED PARKING, CUSTOM PELLA WINDOWS, LARGE ENTERTAINMENT SPACE WITH SALT-WATER POOL. FORMAL DINING AND LIVING WITH LARGE FAMILY ROOM OFF KITCHEN. A MUST SEE FOR THOSE LOOKING FOR A HOME THAT IS CLOSE TO EVERYTHING HOUSTON HAS TO OFFER.' ,`Acres` = '0.1377' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Montrose' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 12 MONTROSE' ,`LotDesciption` = 'Other' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WOODROW WILSON MONTESSORI' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'GREGORY-LINCOLN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Left Side,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Montrose' ,`TaxAmount` = '20802' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1928' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705950' WHERE `Matrix_Unique_ID` = '206741274' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T13:52:36.250' ,`MLSNumber` = '17284718' ,`ListAgentFullName` = 'Moni Bohnisch' ,`ListOfficeName` = 'Douglas Elliman Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.757255' ,`Longitude` = '-95.512533' ,`PhotoCount` = '13' ,`PostalCode` = '77024' ,`RoomCount` = '12' ,`ListPrice` = '5495000.00' ,`Status` = 'Active' ,`StreetName` = 'Tyne' ,`StreetNumber` = '11206' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '6' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '6980' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THE EPITOME OF LUXURY LIVING. A magnificent and exquisite Modern New Built Masterpiece combines quality finishes, effortless elegance & marked with sophisticated touches. Stunning Interior. Regal reception with elegant formals showcasing double height ceiling spaces. Dining Rm with Wine closet & Lg windows overlooking front yard. Thoughtful layout. Perfectly proportioned floor-plan with integrated living & entertaining spaces. Large windows w/natural light radiating throughout. Gourmet kitchen with custom cabinetry & superior finishes. First floor primary suite w/spacious walk-in dressing area and a fully outfitted, spa-like lavish primary bath. Second floor features large game room & four additional secondary bedrooms. ELEVATOR SHAFT. Home rests on a gorgeous lot with towering trees & spectacular views in a prime quiet Piney Point village. The perfect home with a combination of luxury living & custom vision that so many buyers desire. Never flooded (Per Seller).' ,`Acres` = '' ,`Area` = '23' ,`BuilderName` = 'Blue Kite Building' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 74 BLK 4 TYNEWOOD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '38169' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'MEMORIAL DRIVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Tynewood' ,`TaxAmount` = '27887' ,`TaxRate` = '2.1721' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705950' WHERE `Matrix_Unique_ID` = '206894633' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T12:08:10.093' ,`MLSNumber` = '70595592' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'JR Shipp' ,`SellingOfficeName` = 'JLA Realty' ,`Latitude` = '30.258217' ,`Longitude` = '-95.523857' ,`PhotoCount` = '9' ,`PostalCode` = '77384' ,`RoomCount` = '5' ,`ListPrice` = '451290.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Big Sky' ,`StreetNumber` = '13309' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2621' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New MODERN SERIES DR Horton home! Beautiful one story home with a 2 car garage. This new construction home features gorgeous brick exterior! Features include SS Appliances, Quartz Countertops and 42\" flat cabinets in Kitchen, Separate Shower, Built-In Home Automation, Solid Surface Flooring throughout, Tankless Water Heater, Covered Patio, and Full Sprinkler System. Fosters Ridge offers beautiful community center, playground and pool! Zoned to The Woodlands Schools! DR Horton is America\'s #1 Homebuilder! Come out to Fosters Ridge and make this new home yours today!' ,`Acres` = '0.1722' ,`Area` = '15' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S516422 - FOSTERS RIDGE 22, BLOCK 1, LOT 21' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7501' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Fosters Ridge 22' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705950' WHERE `Matrix_Unique_ID` = '207244501' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T13:58:16.433' ,`MLSNumber` = '31556764' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Rena Malinowski' ,`SellingOfficeName` = 'Walzel Properties' ,`Latitude` = '30.237918' ,`Longitude` = '-95.705408' ,`PhotoCount` = '13' ,`PostalCode` = '77354' ,`RoomCount` = '4' ,`ListPrice` = '308490.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'PRICKLY PEAR COVE' ,`StreetNumber` = '14903' ,`StreetSuffix` = '' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1868' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exceptional 1 story 4 Bedroom Express Home on an Oversized Lot!! Open Concept plan with Kitchen open to huge family room & dining room! Primary suite offers an oversized walk in closet and spa like bath retreat!! Features include 30\" Flat panel maple cabinets w/crown molding, exotic granite, and 4 burner gas cooktop w/SS appliances! Also offers smart home system, full sprinklers, front & back sod, fully front landscape, tankless water heater, LED lighting and more! Large covered patio overlooks the fenced backyard! Call us today to schedule your showing!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Mill Creek Estates 02, BLOCK 2, Lot 24' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6930' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mill Creek' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705950' WHERE `Matrix_Unique_ID` = '207518881' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T12:57:05.187' ,`MLSNumber` = '40826542' ,`ListAgentFullName` = 'Linda Landrum' ,`ListOfficeName` = 'RE/MAX Leading Edge' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.290463' ,`Longitude` = '-94.798580' ,`PhotoCount` = '17' ,`PostalCode` = '77550' ,`RoomCount` = '3' ,`ListPrice` = '349000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue O 1/2' ,`StreetNumber` = '3027' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '954' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Historical home built in 1907 offering 2 bedrooms and 1 full bath. 5 blocks to the beach. Great location between Avenue O & Avenue P for quick access around town. High elevation w/ ground level enclosed - currently tantum garage with shop area. The space is as large as the upstairs living space and could possibly be built out - check with city. Original Wood flooring throughout. Cast iron tub/shower with tile surround in bath. Kitchen recently updated with Marble counter tops and porcelain backsplash in a warm deco pattern. Versace wallpaper in kitchen. Stenciled design on bathroom wall, and entry way. All plumbing fixtures inside the house were replaced. Kitchen sink replaced. Recently painted interior/exterior. Several light fixtures and ceiling fan in living area were replaced. House located on a corner lot, fenced backyard with Pear tree. Iron fence in front with beautiful old gate from the Rosenburg library added. Owner is a Texas Real Estate Broker. Flood policy $600 year. ' ,`Acres` = '0.0426' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Owner/Agent,Sellers Disclosure,Special Addendum,Tenant Occupied' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOT 1 & W 1/2 OF LOT 2 (2001-1) SW B' ,`LotDesciption` = 'Corner' ,`LotSize` = '1856' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Galveston Outlots' ,`TaxAmount` = '4068' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1907' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663705950' WHERE `Matrix_Unique_ID` = '208068257' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T12:05:19.230' ,`MLSNumber` = '46161010' ,`ListAgentFullName` = 'Shelley Munday' ,`ListOfficeName` = 'Doug Erdy Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.105270' ,`Longitude` = '-95.302102' ,`PhotoCount` = '39' ,`PostalCode` = '77365' ,`RoomCount` = '12' ,`ListPrice` = '885000.00' ,`Status` = 'Active' ,`StreetName` = 'Cabango' ,`StreetNumber` = '19278' ,`StreetSuffix` = 'Drive' ,`City` = 'Porter' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '3903' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous LAKEFRONT Property, with SCENIC views on 2.13 acres in the Fabulous RIVERWALK Community. This home offers 5 Bedrooms, 4 Full baths with 2.5 half baths. All rooms are down with the exception of the media room being up with a large BALCONY off the MEDIA room, great spot to watch the neighborhood 4th of July Firework show. BREATHTAKING views from inside looking out. Kitchen is a chefs delight, with a large island, custom cabinets, walk-in pantry, wine fridge tons of built-ins, opens up to the living room, Large STUDY and Formal Dining off the Foyer, Primary Bedroom has private entry to your outside covered patio, OUTDOOR KITCHEN. Luxurious Primary Bath, with his and her vanity, custom closet details, bedrooms are a great size with walk-in closets and own bathroom, one bedroom has its own private entry to and from the Garage, great for a mother in-law suite. So much to mention in this custom home!! You must see in person!. Roof Replaced 2021. MOTIVATED Sellers.' ,`Acres` = '2.13' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S834903 - RIVERWALK 03, BLOCK 3, LOT 45, 46, ACRES 2.13' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View,Waterfront,Wooded' ,`LotSize` = '92783' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'SORTERS MILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Mediterranean,Ranch,Traditional' ,`Subdivision` = 'Riverwalk' ,`TaxAmount` = '11965' ,`TaxRate` = '2.1331' ,`WaterSewer` = 'Aerobic,Septic Tank' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705951' WHERE `Matrix_Unique_ID` = '208364127' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T13:46:54.097' ,`MLSNumber` = '12481313' ,`ListAgentFullName` = 'April Maki' ,`ListOfficeName` = 'Gehan Homes Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.538964' ,`Longitude` = '-96.288516' ,`PhotoCount` = '16' ,`PostalCode` = '77845' ,`RoomCount` = '5' ,`ListPrice` = '524990.00' ,`Status` = 'Active' ,`StreetName` = 'Portland' ,`StreetNumber` = '2718' ,`StreetSuffix` = 'Avenue' ,`City` = 'College Station' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2482' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your new home awaits in the master-planned community of Castlegate II, located in the growing South College Station area. The stunning Tulane Floor Plan has it ALL! It is a 2,482 sqft 1-story home offering 3 bedrooms, 2.5 baths, STUDY & 2-car garage! The gorgeous kitchen features an oversized island, lots of cabinet space, soaring ceilings & overlooks the the family room. The primary bath has an oversized tub, walk-in shower with double sinks. The MASSIVE closet is a sight to see! Come out today and see this gorgeous home for yourself!' ,`Acres` = '' ,`Area` = '61' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6 Block 46 Section 208' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8855' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '153 - College Station' ,`SchoolElementary` = 'SPRING CREEK ELEMENTARY SCHOOL (College Station)' ,`SchoolHigh` = 'COLLEGE STATION HIGH SCHOOL' ,`SchoolMiddle` = 'WELLBORN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Castlegate II' ,`TaxAmount` = '' ,`TaxRate` = '2.26' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705951' WHERE `Matrix_Unique_ID` = '208600006' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T13:13:26.417' ,`MLSNumber` = '79062287' ,`ListAgentFullName` = 'Armando Espinosa Jr' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.783966' ,`Longitude` = '-95.383152' ,`PhotoCount` = '17' ,`PostalCode` = '77009' ,`RoomCount` = '9' ,`ListPrice` = '525000.00' ,`Status` = 'Active' ,`StreetName` = 'Byrne' ,`StreetNumber` = '928' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '928' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fabulous find in the Heart of the Heights! 3 SEPARATE PROPERTIES for the price of one! The front traditional cottage houses 2 bedrooms, 1 full bath plus a living room, kitchen and washer/dryer connections. The 2 additional apartment units located on the back of the property each have their own kitchen and full bath with a shared laundry room. 5,000 sq ft lot perfect to build new construction of property. *Never Flooded\r\n\r\nPlenty of parking as well! Excellent walk score to get to White Oak venues, Greater Heights Eateries\r\n\r\nVirtual Tour Uploaded' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Space Heater' ,`HOAMandatory` = '0' ,`Legal` = 'LT 7 BLK 1 RIDGEMONT SEC 1' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman,Traditional' ,`Subdivision` = 'Ridgemont Sec 01' ,`TaxAmount` = '10905' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705951' WHERE `Matrix_Unique_ID` = '208710155' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T13:16:25.810' ,`MLSNumber` = '13634193' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = 'Nick Hughey' ,`SellingOfficeName` = 'Stanfield Properties' ,`Latitude` = '29.435402' ,`Longitude` = '-95.441353' ,`PhotoCount` = '34' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '337990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Truckee River' ,`StreetNumber` = '1262' ,`StreetSuffix` = 'Drive' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'D.R. Horton, America\'s #1 Builder since 2002! This NEW CONSTRUCTION Easton Plan with Elevation T, their NEWEST modern design offers 4 spacious bedrooms and 2 bathrooms, covered patio, a 2-car garage and no back neighbors! This 4-sided brick, STUNNING home with open concept has an expansive kitchen which includes granite countertops, 42\" cabinets, large breakfast bar and stainless steel appliances including gas range, microwave and dishwasher. As you walk into the Primary bathroom, you will see dual sinks, oversized shower, soaker tub (on select inventory) and a large walk-in closet! Water resistant vinyl flooring, 2\" blinds and a tankless water heater are all included! Did we mention the Smart Home Technology that\'s included?! Security System with prewired locations for more Smart Technology! Location, Location, Location - right off 288 and close to downtown! Sierra Vista also has amenities for all ages - enjoy the NEW Island Amenity Village!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton, Inc.' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Sierra Vista Lot 14 Block 4 Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6958' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.6' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705951' WHERE `Matrix_Unique_ID` = '208992778' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T13:06:47.713' ,`MLSNumber` = '95005303' ,`ListAgentFullName` = 'Lily Ling' ,`ListOfficeName` = 'Lily H. Ling, REALTOR' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.568456' ,`Longitude` = '-95.560215' ,`PhotoCount` = '20' ,`PostalCode` = '77459' ,`RoomCount` = '8' ,`ListPrice` = '378000.00' ,`Status` = 'Active' ,`StreetName` = 'Talia Wood' ,`StreetNumber` = '3519' ,`StreetSuffix` = 'Court' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2410' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Very conveniently located along Highway 6 and FM 1092/Murphy/University Blvd. Walking distance to two parks as well as Krogers, Target, Lowes, and other shops and restaurants. Rare floorplan of 3 out of the 4 bedroom suites( master bath and Hollywood bath between 2nd and 3rd bedroom) + study+ powder room are ALL ON 1ST FLOOR. Game room + 4th bedroom suite are on 2nd floor. Gorgeous stucco/stone/brick exterior. Lush landscaping. Corner lot. Built in 2015 close by Quail Valley Gulf club. Open and high ceiling. red oak hardwood. marble backsplash. custom cabinets. nice countertop. Chandeliers, Porcelain tiles. Pre-wired security. Energy Star. exterior gas connection in back yard close to back door. Samsung refrigerator, washer and dryer will stay. If you like to have a one story home with extra space upstairs, This house will be your best option. This Property and entire neighborhood (Talia Wood) did not flood in Harvey.' ,`Acres` = '0.1018' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TALIA WOOD PATIO HOMES, BLOCK 2, LOT 13' ,`LotDesciption` = 'Corner' ,`LotSize` = '4435' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'QUAIL VALLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'QUAIL VALLEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Talia Wood Patio Homes' ,`TaxAmount` = '6249' ,`TaxRate` = '2.33' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705951' WHERE `Matrix_Unique_ID` = '209164775' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T13:47:07.013' ,`MLSNumber` = '61736045' ,`ListAgentFullName` = 'Melissa Christ' ,`ListOfficeName` = 'Zane Anderson Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.921054' ,`Longitude` = '-95.274023' ,`PhotoCount` = '40' ,`PostalCode` = '75862' ,`RoomCount` = '5' ,`ListPrice` = '1095000.00' ,`Status` = 'Active' ,`StreetName` = 'Aztec Road' ,`StreetNumber` = '542' ,`StreetSuffix` = '' ,`City` = 'Trinity' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Do you want privacy, gorgeous lake views and a home that makes your feel like you are on vacation year round? This Lakefront home on lake Livingston offers stunning waterfront views, privacy and updated finishes for you to enjoy. You will appreciate the impressive views of the lake from the living room. The kitchen and expansive island are ready for you to spread out & prepare meals for family and friends. This 5 bedroom home with over 5500 sq. ft. has so much to offer that words are not enough to describe this one a kind property. There are four bedrooms downstairs. Two of the guest rooms share a jack/jill bathroom. Another guest bedroom has its own en-suite bathroom with water views. The main bedroom is very spacious and large with its own en-suite bathroom and large closet. This house has three full bathrooms, two 3/4 bathrooms and a large 1/2 bath. Additionally, this home has been completely updated including a new 50 year roof and all new AC. Home may also be leased for $4900/mo.' ,`Acres` = '0.83' ,`Area` = '42' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0258 HADLEY, KING,TRACT 09,.83 ACRES' ,`LotDesciption` = 'Waterfront,Wooded' ,`LotSize` = '36154' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (TRINITY)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'TRINITY E1' ,`TaxAmount` = '5810' ,`TaxRate` = '1.8863' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663705951' WHERE `Matrix_Unique_ID` = '209255257' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T13:39:24.790' ,`MLSNumber` = '34349009' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.405875' ,`Longitude` = '-95.059823' ,`PhotoCount` = '33' ,`PostalCode` = '77568' ,`RoomCount` = '10' ,`ListPrice` = '306088.00' ,`Status` = 'Active' ,`StreetName` = 'Dalvay Beach' ,`StreetNumber` = '13306' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1605' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CHARMING 1 STORY COLINA HOME WITH 1605 SQUARE FEET, OPEN CONCEPT-4 BEDROOM, 2 BATH HOME WITH LEVEL 2 GRANITE KITCHEN COUNTERTOPS, BUILDER\'S CHOICE LEVEL 3 -42\' CABINETS WITH CROWN MOULDING, LEVEL 3 KITCHEN BACKSPLASH, 9\' SINGLE BOWL KITCHEN SINK, STAINLESS STEEL APPLIANCES WITH 5 BURNER GAS STOVE, VINYL FLOORING EVERYWHERE EXCEPT BEDROOMS, BUILT IN TAEXX PEST CONTROL, RINNAH TANKLESS WATER HEATER, FRONT GUTTERS, PEX PLUMBING, LENNOX SEER 16 A/C, BACK COVERED PORCH, CORDLESS FAUX WOOD BLINDS THROUGHOUT, 2ND SINK IN MASTER BATH, BUILT IN SHELVES IN MASTER CLOSET, IN NEWEST COLINA HOMES SECTION, ANTICIPATED COMPLETION DATE IS DECEMBER.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 21 Block 2 Section 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5400' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1330' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.55' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705951' WHERE `Matrix_Unique_ID` = '209261927' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T13:37:03.970' ,`MLSNumber` = '11903969' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.405826' ,`Longitude` = '-95.059814' ,`PhotoCount` = '28' ,`PostalCode` = '77568' ,`RoomCount` = '7' ,`ListPrice` = '333505.00' ,`Status` = 'Active' ,`StreetName` = 'Stonewater Cove' ,`StreetNumber` = '2313' ,`StreetSuffix` = '' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1759' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BRAND NEW COLINA HOME- 1 STORY OFFERS 4 BEDROOMS, 3 FULL BATHS, OPEN CONCEPT INCLUDES UPGRADED 42\" KITCHEN CABINETS WITH CROWN MOLDING; UPGRADED KITCHEN GRANITE COUNTERTOPS; VINYL PLANK FLOORING EVERYWHERE EXCEPT BEDROOMS; SINGLE 9\" KITCHEN SINK; BUILT IN TAEXX PEST CONTROL; FRONT GUTTERS, PEX PLUMBING; 16 SEER LENNOX A/C; BACK COVERED PORCH; RINNAI TANKLESS WATER HEATER; CORDLESS FAUX WOOD BLINDS, DOUBLE SINKS IN MASTER BATH AND MUCH MORE! CUL-DE-SAC HOME SITE WITH NO BACK NEIGHBORS!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 40 Block 1 Section 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7400' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1330' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '2.48' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705951' WHERE `Matrix_Unique_ID` = '209533158' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T13:08:55.580' ,`MLSNumber` = '16575610' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.057479' ,`Longitude` = '-95.502313' ,`PhotoCount` = '15' ,`PostalCode` = '77379' ,`RoomCount` = '6' ,`ListPrice` = '442900.00' ,`Status` = 'Active' ,`StreetName` = 'Brookway Willow' ,`StreetNumber` = '5323' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '3577' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '6 bedrooms 3 1/2 baths and a two car garage with an Austin stone arched covered front porch and a covered back porch in Senterra Lakes! High ceilings in the living room with a gas log cast stone fireplace. New LVP throughout the main floors. Flexible plan with four bedrooms up and the master with a secondary bedroom down or this room would be a great office. This home has a game room and a separate media room. New interior paint throughout and new carpet in all bedrooms and upstairs. The kitchen has granite counters and new stainless steel appliances and includes a fridge. Fenced in yard with covered patio area available. Senterra Lakes is located in a popular area of Spring. It offers its residents a natural pond and 4 retention ponds with catch and release fishing, walking paths, two tennis courts, playground, pool and clubhouse. Move in ready!' ,`Acres` = '0.1825' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 4 SENTERRA LAKES SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '7951' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KUEHNLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KRIMMEL INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Senterra Lakes' ,`TaxAmount` = '7749' ,`TaxRate` = '2.5965' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705952' WHERE `Matrix_Unique_ID` = '209558280' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T12:26:13.860' ,`MLSNumber` = '82840734' ,`ListAgentFullName` = 'Yvonne Bonner-Holley' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.798935' ,`Longitude` = '-95.326171' ,`PhotoCount` = '22' ,`PostalCode` = '77026' ,`RoomCount` = '2' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Wayne' ,`StreetNumber` = '4209' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '4194' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The property is currently being used as a church. Located on a 15K square foot lot with Parking.' ,`Acres` = '0.3489' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 10 BLK 1 KASHMERE GARDENS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ISAACS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'FLEMING MIDDLE SCHOOL' ,`ShowInstructions` = 'Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Kashmere Gardens' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705952' WHERE `Matrix_Unique_ID` = '209575947' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T12:36:32.130' ,`MLSNumber` = '51576041' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.004000' ,`Longitude` = '-95.795690' ,`PhotoCount` = '6' ,`PostalCode` = '77447' ,`RoomCount` = '4' ,`ListPrice` = '360640.00' ,`Status` = 'Active' ,`StreetName` = 'Mersmann Ridge' ,`StreetNumber` = '16015' ,`StreetSuffix` = 'Drive' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1748' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction One Story 4 Bed/2 Bath, 1,748 sq. ft with 2 Car Garage! This Open Concept home has a beautiful kitchen open to the dining open and a huge living room! Primary bathroom suite with separate soaking tub and shower offers a walk in closet! Features include 36\" Flat panel maple cabinets, exotic granite, 4 burner gas cooktop w/stainless steel appliances, tile wall surrounds in bathrooms, smart home system, full sprinklers, front & back sod, fully front landscape, tankless water heater, LED lighting and more! Large covered patio overlooks the PRIVATE backyard! Call us today to schedule your showing!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '16/3/12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Stone Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705952' WHERE `Matrix_Unique_ID` = '209617001' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T12:25:25.270' ,`MLSNumber` = '30140377' ,`ListAgentFullName` = 'Susan Lerner' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819936' ,`Longitude` = '-95.678370' ,`PhotoCount` = '34' ,`PostalCode` = '77084' ,`RoomCount` = '10' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Zephyr Glen' ,`StreetNumber` = '3530' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2390' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wow! This 4/2.1/2 comes with so many extras that will improve your comfort and lifestyle! Primary bedroom on first floor, with a spacious bathroom that includes a double sink vanity, tub and separate shower, and a large walk-in closet. Generous sized game room up. One upstairs bedroom could be a second primary bedroom. It has direct access to the bathroom and an oversized walk-in closet. This home includes: Fully paid for solar panels, whole house water softening filtration, reverse osmosis water system at kitchen sink, added air filtration with 2 media filters installed at air handler in attic, ceiling fans, insulated garage with portable AC unit (think exercise-workout room or comfortable workshop space). Engineered wood flooring in all 3 upstairs bedrooms, and vinyl plank and tile on first floor. Carpet on stairs and in game room only. Washer, dryer, and refrigerator come with the home, too! Low taxes - 2.487. Never flooded. Don\'t miss out on this opportunity at a great price!' ,`Acres` = '0.1157' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 4 BARKERS CROSSING SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5040' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '385' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'SCHMALZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MAYDE CREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Barkers Xing Sec 04' ,`TaxAmount` = '5212' ,`TaxRate` = '2.487' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705952' WHERE `Matrix_Unique_ID` = '210084700' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T12:45:05.910' ,`MLSNumber` = '43519330' ,`ListAgentFullName` = 'Allison Yancy' ,`ListOfficeName` = 'Compass RE Texas, LLC- Lake Conroe' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.977361' ,`Longitude` = '-95.477229' ,`PhotoCount` = '18' ,`PostalCode` = '77014' ,`RoomCount` = '4' ,`ListPrice` = '159900.00' ,`Status` = 'Active' ,`StreetName` = 'Farlan' ,`StreetNumber` = '3806' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '888' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'INVESTOR\'S SPECIAL!! This 2 bedroom, 1 bath home is looking for some TLC. This home would make a great investment and is priced to sell quickly. There are 2 bedrooms and one full bath with a tub/shower combo. Spacious living room with high ceilings. The kitchen does have a gas range and pantry. Sliding glass doors lead to the expansive back yard that is partially fenced. Washer/dryer hook up\'s are in the garage. Located in a mature neighborhood with area pools and just minutes to restaurants, I-45, IAH and so much more. AS-IS.' ,`Acres` = '0.1061' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 73 BLK 3 SABLECHASE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4620' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'BENEKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sablechase Sec' ,`TaxAmount` = '3085' ,`TaxRate` = '2.8817' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705952' WHERE `Matrix_Unique_ID` = '210088689' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T13:15:29.513' ,`MLSNumber` = '9575531' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.069720' ,`Longitude` = '-95.426108' ,`PhotoCount` = '15' ,`PostalCode` = '77373' ,`RoomCount` = '4' ,`ListPrice` = '357900.00' ,`Status` = 'Active' ,`StreetName` = 'Sarah Springs' ,`StreetNumber` = '25807' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2555' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This wonderful 1 story brick home is ready for your family to move into! Mature landscaping in the front yard. Formal dining room. Living room with built in fireplace. Updated kitchen & bathrooms. The kitchen features white cabinets, breakfast bar, granite countertops and SS gas cooktop, oven, microwave & dishwasher. Large master bedroom has sitting area and ensuite bath with dual vanities, jetted tub & walk-in shower. Tile floor through out. No back neighbors. Backyard with covered walkway from the garage to the house. Located in a gated community that features pool, 3 Lakes, Tennis courts, sand volleyball and more. Located close to I45 for quick access to local restaurants and shopping centers. Lots of room for your family. Come see today!' ,`Acres` = '0.2087' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 2 SPRING LAKES SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9093' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '770' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'SALYERS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'SPRINGWOODS VILLAGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Lakes' ,`TaxAmount` = '7325' ,`TaxRate` = '2.9067' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705952' WHERE `Matrix_Unique_ID` = '210124767' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T13:31:56.967' ,`MLSNumber` = '45929385' ,`ListAgentFullName` = 'Vinod Ramani' ,`ListOfficeName` = 'Urban Living' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.772728' ,`Longitude` = '-95.322560' ,`PhotoCount` = '11' ,`PostalCode` = '77020' ,`RoomCount` = '9' ,`ListPrice` = '369990.00' ,`Status` = 'Active' ,`StreetName` = 'Market' ,`StreetNumber` = '4706' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1955' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'In the flourishing area of East Downtown lies Market Street. Market Street is walking distance from Midway\'s East River Project. These Single-Family homes offer Contemporary designs and hand selected finishes. Each home features an open concept living/dining/kitchen area perfect for urban lifestyle. This community features private driveways and large back yards.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Joes Construction' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 1 Block 1 N/A' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HENDERSON N ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'N/A' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705952' WHERE `Matrix_Unique_ID` = '210124967' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T12:41:30.290' ,`MLSNumber` = '33870266' ,`ListAgentFullName` = 'Kyle Watters' ,`ListOfficeName` = 'Exl Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.131632' ,`Longitude` = '-95.410262' ,`PhotoCount` = '36' ,`PostalCode` = '77386' ,`RoomCount` = '7' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Creston' ,`StreetNumber` = '1938' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2380' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! Located on a corner lot in Imperial Oaks, this 3 bedroom, 2 bath has a recently updated downstairs (2021), with the garage having been built out into a fourth bedroom, den, or game room. Kitchen has been recently updated with new cabinets, floors, and countertops, along with new appliances throughout. Two bedrooms upstairs share a full bath with two balconies, one in the front and one in back of the house. 32 windows throughout this home give ample natural lighting, with plenty of privacy from the landscaping and backyard fencing. The backyard features a beautiful sparkling pool with a new pump installed in 2021. Thanks for showing!' ,`Acres` = '0.2009' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'IMPERIAL OAKS 03, BLOCK 15, LOT 37' ,`LotDesciption` = 'Corner,Subdivision Lot,Wooded' ,`LotSize` = '8750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'KAUFMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Oaks 03' ,`TaxAmount` = '4780' ,`TaxRate` = '2.4827' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705953' WHERE `Matrix_Unique_ID` = '210422992' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T13:23:35.827' ,`MLSNumber` = '96227897' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.537376' ,`Longitude` = '-95.062394' ,`PhotoCount` = '13' ,`PostalCode` = '77573' ,`RoomCount` = '3' ,`ListPrice` = '415000.00' ,`Status` = 'Active' ,`StreetName` = 'Teal Shore' ,`StreetNumber` = '2435' ,`StreetSuffix` = 'Court' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1858' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming one-story and gated South Shore Harbour community. The home located in a premium corner lot and the Cul De Sac for additional street parking and privacy. Stunning pool with beautiful landscaping. New roof. Fresh interior paint. LVP flooring throughout living areas and kitchen. New carpets installed in all bedrooms. The kitchen features a granite countertop and an island with all new appliances (Microwave, wall oven, dishwasher, cooktop). Large backyard with exterior brick walls and two private metal gates. Super clean and move-in ready. Conveniently located close to South Shore Harbour Country Club. Quick access to Kemah Boardwalk and Space Center.' ,`Acres` = '0.1894' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 18 PAGE 5 LOT 11 BLK 2 SOUTH SHORE HARBOUR SEC 15' ,`LotDesciption` = 'Corner' ,`LotSize` = '8249' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '535' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'FERGUSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CLEAR CREEK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'South Shore Harbour' ,`TaxAmount` = '6270' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705953' WHERE `Matrix_Unique_ID` = '210456045' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T12:27:26.150' ,`MLSNumber` = '58598056' ,`ListAgentFullName` = 'Jeannie Jacobs' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.698706' ,`Longitude` = '-95.457626' ,`PhotoCount` = '13' ,`PostalCode` = '77401' ,`RoomCount` = '15' ,`ListPrice` = '1795000.00' ,`Status` = 'Active' ,`StreetName` = 'Evergreen' ,`StreetNumber` = '4620' ,`StreetSuffix` = 'Street' ,`City` = 'Bellaire' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '4515' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction custom built home by Venn Builders in the heart of Bellaire. Estimated completion date is Winter 2022. This stunning home boasts an open concept floor plan with floor to ceiling windows. The first level of the home offers an inviting fireplace and captivating chef\'s kitchen with a massive pantry and wine closet. Outside, you will discover a beautiful alfresco patio space. Premium appliances and finishes throughout enhance the luxurious design of the property. The second level exhibits a grand primary suite with an expansive walk in closet and gorgeous primary bath oasis. As well as secondary bedrooms, laundry room and more space for entertainment.' ,`Acres` = '0.194' ,`Area` = '17' ,`BuilderName` = 'VENN BUILDERS' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bellaire Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 27 BLK 2 CEDAR OAKS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8450' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HORN ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Cedar Oaks' ,`TaxAmount` = '' ,`TaxRate` = '2.2271' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705953' WHERE `Matrix_Unique_ID` = '210667948' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T13:28:03.143' ,`MLSNumber` = '78295832' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.232054' ,`Longitude` = '-95.577266' ,`PhotoCount` = '12' ,`PostalCode` = '77354' ,`RoomCount` = '4' ,`ListPrice` = '358000.00' ,`Status` = 'Active' ,`StreetName` = 'Woodland Oaks' ,`StreetNumber` = '6807' ,`StreetSuffix` = '' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2255' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful home is ready for your family to move into with four bedrooms, 2 1/2 baths, two car garage on a large lot with an additional larger storage building and a covered front porch. Enter into the living room with lots of natural lighting. The kitchen has new granite countertops, and stainless steel gas range, microwave and dishwasher. Tile throughout the 1st floor with new carpet on the second floor. New interior paint throughout. Some updated fixtures. All bedrooms upstairs. Large backyard with firepit for family evening time. Roof replaced in 2021 (per previous owner). Come by today!' ,`Acres` = '0.2755' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WOODLAND OAKS, BLOCK 6, LOT 129' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '365' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'TOM R. ELLISOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodland Oaks' ,`TaxAmount` = '4233' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705953' WHERE `Matrix_Unique_ID` = '210724879' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T12:42:57.400' ,`MLSNumber` = '482099' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.841742' ,`Longitude` = '-94.989159' ,`PhotoCount` = '18' ,`PostalCode` = '77521' ,`RoomCount` = '9' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Kingston Liberty' ,`StreetNumber` = '9823' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1932' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BRAND NEW LENNAR Community - STERLING POINT!!! New Lennar Wildflower II Collection Homes in Sterling Point! The Clover II, brick Elevation \"B\" is a single-story home that showcases a generous open floorplan shared between the family room, dining room and kitchen, leading directly to a covered patio for seamless indoor-outdoor living. A flex room off the foyer is perfect as a home office or bonus room. Four bedrooms complete this home. \r\n**Estimated Completion Date, November 2022**' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0001 BLK 004 LOT 004' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'PUMPHREY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sterling Point' ,`TaxAmount` = '' ,`TaxRate` = '3.735' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705953' WHERE `Matrix_Unique_ID` = '210777184' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T12:07:48.490' ,`MLSNumber` = '47981869' ,`ListAgentFullName` = 'Jennifer Hernandez' ,`ListOfficeName` = 'C. E. Muegge Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.204003' ,`Longitude` = '-96.274522' ,`PhotoCount` = '17' ,`PostalCode` = '77437' ,`RoomCount` = '9' ,`ListPrice` = '150000.00' ,`Status` = 'Active' ,`StreetName` = 'Washington' ,`StreetNumber` = '901' ,`StreetSuffix` = 'Street' ,`City` = 'El Campo' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1498' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 bedroom 2 bath home in El Campo city limits on a corner lot. Home has 2 bedroom with a guest suite/3rd Bedroom with its own bathroom.. Washroom has plenty of room for extra storage. Storage unit in backyard is included in the sale. Just waiting for your personal touch!' ,`Acres` = '0.4821' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'DUSON BLOCK 6 LOT 4,5,6' ,`LotDesciption` = 'Other' ,`LotSize` = '21000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '198 - El Campo' ,`SchoolElementary` = '' ,`SchoolHigh` = 'EL CAMPO HIGH SCHOOL' ,`SchoolMiddle` = 'EL CAMPO MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Duson' ,`TaxAmount` = '3196' ,`TaxRate` = '2.4815' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705953' WHERE `Matrix_Unique_ID` = '210808872' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T13:57:31.540' ,`MLSNumber` = '42691970' ,`ListAgentFullName` = 'Sarah Underwood' ,`ListOfficeName` = 'Oro Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.346355' ,`Longitude` = '-96.653399' ,`PhotoCount` = '45' ,`PostalCode` = '77879' ,`RoomCount` = '2' ,`ListPrice` = '515000.00' ,`Status` = 'Active' ,`StreetName` = 'Houston' ,`StreetNumber` = '700' ,`StreetSuffix` = 'Avenue' ,`City` = 'Somerville' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1408' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for a beautiful Texas cabin located in close proximity to lake Somerville? This is the one! This secluded 2.26 acre property features a custom built 2 bed 1.5 bath home, a 1 bed 1 bath full functioning guest apartment, a 3,200 sq ft shop with an additional 1000 sq ft of carport space. The house is plumbed with pex piping, fully insulated with spray foam insulation, all upgraded industrial electrical throughout, and equipped with a tankless on demand water heater. The property is set up with 400 amp service- 200 amp to the house and 200 amp to the shop. No detail was left out with this property! Come enjoy watching the wildlife from the beautiful front or back porch. NO HOA! Somerville is located approximately 30 minutes to a&m and 25 minutes to Brenham.' ,`Acres` = '2.2679' ,`Area` = '59' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S2513 H&G (POST OAK HILL) LOT 29,30,31 2.2679 ACRES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '98790' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '158 - Somerville' ,`SchoolElementary` = 'SOMERVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SOMERVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'SOMERVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'H & G Post Oak Hill' ,`TaxAmount` = '3052' ,`TaxRate` = '1.7844' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663705953' WHERE `Matrix_Unique_ID` = '210958045' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T12:44:48.673' ,`MLSNumber` = '43116791' ,`ListAgentFullName` = 'Allison Yancy' ,`ListOfficeName` = 'Compass RE Texas, LLC- Lake Conroe' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.383924' ,`Longitude` = '-95.638387' ,`PhotoCount` = '28' ,`PostalCode` = '77356' ,`RoomCount` = '7' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Bilsing' ,`StreetNumber` = '10519' ,`StreetSuffix` = 'Cove' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1672' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LAKE VIEWS from this single story home that offers 3 bedrooms, 2 full baths and 2 car attached garage. BRAND NEW carpet throughout the home with tile in the wet areas. The kitchen has granite counters, ample storage, electric range, microwave and eat-in breakfast area. The living room is spacious for all of your furnishings. The primary suite has carpet, walk-in closet and en-suite bathroom with dual sinks, jetted tub and shower. The secondary bedrooms are good size and share a full bathroom with tub/shower combo. My favorite feature is the screened in patio with 2 doors that lead to the fully fenced backyard. Enjoy the mature trees. Cape Conroe has an area park, pool and gated boat ramp. Close to all of your favorite restaurants, shopping and lake fun! Montgomery ISD. Call for a private showing.' ,`Acres` = '0.1588' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CAPE CONROE 02, BLOCK 12, LOT 17' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '6917' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '240' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cape Conroe' ,`TaxAmount` = '4650' ,`TaxRate` = '2.3542' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705954' WHERE `Matrix_Unique_ID` = '210975923' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T12:21:56.853' ,`MLSNumber` = '24546957' ,`ListAgentFullName` = 'Ashly Singletary' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.851479' ,`Longitude` = '-95.406099' ,`PhotoCount` = '15' ,`PostalCode` = '77091' ,`RoomCount` = '3' ,`ListPrice` = '249000.00' ,`Status` = 'Active' ,`StreetName` = 'Ishmeal' ,`StreetNumber` = '363' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1359' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is perfect for an investment property or a personal home. The kitchen, dining and living room are very open and has large window in front for natural light. Kitchen has a new electric range. Home has a large back yard for grilling and lots of room for playing. Please verify all room dimensions.' ,`Acres` = '0.198' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK 5 WILDROSE GARDENS SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8625' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WESLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Wildrose Gardens Sec 04' ,`TaxAmount` = '3202' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705954' WHERE `Matrix_Unique_ID` = '211073218' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T13:31:25.580' ,`MLSNumber` = '61658361' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.853456' ,`Longitude` = '-95.252163' ,`PhotoCount` = '10' ,`PostalCode` = '77078' ,`RoomCount` = '3' ,`ListPrice` = '164500.00' ,`Status` = 'Active' ,`StreetName` = 'Courben' ,`StreetNumber` = '9323' ,`StreetSuffix` = 'Circle' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '928' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home has great potential, perfect for the first-time home buyer or as an excellent investment property. Situated on an oversized cul-de-sac lot in the Wood Glen community in Northeast Houston. Adorable 3 bedroom, 1 bath home was recently updated with full interior/exterior new paint, new granite countertops in the kitchen and bath with new sinks and plumbing fixtures. New luxury vinyl plank flooring in the living, dining and kitchen and new carpet in the bedrooms. The stainless steel appliance package includes a new gas range, microwave and dishwasher. A white refrigerator is included. Centrally located with easy access to HWY 59, 610 and HWY 90 plus easy access to schools, shopping and parks. No Restrictions/HOA.' ,`Acres` = '0.1377' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 10 BLK 6 WOOD GLEN SEC 2' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HILLIARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wood Glen' ,`TaxAmount` = '2071' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705954' WHERE `Matrix_Unique_ID` = '211113697' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T12:59:28.177' ,`MLSNumber` = '76355551' ,`ListAgentFullName` = 'Rosalinda Sierra' ,`ListOfficeName` = 'Sierra Group Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.085387' ,`Longitude` = '-95.266270' ,`PhotoCount` = '50' ,`PostalCode` = '77365' ,`RoomCount` = '4' ,`ListPrice` = '437900.00' ,`Status` = 'Active' ,`StreetName` = 'N Plantation Estates' ,`StreetNumber` = '19875' ,`StreetSuffix` = '' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2725' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GORGEOUS ALL STUCCO WITH STONE ACCENTS HOME!! FEATURING 3 BEDROOMS AND ADDITIONAL OFFICE OR STUDY ROOM WITH 2 AND 1/2 BATHROOMS!!HIGH CEILINGS AND CROWN MOLDING TROUGH OUT THE HOME WITH RECESS LIGHTING!! HUGE ISLAND GRANITE KITCHEN WITH SOFT-CLOSING DRAWERS WITH STAINLESS STEEL APPLIANCES!! BEAUTIFUL CERAMIC TILE FLOORING, THE OWNERS RETREAT OFFERS A HUGE CLOSET SPACE, BEAUTIFUL FIREPLACE !!OUTSIDE GRILL PERFECT FOR ENTERTAINMENT WITH FRIENDS AND FAMILY!! MUST SEE THIS GEM!! IN A VERY QUITE neighborhood!! NO MUD TAX!! MUST SEE TO APPRECIATED ALL THE GOOD TASTE OF THIS BEAUTY!! STILL SMELLS LIKE NEW!! ONLY 2 YRS OLD!!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 44 BLOCK 2 Plantation Estates Sec 2' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'BROOKWOOD FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Plantation Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663705954' WHERE `Matrix_Unique_ID` = '211152662' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T12:25:55.530' ,`MLSNumber` = '51747479' ,`ListAgentFullName` = 'Ginger Salas' ,`ListOfficeName` = 'Homelove Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.036474' ,`Longitude` = '-95.231615' ,`PhotoCount` = '43' ,`PostalCode` = '77339' ,`RoomCount` = '9' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Walnut' ,`StreetNumber` = '1601' ,`StreetSuffix` = 'Lane' ,`City` = 'Kingwood' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3549' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning Forest Cove home has an incredible amount of character, is ideally located on over an acre within close proximity of Hwy 59, and is zoned to fantastic Kingwood schools! Home features contemporary design elements including living room with stone gas log fireplace and wet bar with refrigerator, kitchen with granite counters, double ovens, and a breakfast room large enough for a full dining table with walls of windows that overlook the back yard! There is an enormous game room with a half bath and a primary retreat with soaring ceilings, updated en suite bath with dual vanity, steam shower, and free standing tub! Secret door off living leads to large laundry room with a ton of storage! On the second floor, there are three ample secondary bedrooms, a full bath with dual vanity and separate shower, and a study! The garage/shop has plenty of room for 4 cars, has epoxy coating, and a workshop! The acre lot features a private tennis/basketball court, play structure, and garden!' ,`Acres` = '1.0191' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 33 FOREST COVE SEC 5 U/R' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '44390' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '170' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'FOSTER ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Forest Cove' ,`TaxAmount` = '12606' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705954' WHERE `Matrix_Unique_ID` = '211182694' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T13:00:20.433' ,`MLSNumber` = '6216725' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Newmark Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.565922' ,`Longitude` = '-95.746774' ,`PhotoCount` = '28' ,`PostalCode` = '77469' ,`RoomCount` = '9' ,`ListPrice` = '735000.00' ,`Status` = 'Active' ,`StreetName` = 'Masterson Garden' ,`StreetNumber` = '23742' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3485' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEWMARK HOMES\' new construction the Langford with 3 car garage has 20-foot ceilings in the entry, and family room. Double 8-foot entry doors and 1st floor 8-foot interior doors provide a large open main entry to an elegant curved staircase with wood floors throughout the main living areas. The kitchen features upgraded appliances and a large serving island. This four-bedroom house backs to green space and pond without near back neighbors. The exceptional Newmark Homes\' Langford has 2 beds down and 2 up each with private bath for 4 full baths and powder bath for guest' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Newmark Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Block 1' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '8773' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1095' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'PHELAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Veranda' ,`TaxAmount` = '' ,`TaxRate` = '3.17' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705954' WHERE `Matrix_Unique_ID` = '211322984' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T13:39:17.227' ,`MLSNumber` = '65250048' ,`ListAgentFullName` = 'John Prell' ,`ListOfficeName` = 'Creekview Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.697391' ,`Longitude` = '-95.536245' ,`PhotoCount` = '28' ,`PostalCode` = '77036' ,`RoomCount` = '8' ,`ListPrice` = '308460.00' ,`Status` = 'Active' ,`StreetName` = 'Redding' ,`StreetNumber` = '7414' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1710' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this beautiful renovated home in the much-desired subdivision of Sharpstown. This home has been completely rehabbed inside and out. Move in ready. The kitchen features new quartz countertops, new stainless steel appliances, deep sink, tile backsplash, refrigerator, and a new hardware throughout. Both restrooms feature quartz counters, new tiling, new sinks and hardware. The home boasts fresh paint inside and out, and modern light fixtures. New luxury vinyl throughout the house. No carpet at all in this home. This home is minutes away from parks, shopping, dining, and much more. Includes new washer, new dryer, and new refrigerator. This home has never flooded.' ,`Acres` = '0.1722' ,`Area` = '21' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sharpstown Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 53 BLK 58 SHARPSTOWN COUNTRY CLUB TERRACE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7502' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'NEFF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHARPSTOWN HIGH SCHOOL' ,`SchoolMiddle` = 'SUGAR GROVE MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Sharpstown Country Club Terrace 2' ,`TaxAmount` = '4411' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705955' WHERE `Matrix_Unique_ID` = '211350523' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T12:15:27.827' ,`MLSNumber` = '66159184' ,`ListAgentFullName` = 'Tami Christopher' ,`ListOfficeName` = 'Market Force Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.076957' ,`Longitude` = '-95.168296' ,`PhotoCount` = '25' ,`PostalCode` = '77345' ,`RoomCount` = '8' ,`ListPrice` = '279900.00' ,`Status` = 'Active' ,`StreetName` = 'Woodspring Forest' ,`StreetNumber` = '2702' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1957' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One story PULTE Belclaire! DREAM kitchen has GRANITE, cabinets with extra trim, upper and lower cabinet lighting, awesome subway tile backsplash. Breakfast Bar open to Living area. Fireplace log fireplace. MASTER SUITE has separate shower and double vanity. Sprinkler -PRIVATE PATIO - DOLLHOUSE.' ,`Acres` = '' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 3 WOODSPRING FOREST SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'HIDDEN HOLLOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodspring Forest Sec 2' ,`TaxAmount` = '4817' ,`TaxRate` = '2.86442' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705955' WHERE `Matrix_Unique_ID` = '211427710' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T13:12:57.737' ,`MLSNumber` = '27239340' ,`ListAgentFullName` = 'Kimberly Bowling' ,`ListOfficeName` = 'Front Real Estate Co - Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.317166' ,`Longitude` = '-94.936781' ,`PhotoCount` = '16' ,`PostalCode` = '77327' ,`RoomCount` = '5' ,`ListPrice` = '180000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 2800' ,`StreetNumber` = '39' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1484' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Low Taxes! Tarkington Schools. 4 Bedrooms 2 Baths. Cute, Cute, Cute.... Cottage style house in a quiet country location. Comes see this gem, it wont last long. Roof is brand new.' ,`Acres` = '0.6' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SPRING OAKS, LOT 8, ACRES .6' ,`LotDesciption` = 'Cleared' ,`LotSize` = '26136' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '102 - Tarkington' ,`SchoolElementary` = 'TARKINGTON PRIMARY SCHOOL' ,`SchoolHigh` = 'TARKINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'TARKINGTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Oaks' ,`TaxAmount` = '1973' ,`TaxRate` = '1.5226' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663705955' WHERE `Matrix_Unique_ID` = '211444743' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T13:55:00.673' ,`MLSNumber` = '12420161' ,`ListAgentFullName` = 'Rosa Ellenburg' ,`ListOfficeName` = 'R&G Property Services De Tejas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.558622' ,`Longitude` = '-95.291797' ,`PhotoCount` = '46' ,`PostalCode` = '77584' ,`RoomCount` = '10' ,`ListPrice` = '395000.00' ,`Status` = 'Active' ,`StreetName` = 'Sebastopol' ,`StreetNumber` = '4607' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2252' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come and see this splendid home situated in Pearland on a quiet cul-de-sac Corner lot, 4 bedrooms, 2 baths and 2 car garage, the entire home is Laminate wood, and Tile Flooring. NO CARPET!! great formal dining room, formal living room with fireplace, large Breakfast area and Kitchen, 42\' cabinet, granite counters, with island and breakfast bar overlooking the spacious family room. . This home is EXCELLENT for entertaining!' ,`Acres` = '0.1635' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PARKS AT WALNUT BEND SEC 1 (A0239 HT&BRR) , BLOCK 3, LOT 35' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7122' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '325' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'C J HARRIS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH EAST' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Parks At Walnut Bend Sec 1-2' ,`TaxAmount` = '7507' ,`TaxRate` = '2.8851' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705955' WHERE `Matrix_Unique_ID` = '211470717' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T13:51:27.500' ,`MLSNumber` = '52339935' ,`ListAgentFullName` = 'Monica Foster' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.483124' ,`Longitude` = '-95.158396' ,`PhotoCount` = '33' ,`PostalCode` = '77573' ,`RoomCount` = '12' ,`ListPrice` = '486000.00' ,`Status` = 'Active' ,`StreetName` = 'Cameron' ,`StreetNumber` = '6123' ,`StreetSuffix` = 'Court' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3467' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Situated on a terrific cul-de-sac street, this home has lots of energy efficient features and easy access to schools, shopping & restaurants! A terrific stone & brick elevation will front elevation will greet you each day. Once inside, notice the upgraded travertine tile flooring that adorns much of the first floor. The Study has pretty French doors and hardwood flooring, perfect for those who now work from home. The Kitchen boasts 42\'\' cabinetry, granite counters, new appliances, a butler\'s pantry & huge walk-in pantry. The Formal Dining Room is a great place for many a gathering. The Primary Bedrooms is spacious & has a bay window with room for a reading nook or work area. The ensuite bathroom features a jetted tub & separate, tiled shower, as well as double sinks & walk-in closet. Upstairs finds a roomy Gameroom & a Media Room, imagine the movie nights! 3 Generous Secondary Bedrooms are also found upstairs, one is ensuite. Out back has a covered patio & garden! Never flooded.' ,`Acres` = '0.1893' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WESTOVER PARK SEC 4 (2003) ABST 9, BLOCK 1, LOT 11, ACRES 0.' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8244' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '605' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'HALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westover Park' ,`TaxAmount` = '9527' ,`TaxRate` = '2.5697' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705955' WHERE `Matrix_Unique_ID` = '211485563' --> 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','211723731','1663705955','211723731','2022-09-02T13:48:05.123','97592256','Ciara Jarmon','DOSS Pros, LLC','','','29.805856','-95.418530','17','77008','4','699000.00','Active','22nd','1112','Street','Houston','4','1','4','2959','Single-Family','','0.0495','9','','','Electric Dryer Connections,Washer Connections','','No Disclosures,Sellers Disclosure','1','','1','Heights/Greater Heights','Central Electric','0','LT 6 BLK 1 VILLAS ON WEST 22ND STREET','Corner','2155','Appraisal District','','','0','','2','','0','','','','','Composition','27 - Houston','SINCLAIR ELEMENTARY SCHOOL (HOUSTON)','WALTRIP HIGH SCHOOL','HAMILTON MIDDLE SCHOOL (HOUSTON)','Appointment Required,Leave Business Card,Lockbox Back','Appraisal District','4','Contemporary/Modern','Villas/West 22nd Street','12563','2.3307','Public Sewer,Public Water','2016','Appraisal'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T12:04:36.610' ,`MLSNumber` = '28017833' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '29.836107' ,`Longitude` = '-95.772825' ,`PhotoCount` = '15' ,`PostalCode` = '77449' ,`RoomCount` = '6' ,`ListPrice` = '443390.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'San Leo' ,`StreetNumber` = '4230' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2594' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW MODERN DESIGN! This beautiful Two story home on a cul-da-sac!! Features an open concept with designer details at every corner!! Light and bright kitchen with an abundance of cabinet space, stainless steel appliances, under cabinet lighting, quartz countertops, and so much more!!! Beautiful hard surface flooring!! The Primary suite has quartz counter tops, double sinks and a separate shower and tub!! Huge game room!!! Smart Home Technology, fully landscaped front & back including sprinkler system. Tankless water heater. Garage door opener. Large covered back patio. 16-SEER A/C and SO MUCH MORE!' ,`Acres` = '0.1417' ,`Area` = '25' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 3 VENTANA LAKES EAST SEC 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6171' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BETHKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Ventana Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705955' WHERE `Matrix_Unique_ID` = '211730407' --> 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','211819113','1663705955','211819113','2022-09-02T13:06:58.160','10426192','Rick Lamar','Rick Lamar Real Estate, LLC','','','30.083230','-95.543025','36','77379','8','360000.00','Active','George Wayne','21539','Way','Spring','2','1','4','2571','Single-Family','This beautiful 4 bedroom, 2.5 bath 2-story home offers a spacious family room, a study/flex space, an open concept kitchen and dining area. It also features a secluded downstairs owners\' retreat with a large walk-in closet, a walk-in utility room with convenient garage access and an upstairs game room. Sale of playscape in back yard is negotiable (just purchased this summer). Home is in a cul-de-sac with oversized back yard.','0.2864','14','','','Gas Dryer Connections','','Exclusions,Mud,Sellers Disclosure','1','','','Spring/Klein/Tomball','Central Electric','1','LT 23 BLK 4 WILLOW TRACE SEC 1','Subdivision Lot','12476','Appraisal District','','730','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','32 - Klein','SCHULTZ ELEMENTARY SCHOOL','KLEIN OAK HIGH SCHOOL','KRIMMEL INTERMEDIATE SCHOOL','Appointment Required,Request Online Appointment,Supra Keybox','Appraisal District','2','Traditional','Willow Trace Sec 1','7053','2.8765','Water District','2012','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T12:27:06.637' ,`MLSNumber` = '47123196' ,`ListAgentFullName` = 'Ace Hernandez' ,`ListOfficeName` = 'Manor Lane Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.585663' ,`Longitude` = '-95.775945' ,`PhotoCount` = '20' ,`PostalCode` = '77469' ,`RoomCount` = '6' ,`ListPrice` = '210000.00' ,`Status` = 'Active' ,`StreetName` = 'Pultar' ,`StreetNumber` = '601' ,`StreetSuffix` = 'Road' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful home in a small town with the benefits of a new home! Well, you just found yourself a cozy 4 bedroom, 2 bathroom home. This home features ceramic tile, no carpet, custom cabinets, lots of closet space and built-ins. Detailed, recessed ceiling in living room and excellent floor plan. Schedule your private showing today. Don’t miss out because this one won’t last!' ,`Acres` = '0.09' ,`Area` = '30' ,`BuilderName` = 'Unknown' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = '0023 J T EDWARDS, ACRES 0.09, LOT 8 (PT)' ,`LotDesciption` = 'Cleared' ,`LotSize` = '3920' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'PINK ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'J T Edwards' ,`TaxAmount` = '974' ,`TaxRate` = '2.3748' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663705955' WHERE `Matrix_Unique_ID` = '211837489' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T13:18:04.703' ,`MLSNumber` = '30898083' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.964827' ,`Longitude` = '-95.704429' ,`PhotoCount` = '24' ,`PostalCode` = '77433' ,`RoomCount` = '5' ,`ListPrice` = '674900.00' ,`Status` = 'Active' ,`StreetName` = 'Fieldhaven' ,`StreetNumber` = '26319' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3604' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 26319 Fieldhaven Ct in the prestigious golf course community of Black Horse Ranch. This home is on a large corner lot with mature oak trees and on a quiet cul-de-sac street. Very spacious with five bedrooms, 3 1/2 baths, and a four car garage. You will enjoy making memories in the backyard with large pool and spa and covered back porch. This home has new quartz counters and stainless steel appliances in the kitchen and includes a black fridge. New Luxury Vinyl Plank flooring in the front formals and new interior paint throughout. The primary retreat is on the first floor and has an updated bathroom with quartz counters and a frameless glass shower. The second floor has four large bedrooms with walk-in closets, a grand game room with bay windows and an additional flex room. Blackhorse Ranch is zoned to outstanding schools in CFISD, great amenities including the beautiful golf course, and has easy access to 290.' ,`Acres` = '0.3241' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 2 BLACKHORSE RANCH SEC 1' ,`LotDesciption` = 'Corner,Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '14116' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1004' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'POPE ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Blackhorse Ranch' ,`TaxAmount` = '12309' ,`TaxRate` = '2.919' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705956' WHERE `Matrix_Unique_ID` = '211851896' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T12:47:02.487' ,`MLSNumber` = '73509398' ,`ListAgentFullName` = 'Allison Yancy' ,`ListOfficeName` = 'Compass RE Texas, LLC- Lake Conroe' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.395706' ,`Longitude` = '-95.648879' ,`PhotoCount` = '42' ,`PostalCode` = '77356' ,`RoomCount` = '9' ,`ListPrice` = '799000.00' ,`Status` = 'Active' ,`StreetName` = 'La Jolla' ,`StreetNumber` = '69' ,`StreetSuffix` = 'Circle' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3523' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Recently updated home located on 3/4 acre in the gated community of Del Lago Estates on Lake Conroe. This beautiful home offers the elbow room you have been searching for coupled with lake views and neighborhood boat launch. Recent updates include: concrete flooring on the main level, interior paint, fixtures, appliances, outdoor fans, back patio pergola, landscaping, vanity in the powder room, office door and fencing in the backyard. The kitchen is spacious with an electric cooktop in the granite island, tons of counter space, storage and walk-in pantry. The primary suite overlooks the lush backyard and has a fireplace, sitting area, en-suite bathroom with dual sinks, jetted tub, shower and walk-in closet. Upstairs boasts a huge game room with balcony access 3 guest bedrooms and a full bathroom. The neighborhood is ideal for taking a stroll and is close to area amenities, Historic Montgomery, IAH and The Woodlands. Come and live where you love to play! Montgomery ISD.' ,`Acres` = '0.7343' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S401400 - DEL LAGO ESTATES, LOT 69' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '31986' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Del Lago Estates' ,`TaxAmount` = '8707' ,`TaxRate` = '1.8242' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705956' WHERE `Matrix_Unique_ID` = '211861676' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T13:23:10.167' ,`MLSNumber` = '10999832' ,`ListAgentFullName` = 'Bruce Sellers' ,`ListOfficeName` = 'Keller Williams Advtge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.421113' ,`Longitude` = '-95.613471' ,`PhotoCount` = '49' ,`PostalCode` = '77356' ,`RoomCount` = '15' ,`ListPrice` = '1199000.00' ,`Status` = 'Active' ,`StreetName` = 'Promenade' ,`StreetNumber` = '83' ,`StreetSuffix` = 'Street' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '5671' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in the Estates Section of the gated country club community of Bentwater on the shores of Lake Conroe, this home is uniquely situated on the golf course while also enjoying a water view. Dramatic interior colors with a downstairs layout that\'s ideal for entertaining whether for four guests of forty. Upstairs has three bedrooms, a open game area and private media room. Exterior features fully screened rear deck with (remote control screens) overlooking your pool and spa area. With the double fairway of #12 Weiskopf behind you it\'s a very private setting, perhaps 250 yards from the homes across the way. Viewing down the fairway you see the #12 green and Lake Conroe just behind it. Two two-car garages (connected) provide plenty of space for your vehicles, your golf cart and even has room for a workshop area. Back inside, the photos show you the individual rooms, but this is one of those homes you\'ll want to see in person go fully appreciate the layout. Exemplary Montgomery ISD.' ,`Acres` = '0.3129' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Propane,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S261525 - BENTWATER 25, BLOCK 1, LOT 11' ,`LotDesciption` = 'In Golf Course Community,On Golf Course,Subdivision Lot,Water View' ,`LotSize` = '13632' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1381' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bentwater' ,`TaxAmount` = '11225' ,`TaxRate` = '2.1142' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663705956' WHERE `Matrix_Unique_ID` = '211868779' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T12:01:21.923' ,`MLSNumber` = '59765194' ,`ListAgentFullName` = 'Jacqueline Booth' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.295129' ,`Longitude` = '-94.913079' ,`PhotoCount` = '48' ,`PostalCode` = '77554' ,`RoomCount` = '12' ,`ListPrice` = '1150000.00' ,`Status` = 'Active' ,`StreetName` = 'Bora Bora' ,`StreetNumber` = '211' ,`StreetSuffix` = 'Drive' ,`City` = 'Tiki Island' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '3135' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous home with bay views down the canal. This home features a spacious kitchen with granite countertops, a sub-zero refrigerator, a beverage/wine cooler, and a built-in ice maker. The kitchen and breakfast area are open to the living room. There is an elevator to all floors. One of the bedrooms has been transformed into a formal dining room with a wine room and a butler\'s pantry. It can be made back into a bedroom with a full bath if your so desire. There are two dormer rooms on the 2nd floor that would make great bunk rooms as well as an office/craft space. The utility room is on the 2nd floor as well for easy access. The primary bedroom has a huge walk-in closet as well as a secondary closet. Entertain family and friends, fish off the dock, or just sit and take in the views. Call today to schedule your private showing.' ,`Acres` = '0.138' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tiki Island' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 7 S BUNDICK SUR LOT 12 (13-1) TIKI ISLAND' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '6011' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HAYLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Tiki Island' ,`TaxAmount` = '17566' ,`TaxRate` = '2.4912' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705956' WHERE `Matrix_Unique_ID` = '211958534' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T13:19:29.763' ,`MLSNumber` = '32299060' ,`ListAgentFullName` = 'Betsy Sherman' ,`ListOfficeName` = 'Lot & Block Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.823536' ,`Longitude` = '-95.553141' ,`PhotoCount` = '36' ,`PostalCode` = '77043' ,`RoomCount` = '4' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Fontana' ,`StreetNumber` = '2811' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2295' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully reimagined home in desirable & convenient Spring Shadows. The soothing, neutral color palette will compliment any style. Upon entry you are greeted with engineered wood floors that carry throughout the home. An open concept allows for easy entertaining in the light filled living spaces. The study/flex space with french doors off of the dining area is ideal for working from home. Custom cabinetry & built ins create an abundance of storage in the kitchen, bathrooms & closets. Three large secondary bedrooms share a hall bath with double vanity & tub/shower combo with lighted niche! Spacious primary suite offers a space to sit & read or take in views of the large backyard. Designer touches throughout the ensuite bath make for a relaxing space to get ready for the day! Updates incl. *pex plumbing, foundation w/ warranty, new roof, water heater, HVAC & ductwork, & stainless appliances to name a few! *Per seller. Ideal location with access to Beltway 8, I-10 & 290!' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK W17 SPRING SHADOWS SEC 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '336' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'TERRACE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING OAKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Shadows Sec 10' ,`TaxAmount` = '8985' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705956' WHERE `Matrix_Unique_ID` = '211959492' --> 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','211983434','1663705956','211983434','2022-09-02T13:24:53.123','60746701','Heather Lange','RE/MAX One','','','29.973250','-93.980927','25','77627','7','159900.00','Active','10th','808','Street','Nederland','2','0','3','1184','Single-Family','','0.16','51','','','Gas Dryer Connections','','Sellers Disclosure','1','','0','','Central Gas','0','S40E LT 24, 8N10E LT 25','Subdivision Lot','7000','Appraisal District','','','0','','1','Gas Oven','0','','','Gas Range','','Composition','152 - Nederland','HIGHLAND PARK ELEMENTARY SCHOOL (NEDERLAND)','NEDERLAND HIGH SCHOOL','CENTRAL MIDDLE SCHOOL (NEDERLAND)','Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Other Style','Midway','3040','','Public Sewer,Public Water','1962','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','211988536','1663705956','211988536','2022-09-02T12:19:13.603','94370381','Kayla Hayden','Top Guns Realty on Lake Conroe','','','30.967191','-95.919550','38','77864','11','285000.00','Active','Tammye','203','Lane','Madisonville','2','0','4','2385','Single-Family','The perfect house right in town! This 2,385 square foot house is situated on two large lots. If you’re looking to build or add on to, this is the place! This house includes 4 bedrooms, 2 baths, a cozy living room, and a back porch that opens up to a big fenced back yard, perfect for any friend or family gatherings. A new floor was just installed throughout majority of the house along with other updates! Great location and great neighborhood! Call The Wells Team to schedule a showing!','0.44','52','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Madisonville Area','Central Electric','0','GREENBRIAR ACRES BLK 2 LOT 18 & LOT 19','Cleared','18994','Appraisal District','','','0','','0','Electric Oven','0','','','Electric Cooktop','','Aluminum','175 - Madisonville Consolidated','MADISONVILLE ELEMENTARY SCHOOL','MADISONVILLE HIGH SCHOOL','MADISONVILLE JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front','Seller','1','Traditional','Greenbriar Acres','3089','2.4226','Public Sewer,Public Water','1977','Appraisal'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T13:04:29.990' ,`MLSNumber` = '85234799' ,`ListAgentFullName` = 'Oscar Morales Velandia' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.163328' ,`Longitude` = '-95.061140' ,`PhotoCount` = '18' ,`PostalCode` = '77327' ,`RoomCount` = '3' ,`ListPrice` = '140000.00' ,`Status` = 'Active' ,`StreetName` = 'Road 5122' ,`StreetNumber` = '438' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '840' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 bedroom 2 bath single wide home on just over acre in growing Cleveland, TX. Perfect property for first time home buyers in a low budget. Convenient location to the schools and stores. Easy access from grand parkway 99. Cleared and levelled lot with big space for storage shed, vehicles, pool, horse barn, you name it. Newly built front deck.' ,`Acres` = '0.41' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SANTA FE, SEC 1, BLOCK 8, LOT 1122, ACRES .41, MH LABEL# UNA' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '17860' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe' ,`TaxAmount` = '1430' ,`TaxRate` = '2.1513' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663705956' WHERE `Matrix_Unique_ID` = '212004368' --> 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','212013585','1663705957','212013585','2022-09-02T13:17:48.000','23729388','Angelica Ramirez','Angelica M Ramirez','','','29.793911','-95.551022','14','77043','7','439900.00','Active','Shadeland','1402','Drive','Houston','2','0','3','2275','Single-Family','This home is picturesque with rustic & modern charm! The large redesigned open floor plan offers a walk-in pantry, grand kitchen w/mahogany open shelves, quartz counter tops, custom cabinets built onsite & an oversize island. Home was completely updated in 2021 w/electrical, sewer, plumbing, added insulation, windows, A/C ducts & pre-wired w/security alarm/data. The master bathroom w/vaulted ceiling & walk-in closet are both part of the new addition. Back porch features unique vaulted ceiling w/recesses lighting. This is a large corner lot.','0.2304','24','','','Gas Dryer Connections,Washer Connections','','Owner/Agent','1','','','Spring Branch','Central Gas','0','LT 1 BLK 3 SHADOW OAKS','Corner','10038','Appraisal District','','','0','','0','','0','','','Gas Range','','Composition','49 - Spring Branch','SHADOW OAKS ELEMENTARY SCHOOL','SPRING WOODS HIGH SCHOOL','SPRING OAKS MIDDLE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Shadow Oaks','6022','2.4415','Public Sewer,Public Water','1955','Appraisal'); --> 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','212022205','1663705957','212022205','2022-09-02T12:10:52.410','50494857','Ryan Birdsong','Birdsong Real Estate','','','29.054478','-95.477966','48','77566','9','599900.00','Active','Lakewood','2','Lane','Lake Jackson','3','1','4','3537','Single-Family','One of a kind opportunity! Custom designed by renowned architect Peter Jay Zweig and featured in the April 1990 edition of Architecture Magazine. The home has also been featured in the Style section of the Houston Post. This beautiful, contemporary home sits on an incredible 2 acre lot in the Lake Jackson Farms neighborhood. The two wings of the house are separated by a glazed 30-foot-high tower entry, with the primary bedroom and guest bedrooms located at the opposite ends of a main circulation axis running the length of the home. The living spaces spin off this axis diminishing its formal parti and creating a sense of surprise. The family room is set two steps down off the central corridor with large custom-designed media center. The fireplace, a beautiful crafted object against a window, is located in a small study across the hallway that overlooks a private courtyard. Enjoy outdoor entertainment with the homes multiple patios and courtyards as well as a wonderful screened in pool.','2','5','','','','','Sellers Disclosure','','','1','Lake Jackson','Central Electric','0','LAKE JACKSON FARMS-REPLAT LOT 13C ACRES 2.0','Subdivision Lot','87120','Appraisal District','','','0','','3','Double Oven','1','Enclosed,In Ground','','Gas Cooktop','','Composition','7 - Brazosport','BRANNEN ELEMENTARY SCHOOL','BRAZOSWOOD HIGH SCHOOL','LAKE JACKSON INTERMEDIATE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','1','Contemporary/Modern','Lake Jackson Farms-Replat','8471','1.9981','Aerobic,Well','1988','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','212060988','1663705957','212060988','2022-09-02T12:24:14.647','5295795','Willie Moore Jr.','United Realty','','','29.298978','-94.789558','28','77550','4','425000.00','Active','Avenue L','2110','','Galveston','2','0','2','1090','Single-Family','You will not want to miss out on this diamond on the ISLAND. The owner has paid meticulous attention to detail on this island renovation that you will just have to see for your self to truly appreciate it. Some of the features include but are not limited to 1. All new windstorm window 2. New sewer drainage lines 3 All new drywall 4. New dimmer light switches, 5. Hurricane framing ties, 6. Custom doors and Vanities, 7, New Chevron floors,8. All new stainless steel appliance package. 9. 30 year roof 10. Organic garden including{ grapefruit trees, orange trees, melon patch and outdoor grilling area. 11. New furnace, 12. Rain shower heads 13. Security cameras 14. Finger print door locks just to name a few..........','0.1047','33','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','East End','Central Electric','0','ABST 628 M B MENARD SUR E 38 FT OF LOT 10 (10-1) BLK 81 GALV','Cleared','4560','Appraisal District','','','0','','0','Gas Oven','0','','','Gas Cooktop','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required','Appraisal District','1','Contemporary/Modern','Galveston Townsite','3857','2.0662','Public Sewer,Public Water','1965','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','212075316','1663705957','212075316','2022-09-02T12:42:49.350','82784993','Jared Turner','Tri Pointe Homes','','','29.701950','-95.795000','5','77494','6','629986.00','Active','Regatta Park','6711','Lane','Katy','3','0','4','2688','Single-Family','**MODEL HOME** The Merganser is a charming 3-bedroom home. Function is what this home is all about. You’ll love the flex room, perfect for a home office and the soaring ceilings in the foyer, making for a grand entry. The primary suite is upstairs and conveniently located next to the laundry room. Have fun in the gameroom on the weekends or enjoy weeknight dinners in the casual dining room. The kitchen is open-concept and is ideally set up for hosting.','','36','Tri Pointe Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Other Disclosures','1','Gaslog Fireplace','1','Katy - Southwest','Central Gas','1','40/02/01','Corner,Subdivision Lot','5156','Appraisal District','','1300','1','To Be Built/Under Construction','2','','0','','','Gas Cooktop','','Composition','30 - Katy','WILSON ELEMENTARY SCHOOL (KATY)','SEVEN LAKES HIGH SCHOOL','SEVEN LAKES JUNIOR HIGH SCHOOL','Appointment Required','Builder','2','Traditional','Haven at Seven Lakes','','2.55','Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212076642','1663705957','212076642','2022-09-02T12:10:36.530','88357116','Kimberly Capps-Rumfield','Keller Williams Realty-FM','','','32.128205','-96.948776','24','76670','6','263000.00','Active','Water','407','','Milford','2','0','3','1312','Single-Family','LABOR DAY SPECIAL - $1000 offered as a buyers to go toward rate buy down! Country roads take me home! This adorable and affordable home is located in the heart of Milford and just minutes from the highway. Well maintained home features three bedrooms, two baths and backs up to wide open pasture land. The front porch is perfect for you to sip coffee and visit with the neighbors. Milford is located in the southern part of Ellis County and is centrally located between Dallas and Waco.','0.25','84','','','','','Sellers Disclosure','1','','','','Central Electric','0','470 E L HOGAN 0.25 AC','Corner','10890','Appraisal District','','','0','','2','Gas Oven','0','','','','','Composition','743 - Milford','MILFORD SCHOOL','MILFORD SCHOOL','MILFORD SCHOOL','Lockbox Front','Appraisal District','1','Traditional','E L Hogan','2316','1.6381','Public Sewer,Public Water','2002','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','212088293','1663705957','212088293','2022-09-02T12:05:56.187','50895816','Nicholas Carona','Orchard Brokerage','','','30.296811','-95.490812','30','77304','13','750000.00','Active','Magenta','2703','Meadow','Conroe','4','0','5','4526','Single-Family','Click the Virtual Tour link to view the 3D walkthrough. Welcome home to a residence that exudes elegance! Meticulous attention to detail throughout including a formal entry, built-ins, soaring ceilings, arched doorways, crown molding, & more. The expansive island kitchen boasts granite countertops, a huge walk-in pantry, a double wall-oven, gas cooktop, stainless steel appliances, & an attached dry bar/butler\'s pantry. With spaces such as a formal living room, a study, formal dining, plus a family room & a media room upstairs, means ample space to suit all needs. The primary suite feels luxurious w/ a gorgeous tray ceiling, a walk-in closet, & an ensuite w/ a jetted tub, separate shower, & a connection to the laundry room for maximum convenience! The huge backyard oasis will make you feel like you\'re at a resort, complete w/ an in-ground pool, jacuzzi, & a covered patio. Whole-home generator, new tankless water heater, new roof July \'22, new fence, new pool automation system & pumps','1','19','','','Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Conroe Southwest','Central Gas','0','SILVERSTONE 01, BLOCK 2, LOT 45','Subdivision Lot,Wooded','43560','Appraisal District','','700','0','','3','Double Oven','1','In Ground','','Gas Cooktop','','Composition','11 - Conroe','RICE ELEMENTARY SCHOOL (CONROE)','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Lockbox Front','Appraisal District','2','Traditional','Silverstone 01','10750','2.1863','Public Sewer,Public Water','2004','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','212101697','1663705957','212101697','2022-09-02T13:07:22.307','18298227','Elizabeth Kyser','Keller Williams Hou Preferred','','','29.396891','-94.928408','32','77590','5','220000.00','Active','13th','2309','Avenue','Texas City','2','0','3','1819','Single-Family','2309 13th Ave N is ready for your viewing pleasure! You find that this lovely 3/2 located in the heart of Texas City has two generous sized living spaces. Touches of the original hardwood floor add charm throughout the home. Let your imagination run wild with all the possibilities of what can be done in the oversized backyard. This home is the perfect opportunity to add your own touches. Roof is 2 years old, recent bathroom remodel, and newer HVAC system. Don\'t wait, schedule your showing today','0.2169','33','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','0','Texas City','Central Gas','0','ABST 142 PAGE 3 LOT 35 STAFFORDS 1ST ADDN','Cleared,Subdivision Lot','9450','Appraisal District','','','0','','1','Electric Oven,Freestanding Oven,Single Oven','0','','','Electric Cooktop','','Composition','52 - Texas City','GUAJARDO ELEMENTARY SCHOOL','TEXAS CITY HIGH SCHOOL','BLOCKER MIDDLE SCHOOL','Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Stafford 1','2887','2.5335','Public Sewer,Public Water','1964','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','212103426','1663705957','212103426','2022-09-02T12:58:09.800','45349908','Jose Garza','Alchemist Real Estate','','','29.060555','-95.443475','36','77566','4','259900.00','Active','Sunflower','111','Street','Lake Jackson','2','0','3','1492','Single-Family','Beautiful 1 story brick home in Lake Jackson with 3 bedrooms and 2 full bathrooms. Property has been completely remodeled from top to bottom. Brand new roof, new flooring, new kitchen cabinets, new appliances and much more.','0.233','5','','','Electric Dryer Connections,Gas Dryer Connections','','Sellers Disclosure','','','1','Lake Jackson','Central Gas','0','TANGLEWOOD SEC 3 (LAKE JACKSON), BLOCK 13, LOT 18','Cleared','10149','Appraisal District','','','0','','2','Single Oven','0','','','','','Composition','7 - Brazosport','BRANNEN ELEMENTARY SCHOOL','BRAZOSWOOD HIGH SCHOOL','LAKE JACKSON INTERMEDIATE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','1','Ranch,Traditional','Tanglewood Lake Jackson','4121','2.3371','Public Water','1978','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','212117532','1663705957','212117532','2022-09-02T12:29:33.743','36755732','Amy Chance','Compass RE Texas, LLC','','','30.069989','-94.085918','19','77701','2','39000.00','Active','Powell','885','','Beaumont','1','0','2','814','Single-Family','The south end of Beaumont is near downtown. This home sits on the edge of the Port Area making your work commute simple as you are very close to MLK. Hassle-free traffic area. This home sits on a large lot allowing access from the rear and front streets. Quiet nieghborhood. \r\n\r\n This home would make a great investment property for a landlord looking to cater to an affordable to moderately low price range. The small 2 bedroom 1 bath home hosts a history full of memories. This well-established neighborhood is full of warm humans who are looking to welcome a new neighbor. Let us help you begin your investment portfolio. The seller is motivated and willing to accommodate a buyer looking to get started in real estate investing.','0.13','51','','','','','Mud','','','','','Other Heating','0','D BROWN','Other','','','','','0','','0','','0','','','','','Other','143 - Beaumont','CHARLTON-POLLARD ELEMENTARY SCHOOL','BEAUMONT UNITED HIGH SCHOOL','KING MIDDLE SCHOOL (BEAUMONT)','Appointment Required,Request Online Appointment','Appraisal District','1','Traditional','D BROWN','','','Public Sewer,Public Water','1962','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','212119290','1663705957','212119290','2022-09-02T12:00:49.180','53655642','Christopher Davidson','Walzel Properties','','','29.892560','-95.484171','16','77088','8','230000.00','Active','Wildforest','8715','Drive','Houston','2','0','3','1464','Single-Family','MOTIVATED SELLER! SUBMIT ALL OFFERS! SELLER WILL CONTRIBUTE $5,000 TOWARDS BUYERS EXPENSES!! Welcome to the highly desired Inwood North! This home is perfect for someone that is willing to put in a little TLC. This lovely home comes with an indoor atrium and sunroof for optimal lighting and also a Brick & Mortar Fireplace in the Living Room! this lovely floor plans offers 3 spacious bedrooms, 2 bathrooms and a 2 car garage! Less than 2 blocks away from the Neighborhood Pool and minutes away from Alabonson Park! This is a great chance for a first time homeowner to purchase a home in this neighborhood for an affordable price. Call now to schedule a viewing today!','0.1423','11','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Freestanding','1','Northwest Houston','Central Electric','1','LT 20 BLK 19 017*I5645955-002-019-020 INWOOD NORTH SEC 2','Subdivision Lot','6200','Appraisal District','','300','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','32 - Klein','NITSCH ELEMENTARY SCHOOL','KLEIN FOREST HIGH SCHOOL','KLEIN INTERMEDIATE SCHOOL','Lockbox Front','Appraisal District','1','Traditional','Inwood North Sec 02','3291','2.6055','Public Sewer,Public Water','1978','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','212123217','1663705957','212123217','2022-09-02T13:30:03.073','62777260','Juan Pardo','RE/MAX East','','','29.833727','-95.468959','11','77092','4','420000.00','Active','De Milo','5209','Drive','Houston','2','0','4','1576','Single-Family','Professionally renovated 4 Bedroom, 2 Bath, 1 Car Attached Garage, new windows, new a/c and heat, new kitchen cabinets, new stainless steel appliances, wood floors completely redone, new tiled showers, recessed lighting.','0.1446','9','','','Gas Dryer Connections,Washer Connections','','No Disclosures','1','Mock Fireplace','1','Oak Forest West Area','Central Gas','0','LT 4 BLK 14 OAK FOREST SEC 16','Cleared,Subdivision Lot','6300','Appraisal District','','','0','','1','Convection Oven,Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','27 - Houston','SMITH ELEMENTARY SCHOOL (HOUSTON)','SCARBOROUGH HIGH SCHOOL','CLIFTON MIDDLE SCHOOL (HOUSTON)','Appointment Required','Appraisal District','1','Traditional','Oak Forest Sec 16','5388','2.3307','Public Sewer,Public Water','1955','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','212125048','1663705957','212125048','2022-09-02T12:05:27.653','2919474','Alex Rezende','AroundTown Properties Inc','','','29.813696','-95.348430','29','77026','6','354888.00','Active','Batterson','6009','Street','Houston','3','1','3','1665','Single-Family','This brand new smart home features 3 Bedrooms & 2.5 Baths a 2 car attached garage & a low maintenance backyard! Granite countertops & built-in stainless steel appliances in the open concept kitchen with tons of natural light. Tile flooring throughout the living areas/walkways and carpet in all bedrooms. Smart Home Features include LED lights, smart garage door opener, Smart thermostat, Smart lock, Smart doorbell, electric car outlet, low voltage panel, smart light switch, HVAC 16 SEER. Linder Landing is perfectly situated just North of Downtown Houston and only minuted from 610. The prime location provides convenient access to Downtown Houston and other major employment centers, fine dining, shopping & entertainment! This exclusive community is comprised of only five homes and features modern floor plans and high-end interior finishes. Quality construction by MTY Builders paired with the luxurious open concept design is sure to impress! 5 Units starting at $344,888.','','9','MTY BUILDERS','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Corporate Listing','1','','','Northside','Central Electric','0','LOT 5 BLOCK 1 Linder Landing','Cleared,Subdivision Lot','2600','Survey','','','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','ROSS ELEMENTARY SCHOOL (HOUSTON)','NORTHSIDE HIGH SCHOOL','KEY MIDDLE SCHOOL','Accompany,Appointment Required,Lockbox Front','Builder','2','Contemporary/Modern','Linder Landing','','2.33','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212128442','1663705957','212128442','2022-09-02T13:09:37.263','66770812','Jose Alves','RE/MAX Universal','','','29.675215','-95.259834','23','77017','4','215000.00','Active','Bendell','8108','Drive','Houston','1','0','3','1242','Single-Family','Come and see this fully beautiful and cozy house, it could be your next home. Fully renovated with new AC, new water heater, new appliances, new floors and upgraded kitchen with granite countertops. The house has a great flow with plenty space, with a nice backyard with a tool shed to help you keeping your home clutter free.\r\nConveniently located nearby great options of shopping, entertainment and dining, it is just a few minutes driving to the Texas Medical Center, the Port of Houston and DownTown. Text listing agent to schedule your appointment today, it will not last longer in the market.','0.1263','3','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','0','Hobby Area','Central Gas','0','LT 17 BLK 55 MEADOWBROOK SEC G','Subdivision Lot','5500','Appraisal District','','','0','','1','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','BONNER ELEMENTARY SCHOOL (HOUSTON)','CHAVEZ HIGH SCHOOL','STEVENSON MIDDLE SCHOOL (HOUSTON)','Supra Keybox','Appraisal District','1','Traditional','Meadowbrook','2618','2.3307','Public Sewer,Public Water','1949','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','212129436','1663705957','212129436','2022-09-02T13:42:33.987','85459153','Jose Alves','RE/MAX Universal','','','29.650354','-95.484676','23','77035','8','395000.00','Active','Ludington','5618','Drive','Houston','2','0','4','2359','Single-Family','Come and see today this fully renovated home with a great flow in an open concept, combining living and dining open to the kitchen and two bedrooms downstairs plus two upstairs. It features new floors, beautifully renovated kitchen with granite counter tops, new stainless steel appliances, new paint and carpets. \r\nConveniently located nearby shopping, entertainment and dinning and just minutes driving to the Texas Medical Center, to the Energy Corridor, to Sugar Land and the Galleria area, this property won\'t last. This could be your next home, text listing agent to schedule your appointment today.','0.1928','20','','','','','Sellers Disclosure','1','','1','Brays Oaks','Central Gas','0','LT 10 BLK 65 WESTBURY SEC 3 R/P','Subdivision Lot','8400','Appraisal District','','','0','','2','','0','','','','','Composition','27 - Houston','ANDERSON ELEMENTARY SCHOOL (HOUSTON)','WESTBURY HIGH SCHOOL','MEYERLAND MIDDLE SCHOOL','Supra Keybox','Appraisal District','1','Traditional','Westbury Sec 03 Pt Rep','5607','2.3307','Public Sewer,Public Water','1958','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','212129727','1663705957','212129727','2022-09-02T13:28:50.583','29532719','Dan Cook','SWE Homes','','','31.812902','-99.428662','8','76834','2','42999.00','Active','Magnolia','2115','Street','Coleman','1','0','2','812','Single-Family','Handy-man special, Corner home with 2 Bedrooms and 1 Bath. Easy access to Hwy. As Is.','0.18','83','','','','','No Disclosures','','','','','Other Heating','0','TURNER HEIGHTS ADDN TOWN COLEMAN, BLOCK 6, LOT S/2 SW/4','Other','7813','Appraisal District','','','0','','0','','0','','','','','Composition','425 - Coleman','COLEMAN ELEMENTARY SCHOOL (COLEMAN)','COLEMAN HIGH SCHOOL','COLEMAN JUNIOR HIGH SCHOOL','Lockbox Front','Appraisal District','1','Traditional','Turner Heights Add','294','2.7444','Other Water/Sewer','1960','Appraisal District'); --> New record created successfully