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` = '2023-01-28T14:28:08.260' ,`MLSNumber` = '85140207' ,`ListAgentFullName` = 'James Coate' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.373121' ,`Longitude` = '-95.192692' ,`PhotoCount` = '50' ,`PostalCode` = '77511' ,`RoomCount` = '13' ,`ListPrice` = '595000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 159' ,`StreetNumber` = '2421' ,`StreetSuffix` = '' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2257' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this well-maintained, dream property in Alvin ISD! Come tour 9.09 acres of classic country lifestyle, remote enough for quiet enjoyment, yet not too far from city amenities! From the gorgeous ranch-styled home to the sprawling hayfield in back, this property oozes potential! Mature oaks and palms grace the entrance, and the residence is a reasonable distance from the county road! Tall covered shed in rear for your heavy equipment! Lots of relaxing possibilities on the patio in back and the amazing 60\' covered porch in front! Once inside, you\'ll be amazed at the charming décor and room sizes! Find fantastic flooring throughout as well as a floor plan that makes sense! Combined formals! Remarkable den with an impressive fireplace! The kitchen is loaded with counter and cabinet space! Must see sunroom! All bedrooms with walk-in closets! Horses allowed! Great tax rate! No MUD! No HOA! No flood per owner! Short rides to downtown Houston and the beaches of Galveston!' ,`Acres` = '9.09' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0496 H T & B R R, TRACT 38-PT LOT 37, ACRES 1.590' ,`LotDesciption` = 'Other' ,`LotSize` = '395960' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'WALT DISNEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'ALVIN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'H T & B R R' ,`TaxAmount` = '4881' ,`TaxRate` = '2.2174' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265507' WHERE `Matrix_Unique_ID` = '203861376' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T14:07:53.930' ,`MLSNumber` = '83651798' ,`ListAgentFullName` = 'Lucy Ware' ,`ListOfficeName` = 'Birdsong Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.121981' ,`Longitude` = '-95.539949' ,`PhotoCount` = '11' ,`PostalCode` = '77515' ,`RoomCount` = '4' ,`ListPrice` = '385000.00' ,`Status` = 'Active' ,`StreetName` = 'Angus' ,`StreetNumber` = '471' ,`StreetSuffix` = 'Trail' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1985' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Under Construction! (Moore\'s Creek) This home will offer 3 bedrooms, 2 baths & a 2 car garage. The kitchen will have stainless steel appliances. Big living room that looks out to the covered patio. Spacious primary bedroom and bathroom. Home will be ready by October 31, 2022' ,`Acres` = '1' ,`Area` = '5' ,`BuilderName` = 'Kirk Enterprises' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'BAR X RANCH SEC 5 (A0038 J B BAILEY) BLK 7 LOT 125' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bar X Ranch Sec 5' ,`TaxAmount` = '340' ,`TaxRate` = '1.5738' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675265508' WHERE `Matrix_Unique_ID` = '206101971' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T14:17:32.050' ,`MLSNumber` = '76801188' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.293005' ,`Longitude` = '-95.565056' ,`PhotoCount` = '25' ,`PostalCode` = '77316' ,`RoomCount` = '4' ,`ListPrice` = '470000.00' ,`Status` = 'Active' ,`StreetName` = 'Sky Top' ,`StreetNumber` = '264' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2262' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 76801188 - Built by Highland Homes - Ready Now! ~ This beautiful floor plan features an enhanced outdoor living area, master separate shower with freestanding tub, pendant lighting over the kitchen island, built in appliances, painted kitchen cabinets, master bay window in primary bedroom, blinds throughout, quartz countertops in kitchen and secondary bathrooms, and vinyl plank flooring!! No back yard neighbors, this home backs up to a reserve.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '2/2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5100' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1391' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest' ,`TaxAmount` = '' ,`TaxRate` = '2.83' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675265508' WHERE `Matrix_Unique_ID` = '208208735' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T14:50:03.007' ,`MLSNumber` = '81386446' ,`ListAgentFullName` = 'Jennifer Perez' ,`ListOfficeName` = 'Texas Skyline Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.775999' ,`Longitude` = '-95.357742' ,`PhotoCount` = '26' ,`PostalCode` = '77009' ,`RoomCount` = '4' ,`ListPrice` = '279000.00' ,`Status` = 'Active' ,`StreetName` = 'Gentry' ,`StreetNumber` = '1708' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '888' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GREAT INVESTMENT PROPERTY WITH IMPROVED PRICE! Located in an up and coming area with great potential. 2 homes for the price of 1. So many choices for this investment. Contact agent for more information and schedule your tour today!' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 28 ALLEN A C' ,`LotDesciption` = 'Other' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHERMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Allen A C' ,`TaxAmount` = '3868' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1910' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265508' WHERE `Matrix_Unique_ID` = '208462704' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T14:07:16.083' ,`MLSNumber` = '25660229' ,`ListAgentFullName` = 'Diane Jacob' ,`ListOfficeName` = 'eXp Realty LLC' ,`SellingAgentFullName` = 'David Peterson' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '30.107339' ,`Longitude` = '-95.507606' ,`PhotoCount` = '48' ,`PostalCode` = '77389' ,`RoomCount` = '16' ,`ListPrice` = '1125000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Stratton Woods' ,`StreetNumber` = '5815' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4637' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the epitome of elegance! Stately Mediterranean style home just minutes from The Woodlands, Grand Parkway, dining & shopping. 4 Bedrooms, 3.5 Baths w/3 car garage, pool, spa, summer kitchen and even a 38kw generator! Prime location in a gated, luxury neighborhood. This home is flooded w/natural light from sunrise to sunset w/panoramic views of the outdoors from the main living areas! The living room has beamed ceilings, fireplace & wine grotto too; the ideal setting for entertaining. Supreme kitchen w/cushion close cabinets/drawers, large island, gas cooktop & pot filler. Primary suite is an awesome retreat w/pool view & spa like bath. Upstairs game room & media room extends the ample living/entertaining space. Easy to enjoy poolside charm while surrounded w/lush landscaping. The summer kitchen is fully equipped, even has solar blinds to enjoy year round. 10x12 pavilion creates a paradise type setting. Attention to detail throughout the entire home inside & out!' ,`Acres` = '0.2522' ,`Area` = '14' ,`BuilderName` = 'Partners in Building' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 39 BLK 1 STRATTON WOODS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10986' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2096' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'NORTHAMPTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HILDEBRANDT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Stratton Woods' ,`TaxAmount` = '16399' ,`TaxRate` = '2.664' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265508' WHERE `Matrix_Unique_ID` = '210222143' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T14:52:49.423' ,`MLSNumber` = '97283465' ,`ListAgentFullName` = 'Carla Rae Southard' ,`ListOfficeName` = 'The Virtual Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.801271' ,`Longitude` = '-95.651715' ,`PhotoCount` = '37' ,`PostalCode` = '77414' ,`RoomCount` = '7' ,`ListPrice` = '339862.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 297' ,`StreetNumber` = '2342' ,`StreetSuffix` = '' ,`City` = 'Sargent' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1827' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BACK ON THE MARKET!!!! This fabulous Three Bedroom 2 Bath home is ready for a new family to start making memories! This home is situated an a HALF ACRE Creek Front lot with beautiful trees and fenced in yard. Boat slip, Pier, Fish cleaning area and bulkhead is all in place for year round enjoyment. Inside, the first floor has a huge screened in porch with the perfect breeze, full kitchen, bathroom and living space. The interior stairs leading upstairs is where you will find 3 spacious bedrooms, utility room, BIG Bathroom and additional living space! Close to the Park, Boat Ramp and several Bait Camps!! Sargent Beach is a short drive to enjoy and this home is a short boat ride to great fishing! Enjoy fishing and crabbing from your own pier! 2 Storage rooms and a play area for the kids, make this home a perfect spot to enjoy all that Sargent, America has to offer!! Comes fully furnished too!!' ,`Acres` = '0.56' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CANEY CREEK ESTATES SEC 1, LOT 147' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '24394' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '60' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '134 - Van Vleck' ,`SchoolElementary` = 'VAN VLECK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'VAN VLECK HIGH SCHOOL' ,`SchoolMiddle` = 'O H HERMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Left Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Caney Creek Estates Sec 1' ,`TaxAmount` = '4558' ,`TaxRate` = '2.3895' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675265509' WHERE `Matrix_Unique_ID` = '210491466' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T14:41:37.457' ,`MLSNumber` = '30231667' ,`ListAgentFullName` = 'Nicole Freer' ,`ListOfficeName` = 'NICOLE FREER GROUP' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.212588' ,`Longitude` = '-95.647765' ,`PhotoCount` = '25' ,`PostalCode` = '77354' ,`RoomCount` = '17' ,`ListPrice` = '619990.00' ,`Status` = 'Active' ,`StreetName` = 'Regal Scott' ,`StreetNumber` = '27128' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3549' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ASHTON WOODS NEW CONSTRUCTION - Welcome home to 27128 Regal Scott Drive located in the community of NorthGrove and zoned to Magnolia ISD. The Richmond floorplan features 5 bedrooms, 4 full baths, 1 half baths and an attached 3 car garage. The first floor includes a formal dining room, a secondary bedroom great for an in-law suite, a kitchen open to the breakfast area and family room, and your primary suite. Come upstairs where you will find 3 additional bedrooms, game room and media room. Don\'t forget to step out back for a view of the backyard. You don\'t want to miss all this gorgeous home has to offer! Estimated completion is November 2022. Call to schedule your showing today! Days on market reflect the number of days the home has been under construction.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Ashton Woods' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'NorthGrove Section 9, Block 4, Lot 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8391' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1295' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'NorthGrove' ,`TaxAmount` = '' ,`TaxRate` = '3.21' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675265509' WHERE `Matrix_Unique_ID` = '210824465' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T14:07:53.930' ,`MLSNumber` = '27014560' ,`ListAgentFullName` = 'Manuel Becerra' ,`ListOfficeName` = 'Vive Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.336129' ,`Longitude` = '-95.311453' ,`PhotoCount` = '42' ,`PostalCode` = '77303' ,`RoomCount` = '7' ,`ListPrice` = '209500.00' ,`Status` = 'Active' ,`StreetName` = 'Crockett Bend' ,`StreetNumber` = '16377' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS HOME IS MOVE-IN READY! Welcome to your fully renovated home on a little over 1 acre. This home offers 4 bedrooms and 2 baths with plenty of outdoor space for the family to enjoy. All new appliances/cabinets can be found in the kitchen. Don\'t delay and make your appointment today; you will not be disappointed.' ,`Acres` = '1.0118' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S356100 - CROCKETT TRACE 01, BLOCK 3, LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '44074' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '260' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric 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,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Crockett Trace 01' ,`TaxAmount` = '2243' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265509' WHERE `Matrix_Unique_ID` = '210864311' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T14:07:53.930' ,`MLSNumber` = '26089172' ,`ListAgentFullName` = 'Stacy Thompson' ,`ListOfficeName` = 'Berkshire Hathaway HomeServicePremier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.806410' ,`Longitude` = '-95.843717' ,`PhotoCount` = '50' ,`PostalCode` = '77493' ,`RoomCount` = '9' ,`ListPrice` = '590000.00' ,`Status` = 'Active' ,`StreetName` = 'Coastal' ,`StreetNumber` = '2718' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3225' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Watch Video Tour of this beautiful one story stone and brick home in the heart of Cane Island. The Darby floor plan offers a desired open concept design. Woodgrain tile extends into the main rooms. Ina Garten would love cooking in the oversized gourmet island kitchen that has crisp white cabinets, granite counters, and stainless appliances. Working from home? You\'ll love the private enclosed office/study. Primary bedroom has a sitting area ideal for reading or exercise equipment. Huge primary closet! Soak the days stress away in large garden tub. Privacy is welcomed in bedroom 2 that is at the front of the house has a connecting full bathroom. Bedroom 3 & 4 surround an unexpected but welcomed bonus/game room. Big laundry room w/folding counter. Sprinkler, 3 car garage, no back neighbor. Amenities include: Parks, trails, pools, fitness center, yoga studio, conservatory. Book an appointment today!' ,`Acres` = '0.1964' ,`Area` = '25' ,`BuilderName` = 'David Weekley' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S422380 CANE ISLAND SECTION 20 BLK 3 LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8557' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cane Island' ,`TaxAmount` = '14364' ,`TaxRate` = '3.4077' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675265509' WHERE `Matrix_Unique_ID` = '210874217' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T14:07:53.930' ,`MLSNumber` = '24029194' ,`ListAgentFullName` = 'Tammie Bell' ,`ListOfficeName` = 'TBT Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.194698' ,`Longitude` = '-95.411090' ,`PhotoCount` = '25' ,`PostalCode` = '77515' ,`RoomCount` = '9' ,`ListPrice` = '525391.00' ,`Status` = 'Active' ,`StreetName` = 'Blue Bonnet' ,`StreetNumber` = '1528' ,`StreetSuffix` = 'Lane' ,`City` = 'Angleton' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3126' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Heritage Park in Angleton! Anglia Homes presents the Horton floor plan! This is a beautiful 2-story home with 4 bedrooms, 3.5 bathrooms, 3 car garage with a flex room and a game room upstairs. The kitchen opens up to the family room. The primary room is downstairs and secluded from the other bedrooms with a large walk in closet. You won\'t want to miss out on this home. Call today for your private showing!' ,`Acres` = '0.27' ,`Area` = '5' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'HERITAGE PARK SEC 2 (A0318 T S LEE) (ANGLETON) BLK 1 LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11761' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '125' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'RANCHO ISABELLA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Heritage Park' ,`TaxAmount` = '525' ,`TaxRate` = '2.6102' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675265510' WHERE `Matrix_Unique_ID` = '210986761' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T14:07:53.930' ,`MLSNumber` = '45556462' ,`ListAgentFullName` = 'Kevin Harberson' ,`ListOfficeName` = 'eXp Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.181042' ,`Longitude` = '-95.354012' ,`PhotoCount` = '38' ,`PostalCode` = '77302' ,`RoomCount` = '11' ,`ListPrice` = '760000.00' ,`Status` = 'Active' ,`StreetName` = 'Mcgregor' ,`StreetNumber` = '14612' ,`StreetSuffix` = 'Road' ,`City` = 'Conroe' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '3122' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'AirBnB where you live!! Rooms for colege kids or teens! 2 bdrm guest house w/kitchenette-separate from beautiful home. 2.5 unrestricted acres, 6 bdrms, 4 baths in all, with a beautiful 2441 sq ft home w/681 sq ft delightful guest house! 10 minutes from I-45,I-59 & Grand Parkway! Built in 2019, looks brand new. Main home has 4bdrm,3 full baths & a huge study/game rm. Gas firepl/ with beautiful wood mantel. Windows everywhere! The utility room can accommodate an extra fridge, freezer and water hook–up for a sink/ice maker, etc. Original home on the prop was built in the 60’s and repaired to use as a workshop or can be restored for RENTAL! Two sheds for mowers,4wheelers, bikes, toys, hay, etc.Huge 3.5 carport attached to home.Over 1000 ft of attic space w/flooring.NO FLOODING!The owners have 9 Nigerian Dwarf goats. They will convey with the property for $3000 or the owners will take them at closing. Fencing stays.Measurements are approximate.TAXES ARE BEING UPDATED FROM NEW BUILD.' ,`Acres` = '2.5' ,`Area` = '19' ,`BuilderName` = 'Americas Home Place' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BENNETTE J O H-OWENS, LOT 33-C, ACRES 2.500' ,`LotDesciption` = 'Cleared' ,`LotSize` = '108900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Bennette J O H-Owens' ,`TaxAmount` = '1015' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675265510' WHERE `Matrix_Unique_ID` = '211236728' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T14:07:53.930' ,`MLSNumber` = '39704620' ,`ListAgentFullName` = 'Karen Cox' ,`ListOfficeName` = 'The Cox Company Real Estate Gr' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.680671' ,`Longitude` = '-95.031880' ,`PhotoCount` = '50' ,`PostalCode` = '77351' ,`RoomCount` = '4' ,`ListPrice` = '775500.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Crest' ,`StreetNumber` = '398' ,`StreetSuffix` = 'Drive' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2587' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You will be captured by the 180 degree panoramic views from this gorgeous waterfront home. Located in a deep water, highly desirable neighborhood on a corner lot. The yard is landscaped, it has a beautiful large Oak tree that offers you shade as well as a wonderful place to swing and enjoy the breeze while relaxing. The covered porch and deck are spacious and offer you several sitting areas that are perfect for entertaining. The home was updated (2017) tastefully with high-end finishes: quartz countertops, solid hickory cabinets with pull-out drawers, new appliances, tile floors, energy efficient windows that are protected by very nice remote controlled shades. Baths were updated with double vanities & tiled showers. Storage room added to deck in 2013 and two-car garage provides ample storage. There is an reinforced steel bulkhead, big boathouse with 2 slips, storage for boating and fishing equipment & and sitting area. Don\'t let this one be the one that got away, call today!' ,`Acres` = '' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'OAK TERRACE ESTATES SECTION 2 LOT 27' ,`LotDesciption` = 'Corner,Subdivision Lot,Waterfront' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '25' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Craftsman' ,`Subdivision` = 'Oak Terrace Estates Sec 2' ,`TaxAmount` = '8010' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265510' WHERE `Matrix_Unique_ID` = '211512413' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T13:17:24.277' ,`MLSNumber` = '13601507' ,`ListAgentFullName` = 'Hai Le' ,`ListOfficeName` = 'Houston Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.941920' ,`Longitude` = '-95.360072' ,`PhotoCount` = '26' ,`PostalCode` = '77032' ,`RoomCount` = '4' ,`ListPrice` = '202000.00' ,`Status` = 'Active' ,`StreetName` = 'Whittier' ,`StreetNumber` = '2106' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1335' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fully remodel with new granite countertops in kitchen, bathroom. New painted cabinets. New fresh paint New carpet, new garage door. This house is on one of the largest lot in neighbor. \r\nThere bedrooms are all on second floor. Large family room on first floor. This house was never flooded through out all big hurricanes as its lots is one of the highest in neighborhood.' ,`Acres` = '0.1037' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 110 BLK 11 GREENBRIAR COLONY T/H' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot' ,`LotSize` = '4515' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '227' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CALVERT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'TEAGUE MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Greenbriar Colony T/H' ,`TaxAmount` = '2972' ,`TaxRate` = '2.5707' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265510' WHERE `Matrix_Unique_ID` = '211709363' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T14:07:53.930' ,`MLSNumber` = '78560105' ,`ListAgentFullName` = 'Sue Johnson' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.171980' ,`Longitude` = '-94.989851' ,`PhotoCount` = '45' ,`PostalCode` = '77554' ,`RoomCount` = '7' ,`ListPrice` = '699000.00' ,`Status` = 'Active' ,`StreetName` = 'Antigua' ,`StreetNumber` = '4405' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1760' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Drastically Reduced!! Just minutes from the Gulf w/ great gulf views! This charming 4 bed 3 bath home sits tucked away in Acapulco Village on the west end of Galveston Island. A cozy home offering an abundance of natural light, let in by the large windows in the family/dining room paired perfectly with the high ceilings. The layout of the home features an open kitchen/living/dining concept, making for a functional feel & a great floor plan. Follow the hallway to the added guest rooms & the primary bedroom with an ensuite, a perfect place to relax in. Upstairs sits an extra bedroom, large enough to accommodate a queen size bed & bunk beds, perfect for extra guests! Come enjoy & take in the nice views from the oversized deck with plenty of space to entertain family & friends. Recent updates include all 3 bathrooms top to bottom, flooring, AC & painting. Added bonus the garage is set for plumbing for a shower & toilet, yard quipped with sprinkler system & storm shutters.' ,`Acres` = '0.1567' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 22 ACAPULCO VILLAGE' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '6825' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Other Style' ,`Subdivision` = 'Acapulco Village' ,`TaxAmount` = '9918' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265511' WHERE `Matrix_Unique_ID` = '211848567' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T14:56:17.740' ,`MLSNumber` = '4962948' ,`ListAgentFullName` = 'Kirsten Abney' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.697832' ,`Longitude` = '-95.457144' ,`PhotoCount` = '32' ,`PostalCode` = '77401' ,`RoomCount` = '10' ,`ListPrice` = '739000.00' ,`Status` = 'Active' ,`StreetName` = 'Verone' ,`StreetNumber` = '4614' ,`StreetSuffix` = 'Street' ,`City` = 'Bellaire' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2120' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming 3 BR/2 BA home, located in the heart of Bellaire on a large lot, offers a warm, welcoming interior. The formal entry opens to the front living room which can accommodate large furniture & offers great versatility. Entertaining in style is easily accommodated in the large dining room & beautifully updated kitchen which boasts SS appliances, limestone counters, and a breakfast nook. A large sunroom with custom built-ins completes the living space & includes large windows & French doors overlooking the beautifully landscaped backyard. The spacious primary bedroom, privately situated upfront, offers three large closets & great natural light. An updated primary bath features a walk-in shower & spa like finishes. Both guest bedrooms offer walk-in closets. The updated guest bath features a tub/shower combo & spa like finishes. Conveniently located near the Med Center, Galleria, & Downtown, this home is close to many of the best restaurants & shopping areas Houston has to offer.' ,`Acres` = '0.2045' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bellaire Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT H BLK 5 TREPTOW' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8910' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HORN ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Treptow' ,`TaxAmount` = '11700' ,`TaxRate` = '2.2271' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265511' WHERE `Matrix_Unique_ID` = '211937000' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T14:07:53.930' ,`MLSNumber` = '12893384' ,`ListAgentFullName` = 'Bonnie Porter' ,`ListOfficeName` = 'Dynamic Home Pros, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.293443' ,`Longitude` = '-94.801368' ,`PhotoCount` = '41' ,`PostalCode` = '77550' ,`RoomCount` = '10' ,`ListPrice` = '699900.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue M 1/2' ,`StreetNumber` = '3207' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '6' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '2400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Hideaway Retreat is the perfect Airbnb. This gorgeous property comes fully furnished and ready to go! Close proximity to the beach and The Strand. Each unit is 3 bedrooms and 3 full baths, washer, dryer, and fridge come with each unit. Good Vibes Only Instagram Wall for Guests to post. Gorgeous private backyard with an amazing heated pool! Off street parking and access to a private back gate entrance. This is a STEAL OF A DEAL and will not last! Schedule your private tour today!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR W 40 FT OF LOT 6 (2006-1) SW BLK 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Galveston Outlots' ,`TaxAmount` = '5725' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265511' WHERE `Matrix_Unique_ID` = '212107498' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T13:08:08.403' ,`MLSNumber` = '12080536' ,`ListAgentFullName` = 'Cecilia Nunez' ,`ListOfficeName` = 'Nextgen Real Estate Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.857120' ,`Longitude` = '-95.443513' ,`PhotoCount` = '33' ,`PostalCode` = '77091' ,`RoomCount` = '4' ,`ListPrice` = '394900.00' ,`Status` = 'Active' ,`StreetName` = 'Joe Louis' ,`StreetNumber` = '6406' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2524' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand New Construction in area with lots of new development. This home offers high ceilings, granite counter-tops, open floor-plan, grand size primary bedroom, jacuzzi and separate shower, walk-in primary closet and so much more!' ,`Acres` = '0.1251' ,`Area` = '9' ,`BuilderName` = 'Rivera’s Constructio' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 INTERNATIONAL SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5450' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'ANDERSON ACADEMY' ,`SchoolHigh` = 'CARVER H S FOR APPLIED TECH/ENGINEERING/ARTS' ,`SchoolMiddle` = 'DREW ACADEMY' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'International Sec 02' ,`TaxAmount` = '342' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675265511' WHERE `Matrix_Unique_ID` = '212270720' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T14:07:53.930' ,`MLSNumber` = '47652979' ,`ListAgentFullName` = 'Genesis Garcia' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.159646' ,`Longitude` = '-95.084615' ,`PhotoCount` = '10' ,`PostalCode` = '77327' ,`RoomCount` = '4' ,`ListPrice` = '268990.00' ,`Status` = 'Active' ,`StreetName` = 'Road 5102B' ,`StreetNumber` = '40' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1401' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to \"The Ponderosa\" Plan by Casas Houston. This Gorgeous home sits on 0.53 of an acre. Low Tax area & HOA. This open floor plan has 9-foot ceilings. Home features formation luxury resilient flooring, granite countertops, 42\'\' floor cabinets, 36 upper cabinets with crown molding, sounded Sheetrock corners, ceiling fans, recessed lights. Energy efficiencies include Clay Brick, American Standard 16 SEER HVAC System, White Vinyl Double Pane Low E-windows, Programmable Thermostat Blown R-38 in flat areas, R-13 Batts in walls, windows, and doors. The Builder does offer a 2/10 warranty.' ,`Acres` = '' ,`Area` = '52' ,`BuilderName` = 'Casas Houston LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SANTA FE, SEC 3, BLOCK 50, LOT 6443' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe Sec 3' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265512' WHERE `Matrix_Unique_ID` = '212271792' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T14:07:53.930' ,`MLSNumber` = '75206262' ,`ListAgentFullName` = 'Genesis Garcia' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.159389' ,`Longitude` = '-95.084605' ,`PhotoCount` = '20' ,`PostalCode` = '77327' ,`RoomCount` = '6' ,`ListPrice` = '277990.00' ,`Status` = 'Active' ,`StreetName` = 'Road 5102B' ,`StreetNumber` = '50' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1505' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to \"The Bungalow XL\" Plan by Casas Houston. This Gorgeous home sits on 0.34 of an acre. Low Tax area & HOA. This open floor plan has 9-foot ceilings. Home features formation luxury resilient flooring, granite countertops, 42\'\' floor cabinets, 36 upper cabinets with crown molding, sounded Sheetrock corners, ceiling fans, recessed lights. Energy efficiencies include Clay Brick, American Standard 16 SEER HVAC System, White Vinyl Double Pane Low E-windows, Programmable Thermostat Blown R-38 in flat areas, R-13 Batts in walls, windows, and doors. The Builder does offer a 2/10 warranty.' ,`Acres` = '' ,`Area` = '52' ,`BuilderName` = 'Casas Houston LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Santa Fe/ Sec 3/ Lot: 6444' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265512' WHERE `Matrix_Unique_ID` = '212272149' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T13:08:08.403' ,`MLSNumber` = '88868463' ,`ListAgentFullName` = 'Sarah Hoffman' ,`ListOfficeName` = 'FYI Realty-Katy' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.809075' ,`Longitude` = '-95.422362' ,`PhotoCount` = '25' ,`PostalCode` = '77008' ,`RoomCount` = '4' ,`ListPrice` = '430000.00' ,`Status` = 'Active' ,`StreetName` = 'Bevis' ,`StreetNumber` = '2542' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2022' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 3 bed, 3.5 bath home in the heart of the heights has so many recent upgrades! New interior and exterior paint, new HVAC w/Remi Halo UV light (for allergens), new water heater, and new fence around the ONLY patio in Meyer Estates. Seller has cleared an additional small parking spot at front door in addition to gate access to the patio from side street! No HOA! Beautifully finished kitchen is open to the large dining/living combo on the second floor and the refrigerator stays! Upstairs you\'ll find a large primary retreat with spa-like bathroom. Each secondary bedroom has it\'s own bathroom. French doors lead into the downstairs secondary, that could be used as a home office. Within walking distance to great restaurants! Conveniently located between 290 and 45 for easy commutes.' ,`Acres` = '0.0374' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 1 MEYER ESTATES' ,`LotDesciption` = 'Other' ,`LotSize` = '1627' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Split Level' ,`Subdivision` = 'Meyer Estates' ,`TaxAmount` = '7089' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265512' WHERE `Matrix_Unique_ID` = '212314898' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T14:07:53.930' ,`MLSNumber` = '92500747' ,`ListAgentFullName` = 'Nicole Hill' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.162979' ,`Longitude` = '-95.630450' ,`PhotoCount` = '29' ,`PostalCode` = '77486' ,`RoomCount` = '10' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'S Amherst' ,`StreetNumber` = '317' ,`StreetSuffix` = '' ,`City` = 'West Columbia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1844' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction Loaded with upgrades and situated on a gorgeous lot, this is the one you will want to call home. A thoughtful open concept with attention to detail and views of a fabulous golf course lot. The chef\'s kitchen features custom cabinetry with soft close doors & drawers, above & below cabinet lighting, level 7 quartz counters with waterfall edge island, SS appliances and walk-in pantry. The family room is open to the kitchen and features a cozy fireplace with shiplap surround, as well as french doors leading out to the oversized covered patio. Your primary retreat has two closets, and the bath boasts dual vanities with LED mirrors, separate soaking tub and oversized tile shower with rain head. Other features include 3 car garage, oversized covered back patio with gas stub out, outdoor eave lighting, full sod, sprinkler system and more. Columbia Lakes is about an hour from Houston with a laid-back country feel' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Cornhusker Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Columbia Lakes Sec 1-2-3-4 Sec 3 (A0133 M Varner)' ,`LotDesciption` = 'Cleared,On Golf Course' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Columbia Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675265512' WHERE `Matrix_Unique_ID` = '212395786' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T13:08:08.403' ,`MLSNumber` = '48229944' ,`ListAgentFullName` = 'Tiffany LaRose' ,`ListOfficeName` = 'The LaRose Kaileh Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.739852' ,`Longitude` = '-95.445783' ,`PhotoCount` = '42' ,`PostalCode` = '77027' ,`RoomCount` = '10' ,`ListPrice` = '3395000.00' ,`Status` = 'Active' ,`StreetName` = 'Essex' ,`StreetNumber` = '4006' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Another Carol Isaak Barden project: House 21. The House of Many Palms, situated in the prestigious Highland Village subdivision, has been influenced by the glamorous luxury of West Palm Beach. Situated on a 7,700 square foot lot, the gated 5 bedroom, 4 1/2 bath home, has a spacious kitchen and vast entertaining area, a north-facing tropical garden, and is designed for indoor and outdoor living. Amenities include a soaring 24-foot entrance, an elevator shaft, and massive amounts of storage. The house has many large walls having been designed with art collectors in mind. Scott Strasser, designer, gave the house transformational rooms infused with natural light. Developer Carol Isaak Barden avoided cold, austere spaces in favor of luxurious finishes and lighting.' ,`Acres` = '0.1768' ,`Area` = '16' ,`BuilderName` = 'Carol Isaak Barden' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Highland Village/Midlane' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 54 BLK 5 HIGHLAND VILLAGE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SCHOOL AT ST GEORGE PLACE' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Highland Village' ,`TaxAmount` = '16690' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675265513' WHERE `Matrix_Unique_ID` = '212514924' --> 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','212685914','1675265513','212685914','2023-01-28T13:08:08.403','22333748','Shane Bergeson','Stanfield Properties','','','29.482052','-95.179814','47','77546','11','2025000.00','Active','Sierra Madre','2513','Street','Friendswood','3','0','4','2963','Single-Family','Horse lover\'s dream on nearly 5 acres in Friendswood ISD! Bring your horses & ride day or night in your private 80\'x150\' lighted & covered arena, complete with cross fencing with horse safe-vinyl & a horse barn with up to 5 stalls with rubber mats, an extra wide aisle, a wash rack with hot water, & a feed/tack room. A gated entrance lined with sprawling oak trees lines the path to the stunning stained glass doors that open into this recently updated single-story steel frame custom home that boasts two gorgeous stone fireplaces, high ceilings, & incredible views of the horse pasture & 40-acre spring-fed lake with private access. In addition, the home offers a sparkling sport pool, a 50\'x30\' workshop, an irrigation system for easy maintenance, & a 3-car garage with guest quarters that are ideal for a home office or for multi-generational living. Nestled deep in Rancho Viejo on a quiet cul-de-sac with no HOA fees, this never flooded home is priced to sell as part of an estate settlement.','4.7538','33','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','2','Friendswood','Central Gas','0','ABST 9 PAGE 14 & 15 LOT 144 SLONES SUB','Subdivision Lot','207075','Appraisal District','','','0','','3','Electric Oven','1','Gunite','','Gas Cooktop','','Composition','20 - Friendswood','CLINE ELEMENTARY SCHOOL','FRIENDSWOOD HIGH SCHOOL','FRIENDSWOOD JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal','1','Traditional','Slone 1','18070','2.2832','Public Sewer,Public Water','1997','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T14:07:53.930' ,`MLSNumber` = '477525' ,`ListAgentFullName` = 'Devon Hackle' ,`ListOfficeName` = 'New Home Guide Texas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.478072' ,`Longitude` = '-95.455159' ,`PhotoCount` = '29' ,`PostalCode` = '77583' ,`RoomCount` = '9' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'BAKERSFIELD' ,`StreetNumber` = '7227' ,`StreetSuffix` = 'Court' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1889' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to a Never Lived In home in Glendale Lakes that is Move-In Ready for you. This home boasts a brick entry which extends down both sides, extended entry, covered patio & a Den Room that can be converted into a 4th bedroom. Entertain guests in the Open Kitchen Area, complete with granite countertops, stainless steel Energy Star appliances & 42-in cabinets. Retreat to the primary bedroom & bathroom with a walk-in closet, extended dual vanities & a shower/tub combo with tile backsplash. Situated off FM-521, Hwy 288, Hwy 6 & Beltway 8, commuters enjoy the ease of access to Downtown Houston, Pearland, Sugar Land & The Texas Medical Center. Zoned to Fort Bend ISD.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 13, BLOCK 4 GLENDALE LAKES SECTION 10' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'GLENDALE LAKES' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675265513' WHERE `Matrix_Unique_ID` = '212728631' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T14:11:08.533' ,`MLSNumber` = '10491428' ,`ListAgentFullName` = 'Luis F. Mendoza' ,`ListOfficeName` = 'Veronica Mendoza Realty, LLC.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.555197' ,`Longitude` = '-95.633495' ,`PhotoCount` = '50' ,`PostalCode` = '77479' ,`RoomCount` = '11' ,`ListPrice` = '680000.00' ,`Status` = 'Active' ,`StreetName` = 'Cranston' ,`StreetNumber` = '5527' ,`StreetSuffix` = 'Court' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3212' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Largest lot in Subdivision, two story entry foyer with curved stairs, offers formal areas, home office, family den, ample kitchen, breakfast bar and ,morning area, all ceramic tile and wood floors (no carpet) main bedroom down, game room up, lots of crown moldings and custom closets, custom attic space, big patio cover with bar, superb sparkling pool and spa with a huge back yard.' ,`Acres` = '0.3417' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'AVALON - VILLAGES OF AVALON SEC 3, BLOCK 3, LOT 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14886' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'COMMONWEALTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FORT SETTLEMENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Villages Of Avalon Sec 3' ,`TaxAmount` = '11043' ,`TaxRate` = '2.1244' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265513' WHERE `Matrix_Unique_ID` = '212989709' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T14:19:45.893' ,`MLSNumber` = '7446120' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.294584' ,`Longitude` = '-95.564546' ,`PhotoCount` = '49' ,`PostalCode` = '77316' ,`RoomCount` = '4' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Sky Top' ,`StreetNumber` = '210' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1905' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 7446120 - Built by Highland Homes - Ready Now! ~ The Bristol features rear brick, island upgrade, built in appliances, 8 foot hollow core interior doors, pendant lighting, primary bathroom 5\' drop in tub. primary bedroom bay window, Quartz countertops in kitchen and primary bathroom. Wood look tile throughout except bedrooms! No back yard neighbors backs up to a reserve.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '13/2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1350' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest 40\'-50\'' ,`TaxAmount` = '' ,`TaxRate` = '2.68' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675265513' WHERE `Matrix_Unique_ID` = '212997650' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T14:07:53.930' ,`MLSNumber` = '41373423' ,`ListAgentFullName` = 'Kami Cudd' ,`ListOfficeName` = 'Green & Associates Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.344959' ,`Longitude` = '-95.530910' ,`PhotoCount` = '38' ,`PostalCode` = '77304' ,`RoomCount` = '7' ,`ListPrice` = '319900.00' ,`Status` = 'Active' ,`StreetName` = 'Billingsgate Chase' ,`StreetNumber` = '483' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1980' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful David weekly floor plan located on a Greenbelt and a cul-de-sac lot. Wonderfully maintained and ready for move-in. The back porch has been extended and partially screened in. Located to all major roads and highways, retail/shopping and schools. All appliances stay. ' ,`Acres` = '0.1399' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S582102 - HILLS OF WESTLAKE 02, BLOCK 4, LOT 7' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '6095' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hills Of Westlake 02' ,`TaxAmount` = '6810' ,`TaxRate` = '2.8638' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265514' WHERE `Matrix_Unique_ID` = '213113251' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T14:07:53.930' ,`MLSNumber` = '82561987' ,`ListAgentFullName` = 'Lindsay Lamont' ,`ListOfficeName` = 'All City Real Estate, Ltd. Co.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.816501' ,`Longitude` = '-95.536384' ,`PhotoCount` = '40' ,`PostalCode` = '77080' ,`RoomCount` = '1' ,`ListPrice` = '515000.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Village' ,`StreetNumber` = '2503' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2140' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 2503 Pine Village Drive, a completely remodeled home located in the highly desired neighborhood of Spring Shadows. This charming 4 bed, 2 bath home located at the end of a cul-de-sac, next to a green space, has undergone a complete transformation. The fully remodeled kitchen boasts quartz countertops, new soft close cabinets, down-draft gas stovetop, a combined microwave and oven unit, and workstation sink with accessories. Major updates include all new HVAC, PEX plumbing, water heater, completely updated bathrooms, updated electrical panel and wiring and a recent roof. In addition to all of those things, there are new hardwood floors, interior and exterior doors, windows, fresh paint inside and out, all new light fixtures, all new appliances and more. Great location near parks, trails, activities, dining options, great schools, and entertainment options in City Centre, Memorial City, and the Energy Corridor. This is a must see! Owner/agent.' ,`Acres` = '0.1933' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 5 SPRING SHADOWS SEC 4' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '8421' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '336' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'SPRING SHADOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING WOODS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Shadows Sec 04' ,`TaxAmount` = '6691' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265514' WHERE `Matrix_Unique_ID` = '213148973' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T14:54:14.953' ,`MLSNumber` = '89797063' ,`ListAgentFullName` = 'Carla Rae Southard' ,`ListOfficeName` = 'The Virtual Realty Group' ,`SellingAgentFullName` = 'Carla Rae Southard' ,`SellingOfficeName` = 'The Virtual Realty Group' ,`Latitude` = '28.810037' ,`Longitude` = '-95.665586' ,`PhotoCount` = '35' ,`PostalCode` = '77414' ,`RoomCount` = '5' ,`ListPrice` = '374862.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Private Road 652' ,`StreetNumber` = '141' ,`StreetSuffix` = '' ,`City` = 'Sargent' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1204' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEAT AS A PIN!! This very well maintained home on THREE WATERFRONT Bulkheaded Lots along with 3 full lots across the street is PRICED TO SELL!! Furnished 2/1 has vaulted ceilings in the Combo Living/Dining Kitchen Area, French doors lead out to the amazingly beautiful shaded backyard! Patio and Picnic Area are the perfect spot to enjoy yourselves year round. Also this home comes with a two car oversize garage and storage shed. The bedrooms are very comfortable size and the walk in shower is a big plus as well. Live Oak Bend offers a great boat ramp, just up the road too. Great Location in this Deed Restricted Waterfront Community, just a short drive to Sargent Beach, several Bait Camps, local restaurants and Matagorda Bay Fishing!! A Short 90 minute drive from Houston and we also have a Regional airport 15 minutes away!! WATER YOU WAITING FOR!! This Jewel will not last long!!' ,`Acres` = '0.593' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Freestanding,Stove,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LIVE OAK BEND SEC 1, LOT 10,11,12' ,`LotDesciption` = 'Subdivision Lot,Waterfront,Wooded' ,`LotSize` = '25831' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '134 - Van Vleck' ,`SchoolElementary` = 'VAN VLECK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'VAN VLECK HIGH SCHOOL' ,`SchoolMiddle` = 'O H HERMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Live Oak Bend Sec 1' ,`TaxAmount` = '7029' ,`TaxRate` = '2.3895' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265514' WHERE `Matrix_Unique_ID` = '213624039' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T13:01:11.643' ,`MLSNumber` = '55492412' ,`ListAgentFullName` = 'Julie Ruffeno' ,`ListOfficeName` = 'The Ruffeno Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.668929' ,`Longitude` = '-96.238943' ,`PhotoCount` = '20' ,`PostalCode` = '77845' ,`RoomCount` = '9' ,`ListPrice` = '359000.00' ,`Status` = 'Active' ,`StreetName` = 'Hardy Weedon' ,`StreetNumber` = '6401' ,`StreetSuffix` = 'Road' ,`City` = 'College Station' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1905' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 3 bedroom/2.5 bath, 1,905 sq. ft. home on almost 3/4 of an acre in Forest Lakes. Open concept design with split bedroom floorplan in this move-in ready home. Granite countertops and island in the spacious kitchen that opens into the living area is perfect for entertaining or enjoying time spent with family. The large living area, complete with wood burning fireplace is great for family gatherings or the college student looking for a place to call home during their time in College Station. A spacious utility room and home study/office are also added amenities. Tile floors throughout, and carpet in the bedrooms make cleaning easy. This home offers a huge fenced in back yard and a two-car garage that doubles as a gameroom/man cave! Forest Oaks also offers access to the beautiful Brooke Lake, located in the community, which is just far enough from the hustle and bustle of town, but close enough to enjoy all the shopping and restaurants Bryan/College Station have to offer.' ,`Acres` = '0.73' ,`Area` = '61' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'FOREST LAKES, LOT 138' ,`LotDesciption` = 'Corner' ,`LotSize` = '31799' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '105' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '148 - Bryan' ,`SchoolElementary` = 'ALTON BOWEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRYAN HIGH SCHOOL' ,`SchoolMiddle` = 'STEPHEN F. AUSTIN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Forest Lakes' ,`TaxAmount` = '5808' ,`TaxRate` = '1.7488' ,`WaterSewer` = 'Aerobic,Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265514' WHERE `Matrix_Unique_ID` = '213688907' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T14:07:53.930' ,`MLSNumber` = '39747362' ,`ListAgentFullName` = 'Joshua Kartzmark' ,`ListOfficeName` = 'Keller Williams Met Inner Loop' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.652652' ,`Longitude` = '-95.720843' ,`PhotoCount` = '31' ,`PostalCode` = '77406' ,`RoomCount` = '8' ,`ListPrice` = '499999.00' ,`Status` = 'Active' ,`StreetName` = 'Bayou Hollow' ,`StreetNumber` = '4210' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2864' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'OPEN HOUSE SAT \r\nSat: 11-2\r\r\n\r\nGorgeous, inviting & energy-efficient! This 2-story floor plan has 4 generously sized bedrooms, ample storage and a second-story game room comfortably accommodate the whole family. There are tons of great features, including a rare water manifold system, beautiful granite counter tops, and a centerpiece fire place! With direct access to the Grand Parkway and 99, prime location in the Fort Bend School District, including a 2 minute walk to James C Neill Elementary, you will love calling Harvest Green home. Peaceful covered back porch... you don’t want to miss this one!' ,`Acres` = '0.1578' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'HARVEST GREEN SEC 12, BLOCK 1, LOT 32' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6875' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '985' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'NEILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'BOWIE MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harvest Green Sec 12' ,`TaxAmount` = '10728' ,`TaxRate` = '3.1129' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265515' WHERE `Matrix_Unique_ID` = '213756657' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T14:39:08.293' ,`MLSNumber` = '18663196' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.293212' ,`Longitude` = '-95.564314' ,`PhotoCount` = '25' ,`PostalCode` = '77316' ,`RoomCount` = '4' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Sky Top' ,`StreetNumber` = '251' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2572' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 18663196 - Built by Highland Homes - Ready Now! ~ This beautiful floor plan features an enhanced outdoor living area, primary separate shower with a freestanding tub, sliding glass doors @ patio, pendant lighting over the kitchen island, built in appliances, painted kitchen cabinets, 8\' doors throughout, primary bay window in primary bedroom, blinds throughout, Quartz countertops in kitchen and secondary bathrooms' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S965280 - WOODFOREST 80, BLOCK 1, LOT 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1391' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest 40\' and 50\'' ,`TaxAmount` = '' ,`TaxRate` = '2.68' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675265515' WHERE `Matrix_Unique_ID` = '213843508' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T13:38:09.027' ,`MLSNumber` = '51588179' ,`ListAgentFullName` = 'Gregory Cordova' ,`ListOfficeName` = 'CENTURY 21 Western Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.557525' ,`Longitude` = '-95.738889' ,`PhotoCount` = '42' ,`PostalCode` = '77469' ,`RoomCount` = '13' ,`ListPrice` = '530000.00' ,`Status` = 'Active' ,`StreetName` = 'Spindrift' ,`StreetNumber` = '534' ,`StreetSuffix` = 'Circle' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2540' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LAKEHOUSE/LAKE VIEW 3 bed/2 bath home. Wide driveway w/golf cart garage parking. Beautiful wooden front door invites you in. Formal dining, living, den/sunroom, kitchen & breakfast nook are open allowing for seamless entertaining of friends & guests, overlooking expansive view of the Lake! Living rm: tray ceiling elevates & crown molding adorns your space, engineered hardwoods continue throughout, w/carpet- bedrooms & tile- bath. Kitchen boasts convenience package: elevated dishwasher, pots/pans drawers, breakfast bar, filtered drinking water, soap dispenser, granite counters, 5 gas cooktop w/designer decorative backsplash. Owners suite & en-suite bathroom: granite counters, dual sinks, walk-in rainfall shower w/wall spa jets & pebbled flooring. HUGE walkin closet w/built-ins. 2 Guest bed- perfect for visitors/home office w/additional full bathroom: tub/shower combo. Back covered patio perfect for entertaining or sit back & relax. Laundry rm w/sink basin. Call today for private showing' ,`Acres` = '0.1641' ,`Area` = '30' ,`BuilderName` = 'Pulte' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'DEL WEBB RICHMOND SEC 15, BLOCK 1, LOT 2' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '435' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'PHELAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Del Webb Sweetgrass' ,`TaxAmount` = '11038' ,`TaxRate` = '2.9548' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265515' WHERE `Matrix_Unique_ID` = '214038160' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T14:07:53.930' ,`MLSNumber` = '54616092' ,`ListAgentFullName` = 'Bonnie Porter' ,`ListOfficeName` = 'Dynamic Home Pros, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.307189' ,`Longitude` = '-94.778767' ,`PhotoCount` = '35' ,`PostalCode` = '77550' ,`RoomCount` = '9' ,`ListPrice` = '599900.00' ,`Status` = 'Active' ,`StreetName` = 'Church' ,`StreetNumber` = '1013' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2172' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your gorgeous Coastal Oasis! Beautiful hardwood floors, open concept, huge kitchen island with gorgeous quartz countertops. 4 Large bedrooms and an additional bunk room. This amazing historical Victorian beauty boast a spacious primary bedroom with a luxurious primary bath retreat and private balcony for those morning cups of coffee or evening sips of wine with a good book. Primary bath includes and free standing soaker tub, rainfall shower and large vanity. Private gated backyard with a large deck to entertain and enjoy the sea breeze. Automatic gate with ally access and private off street parking. Schedule your private tour today!' ,`Acres` = '0.0885' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR E 1/2 OF LOT 4 & W 10-8.5 FT OF LOT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3855' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Victorian' ,`Subdivision` = 'Galveston Townsite' ,`TaxAmount` = '5388' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265515' WHERE `Matrix_Unique_ID` = '214047239' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T14:07:53.930' ,`MLSNumber` = '63480107' ,`ListAgentFullName` = 'Elizabeth Rodriguez' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.873716' ,`Longitude` = '-95.631673' ,`PhotoCount` = '35' ,`PostalCode` = '77084' ,`RoomCount` = '7' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Willow Hearth' ,`StreetNumber` = '14919' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2380' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Stunning home is located in Hearth Stone place subdivision, Conveniently located near Farm to Market 1960 Rd, easy access to beltway 8 and Hwy 290. Home was fully remodeled in 2018, patio was added in 2021, A/C installed in 2015 and New roof in 2016. Check out all the oversize bedrooms and the Huge master bedroom very rare to find. Can\'t forget the large kitchen to do all your cooking and the large covered patio to enjoy during those hot sunny days. Don\'t miss out on this house, Book your showing today!' ,`Acres` = '0.1205' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 2 HEARTHSTONE PLACE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '387' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HORNE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hearthstone Place Sec 01' ,`TaxAmount` = '6592' ,`TaxRate` = '3.171' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265516' WHERE `Matrix_Unique_ID` = '214067231' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T14:07:53.930' ,`MLSNumber` = '6441955' ,`ListAgentFullName` = 'Linda Moreno' ,`ListOfficeName` = 'CUFG Keystone Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.283298' ,`Longitude` = '-97.682727' ,`PhotoCount` = '32' ,`PostalCode` = '78721' ,`RoomCount` = '8' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Bandera Road' ,`StreetNumber` = '4701' ,`StreetSuffix` = '' ,`City` = 'Austin' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2205' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location. Location. Location. Just minutes from downtown Austin. Check out this 3 bedroom, 3 bath ranch home with a private yard. Close proximity to Mueller. Minutes away from Austin Bouldering Project, Breweries, Coffee Shops, and all that the Eastside has to offer! Amazing opportunity in a booming area! **Buyer to verify school and taxes**' ,`Acres` = '0.135' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 8 BLK C OAK LAWN SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '5881' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '111 - Austin' ,`SchoolElementary` = 'NORMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHEAST EARLY COLLEGE HIGH SCHOOL' ,`SchoolMiddle` = 'MARTIN MIDDLE SCHOOL (AUSTIN)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Oak Lawn' ,`TaxAmount` = '7341' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265516' WHERE `Matrix_Unique_ID` = '214107066' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T13:08:08.403' ,`MLSNumber` = '35414450' ,`ListAgentFullName` = 'Cheryl Stovall' ,`ListOfficeName` = 'Birdsong Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.944242' ,`Longitude` = '-95.297151' ,`PhotoCount` = '29' ,`PostalCode` = '77541' ,`RoomCount` = '2' ,`ListPrice` = '294900.00' ,`Status` = 'Active' ,`StreetName` = 'Texas' ,`StreetNumber` = '514' ,`StreetSuffix` = '' ,`City` = 'Surfside Beach' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '775' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'AMAZING OPPORTUNTY!!!! Dreamed of a beach getaway home, a beach residence, or rental opportunity? This one checks all the boxes! Remodeled beach home waiting for you! One bedroom perfect for either two bunk beds or larger bed to be used as a primary bedroom, Second bedroom great for bunk beds or a day sleeper. Large living area perfect for sleeper sofas, dining table - you name it, the possibilities are endless! Both bedrooms have brand new window units, additional unit in kitchen, and living space with a window unit with both cool and heat for those cool beach nights. Amazing location to the jetty\'s and beach access! Under the home is an area that is plumbed and could be converted to additional living space or storage. Home is available to be purchased furnished. Go ahead and bring the pets, there is also a gated area! Do not miss this one, it is sure to go fast!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'SURFSIDE BLK 549 LOT 9 (SE/2) (A0051 F J CALVIT)' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Surfside' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265516' WHERE `Matrix_Unique_ID` = '214128191' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T13:48:41.810' ,`MLSNumber` = '32429318' ,`ListAgentFullName` = 'Judith Vargas' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.222109' ,`Longitude` = '-95.308038' ,`PhotoCount` = '23' ,`PostalCode` = '77302' ,`RoomCount` = '5' ,`ListPrice` = '179000.00' ,`Status` = 'Active' ,`StreetName` = 'Wagon Wheel' ,`StreetNumber` = '15743' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home with spacious lot available 5 minutes North of of 99. Schedule your showing today. Home has open Floorplan with Large Primary Bedroom and Bath. Unlimited possibilities with clean lot. This 3 Bedroom, 2 bath home could keep you cozy this winter with the warm log-burning fireplace as the centerpiece of this home.' ,`Acres` = '0.6912' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S949302 - WESTERN HILL ESTATES 02, BLOCK 2, LOT 4, SERIAL #' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '30108' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'HOPE ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Western Hill Estates 02' ,`TaxAmount` = '1065' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265516' WHERE `Matrix_Unique_ID` = '214188076' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T13:43:46.133' ,`MLSNumber` = '27082918' ,`ListAgentFullName` = 'Cody Horn' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = 'Michele Harmon' ,`SellingOfficeName` = 'RE/MAX Universal' ,`Latitude` = '30.213858' ,`Longitude` = '-95.163707' ,`PhotoCount` = '49' ,`PostalCode` = '77372' ,`RoomCount` = '13' ,`ListPrice` = '599000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Enloe' ,`StreetNumber` = '15909' ,`StreetSuffix` = 'Street' ,`City` = 'Splendora' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2327' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is very well kept and in a very nice deed restricted neighborhood. It has 4 bedrooms and 2 1/2 baths with an office and attached 21x22 garage. High ceilings in the living room and primary bedroom with lots of natural light. Very large covered back porch for those shady evenings and get togethers. The large detached shop/garage has 3 separate sections. The left side is 16x40 with insulated roof, the middle section is 19x26 and fully insulated, the right side and wrapped around the middle portion is a 1 bedroom 1 bath living quarters/apartment with utility room(roughly 580 sqft in total). It has 2.15 acres with a fully fenced back yard to keep you and the animals in the pasture separated. The barn has 5 stalls, a tack/feed room and the back pasture is fully fenced and ready for your animals if you choose to have them (FFA/4H ready).' ,`Acres` = '2.1528' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PARKLAND COMMUNITY 01, LOT 24' ,`LotDesciption` = 'Cleared' ,`LotSize` = '93775' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'PEACH CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkland Community 01' ,`TaxAmount` = '9933' ,`TaxRate` = '2.4206' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265517' WHERE `Matrix_Unique_ID` = '214207863' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T14:07:53.930' ,`MLSNumber` = '95098594' ,`ListAgentFullName` = 'Julie Woods' ,`ListOfficeName` = 'RE/MAX Space Center-Clear Lake' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.545038' ,`Longitude` = '-95.207655' ,`PhotoCount` = '37' ,`PostalCode` = '77546' ,`RoomCount` = '11' ,`ListPrice` = '899000.00' ,`Status` = 'Active' ,`StreetName` = 'Southfield' ,`StreetNumber` = '505' ,`StreetSuffix` = 'Drive' ,`City` = 'Friendswood' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '3667' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Step into the grand entry of this beautiful Brentwood custom home & you will know this family made many wonderful memories here. Lot is largest & most private in Northfield Estates. Enjoy the salt water pool w/water feature, hot tub, sunning deck & in-pool table & seats. 3 car garage attached to house & 2 car detached garage w/carport & 1,300 sf space above garage ready for whatever you can dream. Throughout the home you will notice custom crown molding, amazing door & window casings, beautiful ceilings, built-in cabinets & shelves. Incredible oversized dining room for family gatherings. Private study w/built-ins. Kitchen w/double ovens, silestone counters, butcher block island w/sink & separate bar area. Primary en suite tucked away beside the living room w/features like a sitting area, rainfall shower, jetted tub & AMAZING closet! Secondary bedrooms/bathrooms have their own den/playroom area. Download \"Features & Upgrades\" sheet for all the details. Ready to make you