Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T09:50:56.490' ,`MLSNumber` = '80203622' ,`ListAgentFullName` = 'Ellisa Carswell' ,`ListOfficeName` = 'Carswell Real Estate Co. Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.167125' ,`Longitude` = '-95.747521' ,`PhotoCount` = '48' ,`PostalCode` = '77355' ,`RoomCount` = '16' ,`ListPrice` = '9450000.00' ,`Status` = 'Active' ,`StreetName` = 'Windy Ridge' ,`StreetNumber` = '38262' ,`StreetSuffix` = 'Trail' ,`City` = 'Magnolia' ,`BathsFull` = '6' ,`BathsHalf` = '4' ,`BedsTotal` = '5' ,`SqFtTotal` = '14377' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spectacularly landscaped grounds surround this sprawling home in scenic Magnolia. Step through the arched double-door entry & into the grand 2-story foyer, w/twin wrought-iron staircases & custom chandeliers.This attention to detail carries through all 14,377 sf of the estate, from the gourmet kitchen with separate catering kitchen to the formal dining room.Treat guests to a wine tasting in the climate-controlled wine room before leading them to one of the 3 pools, including the tiered main pool with swim-up bar tucked into a cave. Indoor recreation can be found with the 2-story library & games room plus pub. Every inch of the 20+ac resort-like grounds is ready to enjoy thanks to landscaped lighting & golf cart paths. Practice your swing at the par 3 golf hole by the 2.5ac pond stocked w/bass for private fishing. This immaculate turnkey opportunity waits to welcome you home.' ,`Acres` = '20.581' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '4' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S579912 - HIGH MEADOW RANCH 12, BLOCK 1, LOT 12, 13, 14, ACR' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Waterfront,Wooded' ,`LotSize` = '896508' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '5' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'NICHOLS SAWMILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean,Traditional' ,`Subdivision` = 'High Meadow Ranch' ,`TaxAmount` = '70816' ,`TaxRate` = '2.1139' ,`WaterSewer` = 'Aerobic,Public Water,Well' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708160' WHERE `Matrix_Unique_ID` = '200736180' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T09:56:17.567' ,`MLSNumber` = '12174110' ,`ListAgentFullName` = 'Huy Phan' ,`ListOfficeName` = 'Ask Magis Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.706177' ,`Longitude` = '-95.523535' ,`PhotoCount` = '35' ,`PostalCode` = '77036' ,`RoomCount` = '11' ,`ListPrice` = '410000.00' ,`Status` = 'Active' ,`StreetName` = 'Hiawatha' ,`StreetNumber` = '7807' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3303' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this REMODELED 4 bedroom, 2 1/2 Bath with large 2 car detached garage. New roof 2022, new tile in bedroom area, new vinyl plank flooring in kitchen & sunroom, new tile backslash & granite countertops in kitchen and laundry room, new curtains in sunroom. Beautiful open floorplan with spacious living areas, including den, living room, formal dining room, breakfast, and bright sunroom is ideal for entertaining. Relaxing oversized yard close to 14,000 sqft. Great location with easy access to Beltway 8, High way 59 and Westpark Tollway. Closed to China town, Little Saigon, Hong Kong City Mall, Viet Hoa supermarket etc. Call today for your private tour!' ,`Acres` = '0.3214' ,`Area` = '21' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sharpstown Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 17 BLK 1 SHARPSTOWN COUNTRY CLUB EST 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'NEFF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHARPSTOWN HIGH SCHOOL' ,`SchoolMiddle` = 'SUGAR GROVE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sharpstown Cntry Club Estates Sec' ,`TaxAmount` = '8587' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708160' WHERE `Matrix_Unique_ID` = '206444353' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T08:22:49.333' ,`MLSNumber` = '43937501' ,`ListAgentFullName` = 'Wakika Newton' ,`ListOfficeName` = 'Posh Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.584046' ,`Longitude` = '-95.516905' ,`PhotoCount` = '18' ,`PostalCode` = '77489' ,`RoomCount` = '4' ,`ListPrice` = '270000.00' ,`Status` = 'Active' ,`StreetName` = 'Lost Quail' ,`StreetNumber` = '16715' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2694' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Back on the market with granite countertops in the kitchen and the wet bar in the living room. Upon entry, your new home boast both formals. You can walk into your renovated kitchen through the formals. New countertops, new stove, new dishwasher, freshly painted cabinets and a refrigerator is waiting on your first meal to be\r\ncooked. Leaving the kitchen, you will enter the large open living room with a wood burning\r\nfireplace and an entertainment bar.The primary room is downstairs. Upstairs holds the other two\r\nbedrooms and a large gameroom. The entire house has new flooring and new paint. The only thing\r\nthis house is missing is you. Call now to schedule your showing.' ,`Acres` = '0.1636' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'QUAIL RUN SEC 1, BLOCK 5, LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7128' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'EDGAR GLOVER JR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MARSHALL HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'MISSOURI CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Quail Run Sec 1' ,`TaxAmount` = '4559' ,`TaxRate` = '2.2137' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708160' WHERE `Matrix_Unique_ID` = '206482534' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T09:30:54.163' ,`MLSNumber` = '47188240' ,`ListAgentFullName` = 'Alicia Lansford' ,`ListOfficeName` = 'Markham Realty, Inc.' ,`SellingAgentFullName` = 'Stefani Maraldo' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '30.782536' ,`Longitude` = '-95.532773' ,`PhotoCount` = '34' ,`PostalCode` = '77320' ,`RoomCount` = '6' ,`ListPrice` = '465000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Allbritton' ,`StreetNumber` = '15' ,`StreetSuffix` = 'Road' ,`City` = 'Huntsville' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2021' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This truly exceptional property combines the best of rural living while still being close to the city! From the moment you enter this 3 bedroom, 2 bath ranch home, you will notice the tasteful upgrades, including new vinyl flooring, granite counters, barn doors, and exposed wood beams. The airy floor plan features flexible living spaces complete with a wood-burning fireplace and new Anderson windows. Enjoy your privacy overlooking your acreage (5.7 acres!) from your wooden deck nestled between mature shade trees. The remodeled detached garage features a separate bedroom with full bath and mini-split system - possibly an income producing rental with its\' separate entrance! Enjoy a prime location for acreage only minutes from Huntsville amenities. Sellers are motivated! Call today to schedule your showing.' ,`Acres` = '5.723' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'See Agent Remarks' ,`LotDesciption` = 'Cleared' ,`LotSize` = '249294' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven,Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'HUNTSVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Allbritton' ,`TaxAmount` = '3755' ,`TaxRate` = '1.6534' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708160' WHERE `Matrix_Unique_ID` = '207398155' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T08:05:59.463' ,`MLSNumber` = '34220664' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.195938' ,`Longitude` = '-95.421937' ,`PhotoCount` = '30' ,`PostalCode` = '77385' ,`RoomCount` = '8' ,`ListPrice` = '383789.00' ,`Status` = 'Active' ,`StreetName` = 'Bayou Oaks' ,`StreetNumber` = '10276' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1803' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 34220664 - Built by HistoryMaker Homes - Ready Now! ~ The exclusive, gated, Harper’s Preserve offers exemplary schools, resort-style amenities and is located just minutes away from world class dining, shopping, and entertainment. This charming Basswood plan, boasts exceptional curb appeal with its stone accented covered entry, 10\' ceilings throughout, an extended covered patio (the perfect spot for outdoor dining and your grill), and a box out window in the dining area. The home-chef will love the stainless-steel appliances, quartz counter tops, large island, 42 inch white cabinetry w/crown molding, and walk-in pantry. The primary bedroom suite offers dual vanities, a garden tub, separate shower, and TWO walk-in closets!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'HistoryMaker Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S572728 - HARPER\'S PRESERVE 28, BLOCK 4, LOT 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1127' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harper\'s Preserve' ,`TaxAmount` = '' ,`TaxRate` = '3.01' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663708160' WHERE `Matrix_Unique_ID` = '207735965' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T09:48:40.117' ,`MLSNumber` = '43573223' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'KB Home Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.842644' ,`Longitude` = '-95.811419' ,`PhotoCount` = '7' ,`PostalCode` = '77493' ,`RoomCount` = '8' ,`ListPrice` = '359995.00' ,`Status` = 'Active' ,`StreetName` = 'Lally Brook' ,`StreetNumber` = '4522' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2124' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**home is under construction.** This stunning KB Home in Katy Manor is what you’ve been looking for, boasting a brick front, wrought iron spindles, and an open great room. Try a new recipe in the kitchen, equipped with Silestone countertops, tile backsplash, stainless steel Energy Star® appliances, and 42-in. cabinets. Complete with extended dual vanities, a 42-in. Kohler Master Windward® tub, and a separate shower, the primary suite is the ideal place to unwind. Additional home features include faux wood blinds and a covered patio. Katy Manor boasts a splash pad, park, and playground. The community is located near I-10 and the Grand Parkway, giving residents easy access to the Energy Corridor. Enjoy dining, shopping, and entertainment at the nearby Katy Mills Mall and LaCenterra at Cinco Ranch. Zoned to the highly-acclaimed Katy ISD.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'KB Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 5 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '465' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Katy Manor' ,`TaxAmount` = '' ,`TaxRate` = '3.556' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663708161' WHERE `Matrix_Unique_ID` = '207837541' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T09:35:51.480' ,`MLSNumber` = '77748705' ,`ListAgentFullName` = 'Traci Crawford' ,`ListOfficeName` = 'Origen Realty' ,`SellingAgentFullName` = 'Robert Slott' ,`SellingOfficeName` = 'Emblem Properties' ,`Latitude` = '30.304052' ,`Longitude` = '-95.151313' ,`PhotoCount` = '47' ,`PostalCode` = '77328' ,`RoomCount` = '4' ,`ListPrice` = '850000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Fostoria' ,`StreetNumber` = '9667' ,`StreetSuffix` = 'Road' ,`City` = 'Cleveland' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3611' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This CUSTOM beauty is turn-key and ready for new owners! With 4.45 unrestricted acres, you are greeted with a beautiful circle driveway, grand foyer, and open to large formal dining room. Leading into the open-concept kitchen you will find all Viking appliances, and plenty of cabinet and counter space, eat-in kitchen, and living room around the fireplace. Primary bedroom offers entry to patio, sitting area, and oversized closet and en suite bathroom. The secondary bedrooms all have their own full bathrooms and built-in\'s in closets. Custom office/study offers beautiful hardwood shelves built in. The back porch is perfect for entertaining with an outdoor fireplace and kitchen sink. There is also a full bathroom outside and plenty of room for a pool! Large shop with additional parking and ready for all of the projects and toys! Call for a showing today!' ,`Acres` = '4.45' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'A0593 - WILLIAMS T J, TRACT 1A2-C, ACRES 4.45' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '193842' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'GREENLEAF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'WILLIAMS T J' ,`TaxAmount` = '10387' ,`TaxRate` = '2.0783' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708161' WHERE `Matrix_Unique_ID` = '208046684' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T08:58:30.550' ,`MLSNumber` = '22402645' ,`ListAgentFullName` = 'Kay Watson' ,`ListOfficeName` = 'eXp Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.855634' ,`Longitude` = '-98.419579' ,`PhotoCount` = '49' ,`PostalCode` = '78070' ,`RoomCount` = '6' ,`ListPrice` = '980000.00' ,`Status` = 'Active' ,`StreetName` = 'Fawn' ,`StreetNumber` = '211' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring Branch' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '5238' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Situated on almost 4 acres in the hill country, walking distance to the Guadalupe River, minutes from downtown San Antonio, Boerne, Canyon Lake and 1 hour from Fredericksburg, The primary home is 4102 S.F. and the fully equipped casita is 1136 S.F. and has its own private patio. Live in the casita while you update the main home, then upgrade the casita while enjoying your dream home modernized to your exact specifications. Priced with these needed upgrades in mind. The main house has 2 large master suites with patio access from each room. Visualize yourself entertaining beneath the soaring ceilings in the spacious kitchen and patio that runs along the entire back side of the home. Underneath the loft area there is a flex room, the home has huge closets and lots of storage. The casita is perfect for a mother-in-law suite, college student or extra income. This home was featured in the NY times and HGTV when it was built. Quiet convenient neighborhood with river access. Welcome home!' ,`Acres` = '3.689' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'GUADALUPE RIVER ESTATES, LOT 132, UNDIVIDED INTEREST 40.0000' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '160693' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '141 - Comal' ,`SchoolElementary` = 'ARLON SEAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SMITHSON VALLEY HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (COMAL)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Guadalupe River Estates' ,`TaxAmount` = '4610' ,`TaxRate` = '1.786' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708161' WHERE `Matrix_Unique_ID` = '208532976' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T09:47:44.177' ,`MLSNumber` = '28499260' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'KB Home Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.847031' ,`Longitude` = '-95.811363' ,`PhotoCount` = '6' ,`PostalCode` = '77493' ,`RoomCount` = '7' ,`ListPrice` = '299995.00' ,`Status` = 'Active' ,`StreetName` = 'Lally Brook' ,`StreetNumber` = '4527' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1234' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction** Escape the city to this beautiful KB Home on a spacious lot in Katy Manor, boasting a brick front and stone veneer, tile flooring, and open great room. Spend quality time in the kitchen, equipped with Silestone countertops, tile backsplash, stainless steel Energy Star® appliances, and 42-in. cabinets. Unwind in the tranquil primary suite, featuring extended dual vanities and a tub with a Moen Gibson® WaterSense Showerhead. Additional home features include faux wood blinds and a covered patio. The desirable community of Katy Manor South includes a splash pad, park, and playground. The community is conveniently situated near I-10 and the Grand Parkway, giving residents quick access to the Katy Mills Mall and the Energy Corridor. Schools are zoned to the highly-acclaimed Katy ISD.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'KB Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 14 Block 3' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '465' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Katy Manor' ,`TaxAmount` = '' ,`TaxRate` = '3.556' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663708161' WHERE `Matrix_Unique_ID` = '208984156' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T08:28:02.420' ,`MLSNumber` = '74261047' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.749283' ,`Longitude` = '-95.880158' ,`PhotoCount` = '39' ,`PostalCode` = '77494' ,`RoomCount` = '10' ,`ListPrice` = '655000.00' ,`Status` = 'Active' ,`StreetName` = 'Beech Tree' ,`StreetNumber` = '29507' ,`StreetSuffix` = 'Bend' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3670' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Glenmeade home has a brick and stone elevation with a beautiful front porch in Jordan Ranch. This Four Bedroom, 3 ½ Bath home has a two story Family Room, open design to the Kitchen and single Dining Room. The beautiful Kitchen features a large island, 2 pantries, stainless steel appliances, under-cabinet lighting and towering cabinets! The Owner\'s Retreat has vaulted ceilings, a soaker tub and a large shower. The home has a second Bedroom on the first floor with in-suite Bath, great for guests. Upstairs has two Bedrooms, and a Full Bath. Also upstairs, you can enjoy family night in the Retreat or the massive Media Room as well!  The home also features an amazing covered outdoor living space! All this on a quiet 70 foot North facing home-site with plenty of yard space! Check out our energy savings!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 09 Block 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Jordan Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663708161' WHERE `Matrix_Unique_ID` = '209323361' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T09:32:36.843' ,`MLSNumber` = '95997491' ,`ListAgentFullName` = 'Sherry Capps' ,`ListOfficeName` = 'Wyatt Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.391763' ,`Longitude` = '-94.898893' ,`PhotoCount` = '16' ,`PostalCode` = '77590' ,`RoomCount` = '7' ,`ListPrice` = '195000.00' ,`Status` = 'Active' ,`StreetName` = '7th' ,`StreetNumber` = '322' ,`StreetSuffix` = 'Avenue' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1316' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious 4 bedroom, 2 bath home, laminate flooring throughout, high ceilings, ceiling fans, central ac/heat, washer/dryer connections in inside utility room, beautiful cabinetry, soft close drawers. Plenty of closet space/storage, kitchen pantry. Hardi-plank siding, front porch, alley access.' ,`Acres` = '0.1435' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 205 LOTS 6 & 7 BLK 128 TEXAS CITY' ,`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` = '52 - Texas City' ,`SchoolElementary` = 'ROOSEVELT-WILSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TEXAS CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BLOCKER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Texas City' ,`TaxAmount` = '3468' ,`TaxRate` = '2.5335' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708161' WHERE `Matrix_Unique_ID` = '209372965' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T08:54:05.137' ,`MLSNumber` = '30045805' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.443513' ,`Longitude` = '-95.396903' ,`PhotoCount` = '30' ,`PostalCode` = '77578' ,`RoomCount` = '4' ,`ListPrice` = '529695.00' ,`Status` = 'Active' ,`StreetName` = 'Wright' ,`StreetNumber` = '9615' ,`StreetSuffix` = 'Drive' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2518' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 30045805 - Built by Highland Homes - December completion! ~ OVER-SIZED LAKE VIEW CUL-DE-SAC LOT WITH NO BACK NEIGHBORS IN OUR GATED SECTION! Tall ceilings and natural light welcome you into the home. Create memories in the dream kitchen, with a large quartz island that friends & family can gather around. Enjoy cooking with the built-in stainless steel appliances. Set up a home office in the study. Entertainment room is the perfect place to host a movie or game night! The SLIDING glass doors in the family room can be opened to host indoor/outdoor parties in your own backyard oasis with a serene lakeview! Open family and dining area makes this home feel grand. Primary suite includes luxurious FREESTANDING tub in the master bath and large walk-in closet! Full sprinkler system & smart home features included! On-site schools in the community. Walking distance to amenities- cafe, 24hr fitness center, resort style pool & more!!' ,`Acres` = '0.1792' ,`Area` = '5' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'MERIDIANA SEC 45 (A0282 & A0286) (MANVEL) BLK 1 LOT 21' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Water View' ,`LotSize` = '7804' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = '' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '' ,`TaxRate` = '3.63' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663708161' WHERE `Matrix_Unique_ID` = '209504749' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T08:30:29.950' ,`MLSNumber` = '75533511' ,`ListAgentFullName` = 'Claudia Buckalew' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.725426' ,`Longitude` = '-95.441106' ,`PhotoCount` = '14' ,`PostalCode` = '77005' ,`RoomCount` = '4' ,`ListPrice` = '765000.00' ,`Status` = 'Active' ,`StreetName` = 'Drake' ,`StreetNumber` = '3930' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1398' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cute traditional home on a huge corner lot and a huge back yard, and two patios; one in a private side area next to the kitchen, and the other outside of the back door. The home was remodeled inside in 2005 and has wood floors throughout, along with new appliances that will stay with the home. GREAT location, only minutes from The Houston Medical Center, Downtown, The Galleria and Rice University.\r\n\r\nPlease note the home is currently leased but the tenant will be relocating by the end of July. Please call with all with any questions.' ,`Acres` = '0.1938' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 34 BLK 7 MONTCLAIR' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8442' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Montclair' ,`TaxAmount` = '14683' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1952' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708162' WHERE `Matrix_Unique_ID` = '209922082' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T09:05:16.520' ,`MLSNumber` = '58663336' ,`ListAgentFullName` = 'Nicole Freer' ,`ListOfficeName` = 'NICOLE FREER GROUP' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.834436' ,`Longitude` = '-95.852913' ,`PhotoCount` = '17' ,`PostalCode` = '77493' ,`RoomCount` = '9' ,`ListPrice` = '489990.00' ,`Status` = 'Active' ,`StreetName` = 'Solana Point' ,`StreetNumber` = '158' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2751' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ASHTON WOODS NEW CONSTRUCTION - The Thames floorplan features 4 bedrooms, 3.5 baths home with a study, formal dining, game room, butler pantry, added extra storage in the valet area, and 2-car garage. The open Kitchen comes with 42\" white Cabinets, upgraded built-in whirlpool oven/microwave stack, built-in cooktop with hood, white Carrara Morro Quartz counter tops, Designer white brick tile backsplash, and SS Farmhouse Sink. Shaw Wood floors throughout all the common areas and 8-foot doors throughout the downstairs. The home also features upgraded iron balusters and wood tread stairs leading up to game room. The primary retreat is on the 1st floor with a bay window, large bathroom with dual vanities, large mud set shower, and soaking tub. Enjoy the relaxing backyard with a covered patio that includes gas outlet for those summer nights of grilling. This home is designed with Harmony Collection package. Days on market reflect the number of days the home has been under construction.' ,`Acres` = '0.1377' ,`Area` = '25' ,`BuilderName` = 'Ashton Woods' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Sunterra Section 3, Block 4, Lot 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.65' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663708162' WHERE `Matrix_Unique_ID` = '209955035' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T08:50:43.523' ,`MLSNumber` = '30822978' ,`ListAgentFullName` = 'Veronica Erebia' ,`ListOfficeName` = 'DLR Properties, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.680340' ,`Longitude` = '-95.349941' ,`PhotoCount` = '12' ,`PostalCode` = '77033' ,`RoomCount` = '5' ,`ListPrice` = '154000.00' ,`Status` = 'Active' ,`StreetName` = 'Calais' ,`StreetNumber` = '7327' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '987' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'House comes with transferable warranty for foundation and all new repiping.' ,`Acres` = '0.1273' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Tenant Occupied' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 7 BLK 8 SOUTH PARK SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5544' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KELSO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'South Park Sec 01' ,`TaxAmount` = '1630' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1947' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708162' WHERE `Matrix_Unique_ID` = '209987875' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T08:31:03.363' ,`MLSNumber` = '11952357' ,`ListAgentFullName` = 'DeAnna Delgado' ,`ListOfficeName` = 'Cross Capital Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.042066' ,`Longitude` = '-95.558393' ,`PhotoCount` = '50' ,`PostalCode` = '77379' ,`RoomCount` = '14' ,`ListPrice` = '1300000.00' ,`Status` = 'Active' ,`StreetName` = 'Florham Park' ,`StreetNumber` = '59' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '6092' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Extensively updated home on 1+acre in Gleannloch Farms Estates. Updates include Ruud HVAC system (2019),on-demand gas hot water heater(2021),gas pool heater(2020),full kitchen in-law suite w/full bath & separate entrance for privacy, recent outdoor kitchen w/new gas grill & countertop, built-ins shelving, built-in desk, complete 1st floor remodel w/professional chef\'s kitchen & new flooring. Kitchen includes gas & electric oven but also offers a huge fridge/freezer. Backyard features a resort-like pool w/ spa, a fire pit & 2 covered seating areas to enjoy gatherings. Mature landscaping & other features: 2 gas fireplaces, two 2 car garages & motorized drive gates for privacy. Zoned to TX Campuses of Distinction in excellent Klein ISD. Community features horse stables & fitness center, both a short walk from the home. Gleannloch offers baseball & soccer fields, sand volleyball, tennis courts, golf course, multiple playgrounds & pools, splashpad & fishing/boating ponds. MOVE-IN READY!' ,`Acres` = '1.017' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 2 THE ESTATES VILLAGES OF GLEANNLOCH FARMS 6' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '44301' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'HASSLER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Gleannloch Farms' ,`TaxAmount` = '18416' ,`TaxRate` = '2.0766' ,`WaterSewer` = 'Aerobic,Septic Tank,Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708162' WHERE `Matrix_Unique_ID` = '210012844' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T08:35:02.540' ,`MLSNumber` = '81247407' ,`ListAgentFullName` = 'Chelsea Boone' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.080858' ,`Longitude` = '-96.214296' ,`PhotoCount` = '23' ,`PostalCode` = '77871' ,`RoomCount` = '4' ,`ListPrice` = '199900.00' ,`Status` = 'Active' ,`StreetName` = 'Golfview' ,`StreetNumber` = '38' ,`StreetSuffix` = 'Drive' ,`City` = 'Hilltop Lakes' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BRING ALL OFFERS. Selling AS IS Hidden Gem located in the highly sought after Hilltop Lakes Golf Course Community! There are multiple lakes, horse stables, golf course, driving range, Pro Shop, Airstrip to land your plane, and a Texas Shaped Pool located in this community about 2 hours from Houston and an hour located from College Station! This home is very unique. On the first floor you with find a huge kitchen open to the living area that has a fireplace, two bedrooms (one primary) . The upstairs also has a full kitchen, primary bedroom and an additional bedroom. There\'s a sunroom also located upstairs! Both levels are identical! There is also a game room located upstairs above the garage with a pool table that will convey with the property! There is also a laundry room and half bath located in the garage area! There is also a separate garage for your golf cart! This home needs some updates but could be the one you\'ve been searching for! Contact me today for your private showing!' ,`Acres` = '0.2792' ,`Area` = '63' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Normangee/Marquez Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'HILLTOP LAKES SEC 3A BLK 4 LT 7' ,`LotDesciption` = 'Airpark,In Golf Course Community,On Golf Course' ,`LotSize` = '12164' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '131 - Normangee' ,`SchoolElementary` = 'NORMANGEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORMANGEE HIGH SCHOOL' ,`SchoolMiddle` = 'NORMANGEE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Hilltop Lakes Sec 3 A' ,`TaxAmount` = '4530' ,`TaxRate` = '1.8865' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708162' WHERE `Matrix_Unique_ID` = '210062979' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T08:16:46.090' ,`MLSNumber` = '80035864' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.800940' ,`Longitude` = '-95.849623' ,`PhotoCount` = '50' ,`PostalCode` = '77493' ,`RoomCount` = '8' ,`ListPrice` = '515000.00' ,`Status` = 'Active' ,`StreetName` = 'Precision' ,`StreetNumber` = '2306' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2691' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spectacular David Weekley Home in Cane Island with 2-story 4-bedroom, 3 ½ baths.  Enjoy visiting with your neighbors on the front porch. The interior boasts two story family room with a corner fireplace.  The open kitchen has a large island, lots of cabinets, cooktop, and wall oven.  Single dining room is adjacent to the kitchen.  Walk out to the outdoor living patio for family entertaining.  The Owner’s Retreat is spacious and has a super shower and walk-in closet.  Private study downstairs with French doors.  Upstairs has three bedrooms, two full baths, a large retreat area and overlooks the family room. 2-car garage with extra storage space.  Yard is large enough for a future pool. 2691 sq. ft.    Three year heating and cooling energy usage guarantee through Environments for Living Diamond.  KISD schools.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 02 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cane Island' ,`TaxAmount` = '' ,`TaxRate` = '3.45' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663708162' WHERE `Matrix_Unique_ID` = '210076814' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T09:55:02.140' ,`MLSNumber` = '26165042' ,`ListAgentFullName` = 'Misti Bruton' ,`ListOfficeName` = 'AVO Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.062764' ,`Longitude` = '-98.032051' ,`PhotoCount` = '40' ,`PostalCode` = '78619' ,`RoomCount` = '9' ,`ListPrice` = '549000.00' ,`Status` = 'Active' ,`StreetName` = 'Jennifer' ,`StreetNumber` = '600' ,`StreetSuffix` = 'Lane' ,`City` = 'Driftwood' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2128' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fully remodeled home with room to grow in Driftwood! Property sits on over 3 acres and has unlimited potential. Property is currently being used as a vacation rental with lots of thoughtful and functional upgrades. Great open floor plan and an additional living area that opens to the deck for that indoor-outdoor feel. Fresh paint, lots of natural light coming in, spacious kitchen and great size rooms. This property is perfect and have lots of room to grow as you can build more cabins. Just around the corner is the Rolling Oaks Club with a community swimming pool, clubhouse, volleyball court, and beautiful pond surrounded by large oak trees. Buyer to verify deed restrictions with the local county. Schedule your showing today!' ,`Acres` = '3.14' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ROLLING OAKS SEC 4, LOT 15, SERIAL # UNKN, TITLE # 941422315' ,`LotDesciption` = 'Other' ,`LotSize` = '145490' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '185' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '264 - Wimberley' ,`SchoolElementary` = 'JACOB\'S WELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WIMBERLEY HIGH SCHOOL' ,`SchoolMiddle` = 'DANFORTH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Rolling Oaks Sec 4' ,`TaxAmount` = '2531' ,`TaxRate` = '1.6909' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708162' WHERE `Matrix_Unique_ID` = '210160178' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T08:42:36.620' ,`MLSNumber` = '21499193' ,`ListAgentFullName` = 'Jessica Reyes' ,`ListOfficeName` = 'Jason Mitchell Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.608306' ,`Longitude` = '-95.267211' ,`PhotoCount` = '31' ,`PostalCode` = '77075' ,`RoomCount` = '3' ,`ListPrice` = '219000.00' ,`Status` = 'Active' ,`StreetName` = 'Springtime' ,`StreetNumber` = '8446' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1361' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This delightful 3-bedroom, 2-bathroom Traditional is a great starter home! Perfect for first time buyers. The interior includes a wood burning fireplace in the living room. The primary bedroom includes a walk-in closet, private bath with shower and a cozy office/reading area. Attached two-car garage. Backyard space is perfect for socializing. Your future self will thank you for acting fast on this one!' ,`Acres` = '0.1591' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 2B & 3B W 29 FT OF LT 2 & E 34 FT OF LT 3 BLK 28 GULF ME' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6930' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MITCHELL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gulf Meadows Sec 04' ,`TaxAmount` = '3479' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663708163' WHERE `Matrix_Unique_ID` = '210429199' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T09:46:55.490' ,`MLSNumber` = '23379319' ,`ListAgentFullName` = 'Anthony Jensen' ,`ListOfficeName` = 'ZAPP Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.257124' ,`Longitude` = '-94.866231' ,`PhotoCount` = '20' ,`PostalCode` = '77554' ,`RoomCount` = '3' ,`ListPrice` = '549900.00' ,`Status` = 'Active' ,`StreetName` = 'Izamal' ,`StreetNumber` = '2802' ,`StreetSuffix` = 'Court' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1856' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Constructed in 2022, this custom coastal charmer is situated in Campeche Shores, a beautiful community across the street from Moody Gardens\' Golf Course and Evia. This amazing home offers breathtaking views of the golf course and Sydnor Bayou. Once you enter the home, you are welcomed by an open-concept floor plan with vast 10\' ceilings, a spacious living room and dining room with white oak wood flooring, a custom kitchen with stainless steel appliances, custom vent hood and island, quartz countertops and marble mosaic backsplash. The second floor offers a walk-in laundry room, 2 spacious guest bedrooms and guest bathroom and a spa-like primary retreat with a grande bedroom with views of the golf course, rich bathroom with custom cabinetry, marble tiled floors, quartz countertops and subway tiled tub surround. The exterior offers 2 decks, a covered patio on the ground floor and an oversized 1 car garage. This home will not disappoint so come see it today!' ,`Acres` = '0.1156' ,`Area` = '33' ,`BuilderName` = 'Cactusland' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Near West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'IZAMAL COURT AT CAMPECHE SHORES REPLAT (2016) LOT 52A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5034' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '207' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Izamal Court At Campeche Shore' ,`TaxAmount` = '539' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663708163' WHERE `Matrix_Unique_ID` = '210476587' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T08:48:26.883' ,`MLSNumber` = '36380729' ,`ListAgentFullName` = 'Debora Donaldson' ,`ListOfficeName` = 'Keller Williams Realty Austin' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.175008' ,`Longitude` = '-98.077168' ,`PhotoCount` = '32' ,`PostalCode` = '78620' ,`RoomCount` = '6' ,`ListPrice` = '1450000.00' ,`Status` = 'Active' ,`StreetName` = 'Lloyd' ,`StreetNumber` = '460' ,`StreetSuffix` = 'Lane' ,`City` = 'Dripping Springs' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3452' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live at Butler Ranch Estates in Dripping Springs, TX. This beautiful 5 BR/3.5BA 3452 square foot home is perfectly located in the midst of an oak grove on 2.75 acres on a cul-de-sac a short distance from coveted DISD schools, The YMCA, HEB and Austin. When you walk through the front door you can feel the warmth of custom finishes and will love the expansive living/dining/kitchen area with 20 foot ceilings, massive quartz covered island and large windows overlooking the manicured oak trees beyond the covered/attached back porch. The well appointed Master Suite lends itself to privacy and merges beauty and functionality. Adjacent to the Living area is a flex space that is currently being used as a home office but could be used for formal dining. This home is in a great location in an awesome neighborhood with large lots and beautiful homes. We invite you to include this beautiful listing in your search for your next home!' ,`Acres` = '2.7533' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'COUNTS ESTATES PHASE TWO (AKA BUTLER RANCH), BLOCK B, Lot 3' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '119934' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '119 - Dripping Springs' ,`SchoolElementary` = 'WALNUT SPRINGS ELEMENTARY SCHOOL (DRIPPING SPRINGS)' ,`SchoolHigh` = 'DRIPPING SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'DRIPPING SPRINGS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Counts Estates Ph Two Aka Butler Ranch' ,`TaxAmount` = '12809' ,`TaxRate` = '1.9973' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708163' WHERE `Matrix_Unique_ID` = '210514672' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T08:41:49.540' ,`MLSNumber` = '60156280' ,`ListAgentFullName` = 'Michelle Percle' ,`ListOfficeName` = 'American Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.861390' ,`Longitude` = '-96.167563' ,`PhotoCount` = '16' ,`PostalCode` = '77465' ,`RoomCount` = '5' ,`ListPrice` = '420000.00' ,`Status` = 'Active' ,`StreetName` = 'Center Tree' ,`StreetNumber` = '132' ,`StreetSuffix` = 'Drive' ,`City` = 'Palacios' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2205' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '2.25' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'VAQUERO RIVER ESTATES, BLOCK 1, LOT 23, ACRES 2.25' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '98010' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '133 - Tidehaven' ,`SchoolElementary` = '' ,`SchoolHigh` = 'TIDEHAVEN HIGH SCHOOL' ,`SchoolMiddle` = 'TIDEHAVEN INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Vaquero River Estates' ,`TaxAmount` = '4168' ,`TaxRate` = '1.8384' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708163' WHERE `Matrix_Unique_ID` = '210547220' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T09:09:53.027' ,`MLSNumber` = '69723424' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Steven Kinne' ,`SellingOfficeName` = 'Compass RE Texas, LLC' ,`Latitude` = '29.852738' ,`Longitude` = '-95.742516' ,`PhotoCount` = '7' ,`PostalCode` = '77449' ,`RoomCount` = '3' ,`ListPrice` = '312490.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Flowering Garden Lane' ,`StreetNumber` = '21415' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1575' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FANTASTIC NEW D. R. HORTON BUILT 1 STORY 3 BEDROOM! Sought-After Split Plan Design with Private Primary Suite! Island Kitchen with Cabinetry Galore & Corner Walk-In Pantry - Opens to Spacious Breakfast Area & Living Room! Privately Located Primary Suite Features Spacious Walk-In Closet & Pretty Bath with Large Shower! Indoor Utility Room! Hard Surface Flooring in Living Area! Covered Patio Overlooks Backyard! Estimated Completion - September 2022.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 - Block 2 - Section 24' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`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` = 'GOLBOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'MCDONALD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jasmine Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663708163' WHERE `Matrix_Unique_ID` = '210771619' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T09:38:32.690' ,`MLSNumber` = '21065383' ,`ListAgentFullName` = 'Morgan Evans' ,`ListOfficeName` = 'RE/MAX Lake Livingston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.277713' ,`Longitude` = '-95.060852' ,`PhotoCount` = '15' ,`PostalCode` = '77327' ,`RoomCount` = '3' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 3378' ,`StreetNumber` = '455' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1848' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Country living close to town! Come see this fixer upper 3 Bed/2Bath manufactured home nestled on almost UNRESTRICTED 5 acres. Property features a large 1,100 square foot metal workshop/carport with guest quarters upstairs. Call Today to schedule your appointment. PROPERTY IS BEING SOLD AS IS.' ,`Acres` = '4.999' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'MACDONALD, LOT 40 41, TRACT 3, ACRES 4.999, MH LABEL# TRA026' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '217756' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'EASTSIDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Macdonald' ,`TaxAmount` = '3667' ,`TaxRate` = '1.8013' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708163' WHERE `Matrix_Unique_ID` = '210850461' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T09:03:49.893' ,`MLSNumber` = '17552208' ,`ListAgentFullName` = 'Cindy Cole' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.685021' ,`Longitude` = '-95.131406' ,`PhotoCount` = '19' ,`PostalCode` = '77536' ,`RoomCount` = '10' ,`ListPrice` = '259000.00' ,`Status` = 'Active' ,`StreetName` = 'Tyler' ,`StreetNumber` = '2705' ,`StreetSuffix` = 'Lane' ,`City` = 'Deer Park' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2125' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nice, well-established neighborhood in Deer Park. Well-maintained. Within walking distance to High School. Large enclosed patio. Master bath has been updated, plumbing updated with PEX, re-insulated attic & exterior walls, updated carpet in den. Office could possibly be used as 5th bedroom. Formal dining room. Kitchen has lots of cabinets.' ,`Acres` = '0.1641' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Deer Park' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 25 BLK 7 DEER MEADOWS SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'CARPENTER ELEMENTARY SCHOOL (DEER PARK)' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'BONNETTE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Deer Meadows Sec 03' ,`TaxAmount` = '6202' ,`TaxRate` = '2.8239' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708163' WHERE `Matrix_Unique_ID` = '210860953' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T08:41:32.897' ,`MLSNumber` = '36702699' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.209015' ,`Longitude` = '-95.330426' ,`PhotoCount` = '19' ,`PostalCode` = '77302' ,`RoomCount` = '9' ,`ListPrice` = '570692.00' ,`Status` = 'Active' ,`StreetName` = 'Golden Trails' ,`StreetNumber` = '15930' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2683' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 36702699 - Built by Highland Homes - November completion! ~ Gorgeous brand new Mclaren floorplan with soaring two-story ceilings in the family and dining rooms and an abundance of windows for plenty of natural light. Wood-look flooring throughout the main living areas, GE stainless steel appliances, white cabinets, and quartz countertops throughout! This home is also a smart home equipped with Eero wifi enhancers, Honeywell wifi thermostat, Rheem tankless water heater, wifi garage door opener, wifi Smartlock on front door, a Skybell doorbell camera, a full sprinkler system and much more!!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 60, Blk 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5813' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Artavia 45\'s' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663708164' WHERE `Matrix_Unique_ID` = '210911305' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T09:51:49.483' ,`MLSNumber` = '79054509' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.209630' ,`Longitude` = '-95.328957' ,`PhotoCount` = '13' ,`PostalCode` = '77302' ,`RoomCount` = '8' ,`ListPrice` = '573549.00' ,`Status` = 'Active' ,`StreetName` = 'Merigold Heights' ,`StreetNumber` = '17351' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 79054509 - Built by Highland Homes - November completion! ~ BRAND NEW FLOOR PLAN with beautiful sliding glass doors in the family room. 2nd bedroom down En Suite is perfect for guests. Private study located in the front. The heart of the homes features a spacious white kitchen open to the dining and family room. Dining room includes a built in hutch with glass upper shelves. Spacious primary retreat with bay window a relaxing free standing tub . Tankless hot water and Smart Home Technology Package Included!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = '38/1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5765' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Artavia 45\'s' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663708164' WHERE `Matrix_Unique_ID` = '210915507' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T08:59:44.400' ,`MLSNumber` = '78450260' ,`ListAgentFullName` = 'Nathan Kinser' ,`ListOfficeName` = 'NetWorth Realty of Houston, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.735423' ,`Longitude` = '-95.406576' ,`PhotoCount` = '37' ,`PostalCode` = '77098' ,`RoomCount` = '5' ,`ListPrice` = '660000.00' ,`Status` = 'Active' ,`StreetName` = 'Colquitt' ,`StreetNumber` = '1846' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3194' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautifully updated home includes two patios, 4 large bedrooms each with en-suit bath, a large game room, huge double pane windows for tons of natural light and plenty of space to entertain with a totally open concept kitchen, living and dining spaces. The kitchen features new custom back lit cabinetry, new hardware w/ soft close hinges, beautiful quartz counter tops, commercial style SS appliances, a large walk in pantry with custom frosted door, drink fridge and bar area, a large island with breakfast bar and custom tiled backlash from countertop to ceiling. The master bedroom is large with custom ceiling, room for a sitting area and stunning en suite bath. The bathroom features 2 sinks with separate counter space, a separate tub, custom tiled shower and a monster sized closet. The game room on the top level is huge and views from the patio amazing. There is simply to much to list here. Schedule your visit today.' ,`Acres` = '0.0366' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Montrose' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 1 COLQUITT STREET GARDENS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1595' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single 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` = 'Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal' ,`Stories` = '4' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Colquitt Street Gardens' ,`TaxAmount` = '14624' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708164' WHERE `Matrix_Unique_ID` = '210934195' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T09:19:24.560' ,`MLSNumber` = '90446314' ,`ListAgentFullName` = 'Vinh Dang' ,`ListOfficeName` = 'Central Metro Realty' ,`SellingAgentFullName` = 'Kleber Gonzalez' ,`SellingOfficeName` = 'R3 Yes! Real Estate, LLC' ,`Latitude` = '29.925423' ,`Longitude` = '-95.682810' ,`PhotoCount` = '50' ,`PostalCode` = '77095' ,`RoomCount` = '8' ,`ListPrice` = '319900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Prospect Meadows' ,`StreetNumber` = '17502' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1780' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rare find Waterfront Home in the heart of Cypress area across from TOWNE LAKE BOARDWALK. Zoned to top ranking schools. Easy access 290, 99, & I-10. Medical facilities, restaurants, gyms, retail shops, major grocery stores are within two miles radius. Community resort-style amenities with miles of waterfront walking trails and gorgeous parks. Beautiful remodeled kitchen with multiple lake views, abundance of natural light. Spacious backyard will fit a large pool looking out to lake, perfect for entertaining guests at a summer cookout. FLEX SPACE can be used for home office with lake view. Many upgrades done in December 2020, professional fresh paint, elegant Quartz countertop throughout home, new backsplash, brand new 16 SEER HVAC system, new dishwasher, contemporary light and plumbing fixtures, garage door opener with remote. NEVER FLOODED! Million Dollars Homes being built surrounding the area. Low tax rate.' ,`Acres` = '0.124' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 60 BLK 3 CANYON LAKES VILLAGE SEC 3 AMEND' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '5400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '940' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WOODARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'ARAGON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Canyon Lakes Village' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708164' WHERE `Matrix_Unique_ID` = '210937135' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T09:15:53.087' ,`MLSNumber` = '71131199' ,`ListAgentFullName` = 'Jocelyn Bradshaw' ,`ListOfficeName` = 'RE/MAX 5 Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.857167' ,`Longitude` = '-95.033898' ,`PhotoCount` = '38' ,`PostalCode` = '77532' ,`RoomCount` = '12' ,`ListPrice` = '699900.00' ,`Status` = 'Active' ,`StreetName` = 'Sralla' ,`StreetNumber` = '11703' ,`StreetSuffix` = 'Road' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '2248' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This fantastic property has it all! 12 acres of unrestricted surrounding landscape with several gated entry points. After passing through the gate, the long driveway ends, to the right, at a 50x100 commercial building with two 5-ton HVAC, two 12x12 roll-up electric garage doors, 1340 sqft of storage space, three RV carports, a barn; a one-bedroom garage apartment (needs TLC), and a 2,848 sqft home with a new roof and 2xHVAC to the left of the driveway. The home offers a formal living/dining room, kitchen with plenty of cabinet space, a family room with a fireplace, two oversized bedrooms, and two and a half baths. The primary bath has a huge tub, a walk-in shower, his and her sinks, and walk-in closets—lots of windows for tons of natural light. Also, as a bonus, there is a mudroom/laundry entrance at the side of the house. Outside the home, several cover patios are perfect for entertaining and so much more. Endless possibilities. Schedule your appointment today.' ,`Acres` = '12' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'PT TR 4 (HOMESITE) ABST 1640 G W BURKITT' ,`LotDesciption` = 'Cleared,Other' ,`LotSize` = '522720' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'DREW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Right Side,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'G W Burkitt Surv Abs 1640' ,`TaxAmount` = '7930' ,`TaxRate` = '2.0766' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1946' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708164' WHERE `Matrix_Unique_ID` = '210969754' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T08:24:10.967' ,`MLSNumber` = '33040202' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.978509' ,`Longitude` = '-95.740899' ,`PhotoCount` = '19' ,`PostalCode` = '77433' ,`RoomCount` = '7' ,`ListPrice` = '451990.00' ,`Status` = 'Active' ,`StreetName` = 'Via Casa Linda' ,`StreetNumber` = '20742' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2291' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION! LOCATION! LOCATION! The master plan community of Dunham pointe is the place to be. Immediate access to 290 & 99.\r\nDunham Pointe has arrived! This master planned community is perfectly situated near distinctive restaurants, local and national brands, select services, and curated retail to offer a rich and varied lifestyle. Inspired by Romanesque architecture, this stunning community celebrates the zest for life and is designed to create a close-knit community. David Weekly is introducing the Hillhaven plan. If you enjoy enjoy entertaining, look no further. In this Chef\'s Kitchen, guest will want to assist while comparing recipe ingredients on the over-sized island. This kitchen is for those who love to cook! With 12\' ceilings in the family room, natural light flows through ample windows. Inviting amenities like walking trails,clubhouse, pool and Cy-Fair I.S.D schools, will help neighbors become fast friends. Join us!!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 11 Block 01' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'AULT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Dunham Pointe' ,`TaxAmount` = '' ,`TaxRate` = '3.5' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663708164' WHERE `Matrix_Unique_ID` = '211060863' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T09:51:37.860' ,`MLSNumber` = '71660077' ,`ListAgentFullName` = 'Rick Dittemore' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.875742' ,`Longitude` = '-95.701874' ,`PhotoCount` = '17' ,`PostalCode` = '77449' ,`RoomCount` = '5' ,`ListPrice` = '269000.00' ,`Status` = 'Active' ,`StreetName` = 'Dillsbury' ,`StreetNumber` = '19219' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1455' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great starter home in a prime Katy location close to schools shopping and restaurants. This brick home boasts large rooms, an eat in kitchen, double sinks in both baths, spacious closets and a covered back patio. This home is great for entertaining family and friends. Hurry this one won\'t last!' ,`Acres` = '0.1313' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 66 BLK 1 STRATHMORE SEC 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5720' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'JOWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'KAHLA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Strathmore Sec 02' ,`TaxAmount` = '4706' ,`TaxRate` = '2.69' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663708164' WHERE `Matrix_Unique_ID` = '211132904' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T08:07:29.193' ,`MLSNumber` = '56007051' ,`ListAgentFullName` = 'Nan Feng' ,`ListOfficeName` = 'Annoura Realty Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.715237' ,`Longitude` = '-95.756724' ,`PhotoCount` = '50' ,`PostalCode` = '77450' ,`RoomCount` = '8' ,`ListPrice` = '639000.00' ,`Status` = 'Active' ,`StreetName` = 'Briar Landing' ,`StreetNumber` = '21519' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3779' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Sparkling Clean well maintained house in Grand Lakes. Never flooded! Great floor plan! Fresh paint throughout the whole house. Brand new floor and new carpet. High ceiling. Lost of natural light. Rare find 2 bedrooms down and 3 bedrooms up. Study with French door. Gourmet kitchen with granite counters. Tons of storage space! Don\'t forget check out the secret room behind the bookshelf upstairs. Steps away from the lake/trails!! Zoned to award winning Katy ISD schools including Seven Lakes HS! Great location! Close to all commuter routes, shopping & restaurants. Great schools! Neighborhood pools, tennis court and parks right near by. Great schools!!!Available now! Schedule your showing today!!!' ,`Acres` = '0.183' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND LAKES PHASE THREE SEC 6, BLOCK 2, LOT 32' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7972' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1090' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ALEXANDER ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'SEVEN LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'BECKENDORFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Lakes Ph Three Sec 6' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708165' WHERE `Matrix_Unique_ID` = '211204403' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T08:34:24.227' ,`MLSNumber` = '97353929' ,`ListAgentFullName` = 'Jessica Reyes' ,`ListOfficeName` = 'Jason Mitchell Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.495191' ,`Longitude` = '-95.770637' ,`PhotoCount` = '24' ,`PostalCode` = '77469' ,`RoomCount` = '3' ,`ListPrice` = '266000.00' ,`Status` = 'Active' ,`StreetName` = 'Atwood Preserve' ,`StreetNumber` = '6927' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1366' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This delightful 3-bedroom, 2-bathroom Traditional is a great starter home within the Richmond/Rosenberg area. Perfect for first time buyers! The home is easily driveable to shopping and restaurants. The primary bedroom includes a walk-in closet and private bath. Energy Efficient windows through out the home. Attached two-car garage. The inviting patio and large Texas size backyard is perfect for socializing. Your future self will thank you for acting fast on this one!' ,`Acres` = '0.181' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUNRISE MEADOW SEC 7, BLOCK 1, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7886' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '330' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MEYER ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunrise Meadow Sec 7' ,`TaxAmount` = '4815' ,`TaxRate` = '2.8148' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663708165' WHERE `Matrix_Unique_ID` = '211233318' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T08:06:37.947' ,`MLSNumber` = '72322281' ,`ListAgentFullName` = 'Katy Hall Wyly' ,`ListOfficeName` = 'Happen Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.770136' ,`Longitude` = '-95.375470' ,`PhotoCount` = '18' ,`PostalCode` = '77007' ,`RoomCount` = '6' ,`ListPrice` = '502900.00' ,`Status` = 'Active' ,`StreetName` = 'Dart' ,`StreetNumber` = '1724' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2418' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful free-standing patio home in the heart of the First Ward Arts District! This property offers a large rooftop terrace with unobstructed views of downtown. Private gated community and ample parking for guests. The first floor provides a secondary bedroom with walk-in closet and en-suite bathroom. This space would also make a great home office. On the second floor you will find a bright open concept space with hardwood flooring throughout. The kitchen includes a stainless steel appliance package, granite counters, and island with breakfast bar. The living room boasts a gas fireplace and its wrapped by large windows. The primary suite is privately tucked away on the third floor and includes a luxurious en-suite bath with jetted tub, separate walk-in shower, and ample counter space. Also on the second floor is an additional secondary bedroom with the own full bath.' ,`Acres` = '0.0341' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Washington East/Sabine' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 1 MERFISH SABINE DART' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1487' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1904' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Slate' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '4' ,`Style` = 'Traditional' ,`Subdivision` = 'Merfish Sabine Dart' ,`TaxAmount` = '10650' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708165' WHERE `Matrix_Unique_ID` = '211309693' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T08:46:41.133' ,`MLSNumber` = '36423996' ,`ListAgentFullName` = 'Hung Dang' ,`ListOfficeName` = 'The Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.642643' ,`Longitude` = '-95.378115' ,`PhotoCount` = '16' ,`PostalCode` = '77051' ,`RoomCount` = '2' ,`ListPrice` = '164999.00' ,`Status` = 'Active' ,`StreetName` = 'Akard' ,`StreetNumber` = '3110' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1100' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Updated residence!! Fresh paint inside and out, vinyl planking, and a carport. New shingles on the roof! New appliances! New water heater! ' ,`Acres` = '0.1389' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Wall Heater' ,`HOAMandatory` = '0' ,`Legal` = 'LT 11 BLK 10 SUGAR VALLEY' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'REYNOLDS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sugar Valley' ,`TaxAmount` = '1682' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708165' WHERE `Matrix_Unique_ID` = '211454625' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T09:24:55.167' ,`MLSNumber` = '68220184' ,`ListAgentFullName` = 'Dawei Ke' ,`ListOfficeName` = 'Glad Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.715915' ,`Longitude` = '-95.808793' ,`PhotoCount` = '38' ,`PostalCode` = '77494' ,`RoomCount` = '8' ,`ListPrice` = '359000.00' ,`Status` = 'Active' ,`StreetName` = 'Juniper Walk' ,`StreetNumber` = '5110' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2072' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 2 story property with 3 bedrooms and 2.5 bathrooms. High ceilings, Formal Dining, Family Room w/ Fire Place & Master w/ Jetted Garden Tub & Separate Shower & dual Vanities. Access to Cinco amenities & acclaimed KISD schools. Low tax rate! Great location - close to high way 99 &1093.' ,`Acres` = '0.146' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CINCO WEST AT SEVEN MEADOWS SEC 1, BLOCK 3, LOT 40' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6360' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'KILPATRICK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEVEN LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'BECKENDORFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cinco West At Seven Meadows Sec 1' ,`TaxAmount` = '5684' ,`TaxRate` = '2.3145' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708165' WHERE `Matrix_Unique_ID` = '211776801' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T09:19:11.673' ,`MLSNumber` = '30427796' ,`ListAgentFullName` = 'Kimberly Price' ,`ListOfficeName` = 'Coldwell Banker Southern Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.023638' ,`Longitude` = '-94.149797' ,`PhotoCount` = '16' ,`PostalCode` = '77705' ,`RoomCount` = '8' ,`ListPrice` = '284500.00' ,`Status` = 'Active' ,`StreetName` = 'Combs' ,`StreetNumber` = '5465' ,`StreetSuffix` = 'Drive' ,`City` = 'Beaumont' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ready to live the American dream? New construction with 3 bedrooms/game room or possible 4th bedroom. Entering the home, you will find an open living area with high ceilings & custom woodwork throughout. Custom cabinetry & quartz countertops in kitchen & bathrooms & so much more! Not only do you have the luxury of a new home, but it also offers a nice peaceful lot to relax & entertain. Make this one yours today!' ,`Acres` = '0.1784' ,`Area` = '51' ,`BuilderName` = 'CMP 3 Enterprises' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'KATY PLACE L4 B1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7770' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'BLANCHETTE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BEAUMONT UNITED HIGH SCHOOL' ,`SchoolMiddle` = 'VINCENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Katy Place' ,`TaxAmount` = '59' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663708165' WHERE `Matrix_Unique_ID` = '211778767' --> 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','211827007','1663708165','211827007','2022-09-08T09:52:43.553','65132819','Lance Loken','KB Home Houston','','','29.845056','-95.732559','6','77449','8','324995.00','Active','Filbert','20830','Lane','Katy','2','0','3','1631','Single-Family','**Home is under construction.** Enjoy every moment spent in this charming KB Home in The Meadows at Westfield, which boasts a beautiful brick front, extended entry, and an open great room. Prepare incredible feasts in the kitchen, complete with granite countertops, stainless steel Energy Star® appliances, and 30-in. cabinets. Unwind in the tranquil primary suite, featuring extended dual vanities, a 42-in. Kohler Master Windward® tub, and a separate shower. Community comforts include a park, playground, and covered pavilion. Located near Grand Parkway and I-10, the Meadows at Westfield gives residents easy access to shopping and dining at Grand Morton Town Center. Nearby schools are a part of the top-rated Cypress-Fairbanks ISD.','','25','KB Home','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Bear Creek South','Central Gas','1','Lot 6 Block 2','Subdivision Lot','','','','495','1','To Be Built/Under Construction','2','Single Oven','0','','','Freestanding Range,Gas Range','','Composition','13 - Cypress-Fairbanks','M ROBINSON ELEMENTARY SCHOOL','CYPRESS PARK HIGH SCHOOL','THORNTON MIDDLE SCHOOL (CY-FAIR)','Appointment Required','Builder','1','Traditional','The Meadows at Westfield Village','','2.821','Public Sewer,Public Water,Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','211844669','1663708165','211844669','2022-09-08T09:06:43.943','18071460','Ronnie Matthews','D.R. Horton Homes','','','30.232176','-95.242484','15','77357','3','253990.00','Active','Starry Night','21546','','New Caney','2','1','3','1412','Single-Family','FANTASTIC NEW D. R. HORTON BUILT HOME! Amazing 1 story plan!!! Great Open Concept Interior Layout! Lovely Foyer Opens Onto Gourmet Island Kitchen with Corner Walk-In Pantry, Light & Bright Breakfast Area, & Spacious Living Area! Privately Located Primary Suite Offers Great Bath with Large Shower & Walk-In Closet! Indoor Utility Room! Game Room!! Covered Patio Overlooks Wonderful Backyard! Incredible Community with Trails, Rec Center, SplashPad, Pool, AND Elementary School in Subdivision! WOW!','','40','DR Horton','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Cleveland Area','Central Gas','1','Lot 6/ Block 4/ Section 8','Subdivision Lot','','','','750','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','47 - Splendora','TIMBER LAKES ELEMENTARY SCHOOL','SPLENDORA HIGH SCHOOL','SPLENDORA JUNIOR HIGH','Appointment Required','Builder','1','Traditional','Harrington Trails','','','Water District','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T09:18:42.550' ,`MLSNumber` = '67285272' ,`ListAgentFullName` = 'Christie Torres' ,`ListOfficeName` = 'Nextgen Real Estate Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.788339' ,`Longitude` = '-95.351234' ,`PhotoCount` = '34' ,`PostalCode` = '77009' ,`RoomCount` = '10' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Elysian' ,`StreetNumber` = '3015' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2898' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this three story beauty!! Centrally located, easy access to major freeways. Minutes to downtown and all of H-town\'s city dining and local attractions. This home features a stunning kitchen with SS appliances, 10Ft ceiling, and hardwood floors throughout. Too many upgrades to list. Must come and see!!' ,`Acres` = '0.0574' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 ELYSIAN STREET LANDING' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MARTINEZ C ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Elysian Street Lndg' ,`TaxAmount` = '6327' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708165' WHERE `Matrix_Unique_ID` = '211893093' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T08:18:28.270' ,`MLSNumber` = '84490947' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.802535' ,`Longitude` = '-95.840431' ,`PhotoCount` = '50' ,`PostalCode` = '77493' ,`RoomCount` = '7' ,`ListPrice` = '505000.00' ,`Status` = 'Active' ,`StreetName` = 'Lambert' ,`StreetNumber` = '2319' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '3' ,`SqFtTotal` = '2781' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Hillhaven new home plan is crafted to improve your everyday lifestyle while featuring a glamorous atmosphere for social gatherings and special occasions. Your awe-inspiring Owner\'s Retreat provides a glamorous way to begin and end each day with a deluxe en-suite bathroom and walk-in closet. Let your imagination soar in the design freedom of the open concept floor plan. The epicurean kitchen includes a superb storage, meal prep and presentation experience. Your versatile study offers a unique place for you to create an ultimate specialty room. Each spare bedroom provides abundant personality and privacy. The large bonus room and additional half bath upstairs is the ultimate flex space for the perfect game room, media room second home office or exercise space. Extra garage storage, outdoor living and a fireplace check all the boxes on your list!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 08 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Cane Island' ,`TaxAmount` = '' ,`TaxRate` = '3.45' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663708166' WHERE `Matrix_Unique_ID` = '211935905' --> 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','211957719','1663708166','211957719','2022-09-08T08:50:26.223','39929929','Jennifer Hill','Connect Realty','','','30.151988','-95.408005','24','77385','4','315000.00','Active','Willow Creek','32114','Park','Conroe','2','0','3','1802','Single-Family','Beautiful, updated home located in Imperial Oaks Park is ready to be yours. The home has been freshly painted, new light fixtures added, and updated kitchen and bathrooms with granite countertops, painted cabiinets sinks/faucets. Two living spaces for extra entertaining. Easy access to major highways and highly acclaimed schools. You will not want to miss this amazing home. Call today for a private tour to see all this home and area has to offer your family.','0.1452','15','','','Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Wood Burning Fireplace','1','Spring Northeast','Central Gas','1','IMPERIAL OAKS PARK 05, BLOCK 4, LOT 3','Subdivision Lot','6325','Appraisal District','','500','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','KAUFMAN ELEMENTARY SCHOOL','OAK RIDGE HIGH SCHOOL','IRONS JUNIOR HIGH SCHOOL','Leave Business Card,Supra Keybox','Appraisal District','1','Traditional','Imperial Oaks Park 05','4632','2.4827','Water District','2002','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T09:27:55.967' ,`MLSNumber` = '18380510' ,`ListAgentFullName` = 'Michael Parker' ,`ListOfficeName` = 'Phyllis Foster Real Estate Ser' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.494945' ,`Longitude` = '-95.172673' ,`PhotoCount` = '39' ,`PostalCode` = '77546' ,`RoomCount` = '9' ,`ListPrice` = '594200.00' ,`Status` = 'Active' ,`StreetName` = 'Ivy Stone' ,`StreetNumber` = '2524' ,`StreetSuffix` = 'Lane' ,`City` = 'Friendswood' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3562' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come tour this 5 bedroom 3.5 bath home located on cul de sac lot adjoing large green space and park in West Ranch. The spacious study features double doors for ultimate privacy. The oversized dining room is great for entertaining Open concept kitchen with black granite counter tops and ample counter top and cabinet space. Kitchen opens to family room with large wall of windows over looking the backyard. Large primary suite with double sinks and large walk in closet. Upstairs there is a game room, and 4 spacious secondary bedrooms. The community pool is only a 2 minute walk. The master planned community of West Ranch offers two community pool and ample walking, biking, and hiking trails. Don\'t forget to check out the community lake which offers its own fishing pier and canoeing options. Do not miss this great opportunity!!!' ,`Acres` = '0.2077' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WEST RANCH SEC 1 (2007) ABST 9, BLOCK 3, LOT 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9047' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'CLINE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'West Ranch' ,`TaxAmount` = '11486' ,`TaxRate` = '2.6132' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708166' WHERE `Matrix_Unique_ID` = '211963494' --> 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','212005043','1663708166','212005043','2022-09-08T09:22:20.150','50117530','Salvador Caballero','ListWithFreedom.com','','','29.351399','-95.485182','22','77583','10','1678000.00','Active','Fm 1462','1519','','Rosharon','3','2','5','5200','Single-Family','WELCOME HOME! Just minutes south of the world\'s largest medical center. Where urban meets suburban. Amazing 5,200 Sq Ft. home on almost 30 acres of prime unrestricted Columbian hardwoods. Surrounded by 1000\'s of acres of pristine restricted ranchettes and large home sites. 5BDS; 4BTH; 2 1/2BTH. Master located upstairs. Built well above Hurricane Harvey flood levels. 1000\'s of feet of HWY frontage. Double down as event ctr/wedding venue. Observation/party decks. Outdoor kitchen w/ gas f.p. Chicken house. Swimming/fishing pond. 4,000 Sq Ft steel building w/ media room (a/c). NO HOA. Less than 30 mins to the states most popular beach. Wildlife galore! Gated entrance w/ privacy fence. Year-round walking trails. 10 acres cleared in back. Security cameras. Heated pool. Walk-in closet. (NO RESTRICTIONS. NO NEIGHBORS) THIS HOME IS A GREAT OPPURTUNITY!!','28','5','','','Gas Dryer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Rosharon','Central Electric,Central Gas,Propane','0','A0125 A ROBINSON BLOCK 21 TRACT 34A (MASTERSON SD TR 21) ACR','Other,Waterfront','383764','Appraisal District','','','0','','5','','1','In Ground','','','','Composition','5 - Angleton','FRONTIER ELEMENTARY SCHOOL','ANGLETON HIGH SCHOOL','ANGLETON MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Traditional','A Robinson','7199','1.986','Public Sewer,Public Water','2018','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212111723','1663708166','212111723','2022-09-08T09:59:03.207','56225898','Lance Loken','KB Home Houston','','','29.980388','-95.226467','6','77338','7','402030.00','Active','Soaring Legend','10727','Lane','Humble','2','0','3','2091','Single-Family','**Home is under construction** Find total comfort in this lovely KB Home in Estates of Tour 18, boasting a brick front, vinyl plank flooring, extended entry, and an open great room. Impress your guests in the kitchen, equipped with Silestone countertops, tile backsplash, stainless steel Energy Star® appliances, and 42-in. cabinets. Complete with extended dual vanities, a 42-in. Kohler Master Windward® tub, and a separate shower, the primary suite is ideal for relaxation. Additional home features include faux wood blinds and an extended covered patio. This beautiful golf course community is conveniently located near Hwy 59 and Beltway 8, giving residents easy access to Downtown Houston, The Woodlands, Lake Houston, and the George Bush Intercontinental Airport. Residents are mere minutes from dining and shopping at the Atascocita Commons and Deerbrook Mall. Zoned to the highly-rated Humble ISD.','','1','KB Home','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Humble Area East','Central Gas','1','Lot 8 Block 3','Subdivision Lot','','','','748','1','To Be Built/Under Construction','2','Single Oven','0','','','Freestanding Range,Gas Range','','Composition','29 - Humble','LAKELAND ELEMENTARY SCHOOL (HUMBLE)','HUMBLE HIGH SCHOOL','ROSS STERLING MIDDLE SCHOOL','Appointment Required','Builder','1','Traditional','Tour 18','','2.933','Public Sewer,Public Water,Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212112122','1663708166','212112122','2022-09-08T09:56:22.433','30095570','Lance Loken','KB Home Houston','','','29.946538','-95.183251','6','77044','8','302541.00','Active','Hanover Breeze','15706','Lane','Houston','2','0','3','1631','Single-Family','**Home is under construction.** Create unforgettable memories in this stunning KB Home in Lakewood Pines, boasting a brick front and stone veneer, tile flooring, extended entry, and an open great room. Try new cuisines in the kitchen, complete with granite countertops, stainless steel Energy Star® appliances, 42-in. cabinets, and pendant lighting. Seek comfort in the serene primary suite, featuring extended dual vanities, a 42-in. Kohler Master Windward® tub, and a separate shower. Additional home features include faux wood blinds and an extended covered patio. The desirable community of Lakewood Pines offers residents access to a pool, park, and recreation center. Commuters enjoy convenient access to the Houston Ship Channel and Generation Park via the Sam Houston Tollway. Nearby schools are zoned to the highly-rated Humble ISD.','','1','KB Home','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Summerwood/Lakeshore','Central Gas','1','Lot 2 Block 2','Subdivision Lot','','','','732','1','To Be Built/Under Construction','2','Single Oven','0','','','Freestanding Range,Gas Range','','Composition','29 - Humble','CENTENNIAL ELEMENTARY SCHOOL','SUMMER CREEK HIGH SCHOOL','AUTUMN RIDGE MIDDLE SCHOOL','Appointment Required','Builder','1','Traditional','Lakewood Pines','','3.454','Public Sewer,Public Water,Water District','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212182150','1663708166','212182150','2022-09-08T09:31:15.973','49135208','Kaye Kaye Smith','Legacy Real Estate Group','','','31.284748','-94.320002','33','75929','4','629900.00','Active','CR 3465','142','','Broaddus','3','5','4','3443','Single-Family','This WATERFRONT home offers it all! Amazing panoramic views, sandy beaches, plenty room for friends and love ones and lots of updates! Featuring a gorgeous kitchen, huge family room and a wonderful master suite with natural light throughout. So many updates were done in the kitchen and bathrooms with no expense spared! Retreat to enjoy outdoor living on the huge lakeside deck or upstairs balcony and let your hair down! Sits on 1 acre, has 2 carports, storage under the house, fairly new heat pump HVAC units, lots of new double pane windows, fresh paint throughout. Boat dock is included.','1','78','','','','','Sellers Disclosure','','','','','Heat Pump','0','TS 6-7 BLK 4 HARVEY\'S LAKEVIEW & IMPROVEMENTS','Waterfront','','','','','0','','0','','0','','','','','Aluminum','232 - Broaddus','BROADDUS ELEMENTARY SCHOOL','BROADDUS HIGH SCHOOL','BROADDUS HIGH SCHOOL','Appointment Required','Appraisal','2','Traditional','Harvey\'s Lakeview','','','Aerobic,Well','1998','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','212187968','1663708166','212187968','2022-09-08T08:23:27.053','29707190','Jordan Price','HomeSmart','','','29.297966','-94.784118','34','77550','4','589000.00','Active','Avenue M 1/2','1703','','Galveston','2','0','4','1544','Single-Family','THIS HOME IS A MUST SEE! Fully furnished and turnkey ready to continue as a vacation rental, a weekend getaway, or full time living. 4 Bed / 2 Full Baths; recently renovated and beautifully decorated. Central and IDEAL location. Gorgeous kitchen, soft close cabinets and quartz countertops. All bedrooms are large. Primary bedroom on first floor with an amazing oversized, elegant walk in shower. Detached garage, and additional off street parking in rear. Fully fenced back yard with an elevated deck—great outdoor space for entertaining. Just a 5 minute walk to the Seawall or a short drive to Pleasure Pier, the Strand, and UTMB. Currently used as a vacation rental with great occupancy. Please contact listing agent for schedule / available times to view the home. All showings must be scheduled around guest bookings.','0.0904','33','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','East End','Central Gas','0','ABST 628 M B MENARD SUR W 32-10 FT OF LOT 6 (3006-1) SE BLK','Subdivision Lot','3936','Appraisal District','','','0','','1','Gas Oven','0','','','Gas Range','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox','Appraisal District','2','Traditional,Victorian','Galveston Outlots','2837','2.0662','Public Sewer,Public Water','1950','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','212208530','1663708166','212208530','2022-09-08T09:01:36.283','43648866','Matthew Traylor','RE/MAX The Woodlands & Spring','','','30.364545','-95.621249','24','77316','4','135000.00','Active','Forrestal','16834','','Montgomery','1','0','1','330','Single-Family','**CHARMING TINY HOME NEAR LAKE CONROE**This adorable tiny home located in Lake Conroe Village is a perfect house for the minimalist while including extras and conveniences. This property is complete with a porch, oversized concrete driveway, spacious carport, cute landscaping including a small arbor and stone walk to the backyard gate. The backyard is fully fenced and provides a gazebo for morning or evening outdoor enjoyment. You enter into the bright Living/Kitchen/Dining room with a 10\" vaulted ceiling, soft gray and white color palette and an adorable Loft. The Kitchen boasts plenty of upper shelving storage, 2 pantry cabinets, a small refrigerator/freezer and RV size SS range w/oven. The Loft bed sits over the middle of the home; below is the Bath with shower & toilet. The main Bedroom is at the rear of the home which access to the backyard and the laundry room located in a separate exterior building. Just minutes from Lake Conroe, tons of restaurants and all needed amenities.','0.0482','39','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','0','','0','Lake Conroe Area','Other Heating','1','LAKE CONROE VILLAGE, BLOCK 11, LOT 58','Cleared,Subdivision Lot','2100','Appraisal District','','384','0','','0','Electric Oven,Freestanding Oven','0','','','Electric Cooktop,Electric Range,Freestanding Range','','Composition','37 - Montgomery','STEWART CREEK ELEMENTARY SCHOOL','LAKE CREEK HIGH SCHOOL','OAK HILL JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front','Seller','1','Other Style,Traditional','Lake Conroe Village','672','1.825','Public Sewer,Public Water','2018','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212229095','1663708166','212229095','2022-09-08T09:33:03.877','63761672','Frank Sitterle','Frank Sitterle, Broker','','','29.570018','-95.732247','7','77469','16','771117.00','Active','Pearl Glen','23110','Drive','Richmond','4','0','5','3346','Single-Family','Soon to be Move-in Ready, New Construction, 2 Story Home with 2 Bedrooms Down and Oversized 3 Car Garage on Corner Lot! Grand Entry with High Ceilings and Beautiful Wrought Iron Stair Parts. Island Kitchen with Overhang for Seating and Walk-in Pantry, is Open to the Great Room and Generous Breakfast Area. Fireplace at Great Room. Covered Rear Patio. Separate Vanities at Primary Bath with Expansive Walk-in Closet. Game Room at top of Staircase with Views of the Entry and Great Room Below. Jack and Jill Bath at Bedrooms 2 and 3. Extra Large Laundry Room. Wi-Fi Enabled, Built-in Home Intelligence System with Smart Thermostat, Lighting Control, and Smart Entry Door Lock.','0.3172','30','Sitterle Homes','','Electric Dryer Connections,Washer Connections','','Levee District,Mud,Special Addendum','1','Gaslog Fireplace','1','Fort Bend South/Richmond','Central Gas,Zoned','1','VERANDA SEC 12, BLOCK 2, LOT 10','Corner,Cul-De-Sac,Subdivision Lot','13818','Appraisal District','','1095','1','To Be Built/Under Construction','3','Electric Oven,Single Oven','0','','','Gas Cooktop','','Composition','33 - Lamar Consolidated','PHELAN ELEMENTARY SCHOOL','LAMAR CONSOLIDATED HIGH SCHOOL','WESSENDORF/LAMAR JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Controlled Access,No Supra Keybox','Builder','2','Contemporary/Modern,Traditional','Veranda Sec 12','1654','3.1798','Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212231476','1663708166','212231476','2022-09-08T09:17:56.090','53909348','Frank Sitterle','Frank Sitterle, Broker','','','29.568897','-95.730412','7','77469','10','627726.00','Active','Pearl Glen','22927','Drive','Richmond','3','1','3','2473','Single-Family','New Construction with Rear Water View! Custom Glass Doors Lead From the Great Room to the Covered Rear Patio And Will Allow You to Enjoy the Water View. Gas Connection at Covered Rear Patio. Double Coffered Ceiling at Entry with Wall of Windows. The Dining Room and Great Room Feature a High Cathedral Ceiling that is Open to the Island Kitchen. Gas Fireplace at Great Room. The Kitchen Features Cabinets to the Ceiling and a Gas Cooktop. Each Bedroom Boasts an En-Suite Bath and There is Also a Powder Room for Guests. Study at Rear. Primary Bedroom with Cathedral Ceiling, Generous Walk-in Closet, and Water View. Primary Bath with Skylight and Modern, Freestanding Tub. Tile Flooring is Planned for the Entry, Great Room, Dining, Study, Kitchen, Utility Room, All Bathrooms, and Hallways.','0.1548','30','Sitterle Homes','','Electric Dryer Connections,Washer Connections','','Levee District,Mud,Special Addendum','1','Gaslog Fireplace','1','Fort Bend South/Richmond','Central Gas','1','VERANDA SEC 8, BLOCK 1, LOT 9','Cleared,Patio Lot,Subdivision Lot,Water View','6744','Appraisal District','','1095','1','To Be Built/Under Construction','3','Electric Oven,Single Oven','0','','','Gas Cooktop','','Composition','33 - Lamar Consolidated','PHELAN ELEMENTARY SCHOOL','LAMAR CONSOLIDATED HIGH SCHOOL','WESSENDORF/LAMAR JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Controlled Access,No Supra Keybox','Builder','1','Contemporary/Modern,Traditional','Veranda Sec 8','1431','3.1798','Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212262890','1663708166','212262890','2022-09-08T08:47:10.787','75680084','Chip Bubela','Bubela & Associates, Inc','','','29.683030','-96.911145','30','78956','5','595000.00','Active','West','409','Avenue','Schulenburg','3','1','4','4999','Single-Family','OWN AN EXQUISITE PIECE OF SCHULENBURG HISTORY! \r\nFor the first time in its 115-year history, the fabulous “Merrem Mansion,” as it’s been known to locals for generations, is on the public market! Boasting three levels, with approximately 5000SF of living space, it’s located on 2 beautiful acres with stunning, mature trees. The uniqueness and grandeur of this home must be seen to be appreciated. The original rewired lighting fixtures are magnificent, as are the exceptional ceilings in the library, dining room, and formal entry. Original pulley windows in this home were all taken apart, reworked, reassembled, and replaced by the current owner. The entire house has been rewired, insulation blown in, original floors uncovered where needed, and style-appropriate shutters specially built and installed. Whether you’re looking for a fabulous home. A peaceful home located near the center of our lovely small town, this gem deserves a look!','1.9835','69','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Wood Burning Fireplace','2','','Central Electric','0','CITY OF SCHULENBURG (497) BLK 95 1.9834 180 X 480 = 86,400 S','Corner','86400','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Range','','Composition','207 - Schulenburg','SCHULENBURG ELEMENTARY SCHOOL','SCHULENBURG SECONDARY SCHOOL','SCHULENBURG SECONDARY SCHOOL','Appointment Required','Appraisal District','2','Other Style','City Of Schulenburg 497','8248','1.8323','Public Sewer,Public Water','1902','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','212279675','1663708166','212279675','2022-09-08T08:54:29.673','72371733','Joachim Vu','Lone Star Realty','','','29.451169','-95.814082','32','77469','6','975000.00','Active','Walters','5210','Road','Richmond','3','1','4','4919','Single-Family','One of a kind custom home tuck away in a nice and quiet neighborhood with just 2.0215 TAX RATE and minutes away to Interstate 59 and Hwy 36. This two story absolute gem is nestled on a huge 2.545 Acres lot - enough room to build In-Law suite with room to spare. The 20\' foyer ceiling greets you to an open concept floorplan highlighted by extensive soaring ceilings, family room with huge fireplace, Oversize gourmet kitchen, primary en-suite with large sitting area and bath, and media room. 1 month old premium Water Softener System. Appliances will also include refrigerator, and Washer/Dryer. Three car garage provides ample space for storage access. This luxury home is perfect for entertaining, and includes exquisite custom interiors that must be seen to truly appreciate. Country living but yet close to all amenities, shopping, restaurants, etc...','2.545','30','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','','Central Electric','0','0239 H AND TC RY, TRACT 9, ACRES 2.545, SECTION 69, RICHMOND','Subdivision Lot','110860','Appraisal District','','','0','','3','Electric Oven','0','','','Electric Range','','Composition','38 - Needville','NEEDVILLE ELEMENTARY SCHOOL','NEEDVILLE HIGH SCHOOL','NEEDVILLE JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','H & Tc Ry','12966','1.8957','Septic Tank,Well','2016','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','212289690','1663708166','212289690','2022-09-08T08:07:18.803','65286482','Justin Dickey','Keller Williams Professionals','','','29.436920','-95.438449','33','77583','5','392337.00','Active','Tioga View','1907','Drive','Rosharon','2','0','3','1830','Single-Family','Colina Homes- Single Story: Elegant entry with coffered tall ceilings, bedrooms, 2 baths, located in our gated section of Sierra Vista! Spacious master closet with his/her sinks and sep. tub and shower. Tons of Beautiful Finishes included!!Gorgeous kitchen with stunning cabinets, granite and tiled backslash , Perfect backyard and a Large covered back patio ready for weekend BBQ\'s. You\'re going to Love it! Situated in one of Rosharon\'s best communities. and offers everything your are looking in a family friendly community- amenities located in Sterling Lakes - the spashpad, fitness center, Basketball Court, Lakes & Parks. Crystal Lagoon coming soon! Close to Pearland, Alvin, Manvel, Lake Jackson, 30 minutes from Downtown Houston. SHOP AND WORK IN THE CITY AND COME HOME TO A QUIET PEACEFUL COMMUNITY @ SIERRA VISTA!','','5','Colina Homes','','Electric Dryer Connections','','No Disclosures','1','','','Alvin North','Central Gas','1','Lot 31 Block 3 Sec 7','Subdivision Lot','7920','Survey','','1100','1','To Be Built/Under Construction','2','','0','','','Freestanding Range,Gas Cooktop,Gas Range','','Composition','3 - Alvin','MERIDIANA ELEMENTARY SCHOOL','IOWA COLONY HIGH SCHOOL','CAFFEY JUNIOR HIGH SCHOOL','Accompany','Builder','1','Traditional','Sierra Vista West','','3.6','Public Sewer,Public Water,Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212289994','1663708166','212289994','2022-09-08T08:16:16.030','77256500','Ronnie Matthews','D.R. Horton Homes','','','29.832673','-95.855734','17','77493','4','413690.00','Active','Sunrise Gables','1565','','Katy','3','0','4','2060','Single-Family','AMAZING NEW CONSTRUCTION! Beautiful brick and stone exterior. 4 bedroom 3 full bath. High Ceilings, Luxury Hard Surface Flooring, Stainless Appliances with 5 Burner Cooktop, Dark Grey Quartz countertops, grey ceramic tile backsplash & 42\" White Kitchen Cabinetry with Under Cabinet Lighting, Primary Bath with Separate Tub & Shower, Tankless Water Heater, Oversized Covered Patio, & Full Sprinkler System! WOW! Open Concept Interior Design with Island Kitchen Open to Spacious Dining & Living Areas! Privately Located Primary Suite with Pretty Garden Bath & Walk-In Closet! Indoor Utility Room! Zoned to Katy ISD Schools! Unbelievable Community with Crystal Lagoon & Amenity Center with Clubhouse, Playground, Trails, Pool, PLUS MORE! Easy Access to the Grand Parkway! Estimated Completion - February 2023','','25','DR Horton','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Katy - Old Towne','Central Gas','1','17/1/15','Subdivision Lot','6668','Other','','1000','1','To Be Built/Under Construction','2','Single Oven','0','','','Gas Cooktop','','Composition','30 - Katy','ROBERTSON ELEMENTARY SCHOOL (KATY)','KATY HIGH SCHOOL','HASKETT JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Traditional','Sunterra','','','Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212290029','1663708166','212290029','2022-09-08T08:27:14.327','24171702','Justin Dickey','Keller Williams Professionals','','','29.437801','-95.434385','36','77583','10','411310.00','Active','Amador Peak','10635','Drive','Rosharon','3','0','4','2050','Single-Family','Colina Homes- Single Story: Elegant entry with coffered tall ceilings, 4 bedrooms, 3 baths location in our gated section of Sierra Vista! Spacious master closet with his/her sinks and sep. tub\r\nand shower. Tons of Beautiful Finishes included!!Gorgeous kitchen with stunning cabinets, granite\r\nand tiled backslash , Perfect backyard and a Large covered back patio ready for weekend BBQ\'s.\r\nYou\'re going to Love it! Situated in one of Rosharon\'s best communities. and offers everything your\r\nare looking in a family friendly community- amenities located in Sterling Lakes - the spashpad, fitness\r\ncenter, Basketball Court, Lakes & Parks. Crystal Lagoon coming soon! Close to Pearland, Alvin,\r\nManvel, Lake Jackson, 30 minutes from Downtown Houston. SHOP AND WORK IN THE CITY AND\r\nCOME HOME TO A QUIET PEACEFUL COMMUNITY @ SIERRA VISTA! PHOTOS ARE REPRESENTATIVE.','','5','Colina Homes','','Electric Dryer Connections','','No Disclosures','1','','','Alvin North','Central Gas','1','Lot 9 Block 1 Sec 7','Corner,Subdivision Lot','7800','Survey','','1100','1','To Be Built/Under Construction','3','','0','','','Freestanding Range,Gas Cooktop,Gas Range','','Composition','3 - Alvin','MERIDIANA ELEMENTARY SCHOOL','IOWA COLONY HIGH SCHOOL','CAFFEY JUNIOR HIGH SCHOOL','Accompany','Builder','1','Traditional','Sierra Vista West','','3.6','Public Sewer,Public Water,Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212290484','1663708166','212290484','2022-09-08T08:38:31.877','22784641','Ronnie Matthews','D.R. Horton Homes','','','30.238589','-95.707724','8','77354','4','302490.00','Active','Winter Grass Bend','40561','','Magnolia','2','0','4','1748','Single-Family','Exceptional Open Concept 4 bedroom 1 story home! Features Include Open Concept living w/large dining room open to family room & kitchen! Primary bathroom suite offers huge walk in closet! Features include 30\" Flat panel maple cabinets w/crown molding, exotic granite, 4 burner gas cooktop w/SS appliances, tile wall surrounds in bathrooms, smart home system, full sprinklers, front & back sod, fully front landscape, tankless water heater, LED lighting and more! Large covered patio overlooks the PRIVATE backyard with so much room for a pool! Mill Creek Offers 50\' wide lots! Call us today to schedule your showing!','','15','DR Horton/ EXPRESS','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Magnolia/1488 West','Central Gas','1','10/2/2','Subdivision Lot','','','','750','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','36 - Magnolia','MAGNOLIA PARKWAY ELEMENTARY SCHOOL','MAGNOLIA HIGH SCHOOL','BEAR BRANCH JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Traditional','Mill Creek','','','Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212292850','1663708166','212292850','2022-09-08T09:41:56.707','74169145','Anthony Jensen','ZAPP Realty','','','29.256608','-94.872680','18','77554','3','459900.00','Active','103rd','2531','Street','Galveston','2','0','3','1407','Single-Family','This newly constructed 3 bedroom, 2 bathroom home sits on about 1/3 of an acre in the newly developed Neumann addition. The neighborhood will consist of 17 beautiful homes that are located down the street from Moody Gardens\' Golf Course, Sugar Bean, Buffalo Grille and just a short drive to the beach. This coastal charmer offers 10\' ceilings, luxury vinyl plank flooring, shaker style cabinets with quartz countertops, a custom vent hood, stainless steel appliances, and a primary suite with a custom-tiled shower and walk-in closet. Enjoy the coastal views from 2 vast 8\' deep decks on the front and rear. Approximate completion date 12/15.','0.3788','33','Cactusland','','','','Owner/Agent','1','','','Near West End','Central Electric','0','LOT 18 BLK 1 NEUMANN ADDN RPLT NO 1 (2021) ABST 121','Subdivision Lot,Water View','16500','Appraisal District','','','1','To Be Built/Under Construction','1','','0','','','Electric Range','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Lockbox Front','Builder','1','Other Style','Neumann','503','2.0324','Public Sewer,Public Water','2022','Builder'); --> New record created successfully