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-23T09:39:24.817' ,`MLSNumber` = '30432582' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.162967' ,`Longitude` = '-95.621005' ,`PhotoCount` = '27' ,`PostalCode` = '77486' ,`RoomCount` = '7' ,`ListPrice` = '339000.00' ,`Status` = 'Active' ,`StreetName` = 'Riveroaks' ,`StreetNumber` = '2260' ,`StreetSuffix` = 'Drive' ,`City` = 'West Columbia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2264' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Just Reduced! MLS# 30432582 Out With The Old! In With The BRAND NEW! Be the FIRST to live here! Quick Move-In! 3BD 2BA 2,264 sq ft! High Ceilings! Open Concept! This home has everything you\'re looking for! 3-Sides Brick! 3-Car Garage for extra storage space or shop space! Covered Patio! Level 3 Quartz Kitchen Counters w/ Island! Modern White 42\" Kitchen Cabinets! 15\'ceiling in Dining area! Stainless finish appliances! Inviting Owner\'s Suite! Huge Walk-in Closet! Soaker Tub & Separate Shower! Over-sized study w/double doors! 2\'\' Faux blinds! Wall of windows! Energy-Efficient! HERS Rated! No Flooding! Tankless Water Heater! Low Tax Rate 2.186 before homestead! Offers a golf course family-friendly gated community! Easy Commute to Hwy 288! It\'s GREAT to have EVERYTHING NEW! Enjoy peace of mind! You\'ll receive an industry leading 2-year mechanical/10-year structural limited warranty with your Castlerock home purchase! Make your move to Columbia Lakes today!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 30, Block 12, Section 2' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '9750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Columbia Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666556975' WHERE `Matrix_Unique_ID` = '206837861' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:21:45.400' ,`MLSNumber` = '82751891' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.943990' ,`Longitude` = '-95.688451' ,`PhotoCount` = '23' ,`PostalCode` = '77433' ,`RoomCount` = '7' ,`ListPrice` = '640000.00' ,`Status` = 'Active' ,`StreetName` = 'Bryson Creek' ,`StreetNumber` = '11534' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2684' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Explore the freedom to design exquisite living spaces in the vibrant elegance of this spectacular new home in Towne Lake’s Marina Bay! The Ketner by David Weekley Homes offers single-level living and a spacious floor plan. High ceilings, sophisticated flooring, and energy-efficient windows allow the open living spaces to impress from the front door to the breezy Outdoor Living Area. A private study sits at the front of this home, where it can easily serve as an inviting den, quiet home office, or a fun-filled media lounge. The oversized Owner\'s Retreat includes a deluxe en suite bathroom and a large walk-in closet. A variety of designer upgrades await in the gourmet kitchen, including quartz countertops that extend out into the dining space to create a refined buffet. Two oversized secondary bedrooms, each with very own bathroom. The outdoor living area provides a sensational place to relax on breezy mornings and host unforgettable cookouts.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 07 Block 01' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1674' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'RENNELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Towne Lake' ,`TaxAmount` = '' ,`TaxRate` = '3.47' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666556975' WHERE `Matrix_Unique_ID` = '206973973' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:41:44.700' ,`MLSNumber` = '39515412' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.168767' ,`Longitude` = '-95.634289' ,`PhotoCount` = '21' ,`PostalCode` = '77486' ,`RoomCount` = '6' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Green Meadows' ,`StreetNumber` = '439' ,`StreetSuffix` = 'Drive' ,`City` = 'West Columbia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1801' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 39515412 Built by CastleRock NEW HOME UNDER CONSTRUCTION! Greeley (C) 1-Story 3BD 2 BA 3 Car Garage 1,801 sq ft! High Ceilings! Open Concept! Impressive Interior Upgrades! Modern White 42\" Kitchen Cabinets! Quartz Counters! Stainless finish appliances exude refinement and elegance! Inviting Owner\'s Suite! Soaker Tub & Separate Shower! 2\'\' Faux blinds! Wall of windows! Energy-Efficient! HERS Rated! No Flooding! Tankless Water Heater! Low Tax Rate 2.186 before homestead! Covered Patio! Offers a golf course family-friendly gated community, Easy Commute to Hwy 288, Exciting Pearland Town Center, Houston, Bay City, Sweeny & Lake Jackson! Experience the breathtaking sandy beach views just 30 mins away! CastleRock offers NEW HOMES in various stages of construction for those who are looking for spacious 1 & 2 story layouts and Quick Move-In Homes. Nestled in Natural Splendor Enjoy Country Living in Columbia Lakes! Best kept secret south of Houston! Schedule a tour today!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 82, Block 31, Section 3' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '9375' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Columbia Lakes' ,`TaxAmount` = '' ,`TaxRate` = '2.186' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1666556976' WHERE `Matrix_Unique_ID` = '207462423' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:30:43.813' ,`MLSNumber` = '7160353' ,`ListAgentFullName` = 'Misty Gustin' ,`ListOfficeName` = 'RE/MAX Crossroads Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.355166' ,`Longitude` = '-95.081566' ,`PhotoCount` = '11' ,`PostalCode` = '77510' ,`RoomCount` = '6' ,`ListPrice` = '310000.00' ,`Status` = 'Active' ,`StreetName` = 'S Fm 646' ,`StreetNumber` = '6228' ,`StreetSuffix` = 'Road' ,`City` = 'Santa Fe' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1008' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'So many options with this rare find! This 2+ acre cleared property has a charming 2/1 cottage and a HUGE 60x40 shop with 3 roll up doors and a living/kitchen space with a half bath. Conveniently located on FM 646 and having a separate driveway to the shop makes this a prime location for a possible home business or could easily be used for your hobbies. The property really opens up behind the shop to reveal a beautiful, cleared area. This home has so many possibilities including income producing potential. Come see this one today!' ,`Acres` = '2.135' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 48 L CRAWFORD SUR PT OF OUTLOT 215 (215-21) ALTA LOMA O' ,`LotDesciption` = 'Cleared' ,`LotSize` = '93001' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'DAN J KUBACAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Alta Loma Outlots' ,`TaxAmount` = '3706' ,`TaxRate` = '2.3536' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556976' WHERE `Matrix_Unique_ID` = '207804087' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:15:04.283' ,`MLSNumber` = '57243857' ,`ListAgentFullName` = 'Lisa Rimmer' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.500156' ,`Longitude` = '-95.014758' ,`PhotoCount` = '47' ,`PostalCode` = '77573' ,`RoomCount` = '16' ,`ListPrice` = '1449000.00' ,`Status` = 'Active' ,`StreetName` = 'Lake Star' ,`StreetNumber` = '3918' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '6' ,`SqFtTotal` = '9606' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spectacular one of a kind Perry home sprawling over 1 acre of lush gardens, koi pond, and incredible lake views in the desired community of Whispering Lakes Ranch. Enter into an impressive foyer with high ceilings, large windows with custom coverings, and a private elevator. 1st floor Primary bedroom complete with your own fireplace, sitting area, and two huge walk-in closets with 2 safes included. Massive kitchen with custom cabinets, quartzite countertops, a sub-zero refrigerator built-in, and Wolf appliances. Spacious family gathering rooms. Two laundry rooms complete with washers/dryers, ice maker, and craft area. Three staircases take you upstairs where you will find five well appointed bedrooms, walk in closets, game room, bonus room and study. Storm shutters on all windows. Enjoy the outdoors with a large covered patio, sun shade, and beautiful fountains around the tranquil koi pond. Lake and walking trail access from backyard. Click on Virtual tour and matterport pictures!' ,`Acres` = '1.1' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WHISPERING LAKES RANCH SEC 2 PHASE I (2006) ABST 630, BLOCK' ,`LotDesciption` = 'Water View' ,`LotSize` = '47914' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven,Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'SANDRA MOSSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Whispering Lakes Ranch Sec 2 P' ,`TaxAmount` = '22353' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556976' WHERE `Matrix_Unique_ID` = '208196686' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:22:42.527' ,`MLSNumber` = '16167987' ,`ListAgentFullName` = 'Latisha Yates' ,`ListOfficeName` = 'Latisha Yates Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.511565' ,`Longitude` = '-95.457197' ,`PhotoCount` = '23' ,`PostalCode` = '75844' ,`RoomCount` = '5' ,`ListPrice` = '219900.00' ,`Status` = 'Active' ,`StreetName` = 'County Rd 1855' ,`StreetNumber` = '630' ,`StreetSuffix` = '' ,`City` = 'Grapeland' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1104' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cozy country home with pipe entrance and large shade trees on approx 6.2 +/-acres, 3 bedrooms/1 bath with spacious rooms, master has his & her closets, metal roof, 1 car garage with storage room attached, 2 car carport attached and large back deck. Home offers fenced pasture ready for horses/livestock with small stall and separate pole barn with stall and enclosed tack room. Property is 2 tracts of land approx 3.1acr (per county tax records)each both totaling approx 6.2 +/- acres per tax records. Additional homesite is available With electric and water meters in place and in service, where Barn is located a mobile home existed prior to removal, can be used For RV or mobile home. Enclosed tack room offers concrete slab, w/d hookups and toilet. Many possibilities for this property. Home feels larger than actual Sq ft. Vacant and ready for a new family!!! Seller is licensed real estate broker, seller never lived in home. Family owned since home was built. Photos taken prior to vacancy.' ,`Acres` = '6.2' ,`Area` = '41' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Grapeland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'B DAVIS AB 323 3.10 AC' ,`LotDesciption` = 'Cleared' ,`LotSize` = '270072' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '58 - Grapeland' ,`SchoolElementary` = 'GRAPELAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAPELAND HIGH SCHOOL' ,`SchoolMiddle` = 'GRAPELAND JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'N/A' ,`TaxAmount` = '2064' ,`TaxRate` = '1.6377' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556976' WHERE `Matrix_Unique_ID` = '209237271' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:40:00.570' ,`MLSNumber` = '11280592' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.161477' ,`Longitude` = '-95.627369' ,`PhotoCount` = '31' ,`PostalCode` = '77486' ,`RoomCount` = '9' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Freeman' ,`StreetNumber` = '314' ,`StreetSuffix` = 'Boulevard' ,`City` = 'West Columbia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2513' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Need more Room? We\'ve got it! Check out this brand new Castlerock home in Columbia Lakes! Quick Move-In! Trinity Plan 2-Story 4 BD 2.5 BA 3 Car Garage 2,513 sq ft with Gameroom upstairs & Study! High ceilings! Impressive Interior Upgrades! Island kitchen with 42\" white cabinets! Granite countertops! Glass pendant lighting! Stainless finish appliances! Inviting Owner\'s Suite! Soaker Tub & Separate Shower! Walk-in Closet! 2\'\' Faux blinds! Wall of windows! From the moment you walk in, you\'ll love the light, bright and open design. Warm neutral flooring and high ceilings lead you into this beautiful new home! Primary Bedroom 1st floor! 3 spacious bedrooms up! Nice size closets! You\'ll appreciate the 3rd car garage for extra storage! Enjoy laid-back living! Just reduced! Hurry! This one won\'t last long!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 20, Block 21, Section 2' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '9120' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Columbia Lakes' ,`TaxAmount` = '' ,`TaxRate` = '2.186289' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666556976' WHERE `Matrix_Unique_ID` = '209616820' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:41:06.027' ,`MLSNumber` = '55337590' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.166932' ,`Longitude` = '-95.637929' ,`PhotoCount` = '19' ,`PostalCode` = '77486' ,`RoomCount` = '9' ,`ListPrice` = '376000.00' ,`Status` = 'Active' ,`StreetName` = 'Green Meadows' ,`StreetNumber` = '553' ,`StreetSuffix` = 'Drive' ,`City` = 'West Columbia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2507' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 55337590 No Back Neighbors! BUILT BY CASTLEROCK UNDER CONSTRUCTION! Rio Grande (A-Elevation) 2-Story 4 BD 2.5 BA 3 Car Garage 2,507 sq ft! Lot Size 9,374 sq ft. High Ceilings! Open Concept! Impressive Interior Upgrades! Modern White 42\" Kitchen Cabinets! Quartz Counters! Stainless finish appliances exude refinement and elegance! Inviting Owner\'s Suite! Soaker Tub & Separate Shower! Wall of windows! Energy-Efficient! HERS Rated! No Flooding! Tankless Water Heater! Low Tax Rate 2.186! Offers a golf course family-friendly gated community, Easy Commute to Hwy 288, Exciting Pearland Town Center, Houston, Sweeny, Bay City, Angleton & Lake Jackson! Enjoy the beach just 30 mins away! CastleRock offers BRAND NEW HOMES! Spacious 1 & 2 Story plans! Quick Move-In Homes Available! Explore the natural splendor and enjoy laid-back living in Columbia Lakes where neighbors gather and beautiful memories are made. Come take a look! Schedule a tour today!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 101, Block 31, Section 3' ,`LotDesciption` = 'Greenbelt,In Golf Course Community,Subdivision Lot' ,`LotSize` = '9372' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Columbia Lakes' ,`TaxAmount` = '' ,`TaxRate` = '2.186289' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666556977' WHERE `Matrix_Unique_ID` = '210077924' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T08:03:46.807' ,`MLSNumber` = '93868562' ,`ListAgentFullName` = 'Miguel Canas' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.761356' ,`Longitude` = '-94.999120' ,`PhotoCount` = '31' ,`PostalCode` = '77521' ,`RoomCount` = '4' ,`ListPrice` = '276000.00' ,`Status` = 'Active' ,`StreetName` = 'Indian' ,`StreetNumber` = '4803' ,`StreetSuffix` = 'Trail' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1860' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BRAND NEW HOME! Great Location!! Open Concept. Home features two story, entry leads to the large living area and beautiful kitchen with Granite countertops and white cabinets, all new appliances Refrigerator is included, all cabinets are equipped with handles, beautiful Porcelain floors, garage door opener, Gutters, sod back yard, upstairs you\'ll find a game room ,two beds a huge Primary Bedroom complete with a private bathroom and a walk in closet, all bedrooms are equipped with a remote control ceilings fans!! This home has all energy efficient systems!! All rooms measurement are approximate.' ,`Acres` = '0.0546' ,`Area` = '2' ,`BuilderName` = 'Rafael A Bonilla' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 45 BLK 1 SHADY HILL VILLA SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2380' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CARVER ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'BAYTOWN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Shady Hill Villa Sec 02' ,`TaxAmount` = '787' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1666556977' WHERE `Matrix_Unique_ID` = '210144566' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T08:45:54.510' ,`MLSNumber` = '64635430' ,`ListAgentFullName` = 'Kelly S Romero' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.289545' ,`Longitude` = '-94.800243' ,`PhotoCount` = '39' ,`PostalCode` = '77550' ,`RoomCount` = '4' ,`ListPrice` = '635000.00' ,`Status` = 'Active' ,`StreetName` = 'Bernardo De Galvez' ,`StreetNumber` = '3214' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2610' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOTIVATED SELLER, OPEN TO NEGOTIATION. Beautiful and spacious three-story Victorian home with high ceilings and hardwood floors,double French doors, big windows,Study,formal Dining Room. Bathroom with standup showers,Dinning room/breakfast,spacious kitchen w/beautiful granite countertops. Access stairs to 3rd floor spacious attic that could be used as storage or another room.New AC & Heater mini splits.Shaded back yard,It is a must see with a very comfortable front porch to relax and listen to the roaring sound of the beach waves, just 7 blocks away from the Seawall Boulevard. This home has a historical charm. Situated in a FEMA no flood 100-year plan,in beautiful Galveston Island, Texas.This is a very solidly built Victorian home that was constructed in 1912, then renovated in 1960 with recent updating to date. Owners have original blueprints of this house and the construction summary typewritten dated July,1912 built for a Dr. Charles Fisher.' ,`Acres` = '0.118' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR W 1/2 OF LOT 10 & E 1/2 OF LOT 11 (2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5140' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Victorian' ,`Subdivision` = 'Galveston Outlots' ,`TaxAmount` = '5219' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1666556977' WHERE `Matrix_Unique_ID` = '210400988' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:40:33.237' ,`MLSNumber` = '10783968' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.161092' ,`Longitude` = '-95.622699' ,`PhotoCount` = '21' ,`PostalCode` = '77486' ,`RoomCount` = '9' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Montclaire' ,`StreetNumber` = '230' ,`StreetSuffix` = 'Drive' ,`City` = 'West Columbia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2513' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS #10783968 NEW CONSTRUCTION BY CASTLEROCK! Trinity Plan(C-Elevation) 2-Story 4 BD 2.5 BA 3 Car Garage 2,513 sq ft! High Ceilings! Open Concept! Impressive Interior Upgrades! Modern White 42\" Kitchen Cabinets w/ Granite Counters! Stainless steel finish appliances exude refinement and elegance! Inviting Owner\'s Suite! Soaker Tub & Separate Shower! 2\'\' Faux blinds! Wall of windows! Energy-Efficient! HERS Rated! No Flooding! Tankless Water Heater! Low Tax Rate 2.186 before homestead! Offers a golf course family-friendly gated community, Easy Commute to Hwy 288, Exciting Pearland Town Center, Houston, Bay City, Sweeny & Lake Jackson! Experience the breathtaking sandy beach views just 30 mins away! CastleRock offers new homes in various stages of construction for those who are looking for spacious 1 & 2 story layouts and Quick Move-In options. Nestled in Natural Splendor! Enjoy Country Living in Columbia Lakes! Best kept secret south of Houston! Schedule a tour today!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 21, Block 16, Section 2' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '8880' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Columbia Lakes' ,`TaxAmount` = '' ,`TaxRate` = '2.186' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666556977' WHERE `Matrix_Unique_ID` = '210441290' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T08:41:30.327' ,`MLSNumber` = '66728944' ,`ListAgentFullName` = 'Francis Choy' ,`ListOfficeName` = 'TOPRO Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.575214' ,`Longitude` = '-95.428723' ,`PhotoCount` = '39' ,`PostalCode` = '77584' ,`RoomCount` = '12' ,`ListPrice` = '549000.00' ,`Status` = 'Active' ,`StreetName` = 'Mystic Arbor' ,`StreetNumber` = '13509' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This waterfront home is conveniently located in the high demanded Shadow Creek Ranch in Pearland. House features 4-bedrooms and 4 full bathrooms. 3-car garage. High ceiling, contemporary flooring, wrought iron basket spindles, gas log fireplace, large window allows lots of natural lighting throughout. Study room, game room, media room and spacious balcony. Nice size extended covered patio at the backyard for perfect guests entertaining. Relaxing to enjoy quiet evenings with spectacular waterfront viewing from balcony and more. Easy access to major highway including TX 288 and Beltway 8. Perfect location for many nearby amenities. Must see!' ,`Acres` = '0.1546' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SHADOW CREEK RANCH SF-45A, BLOCK 1, LOT 15' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '6734' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '999' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`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` = 'Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadow Creek Ranch Sf-45a' ,`TaxAmount` = '11089' ,`TaxRate` = '3.2123' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556977' WHERE `Matrix_Unique_ID` = '210776905' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:36:26.213' ,`MLSNumber` = '89092790' ,`ListAgentFullName` = 'Susanna Mayberry' ,`ListOfficeName` = 'RE/MAX Leading Edge' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.317647' ,`Longitude` = '-94.770139' ,`PhotoCount` = '37' ,`PostalCode` = '77550' ,`RoomCount` = '7' ,`ListPrice` = '267900.00' ,`Status` = 'Active' ,`StreetName` = 'Dolphin' ,`StreetNumber` = '107' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1554' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming ranch style home in Fish Village nestled just a short walk to UTMB, minutes from great shopping and nightlife on The Strand and just a bike ride to the beach. This 2/1 has a flex room in the back that could be used as another bedroom, office or would make a great workout room or art studio as it has a tons of natural light. Nice fenced backyard with a double car garage, storage shed and an amazing deck with just over 300sf of trex, double swings and windsails. The driveway has a gate and the current owners have housed their 40\' RV behind the fenced area. Home does need some cosmetic work (ie trim, etc) and is priced accordingly. Owner just replaced roof on home and garage - waiting for WPI-8 to be issued.' ,`Acres` = '0.1401' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 PAGE 140 LOT 26 LINDALE PARK' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '6101' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lindale Park' ,`TaxAmount` = '4063' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556978' WHERE `Matrix_Unique_ID` = '210910931' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:25:33.640' ,`MLSNumber` = '74436947' ,`ListAgentFullName` = 'April Salas' ,`ListOfficeName` = 'Southern Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.248457' ,`Longitude` = '-95.430310' ,`PhotoCount` = '22' ,`PostalCode` = '77302' ,`RoomCount` = '8' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Holly Springs' ,`StreetNumber` = '747' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3059' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'STUNNING two story house in River Plantation! Built in 2009. Featuring an open floor plan containing 4 Bedrooms and 2.5 Bathrooms. This home is in a safe sought after community with NEW AC Evaporator coil, NEW neutral wall colors, NEW Pool pump, Granite counter tops and a Large Game room. This home also features Luxury Limestone, Crown Molding, Garden Tub, Spacious rooms with Walk-in Closets, Private Swimming pool, and a Home Security System. ENJOY the large backyard, patio, and swimming pool along with all the amenities of this established community, minutes from parks, area pool, tennis courts, shops & restaurants. The home is zoned to the highly sought out Conroe Independent School District. This home is a MUST SEE! NEVER FLOODED! New carpet installed! Home is move in ready for you and your family!' ,`Acres` = '0.227' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S832010 - RIVER PLANTATION 10, LOT 17-A, 50.000000% UDI' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9887' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '960' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Georgian' ,`Subdivision` = 'River Plantation 10' ,`TaxAmount` = '2807' ,`TaxRate` = '2.3888' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556978' WHERE `Matrix_Unique_ID` = '211135187' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T08:03:43.170' ,`MLSNumber` = '62663045' ,`ListAgentFullName` = 'Paige Potter' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.736568' ,`Longitude` = '-94.949979' ,`PhotoCount` = '26' ,`PostalCode` = '77520' ,`RoomCount` = '7' ,`ListPrice` = '186900.00' ,`Status` = 'Active' ,`StreetName` = 'Jefferson' ,`StreetNumber` = '1306' ,`StreetSuffix` = 'Street' ,`City` = 'Baytown' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1121' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*FRESH PAINT JOB ALERT!! Seller has had entire Outside of Home Repainted White w/ Black Trim! Giving it a NEW & Modern Look!*\r\nDo NOT Miss out on this Amazing Starter Home OR Potential Investment Property! This Spic & Span 3 Bedroom, 1 Bath is READY FOR MOVE IN! Home sits on a Great sized Lot, Has attached garage, Stunning Mixture of Grey tones throughout the house giving it a NEW & Modern Touch. Spacious living/ dining room combination, Ample amount of Wood Finished Cabinets in the Kitchen, Plenty of Granite Counter Top space, Stainless Steel Appliances, Upgraded Flooring in Living Room, Hallway, and Bathroom. Full Bath features tub/ shower combo w/ tile surround, HVAC & Roof replaced in 2015! **Centrally located w/ convenient access to HWY 146 & Grand Parkway** If you\'re looking to add A home to your investment portfolio that needs LITTLE to ZERO improvement\'s- Than look no further- This home is for YOU! *Seller has added new flooring to kitchen to match flooring in living room!*' ,`Acres` = '0.1808' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Special Addendum' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 11 BLK 2 MILBY DALE SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7875' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'LORENZO DE ZAVALA ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'HORACE MANN J H' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Milby Dale' ,`TaxAmount` = '2711' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1952' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556978' WHERE `Matrix_Unique_ID` = '211197870' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:21:55.447' ,`MLSNumber` = '71134218' ,`ListAgentFullName` = 'Janice Clow' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.278827' ,`Longitude` = '-95.483078' ,`PhotoCount` = '40' ,`PostalCode` = '77304' ,`RoomCount` = '8' ,`ListPrice` = '564900.00' ,`Status` = 'Active' ,`StreetName` = 'Bee Balm' ,`StreetNumber` = '228' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2698' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the \"better than new\" 2021 Drees Custom Home Huntley II ( one of the all time favs). The open floor plan, super high ceilings, media room, spacious kitchen designed to be the nucleus of the home and encourages connecting with friends and family. Just off the kitchen is this totally cool pocket work station ( or butler pantry, wine / bar). The back yard is great for playing or a blank canvas to create your own oasis! Grand Central Park is a wonderland of lush, forested beauty. The community is surrounded by woods and pristine lakes. Glorious outdoor and indoor amenities abound in Grand Central Park. As an added benefit to the residents, a dedicated Director of Fun plans over 80 events a year at the various amenities throughout the community. The amenities include a fabulous club lake house, resort style pool, fitness center, playgrounds, parks, trails, dog parks, lakes & fishing - you name it! Your new lifestyle awaits!' ,`Acres` = '0.1826' ,`Area` = '19' ,`BuilderName` = 'Drees Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S537512 - GRAND CENTRAL PARK 12, BLOCK 1, LOT 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7954' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1073' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Grand Central Park 12' ,`TaxAmount` = '1736' ,`TaxRate` = '3.0863' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666556978' WHERE `Matrix_Unique_ID` = '211253950' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:02:59.347' ,`MLSNumber` = '76710846' ,`ListAgentFullName` = 'Michael Seder' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.268853' ,`Longitude` = '-95.559164' ,`PhotoCount` = '48' ,`PostalCode` = '77316' ,`RoomCount` = '15' ,`ListPrice` = '1698000.00' ,`Status` = 'Active' ,`StreetName` = 'Caledonia' ,`StreetNumber` = '174' ,`StreetSuffix` = 'Circle' ,`City` = 'Montgomery' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '6182' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Breathtaking Huntington home overlooking the 8th hole of the Woodforest Golf Course! Gated motor court, porte-cochere, three car tandem garage with epoxy floor, dual wrought iron entry doors lead you to a two story foyer with hand scraped hardwood floors, a curved staircase and abundant windows that provide serene fairway views. The huge den with vaulted beam ceiling, wall of windows and custom fireplace overlooks the sleek and functional kitchen with 6 burner gas cooktop, soft close cabinets and drawers, double oven and ice maker. Formal dining has plantation shutters and crown moulding; wood paneled study with beam ceiling, custom bookshelves and French doors; owner\'s retreat with sitting area and 2nd bedroom suite down; three bedrooms, game room with wet bar and media up (projector and screen stay). Resort like backyard features a fabulous custom pool and spa with in-floor cleaning system, fire pit, pergola with outdoor kitchen and storage area with shelving.' ,`Acres` = '0.3513' ,`Area` = '39' ,`BuilderName` = 'HUNTINGTON HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S965253 - WOODFOREST 53, BLOCK 1, LOT 15' ,`LotDesciption` = 'On Golf Course,Subdivision Lot' ,`LotSize` = '15304' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1265' ,`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` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LONE STAR ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest 53' ,`TaxAmount` = '26557' ,`TaxRate` = '2.665' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556978' WHERE `Matrix_Unique_ID` = '211268578' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:28:00.373' ,`MLSNumber` = '55759476' ,`ListAgentFullName` = 'Evan Howell' ,`ListOfficeName` = 'Evan S. Howell, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.098740' ,`Longitude` = '-95.429640' ,`PhotoCount` = '35' ,`PostalCode` = '77373' ,`RoomCount` = '9' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Kobi Park' ,`StreetNumber` = '23227' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2653' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NICE 2 STORY CLOSE TO EXXON MOBIL CORP CAMPUS AND WALKING DISTANCE TO NORTHGATE ELEMENTARY. MASTER DOWN, LARGE BATH DOUBLE SINKS, SEP SHOWER AND JETTED TUB. AMAZING CLOSETS AND STORAGE. OPEN FLOOR PLAN. ENERGY STAR HOME. LOCATED ON CUL DE SAC STREET. TENNIS COURTS, PLAYGROUND AND SUBDIVISION POOL. NOTE HOME IS NOT FURNISHED PICTURES ARE FOR DEMONSTRATION PURPOSES ONLY. Home is in process of being painted and some flooring replaced.' ,`Acres` = '' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 1 VILLAGE NORTHGATE CROSSING 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7088' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '625' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'NORTHGATE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'SPRINGWOODS VILLAGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'VILLAGES OF NORTHGATE CROSS' ,`TaxAmount` = '5398' ,`TaxRate` = '3.6538' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556978' WHERE `Matrix_Unique_ID` = '211356962' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:16:47.117' ,`MLSNumber` = '71641912' ,`ListAgentFullName` = 'Monica Foster' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Monica Foster' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.488307' ,`Longitude` = '-95.119487' ,`PhotoCount` = '50' ,`PostalCode` = '77573' ,`RoomCount` = '11' ,`ListPrice` = '399900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Aberdeen' ,`StreetNumber` = '2115' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3412' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stately home is situated on a terrific corner lot! Gorgeous, refinished hardwood floors extend into the Formal Dining Room, Family Room & Primary Bedroom. The Family Room has a fireplace that is perfect for warming a chilly night or setting the mood for a date night in! The Kitchen is sure to please the chef in the house! It features gorgeous granite counters & back splash, shaker style cabinetry, a gas range, an island for extra prep space & a refrigerator. The generous Primary Bedroom has an ensuite with a jetted tub, separate shower, and 2 walk-in closets! Upstairs finds a Game Room, 4 generous bedrooms (one of which is ensuite) and a hall bathroom. The backyard has ample space for all the running and playing your heart desires. This home features new windows throughout, adding extra energy efficiency. Never flooded' ,`Acres` = '0.183' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 3 S F AUSTIN SUR LOT 1 BLK 10 BRITTANY BAY' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7971' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BAUERSCHLAG ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'VICTORYLAKES INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Brittany Bay' ,`TaxAmount` = '6253' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556979' WHERE `Matrix_Unique_ID` = '211485886' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:24:01.120' ,`MLSNumber` = '66366237' ,`ListAgentFullName` = 'Shirley Kopecky' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.800229' ,`Longitude` = '-95.465053' ,`PhotoCount` = '40' ,`PostalCode` = '77055' ,`RoomCount` = '12' ,`ListPrice` = '620000.00' ,`Status` = 'Active' ,`StreetName` = 'Teluco' ,`StreetNumber` = '6509' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2611' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Priced to Sell!! Come & see this lovely 3000 sq ft+ property near I-10, Loop 610, & Hwy 290 & outside the 100 & 500 yr flood plains! High lot value - $400k-$450 recently; Aug. 2015 appraisal = $606k when lot value = $200k, unlike now & before MANY more improvements! Home has extensive additions & updates, and boasts a 2 story great room with a dramatic ceiling, extensive real hardwood floors, crown molding + oversized 2 car garage with upscale apartment/quarters & 3 Recent HVAC units with sanitizing UV lights! Main bedroom has a large custom closet & nearly pristine carpet; 2 (of 4) bedrooms & bathrooms in main house are downstairs! The large office/library can double as: wine or media room, 2nd eating area; kitchen includes a gently used Viking gas range. Floor plans uploaded.\r\nPoints buy-down negotiable, depending upon offer. Garage apt.rental currently allowed by Civic Assn. \r\nNew construction in subdivision = $1 Million+ There\'s NOTHING like this home, so close in + full size lot.' ,`Acres` = '0.1865' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 23 WESTVIEW TERRACE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8125' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '10' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HOUSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Westview Terrace Sec 02' ,`TaxAmount` = '8956' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1949' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556979' WHERE `Matrix_Unique_ID` = '211498410' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:14:14.317' ,`MLSNumber` = '93453518' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Pulte Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.832813' ,`Longitude` = '-95.859083' ,`PhotoCount` = '12' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '337320.00' ,`Status` = 'Active' ,`StreetName` = 'Laguna Cove' ,`StreetNumber` = '1020' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2041' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOVE-IN READY! Camelia plan by Centex features a two-story home with an open and inviting gathering area. Gourmet kitchen with grand kitchen island inspires connection and conversation. Spacious upstairs loft offers an entertaining retreat for game time and movie nights! Steel Appliances, Sprinkler System, Front and Rear Gutters. Zoned to Katy ISD. Sunterra Community features a 3.5-acre Crystal Blue Lagoon with white sand beaches, palm trees, cabanas, watercraft rentals of kayaks, paddleboards, etc! Clubhouse, event center, swim-up beach bar, swimming pool, and splash pad – resort style living at its finest!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Centex Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 13, Block 2, Section 10' ,`LotDesciption` = 'Water View' ,`LotSize` = '4000' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.66' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666556979' WHERE `Matrix_Unique_ID` = '211781582' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:52:40.470' ,`MLSNumber` = '29502026' ,`ListAgentFullName` = 'Laura Powers' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.117573' ,`Longitude` = '-95.539496' ,`PhotoCount` = '27' ,`PostalCode` = '77389' ,`RoomCount` = '21' ,`ListPrice` = '1695000.00' ,`Status` = 'Active' ,`StreetName` = 'Morgans Pond' ,`StreetNumber` = '7503' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '5269' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Estimated completion - November 2022. Contemporary elegance is elevated to spectacular heights in this stunning design by multiple award winner & 2019 #1 Custom Home Builder, Matt Powers. .54 AC lot in private gated enclave of Lago Woods. Primary bedroom & guest suite on main level. Thermador/Bosch appliance package, large island, walk-in chef pantry. Large den, tall windows, private study & game room downstairs. Media/playroom w/ 3 ensuite bedrooms upstairs. Additional 17x18 flex room for 6th bedroom, 2nd office or media room. Foam insulation & tankless water heaters for max efficiency. 3 car over sized garage. Lago Woods, gated enclave of 45 homes w/ the amenities of Augusta Pines CC. Minutes to Creekside Park Village, The Woodlands, restaurants, prime shopping, 99, & I-45. Zoned to the acclaimed Klein ISD w/ International Baccalaureate Program. Contact listing agent for additional information-selections. Artistic renderings may vary slightly from selections. Pool not included.' ,`Acres` = '0.5447' ,`Area` = '14' ,`BuilderName` = 'Matt Powers Custom' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 42 BLK 1 SHADOW CREEK ESTATES LAGO WOODS SEC 1' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '23727' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2250' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'FRENCH ELEMENTARY SCHOOL (KLEIN)' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HOFIUS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadow Creek Estates - Lago Woods' ,`TaxAmount` = '5964' ,`TaxRate` = '2.9223' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666556979' WHERE `Matrix_Unique_ID` = '211842484' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:55:35.063' ,`MLSNumber` = '13062168' ,`ListAgentFullName` = 'Shelly Scanlin' ,`ListOfficeName` = 'Styled Real Estate' ,`SellingAgentFullName` = 'Aamir Faridi' ,`SellingOfficeName` = 'Texas United Realty' ,`Latitude` = '30.035410' ,`Longitude` = '-95.658799' ,`PhotoCount` = '29' ,`PostalCode` = '77429' ,`RoomCount` = '8' ,`ListPrice` = '310000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'June Oak' ,`StreetNumber` = '18106' ,`StreetSuffix` = 'Street' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2283' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Such a great home located in Oakcrest!! The main level offers formal dining room, family room, powder room and primary ensuite. Featuring a large kitchen with breakfast bar, granite counters and stainless appliances. The main level primary ensuite features a walk-in closet, dual sink vanity, separate shower and soaking tub. Upstairs you\'ll find a spacious game room, 2 generously sized bedrooms and full bath. Even the garage has it\'s own central air unit! Easy access to 99 and 249. Zoned to Tomball ISD!! Recently replaced roof and water softener!' ,`Acres` = '0.1149' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 1 OAKCREST NORTH SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5005' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oakcrest North Sec 03' ,`TaxAmount` = '6439' ,`TaxRate` = '2.8172' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556979' WHERE `Matrix_Unique_ID` = '211891651' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:55:04.690' ,`MLSNumber` = '29538779' ,`ListAgentFullName` = 'Suzan Zachariah' ,`ListOfficeName` = 'The Local Agents Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.946274' ,`Longitude` = '-95.295029' ,`PhotoCount` = '32' ,`PostalCode` = '77541' ,`RoomCount` = '3' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Sea Bean' ,`StreetNumber` = '437' ,`StreetSuffix` = '' ,`City` = 'Surfside Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1056' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Although this is a popular floorplan for a primary, 2nd or investment home, this home has not been a rental. This home has it all and is being sold fully and beautifully furnished including the golf cart. There is an outdoor shower and lots of room inside the fenced lot to enjoy outside living downstairs as well as upstairs on the front deck. The new owner will love the vaulted ceiling in the open living room/dining area to the kitchen and breakfast bar. To the rear and left is a primary bedroom with a private bath with a shower and a walk-in closet. There is a pantry to the right off the hall and the hall bathroom with a bathtub and the utility room are a little further. The bedroom to the right rear has access to the back deck and the 3rd bedroom is off the hall to the left.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Howard Street Condos' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 12 Blk 1 Gulf Ridge' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Gulf Ridge' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556980' WHERE `Matrix_Unique_ID` = '212008019' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:46:13.110' ,`MLSNumber` = '81293597' ,`ListAgentFullName` = 'Jeffery Smith' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.402739' ,`Longitude` = '-95.051310' ,`PhotoCount` = '39' ,`PostalCode` = '77568' ,`RoomCount` = '7' ,`ListPrice` = '469999.00' ,`Status` = 'Active' ,`StreetName` = 'White Cove' ,`StreetNumber` = '12709' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2904' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous Long Lake Home in the quiet community of Lago Mar will exceed all your expectations. Situated on a nice lot, this 4-sided brick home features a premium elevation, tile flooring, wrought iron spindles, and a fireplace in the great room. Take your culinary abilities to the next level in the island kitchen, complete with granite countertops, a designer stone backsplash, and stainless steel appliances. Unwind in the spa-like primary suite, which features a walk-in closet, dual vanities, a tub, and separate shower. Expanded Patio and drievway,soffit lights for security and a lovely night glow. State of the art security system.Solar panels for energy savings, 2 attic spaces for lots of storage. Spend a nice day outdoors relaxing under the shade of the covered patio. Resort-style amenities include a recreation center, swimming pool, clubhouse, and playground. Commuters enjoy easy access to I-45 and Highway 6. Schools are zoned to Dickinson Independent School District.' ,`Acres` = '0.1515' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAGO MAR POD 7 SEC 1 (2017) ABST 11, BLOCK 3, LOT 8, ACRES 0' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar Pod 7 Sec 1' ,`TaxAmount` = '11150' ,`TaxRate` = '3.5512' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556980' WHERE `Matrix_Unique_ID` = '212114721' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T08:53:13.580' ,`MLSNumber` = '71560351' ,`ListAgentFullName` = 'Jeff Deutschmann' ,`ListOfficeName` = 'Jeff Webb Real Estate ' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.390314' ,`Longitude` = '-95.595735' ,`PhotoCount` = '44' ,`PostalCode` = '77356' ,`RoomCount` = '8' ,`ListPrice` = '409950.00' ,`Status` = 'Active' ,`StreetName` = 'Hunters' ,`StreetNumber` = '11122' ,`StreetSuffix` = 'Landing' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2298' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Hunters Landing Beauty. This premier gated community is steps from the shores of Lake Conroe. This home comes with it\'s own deeded boat slip with lift and cover, within walking distance. Wonderful curb appeal in this 3 bedroom home, 2.5 bath home. Stunning entry with tile flooring, high ceilings and a nice layout. Formal dining room to the right that opens to the kitchen with plenty of white cabinetry, granite counters and a breakfast bar and dining area. The family room has high ceilings with recessed lighting, crown molding, tile flooring and a gas fireplace. Primary bedroom is on the first level and has tiered ceilings with crown molding. The adjoining bath has double sinks, jetted tub, separate walk in shower and a huge closet. Nice sized laundry room on the first floor with built in cabinetry and a folding area. The half bath is nearby. Two bedrooms, full bath and a Texas basement on the 2nd level. Ultra private back yard with covered patio. Enjoy Lake Conroe boating and fishing!' ,`Acres` = '0.1585' ,`Area` = '39' ,`BuilderName` = 'Jerry Ward' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'HUNTERS LANDING, BLOCK 3, LOT 26' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6903' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MADELEY RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hunters Landing' ,`TaxAmount` = '6009' ,`TaxRate` = '2.1392' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556980' WHERE `Matrix_Unique_ID` = '212191496' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:23:28.577' ,`MLSNumber` = '93460252' ,`ListAgentFullName` = 'Donna Rooney' ,`ListOfficeName` = 'CB&A, Realtors-Katy' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.740753' ,`Longitude` = '-95.363584' ,`PhotoCount` = '49' ,`PostalCode` = '77004' ,`RoomCount` = '11' ,`ListPrice` = '500000.00' ,`Status` = 'Active' ,`StreetName` = 'Saint Emanuel' ,`StreetNumber` = '2325' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 4 story free standing \"InTownHomes\" property. The home has been freshly painted with new carpet installed in the upstairs bedrooms. Upon entering, you\'ll instantly be drawn to the livability of this home - suited for entertaining and enjoying the downtown living experience. There are 4 bedrooms, 4.5 baths, home office/study, 4th floor gameroom opening up to a large roof top terrace with an amazing view of the Houston skyline! The 2nd floor features a home office/study, spacious kitchen, dining/living area with a balcony. All 4 bedrooms have en suite bathrooms. This townhome has it all with open living areas, hardwood floors, and upgraded carpet in bedrooms. The primary suite and utility area are located on the 3rd floor. The 4th floor has a spacious gameroom, secondary bedroom plus a full bath along with the walkout roof top terrace. Easy access to Downtown, Medical Center, EaDo District, Midtown, Universities and Montrose. Come check it out!' ,`Acres` = '0.0323' ,`Area` = '4' ,`BuilderName` = 'InTownHomes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Reports Available,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 1 SAINT EMANUEL STREET ENCLAVE' ,`LotDesciption` = 'Cleared' ,`LotSize` = '1409' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2590' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '4' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Saint Emanuel Street Enclave' ,`TaxAmount` = '9851' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556980' WHERE `Matrix_Unique_ID` = '212196995' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:50:29.337' ,`MLSNumber` = '45669904' ,`ListAgentFullName` = 'Miao Sun' ,`ListOfficeName` = 'Daytown International LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.586316' ,`Longitude` = '-95.138880' ,`PhotoCount` = '33' ,`PostalCode` = '77062' ,`RoomCount` = '4' ,`ListPrice` = '312000.00' ,`Status` = 'Active' ,`StreetName` = 'Providence Pine' ,`StreetNumber` = '14410' ,`StreetSuffix` = 'Trail' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2146' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Recently renovated charming 4 bedroom, 2.5 bath home in Prestigious Bay Glen neighborhood. Kitchen with new cacabinet and quartz countertop. All appliance will stay. Fresh paint throughout entire house. A luxurious premary suite with fully updated bathroom. Three bedrooms upstairs with recent cleaned carpet. Back yard with Covered patio and easy maintain grass. Excellent CCISD shcools and close to everything in Clear lake. ' ,`Acres` = '0.1544' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 75 BLK 3 BAY GLEN SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6726' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'WARD ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'CLEARLAKE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay Glen Sec 05' ,`TaxAmount` = '6990' ,`TaxRate` = '2.5769' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556981' WHERE `Matrix_Unique_ID` = '212369937' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:46:16.213' ,`MLSNumber` = '5216028' ,`ListAgentFullName` = 'Susan Starnes' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = 'Milind Patel' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '30.010885' ,`Longitude` = '-95.313102' ,`PhotoCount` = '32' ,`PostalCode` = '77338' ,`RoomCount` = '7' ,`ListPrice` = '225000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Foxway' ,`StreetNumber` = '7319' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1740' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Terrific ranch home with plenty of room for large furniture and entertaining inside and out. Attached 2 car garage with room for a workshop. Pride of ownership shows in details of each part of the house. Patio in the back yard. The yard is fully fenced for the enjoyment of all activities on this larger corner lot. 3 Bedrooms, Two Baths, laundry room with storage. House is close to FM 1960 East. Deerbrook Mall, restaurants, movie theatres, stores to delight shoppers of all types are nearby. Seller says this house has not flooded and that the roof was replaced this year.' ,`Acres` = '0.2163' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 6 FOXWOOD SEC 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9420' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CYPRESSWOOD ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Foxwood Sec 01' ,`TaxAmount` = '4137' ,`TaxRate` = '2.7734' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556981' WHERE `Matrix_Unique_ID` = '212447551' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:28:10.187' ,`MLSNumber` = '87405644' ,`ListAgentFullName` = 'Rickey Chavez' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.996280' ,`Longitude` = '-95.608417' ,`PhotoCount` = '45' ,`PostalCode` = '77429' ,`RoomCount` = '11' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Forest Meadow Drive' ,`StreetNumber` = '12903' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3117' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning home with so much potential surrounded by mature trees and oversized lot. A fixer upper. Needs work but good bones. This timeless home has some amazing upgrades with so much to offer a buyer that wants to put their personal touch and creativity into it. Upgrades include custom cabinets with porcelain floors and fresh paint throughout the entire home. Home features high ceiling and open concept and a stunning sunroom with floor to wall windows overlooking the oversized pool and hot tub. Make your appointment today.' ,`Acres` = '0.433' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 16 LAKEWOOD FOREST SEC 10' ,`LotDesciption` = 'Corner,Subdivision Lot,Wooded' ,`LotSize` = '18850' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '680' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HAMILTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakewood Forest Sec 10' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556981' WHERE `Matrix_Unique_ID` = '212605004' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T08:27:55.390' ,`MLSNumber` = '78763747' ,`ListAgentFullName` = 'Jeffrey Cox' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.842505' ,`Longitude` = '-95.368147' ,`PhotoCount` = '25' ,`PostalCode` = '77022' ,`RoomCount` = '7' ,`ListPrice` = '219000.00' ,`Status` = 'Active' ,`StreetName` = 'Mcgallion' ,`StreetNumber` = '9042' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1780' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home sits on a large corner lot. Tile is on the entire first floor for easy and cleaning! Formal dining area. Living room looks into the open kitchen and to the spacious fenced backyard. There is also a half bath. Upstairs has the primary bedroom with two closets and the private primary bedroom. The two secondary bedrooms are upstairs with access to a hall bath. One car garage is attached. Home is fully fenced with wrought iron fence in the front.' ,`Acres` = '0.0905' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 VICTORIAN HEIGHTS VILLAGE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3944' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '60' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BURBANK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SAM HOUSTON MATH SCIENCE AND TECHNOLOGY CENTER' ,`SchoolMiddle` = 'BURBANK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Victorian' ,`Subdivision` = 'Victorian Heights Village' ,`TaxAmount` = '3079' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556981' WHERE `Matrix_Unique_ID` = '212613214' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T08:03:25.637' ,`MLSNumber` = '79867321' ,`ListAgentFullName` = 'Miguel Canas' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.761472' ,`Longitude` = '-94.999383' ,`PhotoCount` = '32' ,`PostalCode` = '77521' ,`RoomCount` = '5' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Forest' ,`StreetNumber` = '4800' ,`StreetSuffix` = 'Court' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1471' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MUST SEE NEW CONSTRUCTION!! True open concept floor plan, three bedroom two bath. The kitchen is furnished with white soft-close cabinets, Granite backsplash, door handles, granite countertops and stainless steel appliances, refrigerator included!, breakfast bar. All bathroom completed with granite countertop and tile, all bedroom are equipped with ceiling fans and tile(no carpet), all windows completed with blinds, two car parking garage with garage door opener. Welcome home!! Make your appointment to visit today!' ,`Acres` = '0.0838' ,`Area` = '2' ,`BuilderName` = 'Julio Granados' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 39 BLK 1 SHADY HILL VILLA SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3650' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Slate' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CARVER ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'BAYTOWN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Shady Hill Villa Sec 02' ,`TaxAmount` = '836' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666556981' WHERE `Matrix_Unique_ID` = '212625960' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T08:55:18.223' ,`MLSNumber` = '16831598' ,`ListAgentFullName` = 'Claudia Canfield' ,`ListOfficeName` = 'CB&A, Realtors-Katy' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.971373' ,`Longitude` = '-95.208571' ,`PhotoCount` = '50' ,`PostalCode` = '77346' ,`RoomCount` = '4' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Tree Moss' ,`StreetNumber` = '4135' ,`StreetSuffix` = 'Place' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3201' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This house did NOT flood during Harvey! Come see this charming home now on the market! Lovely 4 bedroom, 2.5 bathroom, 2 story home featuring an attached 2-car garage. Step inside this beautiful interior with neutral floors, plenty of natural light and neutral palette. Nice size secondary rooms, plenty of backyard space. New roof 2022, AC 2019. Don\'t miss out on this awesome home!' ,`Acres` = '0.1334' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 1 ATASCOCITA FOREST SEC 20' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5812' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'WHISPERING PINES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'HUMBLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Atascocita Forest Sec 20' ,`TaxAmount` = '6876' ,`TaxRate` = '2.773' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556982' WHERE `Matrix_Unique_ID` = '212649456' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:22:45.973' ,`MLSNumber` = '71672239' ,`ListAgentFullName` = 'Donna Rooney' ,`ListOfficeName` = 'CB&A, Realtors-Katy' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.653595' ,`Longitude` = '-95.576787' ,`PhotoCount` = '43' ,`PostalCode` = '77099' ,`RoomCount` = '8' ,`ListPrice` = '228000.00' ,`Status` = 'Active' ,`StreetName` = 'Whittingham' ,`StreetNumber` = '11207' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1976' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location Location Location! Low Taxes & HOA. The home is minutes away from I-69 and is centrally located to Sugarland and Houston. Quick drive to many retail shops and restaurants, Super Walmart, Sam\'s Club & Costco. \r\nRoof - 9 years, AC - 2016- Kitchen Updated 2022, Brick on all 4 Sides. Replaced plumbing with Pex, laminate wood flooring and upgraded carpet, replaced back fence in 2022. Home has never flooded, no flood insurance required and is not in flood zone. Beautiful 3 bedrooms, 2 full baths, open concept home in Parkglen West.' ,`Acres` = '0.1703' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Stafford Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 & W 1 FT OF LT 16 BLK 19 PARKGLEN SEC 3 - ALIEF' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot,Wooded' ,`LotSize` = '7420' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'CUMMINGS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'HOLUB MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Parkglen Sec 03 Alief' ,`TaxAmount` = '3476' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556982' WHERE `Matrix_Unique_ID` = '212692488' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:07:00.943' ,`MLSNumber` = '91479264' ,`ListAgentFullName` = 'Shirley Kopecky' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.956358' ,`Longitude` = '-97.522947' ,`PhotoCount` = '35' ,`PostalCode` = '76571' ,`RoomCount` = '0' ,`ListPrice` = '415000.00' ,`Status` = 'Active' ,`StreetName` = 'Ridge' ,`StreetNumber` = '851' ,`StreetSuffix` = 'Road' ,`City` = 'Salado' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '2415' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Worried about the future? Here\'s an incredible opportunity to live in an OFF GRID capable home on 1 of the larger & most picturesque lots - a Million $ view - in beautiful Mill Creek (golf course + golf cart community), with 2 gated entrances & a seasonal stream, far below house. The lot is sloped, heavily wooded & has a unique partially submerged earth-type home with concrete walls & a large attached workshop/extended garage. Home is unique, yet comfortable inside; also has a water-well with storage tanks (+ city water), 3 buried propane tanks, solar panels, rain water storage tanks, a tank-less water heater, & a generator. Roof damaged by April hailstorm; awaiting confirmation that insurance co. will pay to replace top rigid foam layer + re-coating (usually found in commercial type buildings). Accompanied showings only; don\'t walk property without an appointment! 4 Open House, wear walking shoes & park in Circle Driveway inside top 851 N Ridge gate. Call Shirley for more details.' ,`Acres` = '0.939' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'MILL CREEK SECTION 2, BLOCK 007, LOT 0002 & more' ,`LotDesciption` = 'In Golf Course Community,Ravine,Water View,Wooded' ,`LotSize` = '40902' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '220 - Salado' ,`SchoolElementary` = '' ,`SchoolHigh` = 'SALADO HIGH SCHOOL' ,`SchoolMiddle` = 'SALADO JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Mill Creek Sec 2' ,`TaxAmount` = '8924' ,`TaxRate` = '2.3547' ,`WaterSewer` = 'Public Water,Septic Tank,Well' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556982' WHERE `Matrix_Unique_ID` = '212751342' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:07:37.103' ,`MLSNumber` = '23534752' ,`ListAgentFullName` = 'Rooy Eapen' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = 'Kaylin Rios' ,`SellingOfficeName` = 'Lucky Money Real Estate' ,`Latitude` = '29.601372' ,`Longitude` = '-95.232639' ,`PhotoCount` = '25' ,`PostalCode` = '77089' ,`RoomCount` = '6' ,`ListPrice` = '240000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Kirkwyn' ,`StreetNumber` = '11402' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1756' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 11402 Kirkwyn Drive! This incredible home is located right off the Beltway in the Kirkwood subdivision and is the perfect home for you and your family. Boosting an amazing 1,756 sq feet this 3 bedroom, 2 bathroom home, a spacious family room, and a grand dining room this home checks all the boxes! Enjoy all new kitchen appliances and a new AC and furnace that was replaced in 2019. This home sits on an 8,803 sq ft oversized corner lot with an abundance of light. Enjoy that expansive backyard with ample space for any addition you can imagine. Enjoy easy access to just about all parts of Houston, including Galveston, Pearland, Medical Center, Downtown, and other various parts of Houston. Come tour this home and see what you can do to make it yours. Schedule your showing today!' ,`Acres` = '0.2021' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 22 LESS E 5 FT BLK 16 KIRKWOOD SEC 3' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8803' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'ATKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'BEVERLYHILLS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Kirkwood Sec 03' ,`TaxAmount` = '4404' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556982' WHERE `Matrix_Unique_ID` = '212780648' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:52:00.940' ,`MLSNumber` = '66745927' ,`ListAgentFullName` = 'Bryant Tran' ,`ListOfficeName` = 'BHGRE Gary GreeneLeague City' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.556866' ,`Longitude` = '-95.291359' ,`PhotoCount` = '30' ,`PostalCode` = '77584' ,`RoomCount` = '8' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Honey Creek' ,`StreetNumber` = '4608' ,`StreetSuffix` = 'Court' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1911' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**BACK ON MARKET w/ Brand New Roof October 2022!** Walk into this phenomenally spacious, well-maintained home in the heart of Pearland! This 3-bed, 2-bath home punches well above its footprint, featuring wide hallways, tall angled ceilings, an open-concept layout, and a large covered patio which makes for a great over-sized starter home or for entertaining many, many guests. This home has been updated with durable percaline tiles and laminate throughout, making cleanup a breeze. Included with the home are both bedroom TVs, fridge, and washing machine. A short walk away is Centennial Park or drive to Independence Park, where you will find baseball fields, tennis courts, walking trails, elaborate playground sets along with an amazing splash pad for those hot Houston summers! This home DID NOT flood during Harvey! Schedule your appointment today!' ,`Acres` = '0.1488' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PARKS AT WALNUT BEND SEC 1 (A0239 HT&BRR) , BLOCK 3, LOT 4' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6482' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '325' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'C J HARRIS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH EAST' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Parks At Walnut Bend Sec 1-2' ,`TaxAmount` = '6627' ,`TaxRate` = '2.8851' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556982' WHERE `Matrix_Unique_ID` = '212813699' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:40:08.917' ,`MLSNumber` = '71380997' ,`ListAgentFullName` = 'Marisol Vazquez' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.047928' ,`Longitude` = '-95.350542' ,`PhotoCount` = '35' ,`PostalCode` = '77373' ,`RoomCount` = '8' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Calico Corners' ,`StreetNumber` = '23103' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1898' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful one-story home on a corner lot. The kitchen boasts stainless-steel appliances, quartz countertops and tile backsplash. The home has plenty of upgrades including flooring, designer paint and upgraded fixtures. Great outdoor space for entertaining!' ,`Acres` = '0.1567' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 6 POST WOOD SEC 3' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6825' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '370' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CHET BURCHETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Post Wood Sec 03' ,`TaxAmount` = '4388' ,`TaxRate` = '2.5868' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556983' WHERE `Matrix_Unique_ID` = '212817955' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T08:41:08.237' ,`MLSNumber` = '29289440' ,`ListAgentFullName` = 'Kelles Kennedy' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.841842' ,`Longitude` = '-94.815737' ,`PhotoCount` = '47' ,`PostalCode` = '77523' ,`RoomCount` = '10' ,`ListPrice` = '714900.00' ,`Status` = 'Active' ,`StreetName` = 'Icet Creek Crossing' ,`StreetNumber` = '15223' ,`StreetSuffix` = 'Avenue' ,`City` = 'Mont Belvieu' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3548' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'We\'re calling this one \"Needle in the Haystack\" - This GORGEOUS Anglia home, built in 2020 has been taken to the next level with so many custom extras: In-ground gunite pool, large pool deck/concrete area and so much more extra concrete on this property to extend and add to the driveway (approx. 3500 SF/Seller). Wraught iron gate over extra drive. This .80 acre property back yard is fully fenced. Custom, popular paint colors throughout the interior. Barn wood under the island, ship lap added under stairs, outdoor lighting all around the house for landscaping and entertainment, controlled by apps. Also added \"soft start\" on both a/c units for energy conservation. This is a special property and Sellers have done more than can be listed here. Look at the price on new homes and add in the value this propery offers. STUNNING, IMMACULATE PROPERTY!' ,`Acres` = '0.7514' ,`Area` = '53' ,`BuilderName` = 'Anglia' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BK 1 ICET CREEK CROSSING SEC 2' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '32731' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '525' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL NORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL NORTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial,Traditional' ,`Subdivision` = 'Icet Crk Xing' ,`TaxAmount` = '10617' ,`TaxRate` = '2.1606' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556983' WHERE `Matrix_Unique_ID` = '212827825' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:46:56.587' ,`MLSNumber` = '10027354' ,`ListAgentFullName` = 'Michael Greiner' ,`ListOfficeName` = 'My Castle Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.743223' ,`Longitude` = '-95.419677' ,`PhotoCount` = '38' ,`PostalCode` = '77019' ,`RoomCount` = '10' ,`ListPrice` = '1550000.00' ,`Status` = 'Active' ,`StreetName` = 'Locke' ,`StreetNumber` = '3019' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3654' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 3 story home in extremely desirable Avalon Place neighborhood on 9172 sq ft lot with a magnificent, well-cared for oak tree in the front yard. Spacious rooms throughout with plenty of windows allowing plenty of natural light. Beautiful crown molding, hardwoods and tile floors throughout. Formal dining and downstairs study. Gated driveway with 2 car carport and studio apartment above the carport. Endless opportunities to remodel to bring to todays standards or to build your dream house on a magnificent lot in one the most sought-after communities in Houston. The owners are offering this property to be sold in its current condition, AS-IS!' ,`Acres` = '0.2106' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'River Oaks Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 & TR 3 BLK F AVALON PLACE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9172' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'RIVER OAKS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Avalon Place' ,`TaxAmount` = '23796' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556983' WHERE `Matrix_Unique_ID` = '212884441' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T08:03:53.827' ,`MLSNumber` = '50883912' ,`ListAgentFullName` = 'Rosemary Browning' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.059580' ,`Longitude` = '-95.198265' ,`PhotoCount` = '43' ,`PostalCode` = '77339' ,`RoomCount` = '10' ,`ListPrice` = '419900.00' ,`Status` = 'Active' ,`StreetName` = 'Woodbridge' ,`StreetNumber` = '3615' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3007' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home in time for the holidays! Imagine sharing all of those special times in this fabulous home. Enjoy sitting on the covered patio with colored lights/ceiling fans. Summertime, anytime in your own pool and spa. Sit at the breakfast table to discuss the day. Have plenty of room to host family/friends in the dining area, den and family room. Fireplace is center stage for lots of memories. Updates are everywhere. Updated kitchen has professional-styled cabinets, appliances and pendant lights. Engineered wood flooring downstairs is durable and smart looking. Primary bath has vessel sinks and glass enclosed shower. Secondary bath has recently been enhanced with tub/shower and dual sinks to provide counter space for several users. Roof was replaced in 2017. Bryant AC unit is up to the task of keeping everyone comfortable. Never lose power with the whole house GENERATOR. IAH, hospitals, retail and restaurants nearby. Acclaimed Humble ISD schools are within walking/biking distance.' ,`Acres` = '0.2221' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 53 BEAR BRANCH VILLAGE SEC 4' ,`LotDesciption` = 'Corner,In Golf Course Community,Subdivision Lot' ,`LotSize` = '9676' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'BEAR BRANCH ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bear Branch Village' ,`TaxAmount` = '6842' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556983' WHERE `Matrix_Unique_ID` = '212927982' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T08:08:33.047' ,`MLSNumber` = '82193722' ,`ListAgentFullName` = 'Feifei Gu' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.569638' ,`Longitude` = '-95.682945' ,`PhotoCount` = '30' ,`PostalCode` = '77479' ,`RoomCount` = '8' ,`ListPrice` = '368000.00' ,`Status` = 'Active' ,`StreetName` = 'Ashbury Trails' ,`StreetNumber` = '5714' ,`StreetSuffix` = 'Court' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2926' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated home located in a cul-de-sac in Riverpark! No flooding ever!\r\nNEW ROOF and NEW DRIVEWAY in 2022.\r\nThis home boasts a two-story, 4 bedroom with TWO BEDROOM SUITES DOWNSTAIRS on opposite sides of the home. 2 bedrooms and a game room upstairs, 2 car attached garage. \r\nSoaring ceilings, wall of windows & gas log fireplace in the family room. \r\nScreened-in back patio allows you to enjoy the outdoors year-round!\r\nThe home is ideally located just minutes from 99 & 59 and shopping & restaurants. Don\'t miss this one!' ,`Acres` = '0.1942' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RIVERPARK SEC 2, BLOCK 1, LOT 46' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8460' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '895' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUTCHISON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverpark Sec 2' ,`TaxAmount` = '6188' ,`TaxRate` = '2.6977' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556983' WHERE `Matrix_Unique_ID` = '212928167' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:40:16.933' ,`MLSNumber` = '90562284' ,`ListAgentFullName` = 'Clinton Omiwade' ,`ListOfficeName` = 'ERA Legacy Living' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.671225' ,`Longitude` = '-95.714639' ,`PhotoCount` = '38' ,`PostalCode` = '77407' ,`RoomCount` = '7' ,`ListPrice` = '429000.00' ,`Status` = 'Active' ,`StreetName` = 'Oakdale Lake' ,`StreetNumber` = '19710' ,`StreetSuffix` = 'Trail' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2227' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous one-story, 2,227 sqft home in a great location ! This home features beautiful tile , and carpet floors through the whole house, stunning front entry with large beautiful kitchen, stunning countertops and so much more! Very spacious Main Living area With great Flooring. Large Sized Kitchen with a Open Concept. 2- car garage. Large backyard ideal for hosting covered by Pergola. House has been extensively taken care of. Located close to multiple grocery options , schools , highways ,swimming pool, Lake Houston. You will be hard-pressed to find this unique open floor plan in this neighborhood. This home has everything you could ever want! This gem will not last long - schedule a showing' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Grand Mission Estates Sec 7, BLOCK 1, Lot 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10864' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '965' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'BOWIE MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Grand Mission Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556984' WHERE `Matrix_Unique_ID` = '212998404' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T08:53:34.723' ,`MLSNumber` = '38057724' ,`ListAgentFullName` = 'Lauren Dito' ,`ListOfficeName` = 'Beth Wolff, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.116406' ,`Longitude` = '-95.364698' ,`PhotoCount` = '23' ,`PostalCode` = '77386' ,`RoomCount` = '10' ,`ListPrice` = '789000.00' ,`Status` = 'Active' ,`StreetName` = 'Northern Spruce' ,`StreetNumber` = '4071' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4081' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 4 bed 3.5 bath home in Woodson\'s Reserve with HEATED POOL and 2 bedrooms down. As you enter this beautiful home, you will have the guest suite with private bathroom and entrance to courtyard with gorgeous fireplace. Open floorplan is perfect for entertaining- oversized dining room features wine grotto and butlers pantry that leads to the island kitchen with quartz countertops, SS appliances, gas cooktopabundance of cabinet space! Living room offers indoor/outdoor living with upgraded sliding doors that open to the immaculate backyard w/covered patio, gorgeous pool and outdoor kitchen! Relax in your primary suite. Spa like primary bath with double sinks, vanity area, large shower, soaking tub and hug walk-in closet that connects to the laundry room. Generously sized bedrooms upstairs and a large gameroom. Media room has windows so it could easily be turned into a 5th bedroom if needed. Reverse osmosis/filtration system installed. Exceptional schools! Don\'t miss out!' ,`Acres` = '0.2194' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S973702 - WOODSON\'S RESERVE 02, BLOCK 2, LOT 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9556' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1335' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Built Up,Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'ANN K. SNYDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodsons Reserve 02' ,`TaxAmount` = '15686' ,`TaxRate` = '3.0987' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556984' WHERE `Matrix_Unique_ID` = '213005156' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T08:28:30.117' ,`MLSNumber` = '26921049' ,`ListAgentFullName` = 'Kori Schmidt' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.748447' ,`Longitude` = '-94.967046' ,`PhotoCount` = '25' ,`PostalCode` = '77520' ,`RoomCount` = '7' ,`ListPrice` = '189000.00' ,`Status` = 'Active' ,`StreetName` = 'Gresham' ,`StreetNumber` = '218' ,`StreetSuffix` = 'Street' ,`City` = 'Baytown' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1276' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This newly remodeled home is ready for it\'s new owners! This corner lot home features two living areas, a 2 car garage with a porte cochere, 3 bedrooms, and tons of natural light! Its recent renovations include AC installed 2020, new windows in 2020 and 2022, roof replaced 2019, siding repairs 2022, all new flooring throughout 2022, completely new bathroom 2022, and new kitchen cabinets 2022. Act fast! You won\'t want to miss out on this one.' ,`Acres` = '0.1377' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 11 BLK 3 MORRELL PARK SEC 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'LAMAR ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'HORACE MANN J H' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Morrell Park Sec 01' ,`TaxAmount` = '2248' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556984' WHERE `Matrix_Unique_ID` = '213169887' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:00:36.403' ,`MLSNumber` = '82143961' ,`ListAgentFullName` = 'Julia Medellin' ,`ListOfficeName` = 'Rose Above Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.545081' ,`Longitude` = '-95.030503' ,`PhotoCount` = '43' ,`PostalCode` = '77565' ,`RoomCount` = '10' ,`ListPrice` = '424500.00' ,`Status` = 'Active' ,`StreetName` = 'Elm' ,`StreetNumber` = '818' ,`StreetSuffix` = 'Road' ,`City` = 'Clear Lake Shores' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1623' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy the island life in this vacation style community which offers golf cart friendly streets, neighborhood parks, community pool and boat launch. Minutes from Kemah Boardwalk, shopping and restaurants! Zoned to CCISD, low taxes & no HOA. This beautiful home sits on an oversized lot that is fully fenced in with an automatic driveway gate. Supersized living room with hand scrapped Hickory flooring on the first floor. The home has recently been painted throughout and the upstairs bedrooms have recently installed neutral carpet. First floor primary suite + walk-in closet. Stainless Steel Appliances, granite countertops and bar top seating in the kitchen. Off the kitchen you will find a stylish breakfast area with a door to access the freshly thatched palapa (great for entertaining and/or enjoying the island breeze), detached garage and a slab to park your RV, boat or trailer. Don\'t wait! Call your Realtor today to schedule your showing in the sought-after community of Clear Lake Shores!' ,`Acres` = '0.1837' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 18 M MULDOON SUR LOTS 893 THRU 896 CLEAR LAKE SHORES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Clear Lake Shores' ,`TaxAmount` = '6236' ,`TaxRate` = '1.8341' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1942' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556984' WHERE `Matrix_Unique_ID` = '213178082' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:03:21.607' ,`MLSNumber` = '39166207' ,`ListAgentFullName` = 'Brittany Schaefer' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.365567' ,`Longitude` = '-96.122471' ,`PhotoCount` = '27' ,`PostalCode` = '77868' ,`RoomCount` = '12' ,`ListPrice` = '349999.00' ,`Status` = 'Active' ,`StreetName` = 'Three Wood' ,`StreetNumber` = '2503' ,`StreetSuffix` = 'Way' ,`City` = 'Navasota' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2042' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful New Construction with a Golf Course view on 1/2 acre lot!!!!! Large covered back porch, 3 car garage with openers. The interior features include Open Living area, Stainless Steel Appliances, Gas Range, Granite countertops in kitchen and all bathrooms. Island Kitchen with large walk-in pantry. Elegant Subway Tile Backsplash, Ceiling fans in family room and all bedrooms. I love the Primary bath with double vanity, separate tub and shower and HUGE walk in closet. Luxury Wood Plank vinyl flooring in living area and plush carpet in bedrooms. Insulated Vinyl Double pane windows, insulated exterior doors, 2-inch faux blinds throughout the home, plex plumbing, tankless water Heater, Exterior is 4 sides brick. Features sheet attached. Golf course and pool.' ,`Acres` = '0.5016' ,`Area` = '60' ,`BuilderName` = 'High Road Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'PECAN LAKES ESTATES PHASE 3 SEC 2, BLOCK 8, LOT 19' ,`LotDesciption` = 'Cul-De-Sac,On Golf Course' ,`LotSize` = '21848' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '129 - Navasota' ,`SchoolElementary` = 'BRULE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NAVASOTA HIGH SCHOOL' ,`SchoolMiddle` = 'NAVASOTA JUNIOR HIGH' ,`ShowInstructions` = 'Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pecan Lakes Estates Ph 3 Sec 2' ,`TaxAmount` = '2579' ,`TaxRate` = '2.3442' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666556984' WHERE `Matrix_Unique_ID` = '213200705' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:42:18.207' ,`MLSNumber` = '39141927' ,`ListAgentFullName` = 'Lisa Cloud' ,`ListOfficeName` = 'Blue Willow Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.826583' ,`Longitude` = '-95.488194' ,`PhotoCount` = '23' ,`PostalCode` = '77092' ,`RoomCount` = '4' ,`ListPrice` = '159000.00' ,`Status` = 'Active' ,`StreetName` = 'Thornwall' ,`StreetNumber` = '6527' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1380' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '4 Bedroom 2 bathroom situated on an oversized lot in Langwood.' ,`Acres` = '0.2543' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 13 LANGWOOD SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11077' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BENBROOK ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Langwood Sec 03' ,`TaxAmount` = '3909' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556985' WHERE `Matrix_Unique_ID` = '213205081' --> 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','213217458','1666556985','213217458','2022-10-23T09:50:22.050','6861526','Stuart Scholer','5th Stream Realty','','','29.809813','-95.407653','50','77008','8','985000.00','Active','26th','540','Street','Houston','3','1','3','3159','Single-Family','Don\'t Miss This Immaculate Home with an ELEVATOR in the Heart of The Heights! 4 Bedrooms (or 3 Bedrooms Plus a Study or Media Room), 3.5 Baths and a Game Room with a Wet Bar and a Covered Outdoor Terrace. The Family Room Overlooks the Picturesque Backyard with Room for Your Outdoor Kitchen and Pool. The Primary Suite is Designed Like a Hotel Suite with a Foyer, Coffee Bar, Lavish Bath with a Soaking Tub & Huge Walk-in Shower and Custom Closet. Over $150,000 in Custom Upgrades Including an ELEVATOR! This Amazing Home Also Showcases Hardwood Floors, Custom Iron Doors, 48\" Thermador Appliance Package, an Extended Kitchen Island, Soft Close Cabinets and Drawers, Data Smart and Built in Speakers, Lush Backyard Landscaping with Uplighting and Sprinkler System.','0.0752','9','TITAN HOMES','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Heights/Greater Heights','Central Gas','0','LT 19 BLK 32 HOUSTON HEIGHTS','Subdivision Lot','3275','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','HELMS ELEMENTARY SCHOOL','HEIGHTS HIGH SCHOOL','HAMILTON MIDDLE SCHOOL (HOUSTON)','Appointment Required,Lockbox Right Side,Supra Keybox','Appraisal District','3','Contemporary/Modern','Houston Hts','17931','2.3307','Public Sewer,Public Water','2019','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T08:10:01.857' ,`MLSNumber` = '31080471' ,`ListAgentFullName` = 'John Simms' ,`ListOfficeName` = 'Legacy Homes & Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.807994' ,`Longitude` = '-95.429856' ,`PhotoCount` = '32' ,`PostalCode` = '77008' ,`RoomCount` = '8' ,`ListPrice` = '339900.00' ,`Status` = 'Active' ,`StreetName` = '24th' ,`StreetNumber` = '1721' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1380' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location, Location, Location! Do not wait to check out this 2 bed, 2 bath Home just minutes from the Heights, Downtown, Memorial and 290! Nestled in a quiet, gated community, there is a bedroom and bathroom on the first floor with access to a backyard area, perfect for hosting. Upstairs is a spacious Living Space with adjoining Dining Room, a beautiful kitchen with Granite countertops and Stainless Steel appliances, and the Primary Bedroom and Bathroom. Great property, great price point and a great area!' ,`Acres` = '0.0528' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 4 COTTAGES AT SHADY ACRES' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '2301' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cottages/Shady Acres' ,`TaxAmount` = '7097' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556985' WHERE `Matrix_Unique_ID` = '213228276' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:33:49.013' ,`MLSNumber` = '2170145' ,`ListAgentFullName` = 'Elizabeth Beery' ,`ListOfficeName` = 'Weichert,REALTORS-Murray Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.754039' ,`Longitude` = '-95.714800' ,`PhotoCount` = '48' ,`PostalCode` = '77450' ,`RoomCount` = '13' ,`ListPrice` = '1190000.00' ,`Status` = 'Active' ,`StreetName` = 'Parklake Village' ,`StreetNumber` = '1730' ,`StreetSuffix` = 'Street' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4645' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Absolutely gorgeous custom home offers a SPARKLING POOL & OUTDOOR covered patio with Beautiful green space and fire pit situated on a large lot in desirable GATED community Park Lake. Spectacular front elevation, impressive double door leads to a grand foyer with high ceilings, it is elegant & welcoming. Excellent floor plan, Many features, upgrades & updates. quality construction with attention to details. Elegant arches, tray ceilings, crown moldings & high ceilings throughout. amazing island kitchen, half bath, 3 car garages with extra big space, Julietta Balcony with beautiful view of front Lakeview. Shows beautifully like a model home. Come to see today!' ,`Acres` = '0.3011' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 2 PARKLAKE VILLAGE' ,`LotDesciption` = 'Corner,Water View' ,`LotSize` = '13118' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'PATTISON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MCMEANS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Left Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Parklake Village' ,`TaxAmount` = '16683' ,`TaxRate` = '2.3333' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556985' WHERE `Matrix_Unique_ID` = '213333872' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:34:24.627' ,`MLSNumber` = '41162134' ,`ListAgentFullName` = 'Chris Hotfelt' ,`ListOfficeName` = 'Keller Williams Platinum' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.748049' ,`Longitude` = '-95.553500' ,`PhotoCount` = '38' ,`PostalCode` = '77042' ,`RoomCount` = '3' ,`ListPrice` = '699500.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar Creek' ,`StreetNumber` = '10203' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3137' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great home in Briargrove/Memorial Bend area. Many updates in this 3 bedroom home. The loft on 2nd floor could be used as a 4th bedroom/office/child playroom that has its own separate AC system. Open concept, vaulted ceilings, with plenty of natural light. Island kitchen has ample counter space and cabinets, gas cooktop, built in microwave and oven, quartz counters, and custom wine fridge. Oversized utility room has plenty of cabinet space and room for freezer or second refrigerator. Primary bathroom is updated with granite counters, extra counter space as well as double sinks and vanity area. Large shower, separate jetted tub. Plenty of room on the tiled back patio area to enjoy a nice evening with family and friends. House has updates everywhere with smart features all around the home!' ,`Acres` = '0.2247' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Briargrove Park/Walnutbend' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1112 BLK 41 BRIARGROVE PARK SEC 6' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9787' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '685' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WALNUT BEND ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Briargrove Park Sec 06' ,`TaxAmount` = '14450' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556985' WHERE `Matrix_Unique_ID` = '213422879' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T08:11:32.977' ,`MLSNumber` = '43477429' ,`ListAgentFullName` = 'Moletha Broadnax' ,`ListOfficeName` = 'Connect Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.829231' ,`Longitude` = '-95.404181' ,`PhotoCount` = '12' ,`PostalCode` = '77018' ,`RoomCount` = '5' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Fenn' ,`StreetNumber` = '401' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1584' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 1 & 2 BLK 6 OAKRIDGE' ,`LotDesciption` = 'Corner' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Slate' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KENNEDY ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Oakridge' ,`TaxAmount` = '5422' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556985' WHERE `Matrix_Unique_ID` = '213468476' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:59:57.560' ,`MLSNumber` = '76697468' ,`ListAgentFullName` = 'Guolong Li' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.657961' ,`Longitude` = '-95.735213' ,`PhotoCount` = '50' ,`PostalCode` = '77406' ,`RoomCount` = '5' ,`ListPrice` = '559000.00' ,`Status` = 'Active' ,`StreetName` = 'Eagle Mountain' ,`StreetNumber` = '4518' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4213' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Step into this beautiful Executive Perry home w/ an entrance that leads in the family room. Enjoy the tropical backyard w/ a fantastic pool & waterfall. There is plenty of yard left to play & entertain in. Spacious 5 bedroom home w/ 3 1/2 baths. 3 car tandem garage. You will enjoy coming home everyday to this beautiful property!' ,`Acres` = '0.3648' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WATERSIDE ESTATES SEC 1, BLOCK 2, LOT 21' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15891' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '590' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground,Vinyl Lined' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'OAKLAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'BOWIE MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Waterside Estates' ,`TaxAmount` = '7811' ,`TaxRate` = '2.2929' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556986' WHERE `Matrix_Unique_ID` = '213487627' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:42:06.837' ,`MLSNumber` = '63234696' ,`ListAgentFullName` = 'Juan Barron' ,`ListOfficeName` = 'RE/ImageProperties and Investm' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.743698' ,`Longitude` = '-95.568840' ,`PhotoCount` = '15' ,`PostalCode` = '77042' ,`RoomCount` = '8' ,`ListPrice` = '469000.00' ,`Status` = 'Active' ,`StreetName` = 'Olympia' ,`StreetNumber` = '10826' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2393' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful Lakeside Estates! This One-Story Colonial offers Approx. 2393 SF with 4 bedrooms, 2.5 baths and a 2 car garage. The Property features a Family-size Den, traditional Formals, high beam ceilings and wood floors. Beautifully update home, with private pool. Kitchen has beautiful counter tops and stainless steel appliances. Convenient west side location for commuting to school, work, entertainment & shopping! Home was high and dry during Harvey. A must see!' ,`Acres` = '0.2039' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Briargrove Park/Walnutbend' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 6 LAKESIDE ESTATES SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8880' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WALNUT BEND ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakeside Estates Sec 03' ,`TaxAmount` = '9133' ,`TaxRate` = '2.5264' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556986' WHERE `Matrix_Unique_ID` = '213487757' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:16:09.443' ,`MLSNumber` = '42514333' ,`ListAgentFullName` = 'Vicki Emerson' ,`ListOfficeName` = 'Hunter Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.801084' ,`Longitude` = '-95.377123' ,`PhotoCount` = '26' ,`PostalCode` = '77009' ,`RoomCount` = '4' ,`ListPrice` = '399990.00' ,`Status` = 'Active' ,`StreetName` = 'Tabor' ,`StreetNumber` = '1102' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '744' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully Updated 2 B/R 1 Bath Heights Bungalow on 5000 Sq. Ft. CORNER LOT Nestled among Trees. 1 Car Garage. Current owner is only the SECOND HOMEOWNER of the property and has lived in home since 1998. Property has been updated throughout including Tankless Water Heater, Replumbed Pipes, Rewired Electrical & Refinished Original Hard Wood floors. 2011 Roof, A/C installed & Sewer replaced in 2018. INSULATION in Attic & B/R Walls. Corian Countertops, Tile Backsplash, Soft Close Cabinets with Pull Out Drawers, Gas Stove & Double Porcelain Sink in Kitchen. Double Pane Low E Casement /Transom Windows in Bedrooms. Mirrored Closets with Built In Wardrobes in Secondary Bedroom. Ceiling Fans throughout. Located 1 Block from Montie Beach Park. Easy Access to 45, 610, Rail, Downtown & Farmers Market on Airline. *All Information provided by Seller*' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 BLK 101 BROOKE SMITH' ,`LotDesciption` = 'Corner' ,`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` = 'BROWNING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Brooke Smith' ,`TaxAmount` = '6336' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1925' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556986' WHERE `Matrix_Unique_ID` = '213495107' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T08:30:36.833' ,`MLSNumber` = '40015050' ,`ListAgentFullName` = 'Ramsey Thompson' ,`ListOfficeName` = 'IndyQuest Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.540057' ,`Longitude` = '-95.052383' ,`PhotoCount` = '48' ,`PostalCode` = '77573' ,`RoomCount` = '9' ,`ListPrice` = '540000.00' ,`Status` = 'Active' ,`StreetName` = 'Charter Pointe' ,`StreetNumber` = '2006' ,`StreetSuffix` = 'Court' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4314' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this grand 5 bedroom, 2-Story cul-de-sac home located in the renowned neighborhood of Marina Bay Park! As you enter this awe-inspiring home, you are greeted with an opulent staircase leading to the 2nd floor which boasts the four secondary bedrooms, two full bathrooms, & two game rooms. Downstairs, you will find the spacious formal dining room & office/study on either sides of the front entry. Kitchen has granite countertops, under-mount lighting, breakfast bar & large eating area. The primary bedroom is a dream, with a beautiful en-suite bathroom boasting a large separate shower, jetted tub, & dual sinks. Outdoors you will find the covered patio with an exquisite pool & large hot tub. New pool heater and LED lights were just installed this year as well as epoxy flooring in the garage. The desirable golf-course community of South Shore is golf-cart friendly and boasts multiple neighborhood parks and pools, all within walking distance. Zoned to highly rated CCISD schools!' ,`Acres` = '0.2013' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 18 LOT 39 BLK 1 MARINA BAY PARK SEC 3' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '8768' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'FERGUSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CLEAR CREEK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Marina Bay Park Sec 3 96' ,`TaxAmount` = '9522' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556986' WHERE `Matrix_Unique_ID` = '213521884' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T08:18:10.210' ,`MLSNumber` = '96402746' ,`ListAgentFullName` = 'Sarah Gongora' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.035166' ,`Longitude` = '-95.541010' ,`PhotoCount` = '50' ,`PostalCode` = '77379' ,`RoomCount` = '8' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Goldengrove' ,`StreetNumber` = '7715' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2765' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to Goldengrove drive! This quiet neighborhood features mature trees and over-sized lots. This rare 5 bedroom and 3 bath home has a beautifully updated kitchen with granite counters and loads of storage in the updated cabinetry. The large family room boasts tall ceilings, a beautiful brick fireplace, and french doors opening to the backyard. In the primary suite, you will find architectural details like the vaulted ceiling, mood lighting, and built-in storage. Downstairs, there are two other secondary bedrooms and full bathroom. Upstairs, you will find a massive game room with ample storage, two large bedrooms, and a full bathroom. In the backyard, enjoy your very own miniature golf course, and there is still plenty of room for play structures and open space. Easy access to Grand Parkway, I-45, and 249. Schedule your tour today!' ,`Acres` = '0.2306' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 1 017*O0258896-002-001-007 OAKWOOD GLEN WEST SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10044' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'EHRHARDT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oakwood Glen West Sec 02' ,`TaxAmount` = '5471' ,`TaxRate` = '2.5085' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556986' WHERE `Matrix_Unique_ID` = '213547658' --> 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','213548090','1666556987','213548090','2022-10-23T09:31:16.057','13837610','David Bowers','BHGRE Gary GreeneGalveston In Town','','','29.324281','-94.772675','31','77550','6','333000.00','Active','Marine','1409','Drive','Galveston','2','1','2','1897','Single-Family','Circa 1959 Brick, one story home with large living and den and two primary bedrooms, each with ensuite baths. Living room, 25x16, and the first primary bedroom have hardwood floors and the rest of the house has tiled floors. Full kitchen has gas range, pantry closet and granite counter tops & breakfast bar. Double French doors and double-paned windows throughout the house. Large two car garage. Landscaped backyard complete with butterfly plants. Great neighborhood. Extensive list of Seller upgrades.','0.1218','33','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','East End','Central Gas','0','ABST 628 M B MENARD SUR LOT 50 HARBOR VIEW','Subdivision Lot','5304','Appraisal District','','','0','','2','','0','','','Gas Range','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required,Supra Keybox','Appraisal District','1','Contemporary/Modern','Harborview','4863','2.0662','Public Sewer,Public Water','1959','Seller'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:22:01.217' ,`MLSNumber` = '98977067' ,`ListAgentFullName` = 'Donna Rooney' ,`ListOfficeName` = 'CB&A, Realtors-Katy' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.740704' ,`Longitude` = '-95.831819' ,`PhotoCount` = '49' ,`PostalCode` = '77494' ,`RoomCount` = '20' ,`ListPrice` = '835000.00' ,`Status` = 'Active' ,`StreetName` = 'Hillside Landing' ,`StreetNumber` = '3043' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4861' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this gorgeous 4,861 sqft property located in the private, gated section of Silver Ranch! This house offers 5 Bedrooms, 4 1/2 Bathrooms, 3-Car Garage, Formal Dining Room, Game Room, Sunroom, Home Office/Study PLUS a Private Pool/Spa that is ready for its new owner(s)! Meticulously maintained limestone/brick house with many amazing features, along with upgraded hardwood and tile flooring, beautiful fixtures and much more. Beautiful living room is open to the kitchen making it a perfect space to entertain! Gourmet kitchen features large island, upgraded granite countertops and cabinetry, glass backsplash, stainless steel appliances and a butler’s pantry. There are TWO primary bedrooms downstairs! The large foyer boasts 8\' doors, an elegant staircase and rich hardwood floors in the entryway, dining & family room, a large covered patio overlooking the sparkling pool, with NO backyard neighbors. This home is a must see! BE SURE TO CHECK OUT THE VIDEO TOUR!!' ,`Acres` = '0.2324' ,`Area` = '36' ,`BuilderName` = 'K Hovnanian Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Home Protection Plan,Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'SILVER RANCH SEC 12, BLOCK 1, LOT 19' ,`LotDesciption` = 'Cleared,Greenbelt,Subdivision Lot' ,`LotSize` = '10125' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'JENKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMPKINS HIGH SCHOOL' ,`SchoolMiddle` = 'TAYS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Silver Ranch Sec 12' ,`TaxAmount` = '14348' ,`TaxRate` = '2.7545' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556987' WHERE `Matrix_Unique_ID` = '213552387' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T08:58:31.953' ,`MLSNumber` = '73302659' ,`ListAgentFullName` = 'Sherri Hughey' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.733330' ,`Longitude` = '-95.393787' ,`PhotoCount` = '27' ,`PostalCode` = '77006' ,`RoomCount` = '6' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Mount Vernon' ,`StreetNumber` = '4402' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2237' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 4402 Mount Vernon! This meticulously maintained, free-standing townhome is located on a large corner lot in a quiet Montrose neighborhood. It is filled with natural light. The open second-floor living area features modern elements and updates, including 16-foot ceilings, new light fixtures, all stainless steel appliances, a gas cooktop and grill, wet bar and wine cooler, and a large quartz waterfall island with a breakfast bar. One bedroom/office is located on the first floor, the primary and secondary bedrooms are on the third floor. Each of the bedrooms have walk-in closets, ensuite baths and marble finishes. A large rooftop deck overlooks downtown and the medical center and is perfect for entertaining. Rare three car garage includes a Tesla home charger. The gated grassy side yard attaches to a community courtyard. The home is located within walking distance of coffee shops, the Menil Collection, shady paths in Boulevard Oaks, and some of Montrose’s best restaurants.' ,`Acres` = '0.036' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Montrose' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 BLK 1 MT VERNON PLACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1569' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'POE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Montrose' ,`TaxAmount` = '12783' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556987' WHERE `Matrix_Unique_ID` = '213553970' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T08:49:10.710' ,`MLSNumber` = '97607611' ,`ListAgentFullName` = 'Lia Jenkins' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.548628' ,`Longitude` = '-95.493860' ,`PhotoCount` = '18' ,`PostalCode` = '77545' ,`RoomCount` = '8' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Rose Embers' ,`StreetNumber` = '2703' ,`StreetSuffix` = 'Court' ,`City` = 'Fresno' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1779' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come take a look at this beautiful Lake Ridge Builders home . Located in the desirable community of Winfield Lakes This Home is perfect for you. Situated on a spacious lot, this offers a premium elevation, tile flooring, a fireplace with a cast stone surround, and covered patio. The chef’s kitchen comes equipped with granite countertops, tile backsplash, stainless steel appliances, and 42” cabinets. Unwind in the spa-like master suite, complete with dual vanities, a 42” tub, and separate shower. Community comforts include a picturesque lake with trails, gazebo, clubhouse, pool, and playground. Commuters enjoy easy access to Highway 6 and Fort Bend Parkway Toll Road. Schools are zoned to the esteemed Fort Bend ISD. Don’t let this opportunity pass you by - Come see for yourself' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '515' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PARKS ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'HIGHTOWER HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Winfield Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666556987' WHERE `Matrix_Unique_ID` = '213603699' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:57:16.087' ,`MLSNumber` = '47626897' ,`ListAgentFullName` = 'Thomas Saunders' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.049927' ,`Longitude` = '-95.171254' ,`PhotoCount` = '30' ,`PostalCode` = '77345' ,`RoomCount` = '8' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'Shore Hills' ,`StreetNumber` = '4802' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION, LOCATION, LOCATION! Overlooking the Fosters Mill duck pond & water fountain, The Views are Stunning, CUL-DE-SAC property is an ideal setting, Impressive entrance w/ beautiful open staircase. EXTENSIVE REMODELING & IMPROVEMNTS with Designer Touches Throughout, Stone Flooring, HIGH CEILINGS IN LIVINGROOM, Walls of Windows HIGHLIGHTING THE VIEWS, Gourmet Kitchen with stainless steel appliances, induction cooktop, quartz counters, commercial fridge, Study off livingroom with Grand Views, Extensive Stone Work Designed Fireplace, Primary is downstairs with an Amazing bathroom with Floating Cabinetry, separate tub & shower with high end tile work, Gameroom upstairs features built-in cabinets & even more fantastic views, Private Pool, Active with wild life & immediate access to greenbelts, surrounded by mature shady trees. This is a rare find.' ,`Acres` = '0.2703' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 15 FOSTERS MILL VILLAGE SEC 1' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot,Water View' ,`LotSize` = '11776' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '655' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'DEERWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'RIVERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Fosters Mill Village Sec 01' ,`TaxAmount` = '5882' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556987' WHERE `Matrix_Unique_ID` = '213629154' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:07:53.797' ,`MLSNumber` = '26476342' ,`ListAgentFullName` = 'Kevin Johnson' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.087260' ,`Longitude` = '-95.662176' ,`PhotoCount` = '45' ,`PostalCode` = '77377' ,`RoomCount` = '11' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Bark' ,`StreetNumber` = '15822' ,`StreetSuffix` = 'Lane' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3998' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful 5 bedroom, 3 1/2 bath home with a huge lot on cul-de-sac street in an awesome neighborhood. This home has an excellent floor plan with beautiful finishes throughout. Upon entering, you find the office with french doors, the extra living/flex space, and dining room. The island kitchen has lots of storage, a good size pantry, and is open to the breakfast area & family room. The primary suite is downstairs, features two vanities, two walk in closets, a garden tub, and a nice shower. You also have a 1/2 bath, oversized laundry room, and ample storage. Upstairs you have 4 large bedrooms, all with walk-in closets, 2 full bathrooms, a game room, and a media room. Out back you have 475 sq. ft. of concrete patio with 1/2 of it covered. There is plenty of room for a pool, plus more. Garage can be 3 car OR 2 car with 1 car workshop. PLUS low taxes and low HOA!' ,`Acres` = '0.2583' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 2 PINE COUNTRY OF TOMBALL SEC 2 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'ROSEHILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pine Country/Tomball' ,`TaxAmount` = '9428' ,`TaxRate` = '2.3767' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556988' WHERE `Matrix_Unique_ID` = '213639711' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T08:12:14.860' ,`MLSNumber` = '51033864' ,`ListAgentFullName` = 'Maritza Soto' ,`ListOfficeName` = 'Value Roc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.670004' ,`Longitude` = '-95.337815' ,`PhotoCount` = '8' ,`PostalCode` = '77033' ,`RoomCount` = '5' ,`ListPrice` = '99500.00' ,`Status` = 'Active' ,`StreetName` = 'Willow Glen' ,`StreetNumber` = '5626' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1032' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perfect investment property and great lot size! Amazing location close to I-610 and Hwy 288 also minutes from Houston medical center! Property being sold AS IS. Seller will make no repairs.' ,`Acres` = '0.1722' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas,No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 7 BLK 5 EDGEWOOD SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7502' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ALCOTT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Edgewood Sec 01' ,`TaxAmount` = '1376' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1948' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556988' WHERE `Matrix_Unique_ID` = '213645627' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:15:18.150' ,`MLSNumber` = '29428294' ,`ListAgentFullName` = 'Sommer Hausman' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.206981' ,`Longitude` = '-95.536573' ,`PhotoCount` = '43' ,`PostalCode` = '77382' ,`RoomCount` = '9' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Greenvine' ,`StreetNumber` = '27' ,`StreetSuffix` = 'Circle' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2829' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this beautiful 2 story brick home with 4 bedrooms- but also office and game room that can be used as bedrooms 5&6. No carpet on the ground level. Living room has a gas fireplace, tall ceilings and large windows that let in plenty of natural sunlight. The kitchen has granite countertops, stainless steel appliances, a large pantry, gas cooktop, and a island to give you room to cook. In the back yard you will find a salt water pool and deck to enjoy the long summer days. Zones to highly desired Woodlands High school and feeder schools. New roof! ' ,`Acres` = '0.1791' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL ALDEN BR 37, BLOCK 1, LOT 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7803' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUCKALEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Alden Br 37' ,`TaxAmount` = '8725' ,`TaxRate` = '2.1811' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556988' WHERE `Matrix_Unique_ID` = '213646078' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T08:31:21.950' ,`MLSNumber` = '35725131' ,`ListAgentFullName` = 'Chris Glapa' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = 'Marian Rohat' ,`SellingOfficeName` = 'Ross & Marshall Realty' ,`Latitude` = '29.845055' ,`Longitude` = '-95.725293' ,`PhotoCount` = '38' ,`PostalCode` = '77449' ,`RoomCount` = '7' ,`ListPrice` = '269900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Juniper Spring' ,`StreetNumber` = '5131' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2020' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Tucked away on a quiet oversized culdesac lot in desirable Ricewood Village, this inviting 2-story home features luxurious updates & modern floorplan! Eye-catching curb appeal boasts a mature Oak tree & potted plants along the sidewalk that leads you to the covered front porch! Upon entering you\'re greeted by gorgeous laminate flooring, custom accent wallpaper, & tons of natural light! Gourmet Chef\'s island kitchen w/exquisite granite counters, custom glass tile backsplash, endless cabinetry, & stainless steel appliances w/gas range & built-in microwave is a dream! Conveniently located half bath & utility space is at the rear of the kitchen & adjacent to the garage access! Spacious master suite w/custom ceiling fan offers an en suite bath w/walk-in shower & separate garden soaking tub, extended vanity w/dual sinks, along w/2 HUGE walk-in closets! Large secondary bedrooms & flex/media/bedroom w/projector & equipment! Oversized private backyard w/extended decking & tons of greenspace!' ,`Acres` = '0.1229' ,`Area` = '25' ,`BuilderName` = 'Foxwood' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 31 BLK 1 RICEWOOD VILLAGE SEC 4' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5352' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '478' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'M ROBINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (CY-FAIR)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ricewood Village Sec 4' ,`TaxAmount` = '5611' ,`TaxRate` = '3.011' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556988' WHERE `Matrix_Unique_ID` = '213647830' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T08:31:17.457' ,`MLSNumber` = '68603635' ,`ListAgentFullName` = 'Heather Trejo' ,`ListOfficeName` = 'Red Door Realty & Associates' ,`SellingAgentFullName` = 'Hillary Chaires' ,`SellingOfficeName` = 'RE/MAX The Woodlands & Spring' ,`Latitude` = '30.058064' ,`Longitude` = '-95.178757' ,`PhotoCount` = '45' ,`PostalCode` = '77345' ,`RoomCount` = '7' ,`ListPrice` = '370000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Falling Brook' ,`StreetNumber` = '3007' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2593' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wait until you see this gem! Beautiful updates on the interior and exterior. No neighbors to the back or left side. Recent kitchen remodel that boast induction cooktop, gorgeous quartz counters and a custom seating area in the breakfast nook. A cozy living room features a gas fireplace and built in cabinets. The flex office/formal seating area is open to the over sized formal dining room just off of the entry. Upstairs you will be pleased to find 3 spacious bedrooms and a newly remodeled bathroom with dual vanity. Plantation shutters and newer light fixtures throughout. Within the past 5 years the entire interior and exterior have been painted. Easy access to greenbelts, Metro Riding, 15 minutes to IAH, and 25 minutes to downtown Houston!' ,`Acres` = '0.2353' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 19 GREENTREE VILLAGE SEC 2' ,`LotDesciption` = 'In Golf Course Community,Wooded' ,`LotSize` = '10250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '312' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GREENTREE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Greentree Village' ,`TaxAmount` = '6711' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556988' WHERE `Matrix_Unique_ID` = '213735568' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:33:43.820' ,`MLSNumber` = '38540564' ,`ListAgentFullName` = 'Sophie Zhang' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.728719' ,`Longitude` = '-95.848112' ,`PhotoCount` = '34' ,`PostalCode` = '77441' ,`RoomCount` = '8' ,`ListPrice` = '518000.00' ,`Status` = 'Active' ,`StreetName` = 'Huggins Crest' ,`StreetNumber` = '27606' ,`StreetSuffix` = 'Court' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2887' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Former BEAZER MODEL HOME in Master Planned Community in the Capri Floor plan. This 1.5 story home features 4 bedrooms, 3 baths, a study, Game room, and loft. There are 3 bedrooms downstairs! Upgrades galore with Stainless steel apliances, granite counter tops, iron spindles,and 2 master closets! There are tile and wood flooring throughout most of the home. Don\'t miss the great covered patio out back and it\'s on a CUL-DE-SAC street across from the pool! Hurry to see this gorgeous home today!' ,`Acres` = '0.1609' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CHURCHILL FARMS SEC 1, BLOCK 1, LOT 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7009' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '630' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Churchill Farms Sec 1' ,`TaxAmount` = '8511' ,`TaxRate` = '2.8745' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556989' WHERE `Matrix_Unique_ID` = '213744258' --> 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','213800938','1666556989','213800938','2022-10-23T08:01:19.717','74940579','Jody Roche','BHGRE Gary Greene','','','30.008102','-95.299213','31','77338','6','189900.00','Active','Heaton Hall','8302','Street','Humble','2','0','3','1560','Single-Family','Wonderful 3/2/2 on large corner lot in Kenswick. Great floorplan! Large Family Room with fireplace. Roof, A/C, water heater, fence and carpet less than 5 years. Big backyard for pets and children to play. Tons of potential!','0.1791','12','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Wood Burning Fireplace','1','Humble Area West','Central Electric','1','LT 37 BLK 1 KENSWICK SEC 1 R/P','Corner,Subdivision Lot','7800','Appraisal District','','259','0','','2','Electric Oven,Freestanding Oven','0','','','Electric Range','','Composition','1 - Aldine','JONES ELEMENTARY SCHOOL (ALDINE)','NIMITZ HIGH SCHOOL (ALDINE)','JONES MIDDLE SCHOOL (ALDINE)','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Kenswick','3907','2.7433','Water District','1978','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213818000','1666556989','213818000','2022-10-23T08:28:09.650','98586872','George Binoy','UGM Realty LLC','','','29.593337','-95.530504','24','77489','8','255000.00','Active','Lisha','2310','Lane','Missouri City','2','0','4','1781','Single-Family','Lovely 4 bedroom and 2 bath home on large cul-de-sac lot. New paint, New Standing Bath, New Air-condition. Dining and breakfast both look out to backyard. This home features High-Ceiling and lots of windows bringing in natural light! New blinds will be installed. Easy access to Hwy 90, Mchard, Texas Parkway, Murphy, FM 288 & FB Tollway.','0.242','38','','','','','Sellers Disclosure','1','Wood Burning Fireplace','1','Missouri City Area','Central Gas','1','QUAIL GREEN WEST SEC 2, BLOCK 3, LOT 27','Subdivision Lot','10543','Appraisal District','','300','0','','2','','0','','','','','Composition','19 - Fort Bend','EDGAR GLOVER JR ELEMENTARY SCHOOL','MARSHALL HIGH SCHOOL (FORT BEND)','MISSOURI CITY MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','1','Traditional','Quail Green West Sec 2','4803','3.1174','Public Sewer,Public Water','1985','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:43:37.877' ,`MLSNumber` = '97317433' ,`ListAgentFullName` = 'Victor Chelf' ,`ListOfficeName` = 'Coldwell Banker Realty, Cy-Fair Office' ,`SellingAgentFullName` = 'Tonja McAllen' ,`SellingOfficeName` = 'Texas Premier Realty' ,`Latitude` = '29.928489' ,`Longitude` = '-95.607860' ,`PhotoCount` = '40' ,`PostalCode` = '77065' ,`RoomCount` = '12' ,`ListPrice` = '375000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Hillside Glen' ,`StreetNumber` = '11146' ,`StreetSuffix` = 'Trail' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2543' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Terrific 4 bedroom, 1 story home with a detached garage in Wortham Park. Recent ROOF in Nov 2021. Open Floor Plan offers Formal Dining, Large Island Kitchen with granite counter tops, 42\" Cabinets and Breakfast Bar. Stainless steel appliances installed in 2021. Large Family Room with Fireplace & High Ceilings. Flooring includes Wide Plank, hand scraped, wood-look laminate floors, tile and carpet. Carpet replaced in Jan 2022. HUGE Primary Suite with walk-in Closet. 3 spacious secondary bedrooms. Recent interior paint. Wheel Chair accessible secondary bathroom. Both HVAC UNITS replaced in Aug 2021. EZ maintenance backyard. Full sprinkler system. Washer, Dryer and Refrigerator convey. Wortham Park offers lots of Parks, Pools, Sidewalks, Easy Access to Hwy 290/1960, Great Shopping, restaurants nearby and zoned to Cy-Fair ISD.' ,`Acres` = '0.1716' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 2 WORTHAM PARK SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ADAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'ARNOLD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wortham Park' ,`TaxAmount` = '5621' ,`TaxRate` = '2.341' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556989' WHERE `Matrix_Unique_ID` = '213847213' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T08:38:19.790' ,`MLSNumber` = '88093769' ,`ListAgentFullName` = 'Noreen Arleth' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.119072' ,`Longitude` = '-95.745103' ,`PhotoCount` = '49' ,`PostalCode` = '77355' ,`RoomCount` = '8' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Turtle Creek' ,`StreetNumber` = '19615' ,`StreetSuffix` = 'Lane' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2858' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Two-story home on approx 1.24+/- acre lot, completely fenced and cross-fenced. Unrestricted. Oversized 24x24 garage with workbench and 6x8 dog kennel area. 12x24 insulated building w/electric & plumbed. Could easily be made into a \"guest house\". Also 12x20 storage shed with workbench, peg board and cabinets. 2 tiered covered deck w/view to in-ground 12\' deep pool w/dive board. Landscaped, cross-fenced tropical backyard. Primary Bedroom is up, w/access to the balcony overlooking this oasis! Spacious bedrooms! 2 secondary up with cedar-lined window seats. One bedroom down with access to full bath. Cedar-lined closet. All windows are wood encased w/rosettes. Kitchen has updated cabinets, appliances and granite. Large island/breakfast bar and tons of counter space. Huge living area with stained concrete floors. Lots of wrap-around porches, covered decks! Low tax rate, ez access to 249, 2920, 99. No HOA fees - No HOA!' ,`Acres` = '1.2362' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'TURTLE CREEK 01, BLOCK 5, LOT 5, ACRES 1.240' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '53849' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'J.L. LYON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Turtle Creek' ,`TaxAmount` = '3843' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556989' WHERE `Matrix_Unique_ID` = '213866048' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T08:40:11.953' ,`MLSNumber` = '14589731' ,`ListAgentFullName` = 'Linda Harris' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.826682' ,`Longitude` = '-95.503120' ,`PhotoCount` = '32' ,`PostalCode` = '77080' ,`RoomCount` = '9' ,`ListPrice` = '298600.00' ,`Status` = 'Active' ,`StreetName` = 'Rannie' ,`StreetNumber` = '8601' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1829' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautifully updated four bedroom located in Spring Branch has been recently updated and MOVE-IN READY! Refinished hardwood oak floors throughout 3 of the bedrooms and family room. New vinyl plank throughout the kitchen, utility room and den. The primary bedroom has new carpet. There is a completely fenced spacious back yard with 4 mature pecan trees. Conveniently located close to major highways for an easy commute! This amazing central location is just minutes from Houston\'s top restaurants, shopping, parks and much more! NO FLOODING. ****COMMERCIAL/ RESIDENTIAL LOT @ 60 X 200****' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 64 BLK 4' ,`LotDesciption` = 'Corner' ,`LotSize` = '11940' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'EDGEWOOD ELEMENTARY SCHOOL (SPRING BRANCH)' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'NORTHBROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wilson Court' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556989' WHERE `Matrix_Unique_ID` = '213868443' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:51:48.803' ,`MLSNumber` = '87377544' ,`ListAgentFullName` = 'AJ Whitener' ,`ListOfficeName` = 'Compass RE Texas, LLCKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.730789' ,`Longitude` = '-95.741948' ,`PhotoCount` = '36' ,`PostalCode` = '77450' ,`RoomCount` = '11' ,`ListPrice` = '775000.00' ,`Status` = 'Active' ,`StreetName` = 'Perdido Bay' ,`StreetNumber` = '4219' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4810' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Positioned on coveted oversized golf course lot backing to the 14th hole, just minutes from Downtown Houston and the Energy Corridor, this Kelliwood Greens dream home awaits a lucky buyer. Towering oaks shade the circle drive and abundant flowering landscaping embrace this impressive estate home with private gate. Lovingly maintained by original owner. Comprehensive renovation boasts tasteful wood-look tile spanning most of the first floor and upgraded interior and exterior lighting. Enormous island kitchen opens to the family room with second fireplace and features SS Kitchenaide appliances: 5 burner gas cooktop, dual ovens and warming drawer. Refrigerator will convey. Entertaining flows outside to private lanai with sparking pool/spa and ample greenspace. Outdoor access from primary, dining and kitchen. Upstairs, natural light pours into the remarkable game room with vaulted ceiling, wood flooring and access to expansive balcony overlooking the manicured fairway. KISD. Welcome home.' ,`Acres` = '0.3254' ,`Area` = '36' ,`BuilderName` = 'Kickerillo' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'KELLIWOOD GREENS SEC 1, BLOCK 8, LOT 3' ,`LotDesciption` = 'Greenbelt,In Golf Course Community,On Golf Course,Subdivision Lot' ,`LotSize` = '14175' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CREECH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'BECK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kelliwood Greens Sec 1' ,`TaxAmount` = '13964' ,`TaxRate` = '2.495' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556990' WHERE `Matrix_Unique_ID` = '213874969' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:13:44.630' ,`MLSNumber` = '76037679' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Pulte Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.832813' ,`Longitude` = '-95.859083' ,`PhotoCount` = '18' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '326090.00' ,`Status` = 'Active' ,`StreetName` = 'Laguna Cove' ,`StreetNumber` = '1004' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1814' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOVE-IN READY with a HUGE backyard! Gordon plan by Centex is a highly sought-after two-story impresses with an open great room overlooking the rounded staircase. High ceilings offer an open and inviting gathering area to make cherished memories. Gourmet kitchen with oversized island and eat-in bar top lends extra dining space, and the walk-in pantry provides generous storage. Stainless Steel Appliances, Sprinkler System, Front and Rear Gutters. Zoned to Katy ISD. Sunterra Community features a 3.5-acre Crystal Blue Lagoon with white sand beaches, palm trees, cabanas, watercraft rentals of kayaks, paddleboards, etc! Clubhouse, event center, swim-up beach bar, swimming pool, and splash pad – resort style living at its finest!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Centex Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9, Block 2, Section 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4000' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.66' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666556990' WHERE `Matrix_Unique_ID` = '213882120' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:36:37.290' ,`MLSNumber` = '76078167' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Pulte Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.832813' ,`Longitude` = '-95.859083' ,`PhotoCount` = '20' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '353870.00' ,`Status` = 'Active' ,`StreetName` = 'Laguna Cove' ,`StreetNumber` = '1028' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1814' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOVE-IN READY nestled on a corner lot! Springfield plan by Centex features a two-story home with an open and inviting family gathering area. Gourmet kitchen area with tons of countertop space and breakfast nook. First-floor covered patio ideal for outdoor entertaining. Stainless Steel Appliances, Sprinkler System, Front and Rear Gutters. Zoned to Katy ISD. Sunterra Community features a 3.5-acre Crystal Blue Lagoon with white sand beaches, palm trees, cabanas, watercraft rentals of kayaks, paddleboards, etc! Clubhouse, event center, swim-up beach bar, swimming pool, and splash pad – resort style living at its finest!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Centex Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1, Block 2, Section 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5065' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.66' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666556990' WHERE `Matrix_Unique_ID` = '213882451' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:52:46.320' ,`MLSNumber` = '74486833' ,`ListAgentFullName` = 'Marvin Loyd' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.538428' ,`Longitude` = '-95.092132' ,`PhotoCount` = '27' ,`PostalCode` = '77058' ,`RoomCount` = '15' ,`ListPrice` = '389900.00' ,`Status` = 'Active' ,`StreetName` = 'Carriage' ,`StreetNumber` = '18602' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2826' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this fantastic family home in desirable, historic Nassau Bay. This corner lot property sits on over 1/4 acre and features mature shade trees and a park-like backyard with a covered patio for entertaining family and friends. Take your golf cart or walk to three neighborhood parks featuring waterside walking paths, tennis, volleyball, covered basketball courts, children\'s play areas, fishing and more. The neighborhood pool, boat marina, post office, restaurants and shops are just around the corner too! The family room features a wood plank floor and brick fireplace looking out to the back yard. The kitchen has a charming breakfast area and leads to spacious dining and living rooms. Across from the large primary Ensuite is the 4th bedroom which can be a study or work out area! The upstairs game room connects two large bright bedrooms and has plenty of space for a pool table or gaming area. This is a one-owner home that has been well cared for. Never flooded!\r\nCome See TODAY!' ,`Acres` = '0.2893' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 30 BLK 21 NASSAU BAY SEC 4' ,`LotDesciption` = 'Corner' ,`LotSize` = '12600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '126' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ROBINSON ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Nassau Bay Sec 04' ,`TaxAmount` = '7839' ,`TaxRate` = '2.4882' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556990' WHERE `Matrix_Unique_ID` = '213913592' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:36:03.470' ,`MLSNumber` = '78129989' ,`ListAgentFullName` = 'Kelly Lawson' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.028192' ,`Longitude` = '-95.494808' ,`PhotoCount` = '44' ,`PostalCode` = '77379' ,`RoomCount` = '10' ,`ListPrice` = '394000.00' ,`Status` = 'Active' ,`StreetName` = 'Ashmere' ,`StreetNumber` = '5507' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2664' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious move-in ready 4-bedroom, 2 ½ bath, with backyard oasis including in-ground Gunite pool, heated spa, tropical banana plantain trees oasis is conveniently located in Terranova West. Open floor plan with Island Kitchen, black appliances, granite countertops, pendant lighting, double ovens, formal dining room, and primary suite downstairs. The primary suite bath has a large walk-in shower, dual shower heads, beautifully detailed tile work, dual sinks in a marble vanity, and ceramic tile flooring that connects to the utility room. Upstairs are three additional spacious bedrooms, a full bath, and a game room complete with 2nd gas log fireplace and dry bar. PEX Plumbing, Plantation Shutters, Crown Molding, and Ceiling fans are found throughout the entire home. Freshly painted and new carpet. Outside is a large, covered patio, pool storage or workshop behind the garage, and a private pool with a rock waterfall.' ,`Acres` = '0.2149' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 278 BLK 8 9017*T1957535-001-008-278) TERRANOVA WEST SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9360' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BENFER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'STRACK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Terranova West' ,`TaxAmount` = '7627' ,`TaxRate` = '2.7066' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556990' WHERE `Matrix_Unique_ID` = '213914928' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:24:24.580' ,`MLSNumber` = '93267814' ,`ListAgentFullName` = 'Anette Trevino' ,`ListOfficeName` = 'Loyal Texas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.769701' ,`Longitude` = '-95.246766' ,`PhotoCount` = '27' ,`PostalCode` = '77029' ,`RoomCount` = '16' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Oswego' ,`StreetNumber` = '10325' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '1746' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great possible profit opportunity.!! You can now own two homes for the price of one!! This is a rare gem. You can either live in one or rent the other half. Or you can have a huge 6-bedroom home with: 2 Kitchens, 2 full baths, 2 Livingroom\'s, 2 zones A/C units, and 2 water heaters. Home was renovated and is move in ready. This beauty also features almost two lots with two large driveways. Home is also situated near downtown and major Freeways.' ,`Acres` = '0.2089' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Tenant Occupied' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 4 JACINTO GARDENS' ,`LotDesciption` = 'Cleared' ,`LotSize` = '9100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WHITTIER ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'FURR HIGH SCHOOL' ,`SchoolMiddle` = 'HOLLAND MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jacinto Gardens' ,`TaxAmount` = '6668' ,`TaxRate` = '2.5534' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556991' WHERE `Matrix_Unique_ID` = '213922650' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T09:12:55.553' ,`MLSNumber` = '17948347' ,`ListAgentFullName` = 'Alice Smith' ,`ListOfficeName` = 'RE/MAX Compass' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.559504' ,`Longitude` = '-95.721770' ,`PhotoCount` = '46' ,`PostalCode` = '77469' ,`RoomCount` = '12' ,`ListPrice` = '465000.00' ,`Status` = 'Active' ,`StreetName` = 'Matthew Glen' ,`StreetNumber` = '1803' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3062' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GORGEOUS home with a grand foyer! Wow! Office; 4 bedrooms; 3.5 baths; upstairs game room or media room WITH a half bath. The trending porcelain plank floors are a buyers delight. HUGE cul-de-sac lot with playset and trampoline that stays. Plenty of room for a pool! STAINLESS STEEL REFRIGERATOR STAYS. This lovely home has total open concept. Kitchen offers granite countertops and stainless appliances. Gas stove. Extensive covered patio will allow you to have those special family BBQ\'s or just sit and enjoy the outdoors. Ensuite Guest room boast of a large shower. The upstairs game room has a half bath for your comfort.' ,`Acres` = '0.2254' ,`Area` = '30' ,`BuilderName` = 'PERRY' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'RIVERPARK WEST SEC 14, BLOCK 2, LOT 7' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9820' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUTCHISON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverpark West Sec 14' ,`TaxAmount` = '8051' ,`TaxRate` = '2.8748' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556991' WHERE `Matrix_Unique_ID` = '213927120' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T08:07:00.370' ,`MLSNumber` = '11370558' ,`ListAgentFullName` = 'Melissa Sumrall' ,`ListOfficeName` = 'Keller Williams Elite' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.818063' ,`Longitude` = '-94.995000' ,`PhotoCount` = '29' ,`PostalCode` = '77521' ,`RoomCount` = '8' ,`ListPrice` = '255000.00' ,`Status` = 'Active' ,`StreetName` = 'Sprangletop' ,`StreetNumber` = '4318' ,`StreetSuffix` = 'Avenue' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1632' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEVER FLOODED! LOW TAX RATE! This 1 Story 3 Bedroom 2 Bath home has been immaculately kept! Perfect size yard for a pool and storage building. Some of its features are granite countertops in the kitchen, stylish tile back-splash, walk-in soaking tub with separate shower in the primary bathroom, walk-in closet, designer cabinets, crown molding, private utility room, and a private covered patio in the perfect sized backyard. Enjoy preparing meals in this impressive kitchen equipped with ample cabinets and generous counter space, the kitchen is an open concept with a breakfast bar/eat in kitchen with pantry. Don\'t wait! Make this beautiful home yours today.' ,`Acres` = '0.1309' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 109 BAY RIVER COLONY SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5700' ,`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` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'BANUELOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Right Side,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay River Colony Sec 1' ,`TaxAmount` = '5043' ,`TaxRate` = '2.705' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556991' WHERE `Matrix_Unique_ID` = '213943046' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T08:26:10.153' ,`MLSNumber` = '35962151' ,`ListAgentFullName` = 'Paul Hicks' ,`ListOfficeName` = 'Hicks and Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.112848' ,`Longitude` = '-95.623132' ,`PhotoCount` = '19' ,`PostalCode` = '77375' ,`RoomCount` = '7' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Spring' ,`StreetNumber` = '13518' ,`StreetSuffix` = 'Court' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1842' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming one story home in exclusive sub-division within walking distance of Tomball High School. Numerous upgrades recently completed, receipts in attachments. Gas log fireplace, split floorplan, huge walk-in closet in master. Open floorplan perfect for entertaining. Low taxes, no MUD. Cozy backyard with very low maintenance. Massive trees in front.' ,`Acres` = '0.1579' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 27 BLK 7 SPRING FOREST ESTATES SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6879' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '325' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TOMBALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Forest Estates' ,`TaxAmount` = '5043' ,`TaxRate` = '2.3717' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556991' WHERE `Matrix_Unique_ID` = '213969625' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T08:22:41.333' ,`MLSNumber` = '63559474' ,`ListAgentFullName` = 'Riaz Ahmed' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.037302' ,`Longitude` = '-95.523564' ,`PhotoCount` = '24' ,`PostalCode` = '77379' ,`RoomCount` = '9' ,`ListPrice` = '339000.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Masters' ,`StreetNumber` = '6710' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2380' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled in mature trees on a huge 20,429 sqft premium lot with lush landscaping making this home a real gem of Spring Creek Forest. The roof, siding, open floor plan, porcelain tiles (18x18 Kitchen & 12x24 in baths), 12 mm laminate floors, carpet, granite counter tops, and brand new bronze fixtures were all updated in 2018. The living room and master feature high vaulted ceilings. Kitchen is open concept with island and breakfast perfect for entertainment. Baths have double vanity, framed mirrors and shower tiles. You’ll have plenty of space for theater seating in your upstairs game room. Easy commute to The Woodlands, Tomball, Conroe & Cypress via Grand Parkway, Hwy 249, & I45. Premier shopping, dining & entertainment is a short driving distance! Klein ISD & private schools nearby. NO FLOODING.' ,`Acres` = '0.4689' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 17 017*S6353500-002-017-007 SPRING CREEK FOREST SEC' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '20425' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition,Wood Shingle' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'EHRHARDT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Creek Forest Sec 02' ,`TaxAmount` = '5608' ,`TaxRate` = '2.5315' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556991' WHERE `Matrix_Unique_ID` = '213973205' --> 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','213984832','1666556992','213984832','2022-10-23T08:39:44.607','89142027','Fariborz Shojai','F S Properties','','','29.750769','-95.488896','26','77057','6','899987.00','Active','Potomac','1632','Drive','Houston','4','1','4','4000','Single-Family','Potomac @ San Felipe, gated. Galleria area. Location. Location. Location. Open floor plan with custom finishes, custom cabinetry & hardwood floors throughout. First floor living with Study/Office. Gourmet Kitchen includes 48\" subzero Viking refrigerator, 48\'\' range, floor to ceiling cabinets, large island, walk-in pantry and mud room. All 4 Bedrooms located on the second floor. Spacious master BR, M Bath & M Closet. JELD-WEN: French doors & windows make this home very quiet & well insulated. Three (3) separate AC units (16 seer Trane) for each floor would reduce electricity consumptions. Breath taking 3rd floor with skyline view: Loft/ Game room, wet bar, full bath & rooftop make this stunning home great for living & entertaining. This beautiful home has it all: OFFICE, YARD, WET BAR, LOFT & ROOFTOP. Zoned to Briargrove elementary. Seller/Agent.','','22','','','','','Owner/Agent,Sellers Disclosure','','','1','Galleria','Central Gas','0','LT 4 BLK 1 POTOMAC GARDENS','Corner','','','','1200','0','','2','','0','','','','','Composition','27 - Houston','BRIARGROVE ELEMENTARY SCHOOL','WISDOM HIGH SCHOOL','TANGLEWOOD MIDDLE SCHOOL','Appointment Required','Builder','3','Other Style','Potomac Gardens Subdivision','','','Public Sewer','2016','Builder'); --> New record created successfully