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-10-19T01:22:01.060' ,`MLSNumber` = '5065203' ,`ListAgentFullName` = 'Marnie Greenwood' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.726822' ,`Longitude` = '-95.397768' ,`PhotoCount` = '34' ,`PostalCode` = '77006' ,`RoomCount` = '15' ,`ListPrice` = '4500000.00' ,`Status` = 'Active' ,`StreetName` = 'South' ,`StreetNumber` = '1412' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Houston' ,`BathsFull` = '6' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '4038' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Live on one of Houston\'s most sought after streets: South Boulevard! The oak-lined ave will lead you to this historic home, which sits on an exceptional 38,295 SF corner lot. The charming brick colonial offers comfortable and functional living. The first floor showcases large formal living room surrounding marble fireplace, bright library with built-in bookshelves and fireplace, a designated formal dining room, island kitchen and a sunroom. The second floor includes a large primary suite and two additional bedrooms. Remarkable wrap-around porch on second floor makes outdoor/indoor living easy. Additional open concept pool house/game room located behind the home with one bedroom apartment complete with kitchenette and full bath on second floor. A pool house terrace overlooks the pool and yard. Large circle drive at the front of the home with additional parking in rear. Located in the historically preserved subdivision of Broadacres.' ,`Acres` = '0.8791' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Rice/Museum District' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BROADACRES' ,`LotDesciption` = 'Corner' ,`LotSize` = '38295' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '4000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'POE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial,Traditional' ,`Subdivision` = 'Broadacres' ,`TaxAmount` = '95557' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203180' WHERE `Matrix_Unique_ID` = '206213428' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T01:22:01.060' ,`MLSNumber` = '71488810' ,`ListAgentFullName` = 'Heidi Dugan' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.717019' ,`Longitude` = '-95.440856' ,`PhotoCount` = '29' ,`PostalCode` = '77005' ,`RoomCount` = '6' ,`ListPrice` = '1199000.00' ,`Status` = 'Active' ,`StreetName` = 'Rice' ,`StreetNumber` = '3930' ,`StreetSuffix` = 'Boulevard' ,`City` = 'West University Place' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '3200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Inspired contemporary in West U with open concept plan & elevator. Primary bedroom down with wood beams, planked accent wall, cozy fireplace & wall of French doors & windows out to private yard. Ensuite highlighted by separate tub & shower & double sinks plus spacious closet. 2nd bedroom on 1st floor with granite enclosed shower & walk-in closet. Downstairs features concrete floors & convenient laundry room. 2nd floor hallmarked by one large open space with incredible soaring vaulted ceiling and steel & wood beams, lofty windows & impressive balcony across entire back wall of home. Classic black & white kitchen with stainless double ovens & oversized island. Adjacent full bath smartly placed upstairs. Wonderful front balcony. Infinitely flexible design can easily be divided into independent rooms or enjoyed as a grand open space. Great looking front elevation. Close proximity to city center, Tiny’s, pool. Just imagine the possibilities! All per seller.' ,`Acres` = '0.1148' ,`Area` = '17' ,`BuilderName` = 'Tim Shore' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 17 BLK 13 COLLEGEVIEW SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Collegeview' ,`TaxAmount` = '25671' ,`TaxRate` = '2.0584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203180' WHERE `Matrix_Unique_ID` = '208026716' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T01:22:01.060' ,`MLSNumber` = '25108659' ,`ListAgentFullName` = 'Armando Espinosa Jr' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.797777' ,`Longitude` = '-95.384671' ,`PhotoCount` = '29' ,`PostalCode` = '77009' ,`RoomCount` = '7' ,`ListPrice` = '544000.00' ,`Status` = 'Active' ,`StreetName` = 'Michaux' ,`StreetNumber` = '4617' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1215' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A MUST SEE! Beautifully remodeled bungalow in the Norhill Historic District! From the perfectly updated front porch to the designer finishes, this home has been thoughtfully redesigned with today\'s buyer and trends in mind. The newly crafted open floorplan allows for an easy flow from one room to the next with generous space in each living area. The living room is light & bright with the plenty of room for oversized furniture & guests. The updated kitchen includes a stainless steel stove, rows of counter space and ample storage with plenty of room for multiple cooks. The dining area includes a gorgeous hanging lamp to showcase the best of meals & marvelous full paned French Doors overlooking the backyard. Both bedrooms are equally delightful and the fully remodeled bath is extraordinary with it\'s oversized tiled shower and designer touches. Don\'t miss the designer flooring throughout the house! Step outside onto the oversized back patio and lush lawn, ready for summer parties!' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 9 BLK 115 NORTH NORHILL' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'FIELD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'North Norhill' ,`TaxAmount` = '8522' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203180' WHERE `Matrix_Unique_ID` = '208327912' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T01:22:01.060' ,`MLSNumber` = '12446805' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.750207' ,`Longitude` = '-95.900952' ,`PhotoCount` = '39' ,`PostalCode` = '77494' ,`RoomCount` = '5' ,`ListPrice` = '370000.00' ,`Status` = 'Active' ,`StreetName` = 'Lemonwood' ,`StreetNumber` = '2610' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1752' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Entertain in style and enjoy the everyday comforts of The Penmark family home plan. Begin and end each day in the perfect paradise of your Owner’s Retreat, which features a refined bathroom and a sprawling walk-in closet. Each spare bedroom provides a wonderful place for unique personalities to flourish. The chef’s specialty kitchen includes a full-function island and a walk in pantry. Your open floor plan offers an impeccable space to play host to picture-perfect memories and brilliant social gatherings. Get the most out of each day in this lovely Energy Saver!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 09 Block 02' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jordan Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666203180' WHERE `Matrix_Unique_ID` = '208426929' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T01:22:01.060' ,`MLSNumber` = '21501758' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.960086' ,`Longitude` = '-95.198140' ,`PhotoCount` = '42' ,`PostalCode` = '77346' ,`RoomCount` = '18' ,`ListPrice` = '674283.00' ,`Status` = 'Active' ,`StreetName` = 'Drummond Maple' ,`StreetNumber` = '12111' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3774' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Carter IX, Elevation M) Two story. 5 bedrooms, 4.5 baths. Primary suite downstairs with large double walk-in closets. Secondary bedroom on first floor with private bath as well. Formal dining room and study. Spacious island kitchen with breakfast area open to family room. Upstairs game room with media room plus three secondary bedrooms. Covered patio and 2 car attached garage. Featuring new homes near Lake Houston and nearly 1,000 acres of wooded bliss, The Groves is a one-of-a-kind master-planned community. It is conveniently located in the acclaimed Humble ISD with easy access to Beltway 8 and Hwy 59. The Hearth Amenity Center is the center of this community and features a resort-style pool, an oversized hearth fireplace with cozy bistro seating and soft festoon lighting. Stop by the Westin Homes model home today to find out more about The Groves!' ,`Acres` = '0.2423' ,`Area` = '1' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10554' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1056' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GROVES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Groves' ,`TaxAmount` = '2411' ,`TaxRate` = '3.5373' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666203181' WHERE `Matrix_Unique_ID` = '208744055' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T01:22:01.060' ,`MLSNumber` = '33482137' ,`ListAgentFullName` = 'Daniel Parker' ,`ListOfficeName` = 'New Leaf Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.683316' ,`Longitude` = '-95.429300' ,`PhotoCount` = '28' ,`PostalCode` = '77025' ,`RoomCount` = '14' ,`ListPrice` = '1399000.00' ,`Status` = 'Active' ,`StreetName` = 'Cloverdale' ,`StreetNumber` = '3306' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4202' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One of a kind house for the neighborhood with high-end finishes from one of Houston\'s premier luxury custom builders. Comparable quality/finishes to new construction in West U or Braes Heights. The square footage does not reflect the unfinished third floor that is already air conditioned and can be finished out for an ADDITIONAL 800ft and converted into one or two rooms. This gem has spacious home study and a planning/homework room, custom moldings/trim work, onsite built cabinets, 7\" french white oak wood floors throughout the house, porcelain & marble countertops, Weathershield aluminum clad wood windows, 2 wood burning fireplaces, mahogany front door, iron hand rails, superior insulation package, and Trane variable speed HVACs.' ,`Acres` = '0.1791' ,`Area` = '17' ,`BuilderName` = 'Parker-Evans Custom' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Reports Available' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Knollwood/Woodside Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 26 BLK 3 WESTRIDGE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LONGFELLOW ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2.5' ,`Style` = 'Georgian' ,`Subdivision` = 'Westridge' ,`TaxAmount` = '6133' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666203181' WHERE `Matrix_Unique_ID` = '208998788' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T01:22:01.060' ,`MLSNumber` = '21673401' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.960403' ,`Longitude` = '-95.195847' ,`PhotoCount` = '42' ,`PostalCode` = '77346' ,`RoomCount` = '18' ,`ListPrice` = '659983.00' ,`Status` = 'Active' ,`StreetName` = 'Alpenglow Lake' ,`StreetNumber` = '12307' ,`StreetSuffix` = 'Path' ,`City` = 'Humble' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3762' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Carter VI, Elevation F) Two Story. 5 bedrooms, 4.5 baths. Private Primary Suite with spacious double walk-in closets downstairs. Formal Dining Room and Study with Spacious Kitchen and breakfast area open to Family Room. Spacious Game Room upstairs with private Media Room. Extended covered patio and attached 2 car garage. Featuring new homes near Lake Houston and nearly 1,000 acres of wooded bliss, The Groves is a one-of-a-kind master-planned community. It is conveniently located in the acclaimed Humble ISD with easy access to Beltway 8 and Hwy 59. The Hearth Amenity Center is the center of this community and features a resort-style pool, an oversized hearth fireplace with cozy bistro seating and soft festoon lighting. Stop by the Westin Homes model home today to find out more about The Groves!' ,`Acres` = '0.207' ,`Area` = '1' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9015' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1056' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GROVES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Groves' ,`TaxAmount` = '2360' ,`TaxRate` = '3.7' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666203181' WHERE `Matrix_Unique_ID` = '209316939' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T01:32:04.600' ,`MLSNumber` = '32306481' ,`ListAgentFullName` = 'Jeanette Coury' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.900166' ,`Longitude` = '-95.567607' ,`PhotoCount` = '45' ,`PostalCode` = '77064' ,`RoomCount` = '11' ,`ListPrice` = '527900.00' ,`Status` = 'Active' ,`StreetName` = 'Dallam' ,`StreetNumber` = '8703' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3861' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful and spacious lakefront 4-bedroom home with 2 full and 2 half-baths in the upscale neighborhood of Willowbridge in the Jersey Village area. Open and flowing living and cooking areas to stay engaged with your family and guests! Large island & bar for food prep and serve, downdraft vent and optional gas for cooktop. Stunning Marble floors at entry, main bath & FP. Relax in your Private, Luxurious main bedroom and updated bath suite with separate vanities, tons of cabinet space and 2 big closets with built-in cabinets/shelves. Hygienic air-jet tub. Storage under stairs. Walk-in closets and Pantry! Convenient hidden 1/2 baths near entry and at kitchen. New wood floors, dishwasher, faucet, paint-June 2022. Plantation shutters with a GORGEOUS view of the Lake and Park accessible outside your back yard. Over-sized garage with workspace, built-in cabinets and shelves for extra storage! Established community with shopping and schools nearby, quick access to Beltway 8 and US 290.' ,`Acres` = '0.1988' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Jersey Village' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 9 WILLOWBRIDGE SEC 4 AMEND' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '8660' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '634' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'GLEASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JERSEY VILLAGE HIGH SCHOOL' ,`SchoolMiddle` = 'COOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Willowbridge Sec 04 Amd' ,`TaxAmount` = '8398' ,`TaxRate` = '2.521' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203181' WHERE `Matrix_Unique_ID` = '209413310' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T01:22:01.060' ,`MLSNumber` = '50473417' ,`ListAgentFullName` = 'Nina Davenport' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.765933' ,`Longitude` = '-95.411954' ,`PhotoCount` = '45' ,`PostalCode` = '77007' ,`RoomCount` = '7' ,`ListPrice` = '695000.00' ,`Status` = 'Active' ,`StreetName` = 'Feagan' ,`StreetNumber` = '5011' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2910' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MC2 ARCHITECT PROJECT: It\'s finally on the market! Located in the Memorial Park/Rice Military area, this stunning well maintained modern townhome offers a sophisticated open floor plan carefully planned views of Downtown Houston\'s impressive skyline. Soaring ceilings, rooms are bright and open with lots of natural light. Freshly painted (in and out), functional floor plan and a GREAT place for entertaining!! Spacious center island, gourmet kitchen with lots of cabinet/counter space and hardwood floors. Beautiful 3rd floor Master Retreat w/3 closets and Balcony. The Master bathroom has double sinks, an oversized jacuzzi tub and a separate shower. also, 3rd floor includes a separate Huge loft/office/study area. It\'s central location provides the convenience of urban living with access to one of the country\'s largest urban parks complete with a PGA golf course. Walking and biking trails, tennis courts, and playing fields. Downtown, Memorial Park, Galleria and fine Dinning near the area.' ,`Acres` = '' ,`Area` = '16' ,`BuilderName` = 'MC2 ARCHITECT PROJEC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rice Military/Washington Corridor' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'W 1/2 OF LT 8 BLK 6 (001* TH 11) BRUNNER' ,`LotDesciption` = 'Other' ,`LotSize` = '2500' ,`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` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'ONE HUNDRED ROY ST TH' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203181' WHERE `Matrix_Unique_ID` = '210536717' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T01:22:01.060' ,`MLSNumber` = '5992660' ,`ListAgentFullName` = 'Jessica Phillips' ,`ListOfficeName` = 'Red Shoe Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.578599' ,`Longitude` = '-95.428179' ,`PhotoCount` = '28' ,`PostalCode` = '77584' ,`RoomCount` = '8' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Emerald Trace' ,`StreetNumber` = '1831' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3233' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome! Gorgeous & gently lived in home that is perfect for entertaining or simply living. Located in the desired and established community of Shadow Creek Ranch. This home features a stunning entry way & foyer w/a 14’ ceiling. At the front of the house is a formal dining room & cozy study adorned w/ beautiful French doors. Kitchen is complete w/a walk-in pantry, 2 large bars which allow for additional seating, granite countertops, tile backsplash, island, gas cook top and plenty of storage & counter space. Open to the breakfast nook and living area, a wall lined w/large windows allow for lots of natural light. Two secondary bedrooms, each w/walk-in closets. A half bath for guests. Primary suite features dual vanities, separate glass enclosed shower, garden tub & bonus space that can be utilized as a customizable walk-in closet, second office, man cave or lady\'s lair (See photos for seller\'s prior customization). The possibilities are endless! Schedule your private tour today!' ,`Acres` = '0.1719' ,`Area` = '38' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SHADOW CREEK RANCH SF-63B, BLOCK 1, LOT 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7487' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '999' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BLUE RIDGE ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'WILLOWRIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'MCAULIFFE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadow Creek Ranch Sf-63b' ,`TaxAmount` = '11276' ,`TaxRate` = '3.2123' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1666203182' WHERE `Matrix_Unique_ID` = '211902329' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T01:22:01.060' ,`MLSNumber` = '30780298' ,`ListAgentFullName` = 'Robert Bland' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.725226' ,`Longitude` = '-95.394385' ,`PhotoCount` = '50' ,`PostalCode` = '77005' ,`RoomCount` = '15' ,`ListPrice` = '4400000.00' ,`Status` = 'Active' ,`StreetName` = 'Shadow Lawn' ,`StreetNumber` = '14' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '5838' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Shadowlawn was developed in the early 1920’s by John H. Crooker who built 14 Shadow Lawn. Crooker had first choice of the Shadow Lawn lots and commissioned MIT trained architect Joseph W. Northrup, Jr., who was in Houston working on some of Rice University\'s early buildings, to design his home. A front porch opens into a gracious entry foyer w/ front stairs and cased openings to the major downstairs rooms; the living room w/access to the sunroom, a handsome library & home office and the formal dining room. The Island kitchen has access to the breakfast rm & butler’s pantry/wet bar. Upstairs to 4 bedrooms w/ private baths. The primary suite has an adjacent sitting room & sunroom with private views. 3rd floor game room w/dormer windows. This brick Colonial Revival style home w/a copper roof sits on a wonderfully private and wooded site; almost 2/3 of an acre. Grounds include a pool, patio and spa. Driveway gate to 3 car garage and updated guest suite. Many recent updates. A fine home.' ,`Acres` = '0.6295' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '4' ,`GeoMarketArea` = 'Rice/Museum District' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 14 & 15 SHADOWLAWN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '27419' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'POE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadowlawn' ,`TaxAmount` = '67589' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1923' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203182' WHERE `Matrix_Unique_ID` = '211927289' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T00:01:39.010' ,`MLSNumber` = '30625601' ,`ListAgentFullName` = 'Quynh Luong' ,`ListOfficeName` = 'Coldwell Banker Realty, Cy-Fair Office' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.831317' ,`Longitude` = '-95.469405' ,`PhotoCount` = '29' ,`PostalCode` = '77092' ,`RoomCount` = '5' ,`ListPrice` = '568000.00' ,`Status` = 'Active' ,`StreetName` = 'Nina Lee' ,`StreetNumber` = '5223' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2508' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A modern ranch-style home located in the desired neighborhood of Oak Forest. Complete remodel 1-story feature 4 beds, 3 full baths & 2-car garage. Upgrades include: All new AC & duct, soft closed shaker cabinets & vanities, LED lighting throughout. Updated electrical & PEX plumbing. SMART Home features NEST thermostat & garage door opener. Open living concept. The kitchen features a quartz countertop, a waterfall island, stainless steel appliances & a touchless faucet. Large laundry room w a utility sink. Expansive master suite w/lavish bath, spacious walk-in shower w/a rain shower head & a walk-in closet. 4th bedroom has an en-suite full bath. New insulations for better energy saving. New energy-efficient double pane windows. Spacious backyard with new sod. Low maintenance landscaping. Minutes to T.C. Jester Park, hike & bike trails, local eateries, coffee shops, all major freeways.' ,`Acres` = '0.1677' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 & TR 4A BLK 22 OAK FOREST SEC 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7303' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WAINWRIGHT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Oak Forest' ,`TaxAmount` = '5049' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203182' WHERE `Matrix_Unique_ID` = '212274071' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T00:17:43.250' ,`MLSNumber` = '71699754' ,`ListAgentFullName` = 'Vera Mitrofanova' ,`ListOfficeName` = 'VAM Real Estate Solutions' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.483422' ,`Longitude` = '-95.499883' ,`PhotoCount` = '44' ,`PostalCode` = '77459' ,`RoomCount` = '11' ,`ListPrice` = '580000.00' ,`Status` = 'Active' ,`StreetName` = 'Magnolia Mist' ,`StreetNumber` = '2414' ,`StreetSuffix` = 'Court' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3357' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Sellers will contribute $10,000 towards buy-down points to reduce buyers’ interest rate. This beautiful pristine barely lived in house by Westin Homes features 4 bedrooms, 3 full bathrooms and 1 half bath. Gourmet kitchen with gorgeous large kitchen island, plethora of counter and cabinet space, dramatic ceilings throughout, abundance of light from energy efficient windows, spacious walk in closets, media room, game room, formal dining, office. Carpet upstairs and in the primary bedroom. Both AC units have been replaced in 2021. Nothing about this house is builder standard. Owners upgraded marble countertops in the bathrooms and floor tiles throughout the first floor worth of over 50K. Enjoy entertaining your friends and family at a covered patio with a spacious backyard. Master Planned community of Sienna Plantation with world class amenities including water parks, Siena golf club, grille, 100+ acres of parks, miles of walking trails and more. Fort Bend ISD. Schedule today!' ,`Acres` = '0.182' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIENNA PLANTATION SEC 22, BLOCK 3, LOT 17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7928' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1254' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna Plantation Sec 22' ,`TaxAmount` = '6274' ,`TaxRate` = '3.1629' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1666203182' WHERE `Matrix_Unique_ID` = '212406622' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T01:22:01.060' ,`MLSNumber` = '5362093' ,`ListAgentFullName` = 'Angela Heiman' ,`ListOfficeName` = 'Texas Premier Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.028030' ,`Longitude` = '-95.445543' ,`PhotoCount` = '24' ,`PostalCode` = '77566' ,`RoomCount` = '3' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Lotus' ,`StreetNumber` = '509' ,`StreetSuffix` = 'Street' ,`City` = 'Lake Jackson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2313' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home has lots of charm from the vaulted ceilings, wood burning fireplace, to the window seats this home screams cozy. The front garage has been converted to a home office with its own entrance, carpet, and mini split. the main bath has oversized gorgeous ceramic shower and wood cabinets. The Master bedroom has 3 closets with built ins for shoes. etc... The Master bath has a 5 by 5 shower with 13 heads, and the 4+ person jacuzzi tub with lights and waterfall will drift you off to sleep. Off the Master is a flex space that has a large stainless-steel sink that was used to wash and groom the owners\' dogs. Close it in and make it a sitting space for your master or leave it open for a place for your pups when away. The back garage has a sink and mini split in it and is extra deep to hold deep freeze, toolbox\'s, ext... Kitchen has ceramic counters and stone backsplash. Outdoor you have a nice, concreted area to entertain guest and a storage building to hold your lawn equipment.' ,`Acres` = '0.1928' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Jackson' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WOODLAND PARK SEC 2 (LAKE JACKSON), BLOCK 27, LOT 7' ,`LotDesciption` = 'Cleared' ,`LotSize` = '8398' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'ROBERTS ELEMENTARY SCHOOL (BRAZOSPORT)' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE JACKSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodland Park Sec 2 Lake Jack' ,`TaxAmount` = '5258' ,`TaxRate` = '2.3371' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203182' WHERE `Matrix_Unique_ID` = '212408652' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T01:22:01.060' ,`MLSNumber` = '24856400' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.762173' ,`Longitude` = '-95.891016' ,`PhotoCount` = '21' ,`PostalCode` = '77423' ,`RoomCount` = '9' ,`ListPrice` = '359070.00' ,`Status` = 'Active' ,`StreetName` = 'Twisting Springs' ,`StreetNumber` = '30219' ,`StreetSuffix` = 'Drive' ,`City` = 'Brookshire' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1931' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this beautiful 1 Story-The Epsom Floor Plan with 3 Bedrooms, 2 Baths, with an attached 2 Car Garage. This home has a spacious OPEN CONCEPT FLOOR PLAN with 10ft. ceilings and offering Home Office and Dining Rooms. You will love the Kitchen with lots of cabinets with under the cabinet lighting, stainless steel appliances, and even a USB outlet. Do not miss all the recessed lighting throughout the home. Tile and Carpet throughout. Covered Patio & Fenced Backyard. COST AND ENERGY EFFICIENCY FEATURES:16 Seer HVAC System, Honeywell Thermostat, Pex Hot & Cold Water Lines, Radiant Barrier, Rheem® Whole House Tankless Gas Water Heater, and Low E Windows that open to the inside of the home for cleaning. The community also offers recreational amenities for residents to enjoy including walking trails, a full-size Olympic pool, a splash pad, parks and playground facilities. Convenient to I-10 and 99. Lamar CISD.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5610' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Willow Creek Farms' ,`TaxAmount` = '' ,`TaxRate` = '2.9348' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666203182' WHERE `Matrix_Unique_ID` = '212431354' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T01:22:01.060' ,`MLSNumber` = '76323082' ,`ListAgentFullName` = 'Yvonne Killings' ,`ListOfficeName` = 'Balanced Life Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.998653' ,`Longitude` = '-95.846777' ,`PhotoCount` = '18' ,`PostalCode` = '77447' ,`RoomCount` = '4' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Gadwall Bayou' ,`StreetNumber` = '26902' ,`StreetSuffix` = 'Lane' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2219' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Are you looking for the quiet of a small community, a cul-de-sac property in front and a dead end no back neighbors in the rear. A backyard that could hold two swimming pools. Not to mention a gas appliance chef\'s kitchen, with all appliances included even the refrigerator. Granite counter tops and the latest soft close cabinets and even a walk in pantry; this is only the beginning of this magnificent property. The laundry room comes complete with the washer and dryer. New updated Wood look tile flooring, custom paint, down stairs primary bedroom, separate garden tub and stand alone shower and a walk in closet for the shopper in you. Bathroom cabinets replaced and granite countertops 3 additional large upstairs bedrooms Just in time for football cook outs. Come and see what this beautiful hidden gem has to offer it\'s next owner.....OPEN HOUSE SATURDAY & SUNDAY 1PM - 3PM' ,`Acres` = '0.229' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 45 BLK 1 MALLARD CROSSING SEC 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9977' ,`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` = '55 - Waller' ,`SchoolElementary` = '' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Mallard Xing Sec 1' ,`TaxAmount` = '6981' ,`TaxRate` = '3.256' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203183' WHERE `Matrix_Unique_ID` = '212485448' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T00:07:36.137' ,`MLSNumber` = '18213292' ,`ListAgentFullName` = 'Ilich Ramirez' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.869954' ,`Longitude` = '-95.742016' ,`PhotoCount` = '24' ,`PostalCode` = '77449' ,`RoomCount` = '10' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Verbena Blossom' ,`StreetNumber` = '6410' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1398' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 6410 Verbena Blossom Trail in Katy, Texas. The home is in the wonderful Lantana neighborhood. The home is a Beazer Homes home that features energy efficiency and is incredibly quiet on the inside. The home is a 3 bedroom, 2 bathroom home with an extended covered patio which is fantastic especially because the home has no back neighbors. The interior is very well appointed and looks wonderful! Come inside and take a look at this fantastic home.' ,`Acres` = '0.124' ,`Area` = '25' ,`BuilderName` = 'Beazer' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLK 1 LANTANA SEC 6' ,`LotDesciption` = 'Greenbelt,Other,Subdivision Lot' ,`LotSize` = '5400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '470' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WALKER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lantana' ,`TaxAmount` = '4883' ,`TaxRate` = '2.831' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203183' WHERE `Matrix_Unique_ID` = '212660159' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T00:42:08.887' ,`MLSNumber` = '4600602' ,`ListAgentFullName` = 'Wanda Pink' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.654423' ,`Longitude` = '-95.838221' ,`PhotoCount` = '12' ,`PostalCode` = '77406' ,`RoomCount` = '7' ,`ListPrice` = '1875000.00' ,`Status` = 'Active' ,`StreetName` = 'LEANING OAK TRAIL' ,`StreetNumber` = '703' ,`StreetSuffix` = 'Trail' ,`City` = 'Richmond' ,`BathsFull` = '6' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5541' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEST BUILT LUXURY HOME KNOW AS FORT KNOX. CONCERT AND STEEL. LAKE VEIW PROPERTY ON ONE ACRE NESTLED IN THE COUNTRY IN PRIVATE NEIGHBORHOOD!' ,`Acres` = '1.0234' ,`Area` = '30' ,`BuilderName` = 'ACE LIFESTYLES LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WHISPERING OAKS, BLOCK 1, LOT 13' ,`LotDesciption` = 'Water View' ,`LotSize` = '44579' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Whispering Oaks' ,`TaxAmount` = '5796' ,`TaxRate` = '1.7948' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1666203183' WHERE `Matrix_Unique_ID` = '212666301' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T01:22:01.060' ,`MLSNumber` = '50151048' ,`ListAgentFullName` = 'Lisa Kornhauser' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.709030' ,`Longitude` = '-95.449909' ,`PhotoCount` = '38' ,`PostalCode` = '77401' ,`RoomCount` = '11' ,`ListPrice` = '1875000.00' ,`Status` = 'Active' ,`StreetName` = 'Acacia' ,`StreetNumber` = '4402' ,`StreetSuffix` = 'Street' ,`City` = 'Bellaire' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '5579' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Situated on one of the most desirable, small quiet streets in the Inner Loop of Bellaire, 4402 Acacia is an oasis of serenity. 4 bedrooms & 3/2 Baths. First floor welcomes you w/ 2 story entry & open Formal Dining Room w/ walk-in wine room & Butler’s Pantry. Kitchen has stainless steel appliances, 2 sinks, granite counters, & ample storage. The Family Room has a gas fireplace, wood beams, & built-in storage. Large Study and Mud Room round out the 1st floor. The Primary Suite has a connected flex room, Primary Bath w/ 2 closets. Game Room is the perfect space to unwind, watch a movie, or play games. The Backyard features a large Covered Patio features an Outdoor Kitchen complete with grill, fridge, and sink, and also overlooks the backyard and Pool. The outdoor space here is a tranquil retreat with a hot tub, pool, waterfall feature and large green space. This home is so rare and the street is so close to Evelyn’s Park and should not be missed.' ,`Acres` = '0.2996' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bellaire Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 BLK 1 SYLVANIA COURTS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HORN ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean,Traditional' ,`Subdivision` = 'Sylvania Courts' ,`TaxAmount` = '39075' ,`TaxRate` = '2.2271' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203183' WHERE `Matrix_Unique_ID` = '212735242' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T01:22:01.060' ,`MLSNumber` = '2953436' ,`ListAgentFullName` = 'Joel Cirilo III' ,`ListOfficeName` = 'Liv Texas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.667387' ,`Longitude` = '-95.440280' ,`PhotoCount` = '38' ,`PostalCode` = '77025' ,`RoomCount` = '8' ,`ListPrice` = '846500.00' ,`Status` = 'Active' ,`StreetName` = 'Woodshire' ,`StreetNumber` = '4006' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3846' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You will immediately feel at home when you tour 4006 Woodshire! Wonderfully bright, this home incorporates large entertainment spaces, home office, bonus room, formal dining room, and an open living/ kitchen area. Entertain in style in this beautifully appointed kitchen featuring new stainless steel appliances, quartz countertops, tile backsplash, oversized kitchen island, large walk-in pantry, built-in microwave and cooktop. The generous owner\'s suite is made for relaxation and enhances a his-and-hers bathroom and a large walk-in closet. This home comes with all brand-new mechanical systems; Electrical panel, HVAC system, PEX lines w/ Tankless water heater, and smart garage-door openers. Enjoy the outdoor lifestyle in your shaded backyard which includes a wide porch and a large grassy area for yard games. The perfect space to consider building an underground pool. Near to parks, restaurants, grocery stores, cafes, and department stores. Schedule your private tour today. No Flood Zone!' ,`Acres` = '0.1653' ,`Area` = '20' ,`BuilderName` = 'Cozy Nest/ Lineage' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Willow Meadows Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 143 BLK 5 WESTWOOD SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHEARN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Left Side,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Westwood Sec 01' ,`TaxAmount` = '3882' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1666203183' WHERE `Matrix_Unique_ID` = '212920176' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T00:13:09.210' ,`MLSNumber` = '10161033' ,`ListAgentFullName` = 'Teresa Conrad' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.024340' ,`Longitude` = '-95.461189' ,`PhotoCount` = '45' ,`PostalCode` = '77090' ,`RoomCount` = '9' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Sweet Grass' ,`StreetNumber` = '1523' ,`StreetSuffix` = 'Trail' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3005' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Hidden Treasure in Ponderosa Forest! SAVE your electricity bill with SOLAR PANEL. A/C 2 yrs. heater 6 mos. New wood floor. Fresh interior/exterior paint. Travertine tiles thru out downstairs. Picture perfect 2 stories home double stain glass doors to welcome your guests. Lush landscape, palm trees along the walking path. Love the amazing TWO fireplaces as the focal point for family gathering. These 3 bedrooms 3.5 bath house has the spacious living, family room, formal dining. The Updated Kitchen has granite counter, potfiller, beautiful backsplash, double ovens. Game room or flex room upstairs with build in cabinets. Primary en-suite has one shower and tub rooms, two walk in closets. Two oversize secondary bedrooms have its own bathroom. Double width driveway has private gate to keep children or pets in. The private backyard features mature trees, storage shed & outdoor shower house. It can turn into a Man-Cave or guest house. Quiet neighborhood in FM 1960 and so close to I-45.' ,`Acres` = '0.1997' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 24 PONDEROSA FOREST SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '523' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PONDEROSA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ponderosa Forest Sec 04' ,`TaxAmount` = '4582' ,`TaxRate` = '2.4101' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203184' WHERE `Matrix_Unique_ID` = '212969381' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T01:26:25.583' ,`MLSNumber` = '7789129' ,`ListAgentFullName` = 'Carlos Alvarez' ,`ListOfficeName` = 'Texas Ally Real Estate Group,' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.618025' ,`Longitude` = '-95.479645' ,`PhotoCount` = '50' ,`PostalCode` = '77085' ,`RoomCount` = '3' ,`ListPrice` = '257900.00' ,`Status` = 'Active' ,`StreetName` = 'Mckinstry' ,`StreetNumber` = '6411' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1437' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Elegantly renovated, Beautiful Stone Front Wall, New exterior-interior Paint, All-Flooring with Ceramic Tile. Upgraded Kitchen with New Fixtures, Stainless Steel Appliances, Quartz Countertops and Backsplash in an open concept to Living-Dining room. Fridge included. Main Bedroom with customized Dresser Make-Up Vanity. Bathrooms with New Cabinets, New Fixtures and Ceramic Tile Showers. Spacious Backyard with a Large customized Porch makes a joyful environment in every season of the year. Swimming Pool Pump installed. Well-maintained Storage Shed. Outside of Flood Zone and never flooded. Near to ClubHouse with Swimming Pool, Basketball Court and Playgrounds. Accessible Location close by Sam Houston Parkway, 610 Loop and 59 Freeway.' ,`Acres` = '0.1909' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 26 WINDSOR VILLAGE SEC 5 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8316' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '60' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WINDSOR VILLAGE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Windsor Village Sec 05 R/P' ,`TaxAmount` = '3696' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203184' WHERE `Matrix_Unique_ID` = '213035103' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T01:22:01.060' ,`MLSNumber` = '91825614' ,`ListAgentFullName` = 'Jonathan McBain' ,`ListOfficeName` = 'Team Price, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.531815' ,`Longitude` = '-95.557213' ,`PhotoCount` = '17' ,`PostalCode` = '77459' ,`RoomCount` = '4' ,`ListPrice` = '410000.00' ,`Status` = 'Active' ,`StreetName` = 'Pomme Bay' ,`StreetNumber` = '6010' ,`StreetSuffix` = 'Pass' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2232' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Showing confirmation required. If pending, and need acceptance, call agent number listed. Pending does not mean accepted.** Pulte\'s \'\'Calla\'\' floor-plan built in 2012 has a fantastic roomy layout. From the front porch, the foyer flows into open island kitchen with granite counters, stainless steel appliances, staggered cabinetry, walk-in pantry, bright sunny dining and great room with entry to covered backyard patio. Master suite has 2 walk-in closets, dual sinks, garden tub and separate shower. Two additional bedrooms with full bath and 4th bedroom and bath upon entry into home. Full irrigation a plus for the new homeowner!' ,`Acres` = '0.14' ,`Area` = '38' ,`BuilderName` = 'Pulte' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIENNA VILLAGE OF ANDERSON SPRINGS SEC 11-A, BLOCK 1, LOT 11' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '6099' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SCHIFF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna Village Of Anderson Spgs Sec 11-A' ,`TaxAmount` = '7122' ,`TaxRate` = '2.8129' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666203184' WHERE `Matrix_Unique_ID` = '213150581' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T01:22:01.060' ,`MLSNumber` = '72978944' ,`ListAgentFullName` = 'Lisa Kornhauser' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = 'Noelia Schmidt' ,`SellingOfficeName` = 'Keller Williams Realty - Memorial' ,`Latitude` = '29.697192' ,`Longitude` = '-95.461014' ,`PhotoCount` = '17' ,`PostalCode` = '77401' ,`RoomCount` = '10' ,`ListPrice` = '824900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Welford' ,`StreetNumber` = '4710' ,`StreetSuffix` = 'Drive' ,`City` = 'Bellaire' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2959' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Situated on a coveted horseshoe street in Bellaire, don\'t miss this 4-bedroom brick traditional home on a 7070 sq ft lot! NO FLOODING. This home features a first-floor primary suite. There is a spacious first floor study or formal living room, formal dining room, family room with fireplace and kitchen with eat in breakfast area. The second-floor features 3 secondary bedrooms, 2 full bathrooms and a game room with fireplace. The backyard features a sparkling pool with fountain. Some recent updates include roof (2021), hot water heaters (2019), HVAC (2017-2018), Heaters (2021) and pool resurfaced, and pool motors rebuilt (2020) and more! Zoned to Condit Elementary & newly built Bellaire High. Don\'t miss!' ,`Acres` = '0.1623' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Bellaire Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 30 BELLVIEW' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7070' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CONDIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bellview' ,`TaxAmount` = '17324' ,`TaxRate` = '2.2271' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203184' WHERE `Matrix_Unique_ID` = '213151751' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T01:22:01.060' ,`MLSNumber` = '76679343' ,`ListAgentFullName` = 'Lisa Kornhauser' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.694107' ,`Longitude` = '-95.438446' ,`PhotoCount` = '30' ,`PostalCode` = '77025' ,`RoomCount` = '12' ,`ListPrice` = '1399000.00' ,`Status` = 'Active' ,`StreetName` = 'Durness' ,`StreetNumber` = '3823' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '5162' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss this exceptional 5-6 bedroom home built by award winning builder Stone Acorn Builders and conveniently located in the sought after Braes Heights neighborhood, this property is walking distance to Mark Twain Elementary, Pershing Middle School, Weekely Family YMCA, Karl Young Park, McGovern Library, and the McGovern Fields. All (3) new AC\'s (2020 and 2021)! The wonderful floor plan features a study on the first floor with an adjacent full bath (could be the 6th bedroom), formal dining room with adjunct butler\'s pantry, formal living room and an open concept family room and kitchen with an adjacent first floor playroom. The second floor boasts 5 bedrooms including a large primary suite with a luxurious spa bath. Quality construction plus fabulous architectural details and millwork throughout! The backyard includes a beautiful pool and spa, covered patio, new back fence (2022) and new turfed side yard (2022). The house never flooded!' ,`Acres` = '0.1722' ,`Area` = '17' ,`BuilderName` = 'Stone Acorn Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Braeswood Place' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 31 BRAES HEIGHTS SEC 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '75' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'TWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Braes Heights Sec 09' ,`TaxAmount` = '28453' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203184' WHERE `Matrix_Unique_ID` = '213152424' --> 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','213176938','1666203185','213176938','2022-10-19T00:20:11.950','79828136','Adeline Phan','Walzel Properties','','','29.663816','-95.734970','23','77407','7','359000.00','Active','Lake Georgetown','4915','Court','Richmond','2','0','4','2141','Single-Family','Don\'t miss this stunning 1 story extremely well maintained home. Fully renovated large one story house in desirable Waterside Estates community. NEW Luxury Vinyl Plank Flooring, NEW Interior/Exterior Paint, NEW Condenser, new Appliances (cooking range, oven, microwave and dishwasher), NEW Granite Counter Top, New Landscaping and Foundation Repairs. Walking distance to large shopping complex that has Kroger, Kumon, Spa, Restaurants and several other services. Easy access to HWY 99. Amazing amenities in the community including resort style pool, tennis courts, lakes & walking trails.','0.1389','37','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','0','Fort Bend County North/Richmond','Central Gas','1','WATERSIDE VILLAGE SEC 3, BLOCK 1, LOT 18','Subdivision Lot','6050','Appraisal District','','610','0','','2','Freestanding Oven','0','','','Gas Cooktop','','Composition','19 - Fort Bend','OAKLAND ELEMENTARY SCHOOL','TRAVIS HIGH SCHOOL (FORT BEND)','BOWIE MIDDLE SCHOOL (FORT BEND)','No Appointment Required','Appraisal District','1','Traditional','Waterside Village','5239','2.2929','Public Sewer,Public Water','2005','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T01:22:01.963' ,`MLSNumber` = '38364269' ,`ListAgentFullName` = 'Michelle Comulada' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = 'Yicel Alvarez' ,`SellingOfficeName` = 'Weichert,REALTORS-Murray Group' ,`Latitude` = '29.909496' ,`Longitude` = '-93.898329' ,`PhotoCount` = '9' ,`PostalCode` = '77642' ,`RoomCount` = '1' ,`ListPrice` = '192000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Mockingbird' ,`StreetNumber` = '247' ,`StreetSuffix` = 'Lane' ,`City` = 'Port Arthur' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1512' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your dream home is waiting for you! 3 bed 2 bath with lots of updates. Home offers an open concept kitchen with lots of natural light and a great floor plan layout. Brand new appliances, new paint, new fixtures, new roof. Large bedrooms with sizable closets. Extra room that can be used as a study/media room/toy room you decide. Lots of space for entertaining. Schedule your showing today!' ,`Acres` = '0.2525' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LIVE OAK TERRACE LT 4 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '236 - Port Arthur' ,`SchoolElementary` = 'LAKEVIEW ELEMENTARY SCHOOL (PORT ARTHUR)' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (PORT ARTHUR)' ,`SchoolMiddle` = 'JEFFERSON MIDDLE SCHOOL (PORT ARTHUR)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Live Oak Terrace' ,`TaxAmount` = '3958' ,`TaxRate` = '3.267' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203185' WHERE `Matrix_Unique_ID` = '213237323' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T00:40:40.107' ,`MLSNumber` = '17437502' ,`ListAgentFullName` = 'Kimblay West' ,`ListOfficeName` = 'Glass House Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.809219' ,`Longitude` = '-94.928451' ,`PhotoCount` = '25' ,`PostalCode` = '77521' ,`RoomCount` = '7' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Hunters Way Ln' ,`StreetNumber` = '6811' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1931' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing 4 bed/2 bath home in Hunters Creek. This home has the ideal open floor plan. Granite kitchen counter tops with a large island. Master suite has whirlpool tub, great after a long hard day. 4th bedroom right off the master suite can be used as a home office. New carpet (9/2022) in living area and front bedrooms. Home equipped with many energy features that you will love. Neighborhood offers a water splashpad and playground within walking distance of home. Comes equipped with security system including doorbell camera. You don\'t want to miss out on this amazing home. Owner is motivated to sale. Schedule your viewing today! Don\'t wait!' ,`Acres` = '0.1389' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 3 HUNTERS CREEK SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '480' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Hunters Crk Sec 01' ,`TaxAmount` = '7461' ,`TaxRate` = '3.63' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203185' WHERE `Matrix_Unique_ID` = '213279248' --> 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','213298765','1666203185','213298765','2022-10-19T00:20:35.830','50924263','Lorannette Lewis','In Town Properties','','','29.769631','-95.406403','21','77007','7','639900.00','Active','Lillian','4517','','Houston','2','1','3','2422','Single-Family','The \"Athens\", built by Sandcastle Homes, is a 2-story, freestanding home in Rice Military! The property\'s standard features include wood flooring in the living room, dining area and the stairs. \r\n\r\nEnjoy a spacious kitchen equipped with stainless steel appliances, custom cabinets, and quartz countertops! Head upstairs to the game room, complete with built-in shelves. All of the bedrooms, including the utility room, can be found on the second floor. \r\n\r\nThe Primary Bedroom is extremely spacious, allowing the buyer to get creative! Its spa-like bath is a dream with its two separate vanities, soaking tub, and shower. The home is in the early stages of construction with time left to pick certain alternative finishes and/or upgrades! Move-In-Ready in April 2023!','','16','Sandcastle Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','','','Rice Military/Washington Corridor','Central Electric','0','Lor 2, Block 1, Section 1','Cleared','2500','Survey','','','1','Never Lived In','2','Electric Oven','0','','','Gas Cooktop','','Composition','27 - Houston','MEMORIAL ELEMENTARY SCHOOL (HOUSTON)','HEIGHTS HIGH SCHOOL','HOGG MIDDLE SCHOOL (HOUSTON)','Appointment Required,Leave Business Card','Builder','2','Traditional','Garden Homes on Lillian','','','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T01:22:01.060' ,`MLSNumber` = '75445831' ,`ListAgentFullName` = 'Debbie Levine' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.690891' ,`Longitude` = '-95.474552' ,`PhotoCount` = '15' ,`PostalCode` = '77401' ,`RoomCount` = '8' ,`ListPrice` = '495000.00' ,`Status` = 'Active' ,`StreetName` = 'Maple' ,`StreetNumber` = '5225' ,`StreetSuffix` = 'Street' ,`City` = 'Bellaire' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1918' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming home with pool surrounded by new construction in ideal Bellaire location. This home is in walking distance to Bellaire High School and features formal living and dining, hardwood floors, walls of windows, den area overlooking the lush backyard and spacious kitchen with built-in desk area. Advanced security system, recent interior paint, recent pool pump and HEPA filter HVAC system are other great features of this home. This home would make a great rental property or live in now and build later. In close proximity to the Bellaire Recreation Center and Bellaire Library as well as just minutes away to the Texas Medical Center, Rice University and Galleria. This is a great opportunity to get into this wonderful neighborhood. Seller to make no repairs and is selling in as-is condition.' ,`Acres` = '0.1686' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bellaire Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 7 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7345' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Braeburn Gardens Sec 01' ,`TaxAmount` = '9065' ,`TaxRate` = '2.2271' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1952' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203185' WHERE `Matrix_Unique_ID` = '213300222' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T00:38:59.427' ,`MLSNumber` = '58673344' ,`ListAgentFullName` = 'Tod Franklin' ,`ListOfficeName` = 'DFWCityhomes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '26.011191' ,`Longitude` = '-97.545996' ,`PhotoCount` = '6' ,`PostalCode` = '78520' ,`RoomCount` = '9' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Hana' ,`StreetNumber` = '7484' ,`StreetSuffix` = 'Drive' ,`City` = 'Brownsville' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great house I\'m a new subdivision. 3 bedroom and a bonus room that could be a 4th or office. Porcelain tile all over the house. Fenced yard.' ,`Acres` = '0.1515' ,`Area` = '85' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 33 BLK 1 ROSEWOOD ESTATES SECTION ONE (2020 PLAT C1-3878' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '695 - Los Fresnos Consolidated' ,`SchoolElementary` = 'VILLAREAL ELEMENTARY SCHOOL' ,`SchoolHigh` = '' ,`SchoolMiddle` = 'RESACA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Rosewood Estates Sub Sec I' ,`TaxAmount` = '5260' ,`TaxRate` = '2.5531' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203185' WHERE `Matrix_Unique_ID` = '213409362' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T01:22:01.060' ,`MLSNumber` = '87087382' ,`ListAgentFullName` = 'Tonia Jaeggi' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.017152' ,`Longitude` = '-95.758787' ,`PhotoCount` = '45' ,`PostalCode` = '77433' ,`RoomCount` = '11' ,`ListPrice` = '545000.00' ,`Status` = 'Active' ,`StreetName` = 'China Green' ,`StreetNumber` = '21607' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3560' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lakefront Trendmaker home in the master planned community of Fairfield. PRIMO location! Just a short walk to the pool, baseball fields, schools & Fairfield Athletic Center. The home offers high ceilings & an open floorplan perfect for entertaining. Family room, kitchen & dining are all open to each other. All bedrooms down, versatile floorplan w/study over looking the lake. Tons of closets & cabinets make this home superb for storage! Custom features like extensive trim, built-ins, curved breakfast bar, layered ceilings & niches. Island kitchen features 42\" cabinets, SS Appliances, Gas Cooktop & is open to den. Primary offers layered ceiling & GORGEOUS views of the lake! POSH master bath has long jetted tub, double vanities w/lots of storage, 2 walk-in closets & oversized shower. Secondary bedrooms have updated shower w/handicap accessibility. Upstairs you will find a large gameroom w/a private bath that could easily be a 5th bedroom or media room. Fresh carpet throughout the house!' ,`Acres` = '0.2323' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 2 FAIRFIELD VILLAGE NORTH SEC 4' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '10118' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '970' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'SWENKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairfield Village North Sec 04' ,`TaxAmount` = '12235' ,`TaxRate` = '2.611' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203186' WHERE `Matrix_Unique_ID` = '213416440' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T01:22:01.060' ,`MLSNumber` = '62241947' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.405771' ,`Longitude` = '-95.508276' ,`PhotoCount` = '23' ,`PostalCode` = '77494' ,`RoomCount` = '7' ,`ListPrice` = '434000.00' ,`Status` = 'Active' ,`StreetName` = 'Lemonwood' ,`StreetNumber` = '2722' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2356' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Thornleigh combines easy elegance with the streamlined versatility to adapt to your family’s lifestyle changes through the years. Escape to the everyday vacation of your Owner’s Retreat, which includes a delightful bathroom and a deluxe walk-in closet. Your open-concept living space awaits your interior design style to create the ultimate atmosphere for special occasions and daily life. The streamlined kitchen is optimized to support solo chefs and family cooking adventures. Unique decorative flair and growing minds are equally at home in the lovely spare bedrooms. Craft the perfect specialty rooms for you and yours in the incredible downstairs sunlit study and the cheerful upstairs retreat. Experience the benefits of living in an award winning urban planned development of The Woodlands Hills with miles of hiking and biking trails. Resort style amenities include adult lap pool, full size gym, splash pad and lazy river. Home is situated on oversize corner cul-de-sac homesite.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 21 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7159' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Jordan Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666203186' WHERE `Matrix_Unique_ID` = '213502962' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T00:25:58.937' ,`MLSNumber` = '94964839' ,`ListAgentFullName` = 'Carlazeli Garcia' ,`ListOfficeName` = 'Ross & Marshall Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.722655' ,`Longitude` = '-95.632229' ,`PhotoCount` = '43' ,`PostalCode` = '77082' ,`RoomCount` = '4' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Naomi Hollow' ,`StreetNumber` = '13802' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 13802 Naomi Hollow Lane! At 2,500 heated square feet, this 4 bedroom, 2.5 bathroom home has plenty of space! Home sits on a corner lot showing pride and joy. Property features new paint, updated kitchen and bathrooms, plus more! The addition of the covered patio with a ceiling fan makes it the perfect area for entertaining. Its subdivision has exclusive access to Brays Bayou Park, next to the community pool and playground. Brays Bayou Park is a 337 acre multi-use area and includes 5+ miles of hike and bike trails. \r\n\r\nHome has lifetime transferable foundation warranty! Never flooded! No Mud taxes and low HOA fees.\r\n\r\nBe sure to check out the virtual tour, our open house this Saturday or Sunday (12-3PM), and schedule your showing today!' ,`Acres` = '0.1309' ,`Area` = '31' ,`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` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 102 BLK 5 (ORIG RES L BK 7) WESTHOLLOW VILLAGE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = 'Enclosed' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'HEFLIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'O\'DONNELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westhollow Village Sec 01 Correcti' ,`TaxAmount` = '5822' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203186' WHERE `Matrix_Unique_ID` = '213522529' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T00:18:40.067' ,`MLSNumber` = '91924842' ,`ListAgentFullName` = 'Vera Mitrofanova' ,`ListOfficeName` = 'VAM Real Estate Solutions' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.760756' ,`Longitude` = '-95.763894' ,`PhotoCount` = '39' ,`PostalCode` = '77450' ,`RoomCount` = '9' ,`ListPrice` = '380000.00' ,`Status` = 'Active' ,`StreetName` = 'Lamplight Trail' ,`StreetNumber` = '1427' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2378' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Seller will contribute $5,000 towards buy-down points to reduce buyers’ interest rate! Hidden gem of Cinco Ranch! Beautiful spacious corner house with high vaulted ceiling with tons of natural light, formal living room with fireplace to cozy up during cold days, huge den with dining area. 4 bedrooms, the 4th bedroom can be used as an office, if need be. Freshly painted throughout all house. Only the primary bedroom has recently installed carpet, the rest of the house has hard flooring. The primary bathroom has shower, tub and double sinks. The kitchen has a plethora of cabinets and storage. Bathrooms and breakfast area have recent light fixtures. The side street does not go through. Perfect for extra parking or extra play areas for kids. A good sized backyard is ready for family gatherings and barbeque. Enjoy recreation amenities including multiple parks, tennis courts, swimming pools of Cinco Ranch. Welcome Home!!!' ,`Acres` = '0.1765' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLK 4 CINCO RANCH MEADOW PLACE SEC 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7688' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1115' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'FIELDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'BECK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cinco Ranch Meadow Place Sec 0' ,`TaxAmount` = '6983' ,`TaxRate` = '2.6083' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203186' WHERE `Matrix_Unique_ID` = '213578923' --> 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','213608896','1666203186','213608896','2022-10-19T00:52:11.617','68397897','Thomas Caine','Texas United Realty','','','29.928702','-95.457634','10','77038','4','149900.00','Active','Woodtown','2514','Drive','Houston','2','0','3','1264','Single-Family','Come see this investor special. Will make a great buy and hold. Come make this one your own with cosmetic updates to make it a flip or a beautiful long term rental. With a $210K ARV, plenty of margins for you. SOLD AS IS. NO OPTION PERIOD. NO REPAIRS BY THE SELLER. DO NOT PRESENT OFFERS BELOW $145k, THEY WILL NOT BE ANSWERED.','0.1727','11','','','','','Sellers Disclosure','','','','Aldine Area','Central Gas','0','LT 10 BLK 13 WOODGATE SEC 2','Subdivision Lot','7524','Appraisal District','','','0','','2','','0','','','','','Composition','1 - Aldine','SAMMONS ELEMENTARY SCHOOL','DAVIS HIGH SCHOOL (ALDINE)','GARCIA MIDDLE SCHOOL','Lockbox Front','Appraisal District','1','Traditional','Woodgate Sec 02','3361','2.8503','Water District','1979','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T00:09:17.753' ,`MLSNumber` = '13273740' ,`ListAgentFullName` = 'Saira Barron' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.361871' ,`Longitude` = '-95.621250' ,`PhotoCount` = '24' ,`PostalCode` = '77316' ,`RoomCount` = '3' ,`ListPrice` = '224900.00' ,`Status` = 'Active' ,`StreetName` = 'Juneau' ,`StreetNumber` = '16863' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1482' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS HOME IS UNDER CONSTRUCTION. Approximate completion by the end of December. \r\n\r\nNew construction by QC Homes! Single story 3 bed 2 and a half bath charmer. Large open-concept living area with lots of natural light and high vaulted ceilings which provide a wonderful sense of space. Eye catching wood look tile floors throughout home with high quality fixtures. The kitchen boasts a fresh modern look with gorgeous granite countertops, beautiful wood cabinets, large pantry for storage, and stainless steel appliances. The primary bath has a very nice shower with a calming spa feel and there is a wonderful yard with a covered back patio for entertaining. You\'ve got to see this home in person! \r\n\r\nThe pictures are from a previously sold home which had the same floor plan. Slight design changes may vary. If you put this home under contract fast enough you can select from a variety of custom color/material options to give this home your personal touch!' ,`Acres` = '0.0494' ,`Area` = '39' ,`BuilderName` = 'QC Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE CONROE VILLAGE, BLOCK 17, LOT 31' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2150' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '384' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Lake Conroe Village' ,`TaxAmount` = '149' ,`TaxRate` = '1.825' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1666203186' WHERE `Matrix_Unique_ID` = '213652354' --> 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','213653224','1666203187','213653224','2022-10-19T00:35:07.970','78889876','Glory Crafts','RE/MAX Fine Properties','','','29.572186','-95.626146','50','77479','4','699900.00','Active','Turnberry','3931','Drive','Sugar Land','2','1','4','3462','Single-Family','This GORGEOUS home located on a Premier Sweetwater Golf Course lot will impress you from the moment you walk in. The Private Courtyard welcomes you with an Arched Wrought Iron Gate and a Koi Pond. The Masterful Architectural Design, Dramatic Fireplace, Staircase, and Soaring Ceilings adorn the Breathtaking Foyer and formal living room. The kitchen was designed with entertaining in mind. It opens to the breakfast and family room and features granite and a designer backsplash. The WALL OF WINDOWS capture the MILLION DOLLAR VIEWS of Sweetwater Golf Course and provide abundant natural light and Ambiance. The formal dining is elegant and Dinner Party Ready! The Romantic primary retreat is Luxurious and provides Tranquil Privacy and a Balcony off the bedroom. The executive study is spacious, and features built in bookshelves. The covered Patio is Perfect for your morning coffee or dining Alfresco and enjoying your Oasis and the Serene Golf Course views. Zoned to Top Ranked schools.','0.2118','29','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Levee District,Sellers Disclosure','1','Freestanding','2','Sugar Land South','Central Gas','1','FIRST COLONY MUD #5 PARCEL H, BLOCK 1, LOT 9','On Golf Course','9224','Appraisal District','','900','0','','2','','0','','','Electric Cooktop','','Composition','19 - Fort Bend','COLONY MEADOWS ELEMENTARY SCHOOL','CLEMENTS HIGH SCHOOL','FORT SETTLEMENT MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal','2','Traditional','First Colony Mud #5 Prcl H','10489','2.1584','Public Sewer,Public Water','1992','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','213744531','1666203187','213744531','2022-10-19T00:53:26.760','37932017','CHUCK EJIM','Discovered Homes Inv. Inc.','','','29.673751','-95.491313','44','77096','9','465000.00','Active','Queensloch','5834','Drive','Houston','2','0','3','2174','Single-Family','Charming Maplewood South home transformed into a sleek, contemporary design. Upon entry you are greeted with gleaming flooring that sets the tone for the neutral, warm color palette throughout. Dining area was built in with the entertainer in mind. Stainless steel appliances, gracious prep space, sleek Quartz countertops, and abundant storage entice your inner chef! Natural light flows in through expansive new windows and glass paned doors lead to a spacious patio ideal for dining, game nights or cookouts. Enjoy mornings in the accent-painted breakfast room & take in views of the large backyard. Two spacious secondary bedrooms with an abundance of closet space share an remodeled hall bath with granite countertops & tub/shower. Generous sized primary bedroom offers a remodeled bath complete with private shower, spacious walk in closet, and private access to the backyard retreat through French doors. Updates include designer fixtures &lighting and remote-controlled fans','0.1928','20','','','Electric Dryer Connections,Washer Connections','','Owner/Agent,Sellers Disclosure','1','Wood Burning Fireplace','1','Meyerland Area','Central Electric','1','LT 22 BLK 12 MAPLEWOOD SOUTH SEC 4','Cul-De-Sac','8400','Appraisal District','','489','0','','2','Convection Oven','0','','','Electric Cooktop','','Composition','27 - Houston','PARKER ELEMENTARY SCHOOL (HOUSTON)','WESTBURY HIGH SCHOOL','MEYERLAND MIDDLE SCHOOL','Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Traditional','Maplewood South Sec 04','5644','2.3307','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','213765050','1666203187','213765050','2022-10-19T00:21:26.733','15828860','Johnny Quarles','Katy-Fulshear Real Estate','','','29.947058','-96.287615','21','77418','4','759000.00','Active','S Garrett','287','Circle','Bellville','3','1','4','3244','Single-Family','NEW BUILD 3244 s/f in the new WEST HILLS subdivision -in the rolling hills and gorgeous landscapes on the outskirts of historic Bellville - @1.8 acres, 4 Bedrooms. This home will be LOADED with options, Brand New Construction from custom builder Monogram Customs. @400 s/f covered back porch. Modern Farmhouse Design. 8\'doors, High Ceilings, Upgraded Entry Door, Stone/Hardie exterior, High-Pitched Roof. Oversized 3-Car Garage. Prepped for Outdoor Kitchen. Low-e Energy Efficient Windows. Coffered Greatroom Ceiling. 3.5 baths, Custom Cabinets, Induction Cooktop, Large Country Style Pantry, Energy Conserving Fireplace, Wide Plank Hardwood, Wine Fridge, Master Closet Shelving/Drawer Package, large Covered Front Porch, Tankless Hot Water System, Island Kitchen, Quartz Countertops. Laundry Room pre-plumbed for fridge, Samsung Microwave/Oven/Convection combo. Energy Recovery System, Foam Insulation Upgrade (see video), Multi-Zone HVAC, City Water, Conventional Septic. NOT in flood zone.','1.8','57','Monogram Homes, LLC','','Electric Dryer Connections','','Other Disclosures','1','Mock Fireplace','1','','Heat Pump','1','West Hills Subdivision Lot 52','Subdivision Lot','78669','Appraisal District','','300','1','To Be Built/Under Construction','','Convection Oven,Electric Oven','0','','','Electric Cooktop','','Composition','136 - Bellville','WEST END ELEMENTARY SCHOOL','BELLVILLE HIGH SCHOOL','BELLVILLE JUNIOR HIGH','Appointment Required,Supra Keybox','Builder','1','Ranch,Traditional','West Hills','','','Public Water,Septic Tank','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','213817179','1666203187','213817179','2022-10-19T00:06:39.290','6264084','Kyle Watts','RE/MAX Leading Edge','','','29.289129','-94.799750','7','77550','7','399000.00','Active','Bernardo De Galvez','3201','','Galveston','1','0','3','1729','Single-Family','Investors, Flippers, and Historical Enthusiast, this is the Home for you! This Charming Historic home sits on a CORNER LOT, and is certified 1900 storm survivor, estimated to have been built in 1892! With original flooring and transoms, the home has maintained the original Historic feel. Although the home needs some TLC, there is plenty of space inside and out to make your dreams happen. Below the main level there are living quarters that are partially finished out which could be utilized in a variety of ways. There is plenty of potential for this space, it could be converted into a duplex, a short-term rental on the bottom, a workshop, or simply a flex living space. Book your showing today and check out this unique home!','','33','','','','','Sellers Disclosure','1','','1','East End','Wall Heater','0','ABST 628 M B MERNARD SUR LOT 7 NW BLK 88 GALVESTON OUTLOTS','Corner','5140','Appraisal District','','','0','','1','','0','','','','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Other Style','GALVESTON OUTLOTS','8156','2.066223','Public Sewer,Public Water','1892','Seller'); --> 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','213817835','1666203187','213817835','2022-10-19T00:05:50.930','47129781','Valentina Lares','Energy Realty','','','29.761179','-95.485798','39','77057','8','2177000.00','Active','Crab Orchard','6023','Road','Houston','5','1','4','4454','Single-Family','This masterfully REMODELED home is situated on a quiet street in the heart of TANGLEWOOD.\r\nRenovated from top to bottom by MCP HOMES–entering through the dramatic OVERSIZED\r\nSTEEL FRAME and glass doors will be sure to impress.Interior features include 21ft\r\nCEILINGS, QUARTZ countertops, contemporary French Oak HARDWOOD floors, new electrical,\r\nLED LIGHTS throughout, PEX plumbing,new HVAC systems,DOUBLE-PANE windows.The\r\nChef\'s kitchen boasts a 48in-7 BURNER and Double Oven Gas Range,48in sink,WINE\r\nCELLAR,butler\'s pantry,and ISLAND with plenty of room for seating. Home offers 4\r\nbedrooms, 5.5 bathrooms, and 2 ADDITIONAL FLEX ROOM spaces, convertible into home office,\r\ngym or 5 th bedroom.Updated exterior features include a METAL ROOF,WHITE GERMAN\r\nSCHMEAR painted bricks, artificial Turf, new sprinklers and drainage, TRAVERTINE pool decking,\r\nreplastering of pool, coping and all new pool equipment, GENERATOR (Generac Protector 36KW\r\nStandby Generator), electric gate and new driveway.','0.1857','22','','','','','Sellers Disclosure','1','','1','Tanglewood Area','Central Gas','1','LT 21 BLK 64 TANGLEWOOD SEC 18','Cleared','8088','Appraisal District','','1650','0','','2','','1','In Ground','','','','Aluminum','27 - Houston','BRIARGROVE ELEMENTARY SCHOOL','WISDOM HIGH SCHOOL','TANGLEWOOD MIDDLE SCHOOL','Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied','Appraisal District','2','Contemporary/Modern','Tanglewood Sec 18','27651','2.3307','Public Sewer,Public Water','1976','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','213818584','1666203187','213818584','2022-10-19T00:25:24.973','30595808','Maihuong Nguyen','Precious Realty & Mortgage','','','29.758951','-95.869824','42','77494','11','660000.00','Active','Parker Ridge','28943','Drive','Katy','3','1','4','3709','Single-Family','Wow, beautiful 2 story home w 4 beds, 3 full baths & a half bath, study room, 2 car tandem garage. Beautiful elevation w stucco, 4 sided brick at corner lot. Wood floor throughout except for carpet in master bedroom on first level. Beautiful kitchen features gray cabinetry w plenty of cabinets, quartz countertop, stainless steel appliances: vent hood, gas cooktop, built in oven and microwave, dishwasher, fridge. Spacious family room with high ceiling, large windows with natural light. House comes with over $5k roll up curtains. Family room opens to breakfast area and kitchen. The master ensuite features a spacious living space, separate garden tub and shower, walk in closet, double vanities. Big game room and other 3 bedrooms on second level. Fridge, washer, dryer stay. Community amenities offer pool, tennis courts, lakes and trails, fitness center, clubhouse and more. Lamar Consolidated ISD. Never flooded. Close to I-10 and 99. Lot of shopping nearby. Low tax rate. Ready to move in.','0.2157','30','Ashton Woods','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Katy - Southwest','Central Gas','1','FIRETHORNE WEST SEC 19, BLOCK 2, LOT 1','Subdivision Lot','9398','Appraisal District','','800','0','','2','Gas Oven,Single Oven','0','','','Gas Cooktop','','Composition','33 - Lamar Consolidated','LINDSEY ELEMENTARY SCHOOL','FULSHEAR HIGH SCHOOL','ROBERTS/LEAMAN JUNIOR HIGH SCHOOL','Supra Keybox','Builder','2','Traditional','Firethorne West Sec 19','1406','2.5848','Public Sewer,Public Water','2021','Builder'); --> New record created successfully