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-28T01:22:36.550' ,`MLSNumber` = '93105814' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.467127' ,`Longitude` = '-95.249809' ,`PhotoCount` = '11' ,`PostalCode` = '77511' ,`RoomCount` = '13' ,`ListPrice` = '349990.00' ,`Status` = 'Active' ,`StreetName` = 'Selah' ,`StreetNumber` = '352' ,`StreetSuffix` = 'Court' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2593' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 Story, 4 Bedroom, 2 1/2 Bath, Study, Formal Dining, Game Room Up, Primary Bedroom Up, Granite Topped Dual Vanities in Primary Bath, Separate Garden Tub and Shower, Rigid Core Floors in Entry, Bathrooms, Dining Room, Kitchen, and Family Room, Granite Kitchen Countertops with Island, Tile Backsplash, 42\" Upper Kitchen Cabinets, Stainless Steel Appliances, Wrought Iron Stair Parts, Covered Back Patio, Cul de Sac Home Site, Irrigation System in Front and Side Yards, Garage Door Opener, Tech Shield Radiant Barrier, Environments for Living Home, plus more…AVAILABLE NOW.' ,`Acres` = '0.1354' ,`Area` = '5' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 3 BLK 1 SEC 10' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '5897' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MARK TWAIN ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'G W HARBY J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kendall Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675265302' WHERE `Matrix_Unique_ID` = '203980713' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T01:22:36.550' ,`MLSNumber` = '57833435' ,`ListAgentFullName` = 'Andrea Kitzmann' ,`ListOfficeName` = 'Keller Williams Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.677386' ,`Longitude` = '-96.423120' ,`PhotoCount` = '20' ,`PostalCode` = '77807' ,`RoomCount` = '6' ,`ListPrice` = '283900.00' ,`Status` = 'Active' ,`StreetName` = 'Rock Ridge' ,`StreetNumber` = '2015' ,`StreetSuffix` = 'Avenue' ,`City` = 'Bryan' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1605' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exquisite 3 bed, 2 bath home on oversized lot in Pleasant Hill from DR Horton! Beautifully constructed, the Roosevelt offers an open concept floor plan with a spacious living room open to the kitchen, dining area, and much more. Enjoy cooking in the gourmet kitchen featuring granite counters, Espresso cabinetry, pantry, and stainless appliance package. Escape to the primary suite with separate tile shower, and huge walk-in closet. Smart home features include video doorbell, programmable thermostat, and smart lights at the front entry. Be one of the first to live in Phase 2 of this subdivision conveniently located just minutes to Lake Bryan, Texas A&M’s RELLIS Campus, Historic Downtown Bryan, and a quick jaunt to the heart of Bryan/College Station. Don\'t forget the tile flooring throughout common areas, covered patio, and more! With an energy efficient design, this home is sure to be #1 on your list. Schedule your showing today and make it yours!' ,`Acres` = '0.19' ,`Area` = '61' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'PLEASANT HILL SEC 2 PH 2, BLOCK 4, LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '148 - Bryan' ,`SchoolElementary` = 'KEMP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRYAN HIGH SCHOOL' ,`SchoolMiddle` = 'STEPHEN F. AUSTIN MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'PLEASANT HILL' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675265302' WHERE `Matrix_Unique_ID` = '205732068' --> 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','205734746','1675265302','205734746','2023-01-28T01:22:36.550','3617274','Andrea Kitzmann','Keller Williams Realty','','','30.677866','-96.423399','18','77807','7','277600.00','Active','Rock Ridge','2019','Avenue','Bryan','2','0','4','1568','Single-Family','Exquisite 4 bed, 2 bath home on an oversized lot in Pleasant Hill from DR Horton! Beautifully constructed, the Dakota offers an open concept floor plan with a spacious living room open to the kitchen, dining area, and much more. Enjoy cooking in the gourmet kitchen featuring granite counters, Espresso scheme cabinetry, pantry, and stainless appliance package. Escape to the primary suite with oversized tile shower, linen closet, and huge walk-in closet. Smart home features include video doorbell, programmable thermostat, and smart lights at the front entry. Be one of the first to live in Phase 2 of this quiet subdivision conveniently located just minutes to Lake Bryan, Texas A&M’s RELLIS Campus, Historic Downtown Bryan, and a quick jaunt to the heart of Bryan/College Station. Don\'t forget the vinyl plank flooring throughout common areas, covered patio, and more! With an energy efficient design, this home is sure to be #1 on your list. Schedule your showing today and make it yours!','0.19','61','DR Horton','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','','','Central Electric','1','PLEASANT HILL SEC 2 PH 2, BLOCK 4, LOT 4','Subdivision Lot','8400','Appraisal District','','400','1','Never Lived In','2','Electric Oven','0','','','Electric Range','','Composition','148 - Bryan','KEMP ELEMENTARY SCHOOL','BRYAN HIGH SCHOOL','STEPHEN F. AUSTIN MIDDLE SCHOOL','No Appointment Required,No Supra Keybox,Request Online Appointment','Builder','1','Traditional','Pleasant Hill','','','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T01:22:36.550' ,`MLSNumber` = '64908153' ,`ListAgentFullName` = 'Andrea Kitzmann' ,`ListOfficeName` = 'Keller Williams Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.677330' ,`Longitude` = '-96.425449' ,`PhotoCount` = '34' ,`PostalCode` = '77807' ,`RoomCount` = '8' ,`ListPrice` = '306390.00' ,`Status` = 'Active' ,`StreetName` = 'Chief' ,`StreetNumber` = '2069' ,`StreetSuffix` = 'Street' ,`City` = 'Bryan' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1953' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exquisite 4 bedroom, 3 bath home with bonus room in Pleasant Hill from DR Horton! Beautifully constructed, the Prescott offers an open concept floor plan with a spacious living room open to the kitchen, breakfast nook, and much more. Enjoy cooking in the gourmet kitchen featuring sparkling granite counters, island, Espresso scheme cabinetry, pantry, and stainless appliance package. Escape to the primary suite with oversized tile shower, and huge walk-in closet that connects through to the laundry room! Smart home features include video doorbell, programmable thermostat, and smart lights at the front entry. Be one of the first to live in Phase 2 of this quiet subdivision conveniently located just minutes to Lake Bryan, Texas A&M’s RELLIS Campus, Historic Downtown Bryan, and a quick jaunt to the heart of Bryan/College Station. Don\'t forget the vinyl plank flooring throughout common areas, covered patio, and more! With an energy efficient design, this home is sure to be #1 on your list.' ,`Acres` = '0.15' ,`Area` = '61' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'PLEASANT HILL SEC 2 PH 2, BLOCK 3, LOT 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6385' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '148 - Bryan' ,`SchoolElementary` = 'KEMP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRYAN HIGH SCHOOL' ,`SchoolMiddle` = 'STEPHEN F. AUSTIN MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pleasant Hill' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675265302' WHERE `Matrix_Unique_ID` = '206395196' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T01:22:36.550' ,`MLSNumber` = '64030946' ,`ListAgentFullName` = 'Elizabeth Villarreal' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.834518' ,`Longitude` = '-95.446358' ,`PhotoCount` = '33' ,`PostalCode` = '77018' ,`RoomCount` = '10' ,`ListPrice` = '1250000.00' ,`Status` = 'Active' ,`StreetName` = 'De Milo' ,`StreetNumber` = '1903' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4159' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning modern farmhouse loaded with custom touches in Houston\'s favorite neighborhood. High ceilings, shiplap, exposed cedar beams, rustic cedar shelving and gorgeous light fixtures set a warm, peaceful tone. 4 sets of double French doors on the 1st floor in addition to large windows and recessed lighting allow beautiful light to flow throughout. Thoughtfully designed primary retreat has luxurious soaking tub, separate shower & custom closet leading to the laundry room. Killer kitchen! is open to the dining area and family room and is a wonderful, glowing space designed for gathering and entertaining with endless quartz countertops, hand-crafted cabinetry, walk in pantry, farmhouse sink, oversized island and stainless Thor appliances including a 48\" duel fuel range with double ovens. Seller will contribute towards a 2 to 1 buydown OR offer $25,000 towards a pool with a full priced offer! Fully sodded with sprinkler system. Never flooded; NOT in flood plain.' ,`Acres` = '0.1653' ,`Area` = '9' ,`BuilderName` = 'VGC Living Designs' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 86 OAK FOREST SEC 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'STEVENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Forest' ,`TaxAmount` = '7253' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675265302' WHERE `Matrix_Unique_ID` = '206566209' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T01:22:36.550' ,`MLSNumber` = '4900149' ,`ListAgentFullName` = 'Jana Bruce' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = 'Adel Diaz' ,`SellingOfficeName` = 'REALM Real Estate Professional' ,`Latitude` = '29.753209' ,`Longitude` = '-95.522656' ,`PhotoCount` = '50' ,`PostalCode` = '77024' ,`RoomCount` = '14' ,`ListPrice` = '4475000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Blalock' ,`StreetNumber` = '230' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '7' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '8023' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Expertly reconstructed Piney Point showcase home on over an acre and built with uncompromising quality rivaling the finest new construction. Turn-key interior is defined by grand proportions notably the magnificent living room that blends seamlessly with the kitchen, dining and wet bar. Professionally-equipped kitchen features a central island with seating, a walk-in pantry, and Thermador appliances including a gas range, double ovens, refrigerator, freezer, speed oven, and built-in coffee maker. The first floor primary suite offers a quiet retreat with a fireplace, sitting room, coffee bar, shared walk-in closet, laundry and bathroom featuring double vanities, heated floor and a double shower and soaking tub. Back stairs lead to a bedroom suite, kitchenette, media room and flex room. The expansive circular drive approaches the porte-cochere and front entry with steel pivot door, and the back yard features one of the largest pools in the Villages complete with water features and a spa.' ,`Acres` = '' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 Dullien' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '46187' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'MEMORIAL DRIVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Dullien' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265303' WHERE `Matrix_Unique_ID` = '206773286' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T01:22:36.550' ,`MLSNumber` = '84495580' ,`ListAgentFullName` = 'Booker Terrell' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.194853' ,`Longitude` = '-95.126817' ,`PhotoCount` = '37' ,`PostalCode` = '77372' ,`RoomCount` = '9' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Rio Blanco Drive' ,`StreetNumber` = '27615' ,`StreetSuffix` = '' ,`City` = 'Splendora' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2619' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This could be it! Buyers can install a second driveway, RV Pad, 20X30 shed and still have room for a pool. Tax Rate 1.92\r\n\r\nRio Vista is a highly sought-after acreage community established in Splendora, Tx. In the Rio Vista community you will find our must see elegant Mediterranean custom designed home. On 1.27 acres, this boastful open split floor plan furnishes this home with high ceilings, crown molding throughout, extended height baseboards, tiled flooring in common areas, and carpet in the bedrooms. The kitchen is outfitted with all stainless-steel appliances, has an island, granite countertops, rock paneled backsplash, tall cabinets, trey ceiling, and recessed L.E.D. lighting. The open concept flows from the kitchen into the living room, which possess large windows to maximize incoming natural light. \r\n\r\nLarge primary and secondary bedrooms and walk-in closets. Granite counter tops in all bath areas. Large, covered patio deck with marble swirl epoxy flooring. Tax Rate 1.92' ,`Acres` = '1.27' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S827600 - RIO VISTA, BLOCK 1, LOT 78, ACRES 1.27' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '55321' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'PEACH CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Rio Vista' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265303' WHERE `Matrix_Unique_ID` = '207595625' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T01:22:36.550' ,`MLSNumber` = '86589273' ,`ListAgentFullName` = 'Ryan Birdsong' ,`ListOfficeName` = 'Birdsong Real Estate' ,`SellingAgentFullName` = 'Judy Melgar' ,`SellingOfficeName` = 'SanDoray Real Estate LLC' ,`Latitude` = '29.056462' ,`Longitude` = '-95.415825' ,`PhotoCount` = '24' ,`PostalCode` = '77566' ,`RoomCount` = '4' ,`ListPrice` = '599000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Creekside' ,`StreetNumber` = '210' ,`StreetSuffix` = 'Lane' ,`City` = 'Lake Jackson' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2750' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One of the last opportunities to get your brand new home in the desirable Creekside Subdivision. Located on a beautiful, .4 acre, creekfront lot. Great floor plan with huge island kitchen, open to the living room. Wonderful study located just off the entry way. Upstairs is a great flex room that could be 4th bedroom or would make a great gameroom. Enjoy the creek views from the large covered patio. You will love the finishes in this Aplin Home.' ,`Acres` = '0.4787' ,`Area` = '5' ,`BuilderName` = 'Aplin Homes Inc.' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Jackson' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'CREEKSIDE SD SEC 4 (A0066 JE GROCE) (LAKE JACKSON) BLK 4 LOT' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '20852' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'BRANNEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE JACKSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Creekside SD' ,`TaxAmount` = '1301' ,`TaxRate` = '2.3371' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675265303' WHERE `Matrix_Unique_ID` = '208066832' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T01:22:36.550' ,`MLSNumber` = '41317775' ,`ListAgentFullName` = 'Tammie Bell' ,`ListOfficeName` = 'TBT Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.167089' ,`Longitude` = '-95.429948' ,`PhotoCount` = '9' ,`PostalCode` = '77515' ,`RoomCount` = '6' ,`ListPrice` = '449000.00' ,`Status` = 'Active' ,`StreetName` = 'Greystone' ,`StreetNumber` = '13' ,`StreetSuffix` = 'Court' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2526' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Greystone! This home is built by Aplin Homes in the new subdivision in Angleton. This is a gorgeous 3 bedroom, 2.5 bathroom, with a 2 car attached garage, with a bonus room upstairs. The kitchen is open to the family room. Primary bedroom is downstairs. Come see this beauty today!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Aplin Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'GREYSTONE SD (REPLAT) (A0380) (ANGLETON) BLK 1 LOT 27' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'CENTRAL ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Greystone' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675265303' WHERE `Matrix_Unique_ID` = '208221433' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T01:22:36.550' ,`MLSNumber` = '67380228' ,`ListAgentFullName` = 'Kelsey Casey' ,`ListOfficeName` = 'Realty ONE Group Iconic' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.098507' ,`Longitude` = '-95.357159' ,`PhotoCount` = '49' ,`PostalCode` = '77386' ,`RoomCount` = '11' ,`ListPrice` = '998800.00' ,`Status` = 'Active' ,`StreetName` = 'Buena' ,`StreetNumber` = '27810' ,`StreetSuffix` = 'Way' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3250' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This meticulously designed modern/contemporary style 1-story home, located in the highly sought-after community of Benders Landing, is finalizing construction! This ONE-OF-A-KIND custom home features 4 spacious bedrooms, a study, massive flex room, 3 full baths, adjoining kitchen & living room, a utility room (with sink), an oversized 2 car garage AND garage door, a TEXAS sized 40’ back covered patio, and an ABUNDANCE of natural light throughout. This property sits on over an acre corner wooded lot offering peace and tranquility to your home life! Too many special features to list. Please see attached property highlight list. Location is prime! Enjoy easy access to I-45, SH-99, the Hardy Toll Road and nearby shops and restaurants. Zoned to the highly rated CISD!! Pictures don\'t do it justice. Don\'t miss your opportunity to see this unique and breathtaking home behind the trees in person! Construction is now complete. Gate is temporary. ' ,`Acres` = '1.1022' ,`Area` = '40' ,`BuilderName` = 'Contracted Out' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'BENDERS LANDING 02, BLOCK 7, LOT 1' ,`LotDesciption` = 'Corner,Subdivision Lot,Wooded' ,`LotSize` = '48014' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '920' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'ANN K. SNYDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Benders Landing' ,`TaxAmount` = '2352' ,`TaxRate` = '1.8487' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675265304' WHERE `Matrix_Unique_ID` = '208766418' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T01:22:36.550' ,`MLSNumber` = '31161378' ,`ListAgentFullName` = 'Anastacio Bartolome' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.718977' ,`Longitude` = '-95.662313' ,`PhotoCount` = '19' ,`PostalCode` = '77082' ,`RoomCount` = '7' ,`ListPrice` = '270000.00' ,`Status` = 'Active' ,`StreetName` = 'Timber Rock' ,`StreetNumber` = '3622' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Vacant and easy to show. NICE AREA QUIET AREA NICE LAYOUT PLAN BIG BACKYARD CLOSE TO SCHOOLS GROCERIES FAST FOOD. Agent is also owner. Motivated seller, bring me your offer!' ,`Acres` = '0.1515' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 35 BLK 2 FORESTVIEW SEC 2' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'REES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'ALBRIGHT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Forestview Sec 02' ,`TaxAmount` = '4567' ,`TaxRate` = '2.405' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265304' WHERE `Matrix_Unique_ID` = '208900118' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T01:22:36.550' ,`MLSNumber` = '92730980' ,`ListAgentFullName` = 'Yolanda Graham' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.447886' ,`Longitude` = '-95.070007' ,`PhotoCount` = '50' ,`PostalCode` = '77539' ,`RoomCount` = '4' ,`ListPrice` = '415000.00' ,`Status` = 'Active' ,`StreetName` = 'Old Bayou' ,`StreetNumber` = '406' ,`StreetSuffix` = 'Drive' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2236' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this beautifully renovated home located on an oversized corner lot in Bayou Chantilly. This spacious home has an amazing flow and a modern design style that includes 4 bedrooms with carpet and 2 bathrooms, tile floors, a fireplace, quartz countertops, stainless steel appliances, and a primary bath walk-in shower. The electrical and plumbing were updated as well as the roof, HVAC system, fence and so much more! You will also love the spacious backyard and back patio for entertaining family and guests. The front of the home has a side drive that enters into the backyard where you can park your boat or RV. The RV hookup is located on the side of the home. You get the value of peaceful living while being conveniently located close to I-45, shopping, dining, schools, and minutes from Galveston.' ,`Acres` = '0.2819' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Dickinson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 11 A FARMER SUR LOT 22 BLK 6 BAYOU CHANTILLY SEC 3' ,`LotDesciption` = 'Corner' ,`LotSize` = '12278' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'HUGHES ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bayou Chantilly' ,`TaxAmount` = '6481' ,`TaxRate` = '2.5984' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265304' WHERE `Matrix_Unique_ID` = '209165109' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T01:22:36.550' ,`MLSNumber` = '10667246' ,`ListAgentFullName` = 'Carol Hearn' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.380443' ,`Longitude` = '-95.501686' ,`PhotoCount` = '22' ,`PostalCode` = '77304' ,`RoomCount` = '4' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Oval Glass' ,`StreetNumber` = '8914' ,`StreetSuffix` = 'Street' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1635' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Pride of ownership in the barley lived in 1 story home! This open \"Sabine\" floor plan offers so much from the entry to the back yard. High ceilings through out, 2\" blinds, recessed lighting, lots of windows, ceiling fans and more. Work from home in the study with double french doors just off the family room. Large den with custom faux electric fireplace including mantel and includes 65\" TV. The open island kitchen has granite, stainless appliances, gas stove, built in microwave, 42\" cabinets, large pantry and overlooks breakfast area. Private spacious primary suite in the back with private bath. Granite, separate tub and shower and large walk in closet. Walk in utility room and 2 large additional bedroom with great closets. Enjoy your covered back porch and large yard for all outdoor entertainment. Great neighborhood park with gorgeous event pavilion, two playgrounds, multiple picnic areas, the walking paths, the sparkling pond with fountains, and the easy access to I-45.?' ,`Acres` = '0.1588' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S340204 - CHASE RUN 04, BLOCK 4, LOT 17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6917' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '432' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'LAGWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Chase Run' ,`TaxAmount` = '4625' ,`TaxRate` = '2.1823' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265304' WHERE `Matrix_Unique_ID` = '210923325' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T01:22:36.550' ,`MLSNumber` = '20828518' ,`ListAgentFullName` = 'Cynthia Trahan' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.788470' ,`Longitude` = '-95.580051' ,`PhotoCount` = '37' ,`PostalCode` = '77043' ,`RoomCount` = '7' ,`ListPrice` = '460000.00' ,`Status` = 'Active' ,`StreetName` = 'Oakmont Glen' ,`StreetNumber` = '1107' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2878' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FIRST FLOOR LIVING AT IT\'S FINEST! BEAUTIFUL DAVID WEEKLY HOME LOCATED IN A SMALL GATED COMMUNITY IN THE ENERGY CORRIDOR.HOME BACKS TO A LARGE PARK WITH BIG TREES AND LUSH LANDSCAPING. BEAUTIFUL WOOD FLOORING THROUGHOUT THE FIRST FLOOR. KITCHEN WITH SS APPLIANCES AND GRANITE COUNTERS IS OPEN TO THE FAMILY ROOM AND HAS A LARGE ISLAND, LOTS OF CABINETS AND COUNTERSPACE. DOWNSTAIRS ALSO FEATURES A STUDY/OFFICE THAT IS CURRENTLY BEING USED AS A DINING ROOM. ALL BEDROOMS ON THE 2ND FLOOR. 2ND FLOOR ALSO HAS A LOFT AREA FOR STUDY/LIBRARY OR DEN. 3RD FLOOR IS A VERY LARGE OPEN GAMEROOM/FLEX ROOM. EASY ACCESS TO I-10, CLOSE TO CITY CENTRE, TOWN & COUNTRY AND MEMORIAL CITY MALL.' ,`Acres` = '0.046' ,`Area` = '24' ,`BuilderName` = 'David Weekly' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 1 ENCLAVE AT SHERWOOD FOREST' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '2002' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'SHERWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STRATFORD HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Enclave/Sherwood Forest' ,`TaxAmount` = '7663' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265305' WHERE `Matrix_Unique_ID` = '210988575' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T01:22:36.550' ,`MLSNumber` = '65462720' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.727478' ,`Longitude` = '-95.930457' ,`PhotoCount` = '43' ,`PostalCode` = '77423' ,`RoomCount` = '11' ,`ListPrice` = '344990.00' ,`Status` = 'Active' ,`StreetName` = 'Dew Crest' ,`StreetNumber` = '32627' ,`StreetSuffix` = 'Street' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1869' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Escape the city to this charming Lake Ridge Builders home in the Vanbrooke community. Nestled on a spacious lot, this 4-sided brick home boasts tile flooring, faux wood blinds, a cast stone fireplace, sprinkler systems, and a covered patio. Prepare incredible feasts in the island kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, 42” upper cabinets, and undercabinet lighting. The spa-like primary suite features dual vanities, a 42” tub, and a separate shower. Community comforts include a playground, splash pad, pavilion with a fire pit, and a swimming pool with a lounge. Residents enjoy easy access to I-10 and the Grand Parkway. Nearby schools are zoned to Lamar Consolidated ISD. You don’t want to miss this home – call today to learn more!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 24 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Vanbrooke' ,`TaxAmount` = '' ,`TaxRate` = '3.29' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675265305' WHERE `Matrix_Unique_ID` = '211059557' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T01:22:36.550' ,`MLSNumber` = '31515930' ,`ListAgentFullName` = 'Summer Patton' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.972522' ,`Longitude` = '-95.674752' ,`PhotoCount` = '50' ,`PostalCode` = '77429' ,`RoomCount` = '18' ,`ListPrice` = '1500000.00' ,`Status` = 'Active' ,`StreetName` = 'Bedford Chase' ,`StreetNumber` = '13503' ,`StreetSuffix` = '' ,`City` = 'Cypress' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '6392' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Experience UTOPIA! More than $100K of UPDATES since 2020, this EXTRAORDINARY CUSTOM home sits on over ½ ac in the GATED ESTATES OF COLES CROSSING! An OUTDOOR WONDERLAND begin at the MAGNIFICENT HEATED POOL: Bridge To Island Spa|Beach Entry|Swim-Up Bar|Sun-Shelf|Raised Deck|Impressive Wtr Features! POOLHOUSE: Kitchen|Full Bath|Storage Rm; SPORTCOURT; PUTTING GREEN; 2 COVERED PATIOS; FIRE PIT; INCREDIBLE LANDSCAPING! Step inside REMARKABLE FLOORPLAN, EXQUISITE ARCHITECTURAL DETAIL & UNIMAGINABLE EXTRAs! GIGANTIC Rooms, 2nd B/R down, WI Closets, 2 Studies, 3-Level Media Rm, 2 Huge Gamerooms, Sunroom, HIDDEN ROOMS! Relish the Soaring Ceilings, Massive UTILITY, Mud Room & INSANE STORAGE! ISLAND KITCHEN: DBL OVENS|5-seat Bar|WI Pantry|Butler Pntry|Rich Brick/Stone Around Cooktop! OWNERS RETREAT: Dbl-Sided FP|Glorious Windows|Sitting Area|Vltd Ceiling. LUX BATH: Dual Shwr w/BENCHES|Jetted Tub|2 Sinks|Fab Closet! *2 GARAGES, Circle Drive* & MORE! SEE VIDEO, VIRTUAL TOUR, FLOORPLAN & UPGRADES' ,`Acres` = '0.5943' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'HOA First Right of Refusal,Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 1 COLES CROSSING SEC 24' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '25887' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'SAMPSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPILLANE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Coles Crossing' ,`TaxAmount` = '26396' ,`TaxRate` = '2.541' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265305' WHERE `Matrix_Unique_ID` = '211209947' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T01:22:36.550' ,`MLSNumber` = '89982717' ,`ListAgentFullName` = 'Virginia Vasquez' ,`ListOfficeName` = 'Hardee & Company Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.845904' ,`Longitude` = '-95.475919' ,`PhotoCount` = '33' ,`PostalCode` = '77092' ,`RoomCount` = '9' ,`ListPrice` = '675000.00' ,`Status` = 'Active' ,`StreetName` = 'Silver Forest' ,`StreetNumber` = '5826' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3316' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 5826 Silver Forest Dr. This gorgeous Energy Star certified recent construction, 4/5 bdrm, 3.5 bath by Design Tech custom homes in a well-established neighborhood, with community swimming pool. This perfect family home, has an enormous amount of space. Open floor plan with high ceilings and plenty of room for hosting holiday gatherings indoors or out on the spacious patios and porches. 42\" tall cabinets, stainless steel appliances, granite countertops, large breakfast room, formal dining room, and study that can be used as a 5th bedroom, are some of the features offered. Master bedroom downstairs features access to the backyard, spa like bathroom, and large custom designed closet. All secondary bedrooms are spacious and light. Backing to a greenbelt, plenty of backyard greenspace, and double wide fence gate to park your boat. Make your appointment today!\r\n\r\nPhotos Coming Soon!!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 1 FOREST WEST SEC 1' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '17300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '238' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WAINWRIGHT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'FOREST WEST' ,`TaxAmount` = '13719' ,`TaxRate` = '2.5304' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265305' WHERE `Matrix_Unique_ID` = '211331289' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T01:22:36.550' ,`MLSNumber` = '75064319' ,`ListAgentFullName` = 'Brian Brookins' ,`ListOfficeName` = 'Boulevard Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.889195' ,`Longitude` = '-95.568808' ,`PhotoCount` = '35' ,`PostalCode` = '77040' ,`RoomCount` = '9' ,`ListPrice` = '339500.00' ,`Status` = 'Active' ,`StreetName` = 'Wall' ,`StreetNumber` = '16302' ,`StreetSuffix` = 'Street' ,`City` = 'Jersey Village' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2141' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*Motivated Seller* Freshly painted exterior 11/2022! Located in a desirable area of Jersey Village and within minutes of everything Jersey Village has to offer (see map in photos). The multiple bonus areas give this home flexibility to fit any lifestyle. The home design allows for optimal privacy from the street but with an abundance of natural light from the double pane windows looking onto the brick paver patio and spacious back yard. The sizeable eat in kitchen with pass through bar into the living area allow for open concept living with enough separation for the chef. *Foundation Assessed 8/22-No issues revealed *Roof Assessed 8/22-General maintenance items identified and all fixed *New garbage disposal 9/22 *All interior cabinets, doors, and trim freshly painted 8/22. *Washer/Dryer and stainless kitchen appliances (oven, microwave, dishwasher) all less than 4 years old *Never flooded-per the owner *Water heater, furnace, and fireplace are all gas.' ,`Acres` = '0.2296' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Jersey Village' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 23 BLK 40A JERSEY VILLAGE COUNTRY CLUB ESTATES SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'POST ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'JERSEY VILLAGE HIGH SCHOOL' ,`SchoolMiddle` = 'COOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Country Club Estates' ,`TaxAmount` = '6167' ,`TaxRate` = '2.7758' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265306' WHERE `Matrix_Unique_ID` = '211434421' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T01:22:36.550' ,`MLSNumber` = '84313577' ,`ListAgentFullName` = 'Jackie Greer' ,`ListOfficeName` = 'Berkshire Hathaway HomeService' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.139485' ,`Longitude` = '-95.049087' ,`PhotoCount` = '35' ,`PostalCode` = '77554' ,`RoomCount` = '7' ,`ListPrice` = '535000.00' ,`Status` = 'Active' ,`StreetName` = 'Ector' ,`StreetNumber` = '4115' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1184' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful updated Sea Isle home. This 3 bedroom 2 bath beach home has been totally updated. Hardy board & paint on outside, windows, kitchen cabinets, appliances, counters, both bathrooms updated, flooring & fixtures & fresh paint in the entire house. Most furniture remains with a few exclusions (art & décor do not remain), hot tub, riding mower, push mower, weed eater & golf cart remain. This will make a great full time, weekend home or vacation rental. It a must see!! Bring your swimsuit & come enjoy the rest of the summer!!' ,`Acres` = '0.1559' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 1570 SEA ISLE 5TH EXTENSION' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6792' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven,Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,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,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Sea Isle Ext 5' ,`TaxAmount` = '6483' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265306' WHERE `Matrix_Unique_ID` = '211494519' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T01:22:36.550' ,`MLSNumber` = '38020164' ,`ListAgentFullName` = 'Kristen Orostieta' ,`ListOfficeName` = 'Oro Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.318147' ,`Longitude` = '-96.632440' ,`PhotoCount` = '40' ,`PostalCode` = '77879' ,`RoomCount` = '2' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Straight Arrow' ,`StreetNumber` = '415' ,`StreetSuffix` = 'Lane' ,`City` = 'Somerville' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '836' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come check out this one of a kind of 1920\'s German home originally from Brenham and moved to Somerville in the sought after Birch Creek Forest subdivision next door to Lake Somerville and state park and just up the road from the boat ramp. This one of a kind home sits on 3 lots and is on over an acre! It features so many uniqueness within a home that is hard to find! Shiplap walls, vintage wood cabinets, oversized covered deck, original wood windows, cozy covered front porch that wraps around to back deck, and beautiful built ins. This home also backs up to a green belt and sits on the middle lot with the remaining lots to the right and left of the home. Subdivision is also short term rental friendly.' ,`Acres` = '1.04' ,`Area` = '59' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Wall Heater,Window Unit' ,`HOAMandatory` = '1' ,`Legal` = 'S2501 BIRCH CREEK FOREST BLK 4 Section 6 Lot 7-9 1.04 ACRES' ,`LotDesciption` = 'Corner' ,`LotSize` = '45302' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '158 - Somerville' ,`SchoolElementary` = 'SOMERVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SOMERVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'SOMERVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Birch Creek Forest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1920' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675265306' WHERE `Matrix_Unique_ID` = '211504059' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T01:22:36.550' ,`MLSNumber` = '18308828' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.727478' ,`Longitude` = '-95.930457' ,`PhotoCount` = '20' ,`PostalCode` = '77423' ,`RoomCount` = '14' ,`ListPrice` = '399990.00' ,`Status` = 'Active' ,`StreetName` = 'Dew Crest' ,`StreetNumber` = '32427' ,`StreetSuffix` = 'Street' ,`City` = 'Fulshear' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2785' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This house is under construction. This gorgeous Lake Ridge Builders home in Vanbrooke truly has it all! Nestled on a spacious lot, this 4-sided brick home boasts a premium elevation, no back neighbors, open ceilings, tile flooring, wrought iron spindles, faux wood blinds, a cast stone fireplace, study with French doors, and covered patio. D