Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T08:31:59.400' ,`MLSNumber` = '57881536' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.169131' ,`Longitude` = '-95.633666' ,`PhotoCount` = '25' ,`PostalCode` = '77486' ,`RoomCount` = '9' ,`ListPrice` = '357000.00' ,`Status` = 'Active' ,`StreetName` = 'Green Meadows' ,`StreetNumber` = '427' ,`StreetSuffix` = 'Drive' ,`City` = 'West Columbia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2513' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 57881536 Built by CastleRock. HOME UNDER CONSTRUCTION! Trinity Plan (C-Elevation) 2-Story 4 BD 2.5 BA 3 Car Garage 2,513 sq ft! High Ceilings! Open Concept! Impressive Interior Upgrades! Modern White 42\" Kitchen Cabinets w/ Quartz Counters! Stainless steel finish appliances exude refinement and elegance! Inviting Owner\'s Suite! Soaker Tub & Separate Shower! 2\'\' Faux blinds! Wall of windows! Energy-Efficient! HERS Rated! No Flooding! Tankless Water Heater! Low Tax Rate - 2.186 before homestead! Offers a golf course family-friendly gated community, Easy Commute to Hwy 288, Exciting Pearland Town Center, Houston, Bay City, Sweeny & Lake Jackson! Experience the breathtaking sandy beach views just 30 mins away! CastleRock offers new homes in various stages of construction for those who are looking for spacious 1 & 2-story layouts and Quick Move-In options. Nestled in Natural Splendor Enjoy Country Living in Columbia Lakes! Best kept secret south of Houston! Schedule a tour today!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 79, Block 31, Section 3' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '9375' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Columbia Lakes' ,`TaxAmount` = '' ,`TaxRate` = '2.186' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669040734' WHERE `Matrix_Unique_ID` = '206831844' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T08:15:11.450' ,`MLSNumber` = '98587672' ,`ListAgentFullName` = 'Lizabeth Comiskey' ,`ListOfficeName` = 'Comiskey Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.297390' ,`Longitude` = '-94.928295' ,`PhotoCount` = '50' ,`PostalCode` = '77554' ,`RoomCount` = '7' ,`ListPrice` = '1250000.00' ,`Status` = 'Active' ,`StreetName` = 'Isles End' ,`StreetNumber` = '103' ,`StreetSuffix` = 'Road' ,`City` = 'Tiki Island' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '3' ,`SqFtTotal` = '2434' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOSTLY FURNISHED --BEAUTIFUL BAY FRONT HOME WITH PRIVATE POOL\r\nHome has the \"WOW\" Factor!\r\nThe kitchen and Family Room is wide open and ideal for entertaining with incredible views of Inter-coastal and Deer Island.\r\nTwo Primary\'s and Two Office Nooks!\r\nYou will love the pool entertainment area\r\nTenant occupied at moment for 4300.00, can be assumed of term' ,`Acres` = '0.122' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tiki Island' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 7 S C BUNDICK SUR LOT 27 TIKI ISLAND SEC 11' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '5314' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '160' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '26 - Hitchcock' ,`SchoolElementary` = 'HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HITCHCOCK HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (HITCHCOCK)' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Other Style' ,`Subdivision` = 'Tiki Island' ,`TaxAmount` = '16127' ,`TaxRate` = '2.2119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040734' WHERE `Matrix_Unique_ID` = '207730961' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T07:20:35.310' ,`MLSNumber` = '29698144' ,`ListAgentFullName` = 'Catherine Borel' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.963287' ,`Longitude` = '-94.029197' ,`PhotoCount` = '28' ,`PostalCode` = '77705' ,`RoomCount` = '7' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Kilarney' ,`StreetNumber` = '8013' ,`StreetSuffix` = 'Drive' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3481' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Never Flooded! Rare opportunity to own a home with a garage apartment combo and a workshop situated on approximately one acre of land outside the city limits in the Nederland School District! This beautiful log home has 3481 sq ft (measured by an appraiser) of living space, a wrap-around covered porch with a circle driveway, and mature trees throughout the property. This lovely home has a large living room with soaring ceilings and a fireplace. The rooms are spacious, including the kitchen with a large work island, breakfast bar, double oven, and many cabinets! The mudroom/pantry/laundry room combo has a half bath for added convenience. The upstairs loft is full of built-in cabinets and workspace. This home will be a showplace with a few personal touches.' ,`Acres` = '1.15' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 80 81 SHAMROCK ACRES' ,`LotDesciption` = 'Cleared' ,`LotSize` = '50094' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '152 - Nederland' ,`SchoolElementary` = 'HELENA PARK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEDERLAND HIGH SCHOOL' ,`SchoolMiddle` = 'WILSON MIDDLE SCHOOL (NEDERLAND)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1.5' ,`Style` = 'Other Style' ,`Subdivision` = 'Shamrock Acres' ,`TaxAmount` = '5454' ,`TaxRate` = '1.9347' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040735' WHERE `Matrix_Unique_ID` = '208709658' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T07:57:01.540' ,`MLSNumber` = '77179062' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = 'Bryan Clark' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.701834' ,`Longitude` = '-95.706431' ,`PhotoCount` = '23' ,`PostalCode` = '77407' ,`RoomCount` = '11' ,`ListPrice` = '369990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Telford Hollow' ,`StreetNumber` = '6806' ,`StreetSuffix` = 'Trail' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1778' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One Story Home The Gaven Plan by D.R. Horton! Under Construction! Ultra Modern & Chic Elevation! Gorgeous Upgraded Vinyl Wood Plank Floors throughout! Plush Carpeting in all Bedrooms! This home is perfect for entertaining! Outstanding Open Floor Plan! Dramatic Gourmet Kitchen with stunning Quartz Countertops, Tile Back-splash, Large Eat-in Working Island with Deep Under-mount Stainless Sink, Tall Shaker Cabinets, Stainless Steel Appliances, Walk In Pantry & More! Gourmet Kitchen gracefully flows into your Casual Dining area & Amazing Family Rm with Wall of Windows! The Private Owner\'s Suite features a Luxurious Bathroom built for 2 with His & Her Sink Vanity, Deep Soaker Tub, Shower W/Seamless Glass Door & Walk-in Closet! Energy Efficient Home: HERS Energy Rated, Tankless/On-Demand H2O Heater, 2 USB outlets & \"Smart Home System, which allows you to control lights, locks, & thermostat! Covered Patio! NO FLOODING! Amenities include: Pool, Splash Pad & More! 20 minutes to The Galleria!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lakeview Retreat Lot: 13 /Block: 2' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Lakeview Retreat' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669040735' WHERE `Matrix_Unique_ID` = '209597751' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T08:29:25.213' ,`MLSNumber` = '55804759' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.169620' ,`Longitude` = '-95.633118' ,`PhotoCount` = '20' ,`PostalCode` = '77486' ,`RoomCount` = '6' ,`ListPrice` = '327000.00' ,`Status` = 'Active' ,`StreetName` = 'Green Meadows' ,`StreetNumber` = '419' ,`StreetSuffix` = 'Drive' ,`City` = 'West Columbia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1801' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS#55804759 Built by CastleRock HOME UNDER CONSTRUCTION! Greeley Plan(C-Elevation) 1-Story 3 BD 2 BA 3 Car Garage 1,801 sq ft! High Ceilings! Open Concept! Impressive Interior Upgrades! Modern White 42\" Kitchen Cabinets! Quartz Counters! Stainless steel finish appliances exude refinement and elegance! Inviting Owner\'s Suite! Soaker Tub & Separate Shower! 2\'\' Faux blinds! Wall of windows! Energy-Efficient! HERS Rated! No Flooding! Tankless Water Heater! Low Tax Rate 2.186 before homestead! Covered Patio! Offers a golf course family-friendly gated community, Easy Commute to Hwy 288, Exciting Pearland Town Center, Houston, Bay City, Sweeny & Lake Jackson! Experience the breathtaking sandy beach views just 30 min away! CastleRock offers NEW HOMES in various stages of construction for those who are looking for spacious 1 & 2-story layouts and Quick Move-In options. Nestled in Natural Splendor Enjoy Country Living in Columbia Lakes! Best kept secret south of Houston! Schedule a tour today!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 77, Block 31, Section 3' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '9375' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Columbia Lakes' ,`TaxAmount` = '' ,`TaxRate` = '2.186' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669040735' WHERE `Matrix_Unique_ID` = '209619761' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T08:19:58.310' ,`MLSNumber` = '40929527' ,`ListAgentFullName` = 'Grace Harris' ,`ListOfficeName` = 'RE/MAX Grand' ,`SellingAgentFullName` = 'Samantha Plomer' ,`SellingOfficeName` = 'Compass RE Texas, LLC' ,`Latitude` = '30.370869' ,`Longitude` = '-95.307093' ,`PhotoCount` = '23' ,`PostalCode` = '77303' ,`RoomCount` = '9' ,`ListPrice` = '449990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Crosby' ,`StreetNumber` = '16612' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2084' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3 bedroom 2 bath w/study & 3rd car garage on just under an acre lot! Elegant entry with crown molding that leads you into an open kitchen with an oversized family room! Kitchen includes white cabinets, silestone countertops w/undermount sink, designer backsplash, Stainless steel appliances, 9 ft long center island overlooking the extra large family room with plenty of windows! Owner suite has high ceilings with a large bath, separate tub & shower and his & her vanity w/silestone countertops! Big secondary bedrooms with plenty of space and the 2nd bath offers 2 sinks for the kids to share! Not to mention a covered patio and a 3 car Garage with space for a SHOP AREA! Ladies bring your hubby, because he will love it! ! Home sits on just under an acre of land where you can build a shop, store your boat, RV, trailer etc. all on your property! Conroe ISD schools and Low Tax rate! Hurry, Call today, this won\'t last long!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'KENDALL HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'Deer Pines Lot 3 Block 3 Section 23' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '43292' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Deer Pines' ,`TaxAmount` = '' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669040735' WHERE `Matrix_Unique_ID` = '209987584' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T08:30:34.833' ,`MLSNumber` = '11133681' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.169607' ,`Longitude` = '-95.633110' ,`PhotoCount` = '15' ,`PostalCode` = '77486' ,`RoomCount` = '6' ,`ListPrice` = '349000.00' ,`Status` = 'Active' ,`StreetName` = 'Green Meadows' ,`StreetNumber` = '423' ,`StreetSuffix` = 'Drive' ,`City` = 'West Columbia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1857' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS#11133681 Built by CastleRock HOME UNDER CONSTRUCTION! Whitman Plan(C-Elevation) 1-Story 3 BD 2 BA 3 Car Garage 1,857 sq ft! High Ceilings! Open Concept! Impressive Interior Upgrades! Modern White 42\" Kitchen Cabinets! Quartz Counters! Stainless steel finish appliances exude refinement and elegance! Inviting Owner\'s Suite! Soaker Tub & Separate Shower! 2\'\' Faux blinds! Wall of windows! Energy-Efficient! HERS Rated! No Flooding! Tankless Water Heater! Low Tax Rate 2.186 before homestead! Covered Patio! Offers a golf course family-friendly gated community, Easy Commute to Hwy 288, Exciting Pearland Town Center, Houston, Bay City, Sweeny & Lake Jackson! Experience the breathtaking sandy beach views just 30 mins away! CastleRock offers NEW HOMES in various stages of construction for those who are looking for spacious 1 & 2-story layouts and Quick Move-In options. Nestled in Natural Splendor Enjoy Country Living in Columbia Lakes! Best kept secret south of Houston! Schedule a tour today!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 78, Block 31, Section 3' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '9375' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Columbia Lakes' ,`TaxAmount` = '' ,`TaxRate` = '2.186' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669040736' WHERE `Matrix_Unique_ID` = '210163301' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T08:32:47.383' ,`MLSNumber` = '2384618' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.167258' ,`Longitude` = '-95.637838' ,`PhotoCount` = '11' ,`PostalCode` = '77486' ,`RoomCount` = '9' ,`ListPrice` = '374000.00' ,`Status` = 'Active' ,`StreetName` = 'Green Meadows' ,`StreetNumber` = '549' ,`StreetSuffix` = 'Drive' ,`City` = 'West Columbia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2513' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS #2384618 No Back Neighbors! NEW CONSTRUCTION BY CASTLEROCK! Trinity Plan(C-Elevation) 2-Story 4 BD 2.5 BA 3 Car Garage 2,513 sqft! High Ceilings! Open Concept! Impressive Interior Upgrades! Modern White 42\" Kitchen Cabinets w/ Quartz Counters! Stainless steel finish appliances exude refinement and elegance! Inviting Owner\'s Suite! Soaker Tub & Separate Shower! 2\'\' Faux blinds! Wall of windows! Energy-Efficient! HERS Rated! No Flooding! Low Tax Rate 2.186 before homestead! Columbia Lakes offers a golf course family-friendly gated community, and Easy Commute to Hwy 288, Exciting Pearland Town Center, Houston, Bay City, Sweeny & Lake Jackson! Experience the breathtaking sandy beach views just 30 mins away! CastleRock offers new homes in various stages of construction for those who are looking for spacious 1 & 2-story layouts and Quick Move-In options. Nestled in Natural Splendor! Enjoy Country Living in Columbia Lakes! Best kept secret south of Houston! Schedule a tour today!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 100, Block 31, Section 3' ,`LotDesciption` = 'Greenbelt,In Golf Course Community,Subdivision Lot' ,`LotSize` = '9372' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Columbia Lakes' ,`TaxAmount` = '' ,`TaxRate` = '2.168' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669040736' WHERE `Matrix_Unique_ID` = '210440684' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T08:46:36.780' ,`MLSNumber` = '37929495' ,`ListAgentFullName` = 'Clarissa Woodward' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.385525' ,`Longitude` = '-94.979016' ,`PhotoCount` = '29' ,`PostalCode` = '77591' ,`RoomCount` = '5' ,`ListPrice` = '185000.00' ,`Status` = 'Active' ,`StreetName` = 'Terrace' ,`StreetNumber` = '214' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1136' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located conveniently in between Galveston and Houston Texas, this 3 bedroom 2 bathroom home offers an easy commute route to schools, local businesses, and area attractions! The home is on a cul-de-sac road, and features a large shaded back yard, back patio, covered front patio, entryway, large living room, and a bump out in the garage for additional storage space. The seller has completed several updates throughout the home this year making it an even better primary residence or investment opportunity for your rental portfolio. \r\nCall Today and Schedule Your Private Showing!' ,`Acres` = '0.1523' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 197 WILLIAMS TERRACE SUB, LOT 14, ACRES .152' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6635' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'SIMMS ELEMENTARY SCHOOL (TEXAS CITY)' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Williams Terrace Sub 97' ,`TaxAmount` = '2790' ,`TaxRate` = '2.582' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040736' WHERE `Matrix_Unique_ID` = '210590692' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T08:26:43.213' ,`MLSNumber` = '80466669' ,`ListAgentFullName` = 'Marcelo Zubieta' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.062177' ,`Longitude` = '-95.428710' ,`PhotoCount` = '37' ,`PostalCode` = '77373' ,`RoomCount` = '6' ,`ListPrice` = '270000.00' ,`Status` = 'Active' ,`StreetName` = 'Cypresswood Hill' ,`StreetNumber` = '534' ,`StreetSuffix` = '' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1860' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! Beautiful, spacious, corner lot home in quiet gated community like this one is hard to find in the Houston area. Schedule your showing today, this listing will not last long. Excellent location with quick access to 99 Grand Parkway, I45, Intercontinental airport, Dining, schools, and shopping. Covered patio and large backyard provide plenty of space for activities and relaxation. Includes outdoor shed and built-in outdoor sink. Refrigerator in the house conveys with the sale. HVAC replaced 2019 and tankless water heater installed 2021. Although deemed to be correct, please verify square footage, room sizes, and school information. Community offers nice outdoor pool, beach voleyball court, and walking/running path around the lake.' ,`Acres` = '0.1128' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 3 CYPRESSWOOD LAKE SEC 3' ,`LotDesciption` = 'Corner' ,`LotSize` = '4915' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '733' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'GINGER MCNABB ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'SPRINGWOODS VILLAGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypresswood Lake Sec 03' ,`TaxAmount` = '4888' ,`TaxRate` = '2.4967' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040736' WHERE `Matrix_Unique_ID` = '210658171' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T08:19:33.257' ,`MLSNumber` = '52107140' ,`ListAgentFullName` = 'Daisy Garcia' ,`ListOfficeName` = 'Keller Williams Elite' ,`SellingAgentFullName` = 'Bernett Harris' ,`SellingOfficeName` = 'Keystone Signature Properties' ,`Latitude` = '29.675395' ,`Longitude` = '-95.032815' ,`PhotoCount` = '28' ,`PostalCode` = '77571' ,`RoomCount` = '3' ,`ListPrice` = '200000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'N 13th' ,`StreetNumber` = '812' ,`StreetSuffix` = 'Street' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2465' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this gorgeous house that has been fully renovated. You walk in to a large spacious open floor plan that will give you plenty of space for you and your family. This house is located on a corner lot and so you will have plenty of outdoor space for all your social gathering plus you are surrounded by trees making it quiet and peaceful. The home features a spacious breakfast nook that includes a wine fridge! Appliances are included as well! Selling as is' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1A LAPORTE TERRACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9576' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'LA PORTE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'La Porte Terrace' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040736' WHERE `Matrix_Unique_ID` = '210721495' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T08:09:53.407' ,`MLSNumber` = '96976491' ,`ListAgentFullName` = 'David Smith' ,`ListOfficeName` = 'Luxely Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.839607' ,`Longitude` = '-95.634542' ,`PhotoCount` = '33' ,`PostalCode` = '77084' ,`RoomCount` = '10' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Sandy Hill' ,`StreetNumber` = '15619' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2366' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Back to the market, buyer financing fell through. A fantastic opportunity, this home features a welcoming interior and comprises expansive living areas and a gas fireplace. A cook\'s dream, this spacious, eat-in kitchen has been recently remodeled to include an electric oven and quartz countertops. A design gem, the master bathroom features a large walk-in shower, double sinks, and quartz countertops. Adding to the home\'s appeal are enhancing the home are manufactured hardwood floors throughout. The relaxing backyard is an ideal play space with a wide porch, pool, and hot tub. An ideal spot for easy summer living. Nestled in a peaceful part of Bear Creek Village. See for yourself why people love this suburban community. Right up the street from grocery stores, cafes, and restaurants. You have all the amenities you would like just minutes from home. Be prepared for \'love at first sight! Schedule your showing before it’s gone.' ,`Acres` = '0.1901' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 10 BEAR CREEK VILLAGE SEC 6' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8280' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BEAR CREEK ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CARDIFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bear Creek Village Sec 06' ,`TaxAmount` = '5100' ,`TaxRate` = '2.1736' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040737' WHERE `Matrix_Unique_ID` = '210864615' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T07:53:00.373' ,`MLSNumber` = '32887675' ,`ListAgentFullName` = 'Hasiyet Keyim' ,`ListOfficeName` = 'Flyers' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.997642' ,`Longitude` = '-95.158352' ,`PhotoCount` = '44' ,`PostalCode` = '77346' ,`RoomCount` = '5' ,`ListPrice` = '389000.00' ,`Status` = 'Active' ,`StreetName` = 'Player Park' ,`StreetNumber` = '19134' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2756' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This custom built 4/2.5/2 home with sparkling pool & spa in the heart of Atascocita! Charming floorplan features Large kitchen with granite counters, Stainless Steel appliances, smooth surface cooktop & lots of cabinet space. Large den with see-thru fireplace views of the Pool and backyard. New wood floors. Master suite down. Large Gameroom & 3 spacious bedrooms up. Tropical paradise. Drive-thru garage!' ,`Acres` = '0.2767' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 5 GOLFERS VILLAGE WALDEN ON LAKE HOUSTON PH 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12052' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '275' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Slate' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'MAPLEBROOK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Walden On Lake Houston Ph 01' ,`TaxAmount` = '6410' ,`TaxRate` = '2.5885' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040737' WHERE `Matrix_Unique_ID` = '211023588' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T07:45:16.253' ,`MLSNumber` = '73987477' ,`ListAgentFullName` = 'David Young' ,`ListOfficeName` = 'Blue Dahlia Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.744877' ,`Longitude` = '-95.403955' ,`PhotoCount` = '47' ,`PostalCode` = '77019' ,`RoomCount` = '8' ,`ListPrice` = '1095000.00' ,`Status` = 'Active' ,`StreetName` = 'Elmen' ,`StreetNumber` = '2322' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2520' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This updated Montrose home is now available. This corner lot, 3 bedroom, 3 full bath house was taken down to the studs in 2014 and rebuilt to maintain it\'s original character and charm. Many of the original design elements were kept including custom milled window, door and baseboard moulding. Original freshly refinished hardwood floors throughout! No carpet, the remodeled kitchen and bathrooms have designer tile to reflect the home\'s charm. The pier and beams were reinforced with structural steel, the first floor has a moisture barrier, superior insulation throughout the house, the attic too with 6-8 inches of spray foam... and, the house has never flooded. New electrical wiring, new plumbing, new LowE windows, ecofriendly countertops, and Solatubes upstairs for natural light. Bright flex space at the top of the stairs. For the car enthusiast, a stand alone 700 sq. ft. garage with car lift. Please see attached list of all property upgrades on Docs tab.' ,`Acres` = '0.1148' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'River Oaks Shopping Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 9 BLK 10 PLAINVIEW SEC 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WOODROW WILSON MONTESSORI' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Plainview Sec 01' ,`TaxAmount` = '16585' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040737' WHERE `Matrix_Unique_ID` = '211161173' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T08:28:33.533' ,`MLSNumber` = '49396721' ,`ListAgentFullName` = 'Mark Goudeau' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.066110' ,`Longitude` = '-95.378336' ,`PhotoCount` = '36' ,`PostalCode` = '77373' ,`RoomCount` = '7' ,`ListPrice` = '279900.00' ,`Status` = 'Active' ,`StreetName` = 'Spring Oak' ,`StreetNumber` = '23803' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1991' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful, spacious two-story home nestled in family friendly community North Spring! This well-maintained gem features a front porch elevation, open floor plan with 3 bedrooms & 2.5 baths, formal dining, game room! Large kitchen! Huge primary suite and private bath includes double sinks, separate shower and garden tub! Close proximity to 45, Hardy Toll with easy access to Downtown, Bush Airport and The Woodlands! This home is a must see that won\'t last long! This beautiful home is in move in condition, recently painted interior and exterior, Great kitchen with 42\'\'cherry cabinets and eat in breakfast area, sprinkler system, large corner lot, with high ceilings. A/C was recently replace and roofing also. This home is a must see, ready for its new family!' ,`Acres` = '0.1734' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 2 NORTH SPRING SEC 12' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7553' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'SMITH ELEMENTARY SCHOOL (SPRING)' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'TWIN CREEKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'North Spring' ,`TaxAmount` = '5653' ,`TaxRate` = '2.8117' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040737' WHERE `Matrix_Unique_ID` = '211873523' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T08:44:51.453' ,`MLSNumber` = '98830750' ,`ListAgentFullName` = 'Arlene Simmons' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = 'Bridgett Badillo' ,`SellingOfficeName` = 'Houston Center Real Estate' ,`Latitude` = '30.015605' ,`Longitude` = '-95.463804' ,`PhotoCount` = '28' ,`PostalCode` = '77090' ,`RoomCount` = '10' ,`ListPrice` = '295000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Sugar Pine' ,`StreetNumber` = '17411' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3056' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'JUST THE HOME YOU WERE WAITING FOR! Move-in ready! Freshly painted interior & exterior (2022). 4 Large bedrooms, 2.5 baths. Formal 2 story entry with sweeping staircase. Formal living and dining rooms. Study with built-ins. Huge den with center fireplace, built-ins, and views of the patio and backyard. Wet bar. Breakfast room with natural lighting. Kitchen with white cabinets, recent electric cook top 2022, double Stainless steel convection ovens. Primary bedroom with room for a sitting area. Roof 2016 and HVAC 2012. Front porch waiting for some rocking chairs! Good size backyard for family fun. Recent laminate wood and tile flooring. Convenient to I45, The Woodlands, shopping and restaurants. Never Flooded.' ,`Acres` = '0.2334' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 8 PONDEROSA FOREST SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10168' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '460' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PONDEROSA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ponderosa Forest Sec 07' ,`TaxAmount` = '4962' ,`TaxRate` = '2.2392' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040737' WHERE `Matrix_Unique_ID` = '212967613' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T08:41:28.097' ,`MLSNumber` = '12435230' ,`ListAgentFullName` = 'Sean Thomas' ,`ListOfficeName` = 'Orchard Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.369557' ,`Longitude` = '-95.583589' ,`PhotoCount` = '31' ,`PostalCode` = '77356' ,`RoomCount` = '7' ,`ListPrice` = '259000.00' ,`Status` = 'Active' ,`StreetName` = 'Regency' ,`StreetNumber` = '46' ,`StreetSuffix` = 'Point' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1492' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located right on Lake Conroe with tons of amenities in gated community -tennis courts, pool, boat launch, and a common long dock walkway. Inviting living room w/high ceiling and exposed beams. Enjoy ease of maintaining wood laminate and tile flooring on the main level and comfort of carpeting on the second level. Bright white cabinetry, stainless steel appliances, and sunny breakfast nook are highlights of the kitchen. Lovely extra loft space upstairs is perfect for a library, office, or media room. Owners can relax on main level in primary bedroom complete with en-suite bath, walk-in closet with built in shelving. Grassy backyard with a few trees and direct access to the community tennis courts. Lake access just around the corner.' ,`Acres` = '0.0775' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S826800 - REGENCY POINT, LOT 45-47 REPLAT' ,`LotDesciption` = 'Patio Lot,Water View' ,`LotSize` = '3375' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '308' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Regency Point' ,`TaxAmount` = '4545' ,`TaxRate` = '2.1625' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040738' WHERE `Matrix_Unique_ID` = '213341159' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T07:31:08.403' ,`MLSNumber` = '8876655' ,`ListAgentFullName` = 'David Gloger' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.372928' ,`Longitude` = '-95.030138' ,`PhotoCount` = '12' ,`PostalCode` = '77568' ,`RoomCount` = '6' ,`ListPrice` = '239900.00' ,`Status` = 'Active' ,`StreetName` = 'Driftwood' ,`StreetNumber` = '846' ,`StreetSuffix` = 'Lane' ,`City` = 'La Marque' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1706' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This property has been placed in an upcoming online event. For more information on \"How To Submit An Offer\" reach out to the listing agent. The winning offer must submit a Texas Real Estate Purchase Agreement. Property is subject to a buyer paid premium for agent compensation to be added to the winning offer. Offers can be submitted to the URL found in the how to offer instructions. Seller reserves the right to accept, counter or reject any or all offers. Buyer\'s lender pre-approval or POF for must be submitted prior to making an offer. Flooring in the entire home has been updated. Complete painting in the interior as well as exterior. New stainless steel appliances...\r\n\r\nDue to the inclement weather the open house schedule for today November 19th is canceled...' ,`Acres` = '0.143' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Marque' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SALTGRASS CROSSING SEC 1 (2007) ABST 2, BLOCK 1, LOT 31, ACR' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '440' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '26 - Hitchcock' ,`SchoolElementary` = 'HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HITCHCOCK HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (HITCHCOCK)' ,`ShowInstructions` = 'Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Saltgrass Crossing Sec 1 2007' ,`TaxAmount` = '7088' ,`TaxRate` = '3.2275' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040738' WHERE `Matrix_Unique_ID` = '213351216' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T08:57:26.813' ,`MLSNumber` = '40164868' ,`ListAgentFullName` = 'Gwendolyn Burwell' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = 'Christy Buck' ,`SellingOfficeName` = 'Infinity Real Estate Group' ,`Latitude` = '29.577441' ,`Longitude` = '-95.379911' ,`PhotoCount` = '40' ,`PostalCode` = '77584' ,`RoomCount` = '6' ,`ListPrice` = '259900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Breezy Pines' ,`StreetNumber` = '2707' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1445' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOTIVATED SELLER! ENJOY YOUR NEW LIFESTYLE IN DESIRABLE ACTIVE 55+ SENIOR COUNTRYPLACE COMMUNITY! See stunning views from Living, Breakfast/Kitchen, & Primary Bedroom. This cul-de-sac lot on golf course is one of the best locations in Countryplace. This light & bright home has fresh paint, High Ceilings, Kitchen Breakfast Area, Dining Room w Bay Window. Large Primary Bedroom has Walk-in Closet, Primary Bath w Garden Tub, Separate Shower, Double Sinks. Enjoy peaceful hours on your back deck in the shade of a grove of mature trees. This active 55+ community has Olympic size Pool, Hot Tub, lighted Tennis Courts, Golf Course, & multitude of Activities at the Clubhouse: Travel Club, Friday Happy Hours at the Grill, Exercise rooms, Library, Game room, Auditorium, & more. Note the 24/7 Manned Security. Ideally located near Hwy 288 & Beltway 8, there\'s easy access to Pearland shopping, restaurants, medical facilities, & only a short drive to downtown Houston, sports arenas, & theater district.' ,`Acres` = '0.1522' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Approved Seniors Project,Estate' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'COUNTRYPLACE SEC 1 (A0510 F B DRAKE) BLK 5 LOT 26' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,On Golf Course' ,`LotSize` = '6630' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '180' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'CHALLENGER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'BERRY MILLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Countryplace Sec 1' ,`TaxAmount` = '4939' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040738' WHERE `Matrix_Unique_ID` = '213427220' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T07:44:26.663' ,`MLSNumber` = '74216355' ,`ListAgentFullName` = 'Mitchell LeJeune' ,`ListOfficeName` = 'Texas Legacy Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.027189' ,`Longitude` = '-95.503732' ,`PhotoCount` = '32' ,`PostalCode` = '77379' ,`RoomCount` = '11' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Lapis River' ,`StreetNumber` = '16415' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2804' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HONEY STOP THE CAR! We have found our dream house. Spectacular 4-bedroom 2.5 bath 2806sqft home on 5750sqft lot. This beauty is ready-to-move into. Home features formal dining room, den with cozy fireplace, study, updated kitchen, breakfast room, primary bedroom down, game room & 3 bedrooms up. Home includes fresh interior paint, granite kitchen counters, new gas oven, new microwave oven, walk in closets, ceiling fans, abundant storage, new fence, sprinkler system, great access to shopping, Grand Parkway/ HWY 99, The Woodlands and IAH. Kids attend acclaimed Klein ISD Schools, Home did not flood during Harvey.' ,`Acres` = '0.132' ,`Area` = '13' ,`BuilderName` = 'Ryland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 2 CYPRESS TRACE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BENFER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'STRACK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Trace' ,`TaxAmount` = '6286' ,`TaxRate` = '2.5965' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040738' WHERE `Matrix_Unique_ID` = '213494252' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T07:38:57.437' ,`MLSNumber` = '65998638' ,`ListAgentFullName` = 'Stephen Findley' ,`ListOfficeName` = 'Sky Real Estate Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.162849' ,`Longitude` = '-95.755933' ,`PhotoCount` = '49' ,`PostalCode` = '77355' ,`RoomCount` = '9' ,`ListPrice` = '659900.00' ,`Status` = 'Active' ,`StreetName` = 'Timber Ridge' ,`StreetNumber` = '19206' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2790' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rare find in 160 acre lake community Indigo lake Estates, the premier community in Magnolia Tx. This over 2 acre plot allows for all the space you will need to enjoy the outdoors. Just under 2800 square ft, this home comes with a 3 car garage, sparkling pool, and an open floor plan ready to entertain. Roof and paint are less than 1 yr, front and back covered porch with private electronic gated entrance. Custom home with original owner that takes pride in perfect upkeep of their private setting, close to the front of the neighborhood.The inside boasts tall ceilings, large rooms, huge game room upstairs with half bath and media black out shades perfect for a movie night. The Kitchen is ready for the Chef, including tons of cabinet space, granite, and a large breakfast bar across facing into the living room. Recent addition of an incredible Spa for the relaxing evenings by the pool. Don’t forget the private lake access, parks at lake, sand volleyball, and basketball court. Welcome Home!' ,`Acres` = '2.313' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'INDIGO LAKE ESTATES 03, BLOCK 1, LOT 1' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '100754' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1090' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'NICHOLS SAWMILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Indigo Lake Estates 03' ,`TaxAmount` = '7214' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040739' WHERE `Matrix_Unique_ID` = '213604819' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T08:41:31.840' ,`MLSNumber` = '52605986' ,`ListAgentFullName` = 'Craig Cosman' ,`ListOfficeName` = '1st Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.997150' ,`Longitude` = '-95.798533' ,`PhotoCount` = '24' ,`PostalCode` = '77447' ,`RoomCount` = '8' ,`ListPrice` = '414900.00' ,`Status` = 'Active' ,`StreetName` = 'Ronda Dale' ,`StreetNumber` = '16027' ,`StreetSuffix` = 'Drive' ,`City` = 'Hockley' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3004' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing opportunity to own an Infinity Classic Home in the desired StoneCreek Ranch subdivision! This home has beautiful curb appeal with 4 sides brick, mature landscaping, and an oversized lot with room for a pool! The sprinkler system and covered front and back porch are just a few of the nice exterior upgrades. The wrought iron stairs and high ceilings make this 3,004 square foot home feel elegant and open. Ceramic tile and beautiful hard wood floors bring even more value to the home. Energy star 3.0 certified gives the same low energy bills as a newly built home. Extremely well maintained, big secondary bedrooms, a huge Gameroom, and recessed ceilings means this home has it all.' ,`Acres` = '0.1749' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 1 STONE CREEK RANCH SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7620' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stone Creek Ranch' ,`TaxAmount` = '9459' ,`TaxRate` = '3.1924' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040739' WHERE `Matrix_Unique_ID` = '213728454' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T08:13:36.917' ,`MLSNumber` = '76894243' ,`ListAgentFullName` = 'Christopher Cerda' ,`ListOfficeName` = 'Chris Christopher Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.154075' ,`Longitude` = '-95.387984' ,`PhotoCount` = '25' ,`PostalCode` = '77386' ,`RoomCount` = '10' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Hamilton Bend' ,`StreetNumber` = '3526' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2412' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THE STARS ARE BRIGHT - You have to see this spectacular two story Lennar home in Imperial Oaks Park. This move-in ready home features an elegant exterior with fresh landscaping mirroring polished interior with fresh paint & like new carpeting throughout. Fantastic layout with plenty of flexibility. Enjoy a formal dining room or flex/office area at the front of the home - you decide! The kitchen overlooks the main living space with tall ceilings. This home has it all with stunning granite countertops in the kitchen, along with stainless steel appliances and a nice breakfast area. Retreat to the primary bedroom tucked away on the first floor. The primary bath boasts dual sinks, soaking tub, separate shower & spacious closet. Three additional bedrooms & a full bathroom are situated upstairs, along with an oversized game room. A rare find! Master-Planned Community with easy access to I-45, GP 99, & The Woodlands amenities. DEEP IN THE HEART OF TEXAS, make this property your new home today!' ,`Acres` = '0.1428' ,`Area` = '15' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S612117 - IMPERIAL OAKS PARK 17, BLOCK 2, LOT 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6220' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BIRNHAM WOODS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Oaks Park 17' ,`TaxAmount` = '8281' ,`TaxRate` = '3.0687' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040739' WHERE `Matrix_Unique_ID` = '213761372' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T08:41:18.860' ,`MLSNumber` = '91433173' ,`ListAgentFullName` = 'Heather Lange' ,`ListOfficeName` = 'RE/MAX One' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.964878' ,`Longitude` = '-93.989377' ,`PhotoCount` = '32' ,`PostalCode` = '77627' ,`RoomCount` = '9' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue G' ,`StreetNumber` = '2004' ,`StreetSuffix` = 'Street' ,`City` = 'Nederland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated home on a double 100 x 140 lot in Nederland ISD! Open-concept den/dining/kitchen. Luxury vinyl plank flooring throughout! Beautiful kitchen & shaker cabinets, granite countertops, & walk-in pantry. Split floorplan with 2 master bedrooms w/full baths. 2 more bedrooms with a jack-n-jill bath. Hall laundry closet. Covered patio & an apartment with one bedroom, living, kitchen ,full bath & a separate deck. Hardi plank siding & storm windows. Foam insulation and new driveway added recently. You will fall in love with this home!' ,`Acres` = '0.32' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 18 & 19 BLK 21, Hillcrest 1st' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '152 - Nederland' ,`SchoolElementary` = 'HILLCREST ELEMENTARY SCHOOL (NEDERLAND)' ,`SchoolHigh` = 'NEDERLAND HIGH SCHOOL' ,`SchoolMiddle` = 'CENTRAL MIDDLE SCHOOL (NEDERLAND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Hillcrest 1st' ,`TaxAmount` = '5440' ,`TaxRate` = '5440.49' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040739' WHERE `Matrix_Unique_ID` = '213770813' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T07:21:11.050' ,`MLSNumber` = '31987850' ,`ListAgentFullName` = 'Clarke Evans' ,`ListOfficeName` = 'Evans and Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.823187' ,`Longitude` = '-95.126167' ,`PhotoCount` = '31' ,`PostalCode` = '77360' ,`RoomCount` = '4' ,`ListPrice` = '179750.00' ,`Status` = 'Active' ,`StreetName` = 'Popular' ,`StreetNumber` = '176' ,`StreetSuffix` = 'Street' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1813' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.4101' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'PINE HARBOR SECTION 3 BLK 7 LOT 6 & 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '17864' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '60' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pine Harbor Sec 3' ,`TaxAmount` = '2072' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040740' WHERE `Matrix_Unique_ID` = '213811022' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T08:53:24.570' ,`MLSNumber` = '17529371' ,`ListAgentFullName` = 'Anja Drewes Neidhardt' ,`ListOfficeName` = 'Anja DrewesProperties, LLC' ,`SellingAgentFullName` = 'Giesla Lazar' ,`SellingOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`Latitude` = '29.647955' ,`Longitude` = '-95.728708' ,`PhotoCount` = '42' ,`PostalCode` = '77406' ,`RoomCount` = '9' ,`ListPrice` = '319900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Cane Lake' ,`StreetNumber` = '3710' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1919' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful one story home in sought after Waterside Estates subdivision! Spacious 4 bedroom/2 bath/2 car garage. Open floorplan with huge living room, vaulted ceilings, formal dining, lots of closet space. 2022 updates: brand-new flooring (carpet with upgraded pad and luxury vinyl plank ), all freshly painted, incl trim and doors, new doorknobs, new front and rear door, new dual flush toilets, new kitchen faucet, new range hood. 2019 updates included: new hvac, water heater, garbage disposal, garage door and motor. Waterside Estates offers a beautiful fishing lake, walking trails, parks, community tennis courts and pool with kiddie splash pad. Zoned to Fort Bend ISD award-winning schools and easy commute make this a great place to call home! Easy access to 99, nearby shopping, dining, and entertainment. The Lifestyle You’re Looking For!' ,`Acres` = '0.135' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WATERSIDE ESTATES SEC 9, BLOCK 1, LOT 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5881' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '640' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'OAKLAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'BOWIE MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Waterside Estates' ,`TaxAmount` = '4741' ,`TaxRate` = '2.2929' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040740' WHERE `Matrix_Unique_ID` = '213910743' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T08:31:48.683' ,`MLSNumber` = '3909162' ,`ListAgentFullName` = 'Sandra Membreno' ,`ListOfficeName` = 'World Wide Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.937103' ,`Longitude` = '-95.275041' ,`PhotoCount` = '20' ,`PostalCode` = '77396' ,`RoomCount` = '7' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Leaftex' ,`StreetNumber` = '7506' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1463' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Newly renovated one-story home ready to move in. Open floor plan with fresh paint and new waterproof vinyl plank flooring. New 25 year shingles. New A/C Unit. New sheetrock throughout the whole house. The beautiful kitchen features Granite countertop and new light fixtures throughout the house. 12ft pool, ready for outdoor entertaining or just hanging out with friends and family! Easy access to Beltway 8 and Highway 59. Schedule your showing today!' ,`Acres` = '0.1641' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Humble Area South' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 19 EASTEX OAKS VILLAGE 3 R/P A' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'NORTH BELT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'HUMBLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Eastex Oaks Village 03 R/P A' ,`TaxAmount` = '2670' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040740' WHERE `Matrix_Unique_ID` = '214076994' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T07:56:40.513' ,`MLSNumber` = '85567054' ,`ListAgentFullName` = 'Omar Sanchez' ,`ListOfficeName` = 'SIS Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.650100' ,`Longitude` = '-95.519497' ,`PhotoCount` = '31' ,`PostalCode` = '77071' ,`RoomCount` = '7' ,`ListPrice` = '699900.00' ,`Status` = 'Active' ,`StreetName` = 'Circle' ,`StreetNumber` = '8002' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4220' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 8002 N Circle! This luxurious Custom Built home has all the modern finishes and space you have been looking\r\nfor.Beyond its perfectly manicured lot is your Grand Entryway with dramatic ceilings & open concept layout. Formal dinning\r\nand living featuring crisp white custom cabinetry and built-ins throughout. Your dream kitchen boasts a gorgeous oversized\r\ngranite waterfall edge island, endless countertop space, commercial grade appliances, custom cabinets. The kitchen opens up\r\nsundreinched family room with a beautiful stone fireplace and great room with french doors that lead to your outside living\r\nspace. Your tranquil first floor Primary Suite w/ Spa-like Ensuite bathroom with separate shower & soaking tub also sleek\r\ndouble vanity. Huge gameroom with connecting balcony, 3 spacious secondary bedrooms & 2 full bathrooms upstairs.\r\nOversized driveway leads you into your 2 car garage. No Flooding! No MUD! Easy living at its best. Call to book your private\r\nshowing today!' ,`Acres` = '0.2078' ,`Area` = '20' ,`BuilderName` = 'JS CONSTRUCTION' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 29 BLK 1 LAKES OF FONDREN SW' ,`LotDesciption` = 'Cleared,Corner,Cul-De-Sac' ,`LotSize` = '9050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GROSS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'WELCH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Lakes Fondren Sw' ,`TaxAmount` = '1159' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669040740' WHERE `Matrix_Unique_ID` = '214098924' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T07:54:21.630' ,`MLSNumber` = '81423545' ,`ListAgentFullName` = 'Esanet Benedict' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = 'Binh Vo' ,`SellingOfficeName` = 'RE/MAX Northwest, REALTORS' ,`Latitude` = '30.058043' ,`Longitude` = '-95.501503' ,`PhotoCount` = '38' ,`PostalCode` = '77379' ,`RoomCount` = '10' ,`ListPrice` = '399900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Ransten' ,`StreetNumber` = '19915' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2987' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful property offers the space & lifestyle you\'ve been looking for! 4 generous sized bedrooms, 3 1/2 bath & 3-car garage. Ideal open-concept floor plan with large living room with brand new gorgeous wood flooring, corner cast stone gas fireplace, open to oversized Kitchen with 42\" maple cabinetry, elegant granite countertops, stone backsplash, stainless-steel appliances, 7\' island, breakfast bar, breakfast room & spacious utility room w/ shelving for additional storage (Refrigerator, Washer/Dryer stay), plus Formal dining or study/bonus room. Primary bedroom is privately situated on main floor with ensuite & walk-in closet. Upstairs is a massive game room/loft, with 3 additional bedrooms & 2 full baths. Recent renovations throughout! Backyard is serene & spacious with covered patio & irrigation system at back & front. Wonderful amenities include pool, clubhouse, tennis, park, lakes. Zoned to popular Klein ISD. Great location close to Hwy 99, I-45, 249, Exxon Campus.' ,`Acres` = '0.1525' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 4 SENTERRA LAKES SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6641' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KUEHNLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KRIMMEL INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Senterra Lakes Sec 01' ,`TaxAmount` = '7843' ,`TaxRate` = '2.5965' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040740' WHERE `Matrix_Unique_ID` = '214123947' --> 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','214128488','1669040741','214128488','2022-11-19T08:22:48.407','68546982','Justin Dugat','Norhill Realty','','','29.784149','-95.355708','2','77009','4','474900.00','Active','Morris','1266','Street','Houston','2','1','4','1944','Single-Family','Choose your own finishes while still under construction! Estimated completion is mid-December 2022. This home has been taken completely down to the studs, reconfigured and doubled in size. Vaulted ceilings, up to 4 bedrooms with almost 2,000 sq feet on a full-size lot. 1266 Morris sits on a quiet street, tucked away in the middle of the booming Near Northside. You\'ll find elevated finishes throughout and a thoughtful design, this home will not disappoint.','0.1148','9','BCR Investments LLC','','','','Sellers Disclosure','','','','Northside','Central Gas','0','TRS 5A & 6A BLK 56 LITTLE & DICKINSON','Subdivision Lot','5000','Appraisal District','','','1','To Be Built/Under Construction','','','0','','','','','Composition','27 - Houston','MARTINEZ C ELEMENTARY SCHOOL','NORTHSIDE HIGH SCHOOL','MARSHALL MIDDLE SCHOOL','Accompany,Appointment Required','Builder','1','Craftsman,Traditional','Little & Dickinson','3614','2.3307','Public Sewer,Public Water','1938','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T07:32:42.377' ,`MLSNumber` = '45718976' ,`ListAgentFullName` = 'Roxana Marquina' ,`ListOfficeName` = 'Aero Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.694911' ,`Longitude` = '-95.354008' ,`PhotoCount` = '33' ,`PostalCode` = '77021' ,`RoomCount` = '3' ,`ListPrice` = '269900.00' ,`Status` = 'Active' ,`StreetName` = 'Goforth' ,`StreetNumber` = '6414' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1548' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1148' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 BLK 28 BELMONT SEC 2' ,`LotDesciption` = 'Other' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PECK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Belmont Sec 02' ,`TaxAmount` = '4312' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040741' WHERE `Matrix_Unique_ID` = '214165734' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T08:39:41.583' ,`MLSNumber` = '60444316' ,`ListAgentFullName` = 'Pierre Joseph' ,`ListOfficeName` = 'Gens Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.649998' ,`Longitude` = '-95.496292' ,`PhotoCount` = '29' ,`PostalCode` = '77035' ,`RoomCount` = '3' ,`ListPrice` = '269900.00' ,`Status` = 'Active' ,`StreetName` = 'Ludington' ,`StreetNumber` = '6023' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1523' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '\"Due to INCLEMENT WEATHER, the OPEN HOUSE scheduled for this weekend has been CANCELLED\". Welcome to Westbury where this freshly painted and newly updated single story property calls home. The property has new appliances, sizable rooms and a huge backyard. Tiles throughout the property (no carpet). Kitchen offers a kitchen nook and a breakfast bar overlooking the living room. Property is well priced for the area and has low property tax rate. Please reach out to your realtor or call for a showing. This property may not last long.' ,`Acres` = '0.1956' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 BLK 93 WESTBURY SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8520' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ANDERSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'FONDREN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Westbury' ,`TaxAmount` = '3306' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040741' WHERE `Matrix_Unique_ID` = '214200164' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T07:41:58.513' ,`MLSNumber` = '34133341' ,`ListAgentFullName` = 'Cynthia Hodges' ,`ListOfficeName` = 'Broussard\'s Real Estate Invest' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.767133' ,`Longitude` = '-95.268391' ,`PhotoCount` = '8' ,`PostalCode` = '77029' ,`RoomCount` = '7' ,`ListPrice` = '172500.00' ,`Status` = 'Active' ,`StreetName` = 'Fannette' ,`StreetNumber` = '8735' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1336' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well kept 3 bedroom 1 bath home inside loop 610. Original oak hardwood flooring. Nice sized formal living room and den...perfect for entertaining! Ceiling fans and window coverings throughout. Spacious indoor laundry and utility room. Ample closet space. Kitchen equipped with 5 burner gas cook top stove, wall oven, and plenty of cabinet space. Dining room has patio doors that lead to the patio and back yard enclosed with a privacy fence. Double drive-way and carport.' ,`Acres` = '0.1324' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 131 BLK 7 PLEASANTVILLE SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5768' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PLEASANTVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FURR HIGH SCHOOL' ,`SchoolMiddle` = 'HOLLAND MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Pleasantville' ,`TaxAmount` = '1977' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1957' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040741' WHERE `Matrix_Unique_ID` = '214260623' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T07:05:49.607' ,`MLSNumber` = '76824558' ,`ListAgentFullName` = 'Clinton Omiwade' ,`ListOfficeName` = 'ERA Legacy Living' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.439623' ,`Longitude` = '-95.442356' ,`PhotoCount` = '35' ,`PostalCode` = '77583' ,`RoomCount` = '3' ,`ListPrice` = '264999.00' ,`Status` = 'Active' ,`StreetName` = 'Onyx Trail' ,`StreetNumber` = '9918' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1466' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous single-story, 1466 sqft home in a great location ! Check out this lovely 3-bedroom, 2-bathroom home This home features fantastic Wood and Tile Floors through the house, stunning front entry with large beautiful kitchen, and so much more! Very spacious Main Living area With great Flooring. Large Sized Kitchen with Open concept. This property provides an abundance of options. This Gem Will Not Last Long.' ,`Acres` = '0.1358' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'STERLING LAKES AT IOWA COLONY SEC 2 (A0289 HT&B) BLK 2 LOT 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '5915' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '860' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'SANCHEZ ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Split Level,Traditional' ,`Subdivision` = 'Sterling Lakes At Iowa Colony' ,`TaxAmount` = '6580' ,`TaxRate` = '3.4099' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040741' WHERE `Matrix_Unique_ID` = '214315673' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T07:09:51.207' ,`MLSNumber` = '45462164' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = 'Jackeline Mateos' ,`SellingOfficeName` = 'Keller Williams RealtyNortheast' ,`Latitude` = '30.020331' ,`Longitude` = '-95.304751' ,`PhotoCount` = '16' ,`PostalCode` = '77338' ,`RoomCount` = '8' ,`ListPrice` = '229990.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Tanner Woods' ,`StreetNumber` = '21111' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1575' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2.74 TAX RATE!!! LOCATION!!! LOCATION!! LOCATION!!! Welcome home to this beautiful 1 story, 3 Bedroom, 2 Bath, with 2 Car Garage. NEW PAINT AND CARPET!!! You will love this spacious floor plan with Spacious Family Room with a peek through opening from the Kitchen (no one sees the dirty dishes). there is also a Formal Living Room that can used as a flex space. Fenced Backyard! You have everything you need with this location with easy access to downtown, neighborhood backs up to Jesse H Jones Park, Cypresswood Golf Club, Bush IAH, and great shopping and entertainment in the Deerbrook area. Easy access to I69/TX59, FM1960, Beltway 8, and Hardy Toll Road. Humble ISD!!! Call today for your private tour!' ,`Acres` = '0.1109' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 4 KENSWICK FOREST SEC 1' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '4830' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'JONES ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kenswick Forest' ,`TaxAmount` = '3974' ,`TaxRate` = '2.7433' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040742' WHERE `Matrix_Unique_ID` = '214539754' --> 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','214558397','1669040742','214558397','2022-11-19T08:36:31.330','28289766','Elisa Gonzalez','Keller Williams Professionals','','','29.737592','-95.324852','32','77023','5','359000.00','Active','Curtin','5019','Street','Houston','1','0','3','1191','Single-Family','Here is your opportunity for a fresh start or renovate existing home in corner lot. Lots of renovated and new construction going on in this subdivision/area.','0.1189','4','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','0','','0','East End Revitalized','Central Gas','0','LT 3 BLK 1 EASTWOOD OAKS','Corner','5180','Appraisal District','','','0','','1','Electric Oven','0','','','Freestanding Range,Gas Range','','Composition','27 - Houston','CAGE ELEMENTARY SCHOOL','AUSTIN HIGH SCHOOL (HOUSTON)','NAVARRO MIDDLE SCHOOL (HOUSTON)','Lockbox Front','Appraisal District','1','Traditional','Eastwood Oaks','4056','2.3307','Public Water','1950','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T07:07:51.187' ,`MLSNumber` = '6042551' ,`ListAgentFullName` = 'Karen Blanton' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.750724' ,`Longitude` = '-95.828449' ,`PhotoCount` = '35' ,`PostalCode` = '77494' ,`RoomCount` = '10' ,`ListPrice` = '699000.00' ,`Status` = 'Active' ,`StreetName` = 'Grayson Lakes' ,`StreetNumber` = '1618' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4034' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION! Gorgeous home in the beautiful Grayson Lakes, sits on the corner with a breathtaking view of the lake that sits directly across the street. With view from all front windows. Two-story foyer, formal living /a dining room, study with double doors, and half bath. Family room has soaring two story ceiling, and dramatic windows and view of sparkling pool, and backyard. Gourmet kitchen with large island, gas cooktop, lots of storage. Spacious Primary and ensuite includes fireplace, bath w/ separate shower and vanities. Custom closet with custom mirrored cabinets, bonus space can be used as exercise or dressing room. Sweeping wrought iron staircase leads to spacious game room overlooking pool. Fully equipped media room and three bedrooms overlooking lake. Sits on a greenbelt, no rear neighbors, Numerous upgrades include Sprinkler, security, shutters, remote patio shades, sound system, smart home light switches and more. Nearby freeway, schools, restaurants, and entertainment.' ,`Acres` = '0.3194' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'COUNTRY LAKES AT GRAYSON LAKES SEC 4, BLOCK 1, LOT 1' ,`LotDesciption` = 'Corner,Greenbelt,Subdivision Lot,Water View' ,`LotSize` = '13912' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1321' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WOODCREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMPKINS HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Country Lakes At Grayson Lakes Sec 4' ,`TaxAmount` = '10946' ,`TaxRate` = '2.4245' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040742' WHERE `Matrix_Unique_ID` = '214724795' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T08:33:33.293' ,`MLSNumber` = '14981015' ,`ListAgentFullName` = 'Debra Brock' ,`ListOfficeName` = 'Vacasa Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.805055' ,`Longitude` = '-95.441702' ,`PhotoCount` = '31' ,`PostalCode` = '77008' ,`RoomCount` = '3' ,`ListPrice` = '625000.00' ,`Status` = 'Active' ,`StreetName` = 'Greengrass' ,`StreetNumber` = '2006' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2049' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful home is located in the prestigious Lazybrook neighborhood, close to White Oak Bayou Greenway Trail in a prime inner loop location minutes from downtown. This home has been meticulously maintained over the years by this long time owner. The roof was replaced around six years ago, there is an oversized two car garage with storage, an aluminum carport and the BBQ Pit is plumbed to natural gas. Washer, dryer and refrigerator are included with the sale of the home. Don\'t let this one get away!' ,`Acres` = '0.2066' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Timbergrove/Lazybrook' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 12 LAZYBROOK SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Back,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lazybrook 8' ,`TaxAmount` = '10122' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040742' WHERE `Matrix_Unique_ID` = '214774790' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T07:45:44.147' ,`MLSNumber` = '40452808' ,`ListAgentFullName` = 'Loretta Moehle' ,`ListOfficeName` = 'RE/MAX Lake Livingston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.704890' ,`Longitude` = '-95.073879' ,`PhotoCount` = '42' ,`PostalCode` = '77351' ,`RoomCount` = '13' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'Harbor View' ,`StreetNumber` = '250' ,`StreetSuffix` = 'Drive' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1536' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Can you say move in ready? This pristine 3/2.5/2 waterfront home is on a great location on Lake Livingston. Home is light and bright with open concept from the kitchen to dining to den room. Main bedroom down with guest bedrooms up allow for plenty of privacy. With 692 square feet of decks and balcony and a half bath down, this home is totally entertainment worthy. Lot has 52 feet of waterfront and a boat house area you will love! With one boat stall and two spaces for jet skis you will have room for all your toys! Home\'s cove location just seconds to big lake water gives you best of both worlds. Access to open water with no worries of bulkhead issues from storm wakes. Get up early to check out the amazing sunrise view from the dock! Subdivision has 2 boat ramps and is only 3 miles to the beautiful Tigerville park. Whether full time or vacation home you will have peace of mind with the SimpliSafe alarm system and Home Warranty that will convey with the home. Come take a look!' ,`Acres` = '' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 46 Shelter Cove Section 2' ,`LotDesciption` = 'Cleared,Subdivision Lot,Waterfront' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Shelter Cove' ,`TaxAmount` = '7210' ,`TaxRate` = '2.632' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040742' WHERE `Matrix_Unique_ID` = '214836110' --> 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','214922513','1669040743','214922513','2022-11-19T07:36:27.057','52648094','Alejandra Silva','JLA Realty','','','30.063171','-95.240760','34','77339','8','395900.00','Active','Somerset Shores','21300','Crossing','Kingwood','3','1','4','2610','Single-Family','Beautiful two story homes built by Censeo homes. this gorgeous open plan offers your family an over sized gourmet kitchen with a very large entertainment island, all open to double height ceilings in the family room. Open dinning, large master bedroom in the first floor as well as the study.','0.1404','40','','','','','Other Disclosures','','','','Kingwood West','Central Gas','1','S642411 - KINGS MILL 11, BLOCK 1, LOT 4','Other','6114','Appraisal District','','600','0','','2','','0','','','','','Composition','39 - New Caney','KINGS MANOR ELEMENTARY SCHOOL','PORTER HIGH SCHOOL (NEW CANEY)','WOODRIDGE FOREST MIDDLE SCHOOL','Lockbox Front','Appraisal District','2','Contemporary/Modern','Kings Mill 11','9761','3.1831','Water District','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','214930091','1669040743','214930091','2022-11-19T08:01:20.900','13572471','Gerri Empey','RE/MAX Leading Edge','','','29.459066','-95.063698','46','77539','4','365000.00','Active','Yupon','3527','Street','Dickinson','2','0','4','3056','Single-Family','Charming ranch style home on 2/3 acre! This sprawling one-level home has an open floor plan, with a formal living room, den/game room, & 4th bedroom - which could be used for a study or craft room. Primary bedroom has an en-suite bathroom with shower and vanity area. Second bath has a soaking tub and a spacious shower.\r\nThe kitchen boasts granite countertops, soft-close cabinets, a generous amount of storage and counter space, plus a large walk-in pantry. The fenced in, wooded backyard has citrus trees, greenhouse, deck and plenty of space for a pool! Owners installed electrical box connection for a generator. Great location, this home has it all!','0.6457','33','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Reports Available,Sellers Disclosure','1','','','Dickinson','Central Gas','0','ABST 19 PERRY & AUSTIN SUR NW 90 FT OF LOT 14 (4-1) FOSTER A','Cleared,Wooded','28125','Appraisal District','','','0','','2','Electric Oven','0','','','','','Composition','17 - Dickinson','CALDER ROAD ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','LOBIT MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Ranch','Foster','9071','2.5214','Public Sewer,Public Water,Water District','1984','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','214931934','1669040743','214931934','2022-11-19T08:18:32.247','10067901','Christopher Johns','Redfin Corporation','','','29.830365','-95.792913','35','77493','12','525000.00','Active','Cantone Grotto','3911','Court','Katy','3','0','4','2757','Single-Family','Stunning Princeton Classic Home on a beautiful waterfront cul-de-sac lot in Marcello Lakes community offering the best lot location on the large lake & quick access to Grand Parkway. This home\'s curb appeal begins w/ a manicured lawn, fresh landscaping, and stone elevation Inside features an open-layout design w/ soaring ceilings, LED lighting, & gorgeous lake views throughout. Down the wide entry hallway, find the formal dining & butler\'s pantry w/ a wine fridge that leads into the vast living space w/ gas fireplace & wall of windows drawing in tons of natural light. Eat-in kitchen boasts granite counters, SS gas appliances, a large island & a breakfast nook. The primary retreat offers breathtaking lake views & upgraded en-suite bath w/ incredible shower. 2 secondary bedrooms w/ a full bath, a guest bedroom, & home office complete this home. Lastly, a covered back patio w/ a gas stub ready for an outdoor kitchen, plenty of grass space, & your own private dock on the water.','0.1833','25','Princeton Classic Ho','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Katy - Old Towne','Central Gas','1','LT 64 BLK 1 MARCELLO LAKES SEC 1','Cul-De-Sac,Subdivision Lot,Waterfront','7986','Appraisal District','','1500','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','30 - Katy','LEONARD ELEMENTARY SCHOOL (KATY)','PAETOW HIGH SCHOOL','HASKETT JUNIOR HIGH SCHOOL','Supra Keybox','Appraisal District','1','Traditional','Marcello Lakes','13523','3.5333','Water District','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','214955615','1669040743','214955615','2022-11-19T07:42:38.527','62201552','Holly Jackson','RE/MAX ONE - Premier','','','29.826511','-94.824907','27','77523','6','325000.00','Active','Brazos','107','Drive','Baytown','2','0','4','1885','Single-Family','A beautiful, almost new home in River Farms! 4 beds, 2 baths and separate study. The kitchen is open to the dining area and living room making it perfect for entertaining. Patio and fenced backyard, low Chambers County taxes and conveniently located near shopping and restaurants. Barbers Hill ISD.','0.18','53','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Chambers County West','Central Gas','1','LT 12 BK 1 RIVER FARMS SEC 1','Subdivision Lot','7841','Appraisal District','','750','0','','2','Freestanding Oven','0','','','Freestanding Range,Gas Range','','Composition','6 - Barbers Hill','BARBERS HILL SOUTH ELEMENTARY SCHOOL','BARBERS HILL HIGH SCHOOL','BARBERS HILL SOUTH MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','1','Traditional','River Farms Sec 1','4456','1.656','Public Sewer,Public Water','2019','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','214960169','1669040743','214960169','2022-11-19T08:26:37.003','73171962','Jamie McMartin','Compass RE Texas, LLCKaty','','','29.735663','-95.914830','43','77494','8','304990.00','Active','Wildcat Way','29850','','Fulshear','2','0','3','1574','Single-Family','D.R. Horton\'s 1 story Denton Floorplan! 3 Bedrooms/2 Full Baths/2 Car Garage/1,574 SqFt. \"Smart Home\" all controllable through your Hub or smartphone. Gorgeous Kitchen with tons of designer touches! Primary Suite with large Primary Bath. Beautiful curb appeal with 3 sides brick. Tamarron offers everything you are looking for in a family friendly community- resort pool, splashpad, fitness center, sports fields, lakes & walking trails ready for you! Call today for your own private tour! Please verify with sales agent options and any upgrades.**PHOTOS ARE WHAT YOU CAN EXPECT FROM THE FLOORPLAN THEY DO NOT SHOW ACTUAL PROPERTY***At this time builder does not sell to Investors in this neighborhood*','','30','D.R. Horton','','Electric Dryer Connections,Washer Connections','','Mud','1','','0','Fulshear/South Brookshire/Simonton','Central Gas','1','Lot 72; Block 1; Section 55A','Cleared,Subdivision Lot','','','','1250','1','To Be Built/Under Construction','2','Gas Oven,Single Oven','0','','','Gas Range','','Composition','33 - Lamar Consolidated','TAMARRON ELEMENTARY SCHOOL','FULSHEAR HIGH SCHOOL','ROBERTS/LEAMAN JUNIOR HIGH SCHOOL','Appointment Required,No Supra Keybox','Builder','1','Ranch,Traditional','Tamarron','','2.96','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','214964536','1669040743','214964536','2022-11-19T08:16:05.673','27248459','Edward McClintick','Joseph Walter Realty, LLC','','','29.532774','-95.043795','25','77573','4','298500.00','Active','Cutter','2030','Drive','League City','2','1','4','2512','Single-Family','Looking for a home with plenty of space and plenty of style? Then come check out 2030 Cutter Dr in League City, TX. This two-story, four-bedroom, two and a half bathroom home has been updated in recent years with a new kitchen, primary en-suite, air conditioning, landscaping, and fence. You\'ll love the bamboo flooring throughout the main living areas. The open floorplan is perfect for entertaining, and the oversized lot provides plenty of room for outdoor activities. Don\'t miss your chance to see this one. A two week leaseback will be needed after closing. Property is being sold as-is.','0.2393','33','','','Electric Dryer Connections','','Sellers Disclosure','1','Gas Connections','1','League City','Central Electric','1','ABST 18 M MULDOON SUR LOT 28 BLK 4 HARBOUR PARK SEC 1','Subdivision Lot','10423','Appraisal District','','550','0','','2','Gas Oven','0','','','Gas Range','','Composition','9 - Clear Creek','FERGUSON ELEMENTARY SCHOOL','CLEAR CREEK HIGH SCHOOL','CLEAR CREEK INTERMEDIATE SCHOOL','Appointment Required','Appraisal District','2','Traditional','Harbour Park Rep Resv A90','5870','2.0697','Public Sewer,Public Water,Water District','1989','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','214964667','1669040743','214964667','2022-11-19T08:27:22.273','75258141','Edward McClintick','Joseph Walter Realty, LLC','','','29.191923','-96.285702','48','77437','3','199900.00','Active','Avenue K','609','','El Campo','2','0','3','1564','Single-Family','Easy flip/Great rental opportunity','0.2366','55','','','','','Sellers Disclosure','','','','','Central Electric','0','SANFORD 2ND BLOCK 9 LOT 6B,7','Other','10306','Appraisal District','','','0','','0','','0','','','','','Composition','198 - El Campo','','EL CAMPO HIGH SCHOOL','EL CAMPO MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Ranch','Sanford 2nd','4029','2.3981','Public Sewer','1957','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','214964808','1669040743','214964808','2022-11-19T08:46:04.707','4761973','Edward McClintick','Joseph Walter Realty, LLC','','','29.845605','-95.786962','25','77493','8','333000.00','Active','Padova Gardens','23722','Drive','Katy','2','0','3','2008','Single-Family','Looking for an open floor plan with plenty of space for entertaining?\r\nThis 3 bedroom, 2 bathroom home has a large living room with plenty of space for all your furniture. The kitchen is open to the living room and features a breakfast bar, perfect for quick meals or entertaining guests. The master bedroom is spacious and features a private bathroom with a walk-in shower.\r\nThe other two bedrooms are also spacious and have plenty of closet space.\r\nThis home is perfect for anyone who likes to entertain or just needs some extra space. Call today to schedule a showing. A five day leaseback will be needed after closing. Property is being sold as-is.','0.1448','25','','','','','Sellers Disclosure','1','','0','Katy - North','Central Gas','1','LT 56 BLK 1 VENTANA LAKES SEC 14','Subdivision Lot','6307','Appraisal District','','800','0','','2','Gas Oven','0','','','Gas Range','','Composition','30 - Katy','BETHKE ELEMENTARY SCHOOL','PAETOW HIGH SCHOOL','STOCKDICK JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Ranch','Ventana Lakes Sec 14','8739','3.2768','Public Sewer,Public Water','2018','Appraisal District'); --> New record created successfully