Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T02:07:08.227' ,`MLSNumber` = '58760745' ,`ListAgentFullName` = 'Ishme Allah' ,`ListOfficeName` = 'Village Property Advisors' ,`SellingAgentFullName` = 'Ishme Allah' ,`SellingOfficeName` = 'Village Property Advisors' ,`Latitude` = '29.733592' ,`Longitude` = '-95.284223' ,`PhotoCount` = '8' ,`PostalCode` = '77012' ,`RoomCount` = '3' ,`ListPrice` = '85000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Avenue F' ,`StreetNumber` = '7816' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '854' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'INVESTOR SPECIAL! Your next flip project is ready for you to get started. This home is already gutted and has approved plans for a master suite addition in back of home.' ,`Acres` = '0.0574' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 32 BLK 33 MAGNOLIA PARK SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DE ZAVALA ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'MILBY HIGH SCHOOL' ,`SchoolMiddle` = 'EDISON MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Magnolia Park Sec 02' ,`TaxAmount` = '1592' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1938' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642248' WHERE `Matrix_Unique_ID` = '208422073' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T01:22:28.833' ,`MLSNumber` = '44034368' ,`ListAgentFullName` = 'Kimberly Harding' ,`ListOfficeName` = 'RE/MAX Synergy' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.549912' ,`Longitude` = '-95.034233' ,`PhotoCount` = '50' ,`PostalCode` = '77565' ,`RoomCount` = '8' ,`ListPrice` = '570000.00' ,`Status` = 'Active' ,`StreetName` = 'Narcissus' ,`StreetNumber` = '123' ,`StreetSuffix` = 'Road' ,`City` = 'Clear Lake Shores' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '2963' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come and see this one-of-a-kind gem Located right across from the water in Clear Lake Shores. Featuring exposed wood ceilings in the main living area, custom kitchen with stainless appliances, gas range and a large open concept dining and living area. Watch the boats go by from your beautiful sunroom. Enjoy winters by your wood burning fireplace in the in the den. Host guests on the first floor in their own private suite. Serve drinks in the custom built in bar and throw big parties in the large private pool and covered entertainment area. 4+ car deep garage and oversized driveway. Get in now to see this beauty in this highly sought-after golf cart community. Come and see this magical home today!' ,`Acres` = '0.1837' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Electric,Heat Pump' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 18 M MULDOON SUR LOTS 2201 THRU 2204 CLEAR LAKE SHORES' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '8000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`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` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Clear Lake Shores' ,`TaxAmount` = '9939' ,`TaxRate` = '1.8341' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1669642248' WHERE `Matrix_Unique_ID` = '208902223' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T01:22:28.833' ,`MLSNumber` = '16345534' ,`ListAgentFullName` = 'Bridget Moore' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.320027' ,`Longitude` = '-95.598980' ,`PhotoCount` = '35' ,`PostalCode` = '77316' ,`RoomCount` = '14' ,`ListPrice` = '354900.00' ,`Status` = 'Active' ,`StreetName` = 'Lakeshore' ,`StreetNumber` = '8840' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3004' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home has it all! Located on almost a HALF ACRE in Montgomery! 4 bedrooms and upgrades galore! Recent construction with no detail too small! From the moment you walk in, you\'ll feel at home. The home has been updated with the latest in modern living. With a formal dining room, family area, and private study, there\'s plenty of space for everyone to enjoy. Gourmet kitchen features a center island with with Quartz countertops and space saver power supplies, plus walk in pantry! Open to breakfast area with plenty of seating! Walking down the hallway, you\'ll pass two bedrooms before arriving at the primary room - featuring a grand bath with two shower heads and a huge garden tub. Plus, there\'s also a huge walk-in closet for all of your clothes and accessories. The large backyard offers a covered patio perfect for enjoy quiet evenings at home, and a shed perfect for extra storage. The lot next door is also available for sale! Prime location and zoned to Montgomery ISD!' ,`Acres` = '0.4559' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'FOREST LODGE SOUTH, LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '19860' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric 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` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Forest Lodge South' ,`TaxAmount` = '3294' ,`TaxRate` = '1.825' ,`WaterSewer` = 'Public Sewer,Public Water,Septic Tank' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642249' WHERE `Matrix_Unique_ID` = '210510554' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T01:22:28.833' ,`MLSNumber` = '21341797' ,`ListAgentFullName` = 'Trina Barcus' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.509486' ,`Longitude` = '-95.715134' ,`PhotoCount` = '40' ,`PostalCode` = '77469' ,`RoomCount` = '10' ,`ListPrice` = '735000.00' ,`Status` = 'Active' ,`StreetName` = 'Warm Coral' ,`StreetNumber` = '1607' ,`StreetSuffix` = 'Circle' ,`City` = 'Rosenberg' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3721' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'EXPERIENCE TRUE ELEGANCE & LUXURY of a WESTIN HOME Two story. 4 bedrooms, 3.5 baths. Primary suite with large SEPARATE SINKS, walk-in closets and private bath. Spacious island kitchen with breakfast area open to family room. Formal dining room and study. Spacious game room and media room upstairs 3 additional secondary bedrooms. Covered Patio and attached 3-car garage. This growing community is already a comfortable home to many who appreciate its state-of-the-art amenities and calming landscape. Outside Stone Creek Estates is the flourishing suburb of Rosenberg, Texas. Shopping is around the corner, there are multiple five-star restaurants, and most importantly is the access to the highly recognized Lamar Consolidated ISD. DON\'T MISS THIS INCREDIBLE OPPORTUNITY' ,`Acres` = '0.2526' ,`Area` = '30' ,`BuilderName` = 'WESTIN' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'STONECREEK ESTATES SEC 4, BLOCK 2, LOT 20' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '11003' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CARTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Stonecreek Estates' ,`TaxAmount` = '8949' ,`TaxRate` = '3.1948' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642249' WHERE `Matrix_Unique_ID` = '211179165' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T01:22:28.833' ,`MLSNumber` = '4600602' ,`ListAgentFullName` = 'Wanda Pink' ,`ListOfficeName` = 'Keller Williams Realty - Memor' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.654423' ,`Longitude` = '-95.838221' ,`PhotoCount` = '50' ,`PostalCode` = '77406' ,`RoomCount` = '7' ,`ListPrice` = '1750000.00' ,`Status` = 'Active' ,`StreetName` = 'LEANING OAK TRAIL' ,`StreetNumber` = '703' ,`StreetSuffix` = '' ,`City` = 'Richmond' ,`BathsFull` = '6' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5541' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEST BUILT LUXURY HOME KNOW AS FORT KNOX. CONCERT AND STEEL. LAKE VEIW PROPERTY ON ONE ACRE NESTLED IN THE COUNTRY IN PRIVATE NEIGHBORHOOD!' ,`Acres` = '1.0234' ,`Area` = '30' ,`BuilderName` = 'ACE LIFESTYLES LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WHISPERING OAKS, BLOCK 1, LOT 13' ,`LotDesciption` = 'Water View' ,`LotSize` = '44579' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Whispering Oaks' ,`TaxAmount` = '5796' ,`TaxRate` = '1.7948' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1669642249' WHERE `Matrix_Unique_ID` = '212666301' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T02:17:15.660' ,`MLSNumber` = '98285688' ,`ListAgentFullName` = 'Andrew Day' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = 'Jamie Rodriguez' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '30.019801' ,`Longitude` = '-95.153776' ,`PhotoCount` = '50' ,`PostalCode` = '77346' ,`RoomCount` = '9' ,`ListPrice` = '519000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Riverside Pines' ,`StreetNumber` = '20519' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2434' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated waterfront pool home with a brand new HVAC and fresh landscaping! This spacious 1 story home offers 4 bedrooms, TWO living spaces, formal dining room and large island kitchen. The upgraded kitchen boasts tons of storage, granite counter tops, newer stainless steel appliances (including beverage fridges!) and is open to the living space and cozy breakfast nook over looking the pool. The primary suite is large with beautiful bay windows facing the water, large walk in closet and a spacious shower and tub. Best of all there\'s NO carpet! Out back you will find no shortage of entertaining space with the custom deck, lagoon style pool and spa, sizable yard and boat house with jetski lift! Here you\'re just a short putter away from the open waters of Lake Houston.' ,`Acres` = '0.2231' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 37 BLK 1 ATASCOCITA SHORES SEC 6' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '9720' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '610' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'PINEFOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Atascocita Shores' ,`TaxAmount` = '9612' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642249' WHERE `Matrix_Unique_ID` = '213016875' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T01:22:28.833' ,`MLSNumber` = '16147344' ,`ListAgentFullName` = 'Yesenia Cavazos' ,`ListOfficeName` = 'Premier One Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.923087' ,`Longitude` = '-95.094139' ,`PhotoCount` = '34' ,`PostalCode` = '77532' ,`RoomCount` = '5' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Chart' ,`StreetNumber` = '1603' ,`StreetSuffix` = 'Drive' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1888' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ready for immediate move in, this charming home offers the opportunity for easy living in the popular Newport neighborhood, located on a quiet cul-de-sac, . Offers a generous, extended drive that will accommodate additional vehicles/golf carts. Newport is an established neighborhood that offers convenient access to Lake Houston, pools, area playgrounds, golf course, tennis courts, hike and bike trails. Make your appointment today to see this lovely property.IS VERY COZY TRADITIONAL HOUSE HAS 4 BEDROOMS 2 1/2 BATHROOMS A KITCHEN ROOM AND LARGE PATIO FOR YOU TO SPEND WITH FAMILY.' ,`Acres` = '0.3375' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 19 NEWPORT SEC 4' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '14700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'CROSBY ELEMENTARY SCHOOL (CROSBY)' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Newport Sec 04' ,`TaxAmount` = '4729' ,`TaxRate` = '2.7105' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642249' WHERE `Matrix_Unique_ID` = '213113809' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T01:22:28.833' ,`MLSNumber` = '92306922' ,`ListAgentFullName` = 'Monica Munoz' ,`ListOfficeName` = 'INNOVA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.666498' ,`Longitude` = '-95.103488' ,`PhotoCount` = '21' ,`PostalCode` = '77536' ,`RoomCount` = '13' ,`ListPrice` = '357900.00' ,`Status` = 'Active' ,`StreetName` = 'Meadow' ,`StreetNumber` = '4726' ,`StreetSuffix` = 'Drive' ,`City` = 'Deer Park' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2690' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Spacious home and ready to move in. Custom built staircase. Family room is open to kitchen and breakfast area. Arched entry ways. Large primary room with walk in closet and bathtub that is separate from shower. The house sits on a nice sized lot with no neighbors backing to property. The refrigerator, washer and dryer stay with the home! The home has energy efficient solar screens. House comes with one year of Warranty - Ultimate Plan.' ,`Acres` = '0.2261' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Deer Park' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 1 EAST MEADOW' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9849' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'COLLEGE PARK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LOMAX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'East Mdw Final' ,`TaxAmount` = '7732' ,`TaxRate` = '2.7308' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642250' WHERE `Matrix_Unique_ID` = '213587759' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T01:22:28.833' ,`MLSNumber` = '11947944' ,`ListAgentFullName` = 'Wendy Cline' ,`ListOfficeName` = 'Wendy Cline Properties Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.258383' ,`Longitude` = '-95.826877' ,`PhotoCount` = '41' ,`PostalCode` = '77363' ,`RoomCount` = '11' ,`ListPrice` = '520000.00' ,`Status` = 'Active' ,`StreetName` = 'Greenway' ,`StreetNumber` = '11089' ,`StreetSuffix` = 'Drive' ,`City` = 'Plantersville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2480' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful BRAND NEW CONSTRUCTION home tucked away on a 1 +/- Acre lot! The modern interior leaves the home a blank slate to make your own! The kitchen boasts tons cabinet space, stainless steel appliances, a granite center island with a breakfast bar, and an elegant tiled backsplash to tie it all together. The kitchenette and Living space feature large windows allowing for tons of natural light! The primary suite is a perfect place for relaxing and the ensuite bathroom offers a walk in shower, granite countertops, and double sinks! Outside, enjoy the scenic views from the 16x8 back porch with Slate Floor. The 2 car garage features speckled grey epoxy flooring. * Water service through Mill Creek * This home is a must see! Schedule your showing today! NO HOA, LOW TAXES & IN WALLER ISD!!!' ,`Acres` = '0.99' ,`Area` = '60' ,`BuilderName` = 'N/A' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Reports Available' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Plantersville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'MILL CREEK EST, SEC 2, BLOCK 16, LOT 29, ACRES .99' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '43124' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '129 - Navasota' ,`SchoolElementary` = 'HIGH POINT ELEMENTARY SCHOOL (Navasota)' ,`SchoolHigh` = 'NAVASOTA HIGH SCHOOL' ,`SchoolMiddle` = 'NAVASOTA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Mill Creek Est, Sec 2' ,`TaxAmount` = '852' ,`TaxRate` = '1.7749' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669642250' WHERE `Matrix_Unique_ID` = '214009441' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T01:22:28.833' ,`MLSNumber` = '68232561' ,`ListAgentFullName` = 'Wendy Cline' ,`ListOfficeName` = 'Wendy Cline Properties Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.258467' ,`Longitude` = '-95.826383' ,`PhotoCount` = '39' ,`PostalCode` = '77363' ,`RoomCount` = '11' ,`ListPrice` = '520000.00' ,`Status` = 'Active' ,`StreetName` = 'Greenway' ,`StreetNumber` = '11113' ,`StreetSuffix` = 'Drive' ,`City` = 'Plantersville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2480' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful BRAND NEW CONSTRUCTION home tucked away on a 1 +/- Acre lot! The modern interior leaves the home a blank slate to make your own! The kitchen boasts tons cabinet space, stainless steel appliances, a granite center island with a breakfast bar, and an elegant tiled backsplash to tie it all together. The kitchenette and Living space feature large windows allowing for tons of natural light! The primary suite is a perfect place for relaxing and the ensuite bathroom offers a walk in shower, granite countertops, and double sinks! Outside, enjoy the scenic views from the 16x8 back porch with Slate Floor. The 2 car garage features speckled grey epoxy flooring. * Water service through Mill Creek *This home is a must see! Schedule your showing today! LOW TAXES & IN WALLER ISD!!!' ,`Acres` = '0.99' ,`Area` = '60' ,`BuilderName` = 'N/A' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Reports Available' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Plantersville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'MILL CREEK EST, SEC 2, BLOCK 16, LOT 28, ACRES .99' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '43124' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '129 - Navasota' ,`SchoolElementary` = 'HIGH POINT ELEMENTARY SCHOOL (Navasota)' ,`SchoolHigh` = 'NAVASOTA HIGH SCHOOL' ,`SchoolMiddle` = 'NAVASOTA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mill Creek Est, Sec 2' ,`TaxAmount` = '852' ,`TaxRate` = '1.7749' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669642250' WHERE `Matrix_Unique_ID` = '214009602' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T01:22:28.833' ,`MLSNumber` = '74761706' ,`ListAgentFullName` = 'Tara Hall' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.956666' ,`Longitude` = '-95.592055' ,`PhotoCount` = '34' ,`PostalCode` = '77429' ,`RoomCount` = '9' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Mill Ridge' ,`StreetNumber` = '12530' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2316' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated 2-story on a huge corner lot in Mill Ridge is ready for new owners to love. This home is in the perfect location, just 1-block from the community pool & park & a short drive to highly acclaimed Cy-Fair schools. With decorator paint, LVP flooring & updated lighting & fans, this modified floorplan offers a study & a spacious family room w/a romantic fireplace, built-ins & lovely views of the yard. The family room opens to a fabulously updated kitchen & casual dining area w/an elegant chandelier & built-in seating. The kitchen features crisp white cabinetry w/glass-front uppers, butcher block countertops, tile backsplash, sleek SS appliances (recent oven & dishwasher) & a custom 11\' deep pantry w/full shelving. This home has 4 spacious bedrooms upstairs w/2 updated bathrooms. Garage shelving. Water heater approx. 1 yr old. Fenced backyard w/a patio, HUGE shade trees, raised garden beds, a garden shed, a gazebo & lots of grassy space for fun & games.' ,`Acres` = '0.2112' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLK 9 MILL RIDGE NORTH' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '525' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MILLSAP ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mill Ridge North' ,`TaxAmount` = '5067' ,`TaxRate` = '2.5362' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642250' WHERE `Matrix_Unique_ID` = '214123091' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T01:22:28.833' ,`MLSNumber` = '74740868' ,`ListAgentFullName` = 'Orrin Padgett' ,`ListOfficeName` = 'RE/MAX Synergy' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.481353' ,`Longitude` = '-95.114426' ,`PhotoCount` = '44' ,`PostalCode` = '77573' ,`RoomCount` = '6' ,`ListPrice` = '500000.00' ,`Status` = 'Active' ,`StreetName` = 'Navajo' ,`StreetNumber` = '2169' ,`StreetSuffix` = 'Pass' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3040' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Immaculate Former Model Home!! Located In The Popular Sedona neighborhood featuring An Open & Inviting Floorplan. Huge kitchen with an island, breakfast bar, walk in pantry and room for a large table; Recently Installed Heated swimming Pool, Updated Primary Bath with Double Sinks, Custom Shower and Enlarged closet! Spacious Primary Bedroom With Natural Light And Vaulted Ceilings. Large Family Room With Inviting Fireplace! Huge Formal Dining Room! A Large Study At The Entry That Could Be An Additional Bedroom With Closets. Huge Covered Patio To Relax, Entertain or Grill! In The Garage You\'ll Find A Ton Of Extra Storage and A Large Built Out Game Room Or Additional Living Space!! Walking Distance to the Elementary School, Local Daycare, Gym and Grocery! This Is Also A Golf Cart Friendly Neighborhood With Low TAXES, LOW HOA and zoned to CCISD! Main House is 2620 sqft, garage area is 420 sqft. Call Today for More Info' ,`Acres` = '0.23' ,`Area` = '33' ,`BuilderName` = 'Cervelle' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SEDONA (2009) ABST 3, BLOCK 2, LOT 10, ACRES 0.23' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10020' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BAUERSCHLAG ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'VICTORYLAKES INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sedona' ,`TaxAmount` = '8681' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642251' WHERE `Matrix_Unique_ID` = '214167667' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T01:22:28.833' ,`MLSNumber` = '20943555' ,`ListAgentFullName` = 'Jesse Glatz' ,`ListOfficeName` = 'TBT Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.060602' ,`Longitude` = '-95.417643' ,`PhotoCount` = '26' ,`PostalCode` = '77531' ,`RoomCount` = '9' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Moore' ,`StreetNumber` = '508' ,`StreetSuffix` = 'Street' ,`City` = 'Richwood' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2101' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exquisite taste & class are abundant in this former, high-end model home! Built just 4 short years ago, this home has all the bells & whistles you could ask for! Elegant solid wood front door, lush landscaping, lawn sprinkler system, spacious corner lot with fenced side & backyards and plenty of parking in the oversized driveway welcome you! Inside will leave you breathless with custom wall accents, wood-look tile, luxury carpet in bedrooms, expansive open floor plan, upgraded second bath, kitchen island addition, shiplap wall in master bedroom & serene master bath area with dual sinks, deep soaking tub & separate shower. Other upgrades include covered patio, oversized walk-in closet in master, alarm system, surround sound in living area, upgraded light fixtures, tile backsplashes, separate media room with ambient lighting & surround sound & media connections & more! No expense spared in this one! Schedule your private showing today & be the next lucky one to claim this home as YOURS!' ,`Acres` = '0.2288' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Richwood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CREEK BEND (A0066 J E GROCE) (RICHWOOD) BLK 1 LOT 12' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9967' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'POLK ELEMENTARY SCHOOL (BRAZOSPORT)' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CLUTE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Creek Bend A0066 J E Groce' ,`TaxAmount` = '7694' ,`TaxRate` = '2.6504' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642251' WHERE `Matrix_Unique_ID` = '214252725' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T01:22:28.833' ,`MLSNumber` = '921264' ,`ListAgentFullName` = 'Sonia Ponce' ,`ListOfficeName` = 'Houston Center Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.838132' ,`Longitude` = '-95.317698' ,`PhotoCount` = '11' ,`PostalCode` = '77016' ,`RoomCount` = '2' ,`ListPrice` = '102000.00' ,`Status` = 'Active' ,`StreetName` = 'Clarington' ,`StreetNumber` = '8606' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investment property for sale, rooms size approximate. Buyer and buyers agent to verify. Sqft is based on HCAD, please also verify. Seller does not have survey, buyer to purchase new if needed. No repairs will be done, SOLD AS IS. Please drive by, bookmark listing for open house notification.' ,`Acres` = '0.1804' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 79 BLK 1 WEDGEWOOD PLACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7860' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'COOK ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wedgewood Place' ,`TaxAmount` = '1119' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642251' WHERE `Matrix_Unique_ID` = '214394040' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T01:22:28.833' ,`MLSNumber` = '29293429' ,`ListAgentFullName` = 'Sonia Ponce' ,`ListOfficeName` = 'Houston Center Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.856634' ,`Longitude` = '-95.315761' ,`PhotoCount` = '10' ,`PostalCode` = '77016' ,`RoomCount` = '2' ,`ListPrice` = '152000.00' ,`Status` = 'Active' ,`StreetName` = 'Westbrook' ,`StreetNumber` = '5406' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1287' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'INVESTMENT PROPERTY on a large corner lot, rooms size approximate. Buyer and buyers agent to verify. Sqft is based on HCAD, please also verify. Seller does not have survey, buyer to purchase new if needed. SOLD AS IS. Please drive by, bookmark listing for open house notification.' ,`Acres` = '0.396' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 128 & 129 BLK 8 BRISTOL PLACE' ,`LotDesciption` = 'Corner' ,`LotSize` = '17250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHADYDALE ELEMENTARY' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bristol Place' ,`TaxAmount` = '2051' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642251' WHERE `Matrix_Unique_ID` = '214394467' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T01:22:28.833' ,`MLSNumber` = '22297151' ,`ListAgentFullName` = 'Sonia Ponce' ,`ListOfficeName` = 'Houston Center Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.814425' ,`Longitude` = '-95.331283' ,`PhotoCount` = '10' ,`PostalCode` = '77026' ,`RoomCount` = '2' ,`ListPrice` = '97000.00' ,`Status` = 'Active' ,`StreetName` = 'Linder' ,`StreetNumber` = '4009' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investment property for sale, rooms size approximate. Buyer and buyers agent to verify. Sqft is based on HCAD, please also verify. Seller does not have survey, buyer to purchase new if needed. No repairs will be done, SOLD AS IS. Please drive by, bookmark listing for open house notification.' ,`Acres` = '0.1435' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 68 BLK 4 WILSHIRE PLACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KASHMERE GARDENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wilshire Place' ,`TaxAmount` = '816' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1935' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642252' WHERE `Matrix_Unique_ID` = '214394672' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T01:22:28.833' ,`MLSNumber` = '27595530' ,`ListAgentFullName` = 'Sonia Ponce' ,`ListOfficeName` = 'Houston Center Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.817856' ,`Longitude` = '-95.331162' ,`PhotoCount` = '10' ,`PostalCode` = '77026' ,`RoomCount` = '2' ,`ListPrice` = '112000.00' ,`Status` = 'Active' ,`StreetName` = 'King' ,`StreetNumber` = '4014' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '860' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investment property for sale, rooms size approximate. Buyer and buyers agent to verify. Sqft is based on HCAD, please also verify. Seller does not have survey, buyer to purchase new if needed. No repairs will be done, SOLD AS IS. Please drive by, bookmark listing for open house notification.' ,`Acres` = '0.2009' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 264 BLK 10 WILSHIRE PLACE' ,`LotDesciption` = 'Other' ,`LotSize` = '8750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KASHMERE GARDENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wilshire Place' ,`TaxAmount` = '1235' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1938' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642252' WHERE `Matrix_Unique_ID` = '214394764' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T01:22:28.833' ,`MLSNumber` = '10466694' ,`ListAgentFullName` = 'Maria Aguirre' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.845326' ,`Longitude` = '-94.822235' ,`PhotoCount` = '25' ,`PostalCode` = '77523' ,`RoomCount` = '11' ,`ListPrice` = '609000.00' ,`Status` = 'Active' ,`StreetName` = 'Arlington Park' ,`StreetNumber` = '15115' ,`StreetSuffix` = 'Avenue' ,`City` = 'Mont Belvieu' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3535' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This GORGEOUS brick home, built in 2021 features a beautiful home design with inviting stone accents. This 4 BR, 3.5 Bath home with 2 car garage is a dream with spiral staircase, open layout, soaring ceilings and resides on a lake lot. The gourmet kitchen features beautiful cabinets, under cabinet lighting, farmhouse sink and quartz countertops. Cozy stone fireplace with cedar mantel and raised hearth in great family room. Choose to dine in the casual dining area or formal dining room. Convenient home office tucked off foyer. The primary bedroom suite has tray ceilings for a grand feel. Attached to it, is the en-suite luxury bathroom with elegant freestanding tub, separate shower, double sinks and spacious walk-in closet. Upstairs you\'ll find an activity room, three secondary bedrooms and 2 full baths. Grill outside under the covered patio while enjoying the relaxing lake front view. Featuring beautiful walking trails around lakes. Zoned to Barbers Hill ISD. Schedule your tour today!' ,`Acres` = '0.2677' ,`Area` = '53' ,`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` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 26 BK 2 LAKES OF CHAMPIONS ESTATES SECTION 3' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '11661' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '517' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`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' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes/Chamtions Estates Sec 3' ,`TaxAmount` = '10655' ,`TaxRate` = '2.1606' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1669642252' WHERE `Matrix_Unique_ID` = '214469590' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T01:22:28.833' ,`MLSNumber` = '18109679' ,`ListAgentFullName` = 'Edna Corona' ,`ListOfficeName` = 'Delcor International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.102639' ,`Longitude` = '-95.217548' ,`PhotoCount` = '26' ,`PostalCode` = '77365' ,`RoomCount` = '4' ,`ListPrice` = '189000.00' ,`Status` = 'Active' ,`StreetName` = 'Heritage Oak Dr' ,`StreetNumber` = '23969' ,`StreetSuffix` = '' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NO NEED TO LOOK FURTHER! THIS IS IT... THIS BEAUTIFUL HOME OFFER A SPLIT FLOOR PLAN WITH GOOD SIZE ROOM, SPACIOUS LIVING AREA WITH FIRE PLACE, DINNING ROOM, ISLAND KITCHEN, NEW A/C AND HEATING, NEW SEPTIC SYSTEM, COVER PARKING AND FANCED THROUGHOUT.' ,`Acres` = '0.2293' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'HERITAGE OAKS, BLOCK 4, LOT 14' ,`LotDesciption` = 'Corner' ,`LotSize` = '9988' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'PORTER ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'NEW CANEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Heritage Oaks' ,`TaxAmount` = '' ,`TaxRate` = '2.1331' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642252' WHERE `Matrix_Unique_ID` = '214488872' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T01:22:28.833' ,`MLSNumber` = '22700340' ,`ListAgentFullName` = 'Laura Ruple' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.528479' ,`Longitude` = '-95.168688' ,`PhotoCount` = '49' ,`PostalCode` = '77546' ,`RoomCount` = '6' ,`ListPrice` = '295900.00' ,`Status` = 'Active' ,`StreetName` = 'Lighthouse View' ,`StreetNumber` = '16923' ,`StreetSuffix` = 'Drive' ,`City` = 'Friendswood' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1860' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming home in a well established community, directly across from a community park with the fishing pond & trails! Pretty curb appeal welcomes you, with lush green grass, a large tree, and well cared for landscaping. Inside, you will discover soft neutral tones, high ceilings, arched doorways & a functional floorplan full of natural light. The chef in your family will love the large kitchen with tons of cabinet space, stainless steel appliances, a cozy breakfast nook, and an open view to the living room making hosting a breeze. The living room is generously sized, and showcases a beautiful fireplace you can curl up around! When it\'s time to relax, find solitude in 1 of the 3 sizeable bedrooms, including the primary suite that offers a large soaking tub. Step outside and onto a great open patio with a large tree for added shade. This community has tons to offer, including a park, pool, sports court, trails, and so much more! OPEN HOUSE 11/12 & 11/13. Showings start 11/12 at 11am.' ,`Acres` = '0.1326' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 4 HERITAGE PARK SEC 20' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5776' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '245' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'GREENE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'BROOKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Heritage Park Sec 20' ,`TaxAmount` = '5136' ,`TaxRate` = '2.166' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642252' WHERE `Matrix_Unique_ID` = '214490351' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T01:22:28.833' ,`MLSNumber` = '50994211' ,`ListAgentFullName` = 'Adriana Banks' ,`ListOfficeName` = 'Douglas Elliman Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.740188' ,`Longitude` = '-95.406355' ,`PhotoCount` = '40' ,`PostalCode` = '77098' ,`RoomCount` = '11' ,`ListPrice` = '1750000.00' ,`Status` = 'Active' ,`StreetName` = 'Kipling' ,`StreetNumber` = '1843' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3820' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Embrace timeless style and designer updates in this exceptional Montrose property featuring a stunning elevator-ready 4BD/3.5BA main house and a two-car garage with 418SF guest quarters. Built by Croix Custom Homes with numerous seller upgrades, the sophisticated home offers beautiful lighting, paint, wallcoverings and hardwood floors. A gorgeous office, formal living room and powder room flank the entry. Ahead, the elegant dining room and wet bar open to a chef\'s kitchen with stainless steel appliances. Relax alongside a fireplace in the family room and sunny breakfast room. Custom carpeted stairs lead to a media room with a balcony. A primary suite with a serene spa bath, a junior suite, two secondary beds with a Jack-and-Jill bath, and a laundry room complete the upper level. Outside, the flat yard is perfect for a pool. Long gated drive, porte-cochère. Deed-restricted neighborhood close to Trader Joe\'s, Whole Foods, Target, Westheimer amenities, Memorial Park, Downtown and more.' ,`Acres` = '' ,`Area` = '16' ,`BuilderName` = 'Croix Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Montrose' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 11 & 12A BLK 11 Winlow Place' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WOODROW WILSON MONTESSORI' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Winlow Place' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642253' WHERE `Matrix_Unique_ID` = '214606442' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T01:22:28.833' ,`MLSNumber` = '94426113' ,`ListAgentFullName` = 'Lindi Braddock' ,`ListOfficeName` = 'Coldwell Banker PropertiesUnlimited' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.153274' ,`Longitude` = '-96.398565' ,`PhotoCount` = '23' ,`PostalCode` = '77833' ,`RoomCount` = '8' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Chauncy' ,`StreetNumber` = '406' ,`StreetSuffix` = 'Street' ,`City` = 'Brenham' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1260' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This showplace home was built in 2021, outfitted with all new appliances & landscaping, designed and decorated to a tee and is ready for someone to call it “home”. Property is being offered TURN KEY, fully furnished and ready to move in, everything stays!\r\nBuilt by Arm River Builders, the floorplan showcases an open concept living/kitchen area, beautiful wood floors, lots of natural light and a paved fire pit area with string lights in the backyard. \r\nHome is currently active on Airbnb. Bookings blocked starting January 2023. Property is located just a short drive from Downtown Brenham!\r\nNotables include-\r\nExterior: sprinkler system, landscaping, fencing, fire pit area, sidewalks, electrical brought to exterior for outdoor lighting (approximately $16,950)\r\nInterior: All furniture, bedding, mattresses, sleeper sofa, TV, all kitchen items, towels, Washer and Dryer, Refrigerator, porch furniture, outdoor furniture plus fire pit, vacuum, keyless entry etc. (approximately $14,500)' ,`Acres` = '0.2313' ,`Area` = '58' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WILKINS, W. G. , BLOCK 26, LOT PT 3B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10075' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '137 - Brenham' ,`SchoolElementary` = 'BISD DRAW' ,`SchoolHigh` = 'BRENHAM HIGH SCHOOL' ,`SchoolMiddle` = 'BRENHAM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wilkins W G' ,`TaxAmount` = '4441' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642253' WHERE `Matrix_Unique_ID` = '214782837' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T01:22:28.833' ,`MLSNumber` = '82304892' ,`ListAgentFullName` = 'Lindi Braddock' ,`ListOfficeName` = 'Coldwell Banker PropertiesUnlimited' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.143959' ,`Longitude` = '-96.394541' ,`PhotoCount` = '21' ,`PostalCode` = '77833' ,`RoomCount` = '8' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Airline' ,`StreetNumber` = '2420' ,`StreetSuffix` = 'Drive' ,`City` = 'Brenham' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1260' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This showplace home was built in 2022, outfitted with all new appliances & landscaping, designed and decorated to a tee. Property is being offered TURN KEY, fully furnished and ready to move in, everything stays!\r\nBuilt by Arm River Builders, the floorplan showcases an open concept living/kitchen area, beautiful wood floors and lots of natural light with a paved patio area in the backyard.\r\nHome is currently active on Airbnb. Bookings blocked starting January 2023. Property is located just a short drive from Downtown Brenham and countless local places to eat, drink, shop and relax!\r\nNotables Include-\r\nExterior: sprinkler systems, landscaping, fenced area, fire pit, sidewalks (All totaling to approximately $11,000)\r\nInterior: All furniture, bedding, mattresses, TV, all kitchen items including dishes, pots and pans etc, towels, Washer and Dryer, Refrigerator, porch furniture, outdoor furniture plus fire pit, vacuum, keyless entry etc. (All totaling to approximately $14,500)' ,`Acres` = '0.2307' ,`Area` = '58' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SOUTH PARK SEC I , BLOCK A, LOT 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '137 - Brenham' ,`SchoolElementary` = 'BISD DRAW' ,`SchoolHigh` = 'BRENHAM HIGH SCHOOL' ,`SchoolMiddle` = 'BRENHAM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'South Park Sec I' ,`TaxAmount` = '1003' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642253' WHERE `Matrix_Unique_ID` = '214783465' --> 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','214985914','1669642253','214985914','2022-11-25T02:26:31.267','15084154','Edie Apiscopa','Venture Realty, LLC','','','29.405694','-95.246871','12','77511','10','289000.00','Active','Meadowview','1817','Drive','Alvin','2','0','4','1846','Single-Family','Traveler\'s delight! This home is set up for those who love to vacation from home or on the road. After a long trip you can park your RV in its very own spot or use the plugin for a generator. This ranch style home boasts a beautiful kitchen with soft close drawers and cabinets adjacent to a perfect sized dining area. It comes with 2 refrigerators, 1 in the kitchen and 1 in the wet bar. This floor plan allows for its next owners to make it their own it is set up and ready for a split unit for any addition you make the the home. Most importantly after a long hard hot day take a dip in the private swimming pool. The patio and decking welcome visitors to entertain. This home was made to enjoy the company of others. There are new storm windows, a water filtration system and 2 storage sheds to boot! Being set in Alvin Texas you are not far from local vacation spots!','0.2653','5','','','Electric Dryer Connections','','No Disclosures,Sellers Disclosure','1','','','Alvin South','Central Gas','0','GLENNVIEW (ALVIN) BLK 3 LOT 14 - LOT 15 (E/2)','Subdivision Lot','11556','Appraisal District','','','0','','2','Electric Oven','1','In Ground','','Electric Cooktop','','Composition','3 - Alvin','ALVIN ELEMENTARY SCHOOL','ALVIN HIGH SCHOOL','ALVIN JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Ranch','Glennview Alvin','5908','2.8854','Public Sewer,Public Water','1961','Appraisal District'); --> New record created successfully