Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T01:22:00.513' ,`MLSNumber` = '13479954' ,`ListAgentFullName` = 'Mary Henderson' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.749796' ,`Longitude` = '-95.438380' ,`PhotoCount` = '46' ,`PostalCode` = '77019' ,`RoomCount` = '9' ,`ListPrice` = '3800000.00' ,`Status` = 'Active' ,`StreetName` = 'Del Monte' ,`StreetNumber` = '3730' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3826' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning River Oaks 4 Bedroom, 3.5 Bath home on a 17,201 SF Lot across from Del Monte Park. Renovated in 2013 (per Owner), the Property retains its original classic charm, while blending today’s updated décor. High end finishes, spacious rooms, & generous built-ins abound. Features include hardwood floors throughout, lovely Formals, wood-paneled Study/Library, island Kitchen opening to the Den/Family Room, and Primary Suite either up or down. The Kitchen has Calcutta marble countertops, glass subway tile, stainless appliances, Sub-Zero refrigerator, Wolf dual fuel range, wine fridge, 2 Bosch dishwashers, & built-in desk. A pleasant reading nook leads to the upstairs Primary Ensuite Bedroom with peaked ceiling and exposed beams. Joined to the house by a covered walkway, the oversized 2-car garage has a built-in Sub-Zero refrigerator, sink and great storage. Enjoy captivating views of the gracious treed backyard, lawn, gardens and expansive brick patios. Outstanding River Oaks location!' ,`Acres` = '0.3949' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'River Oaks Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 & TR 23A BLK 84 RIVER OAKS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '17201' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2662' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'RIVER OAKS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'River Oaks Sec 11' ,`TaxAmount` = '60823' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1946' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202568' WHERE `Matrix_Unique_ID` = '207129640' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T01:22:00.513' ,`MLSNumber` = '52652344' ,`ListAgentFullName` = 'Cynthia Kahanek' ,`ListOfficeName` = 'RE/MAX 1st Team' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.066724' ,`Longitude` = '-95.447577' ,`PhotoCount` = '50' ,`PostalCode` = '77566' ,`RoomCount` = '16' ,`ListPrice` = '560000.00' ,`Status` = 'Active' ,`StreetName` = 'Arrowhead' ,`StreetNumber` = '204' ,`StreetSuffix` = 'Drive' ,`City` = 'Lake Jackson' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3365' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOOK! WE FOUND YOUR DREAM HOME! This incredible custom home in prestigious Northwood Estates has absolutely amazing curb appeal, a perfect layout, and a spectacular covered outdoor living/dining area. This very well maintained home features two spacious living areas, two primary bedrooms (four bedrooms in total), two dining areas, large kitchen with lots of storage space, home office, shining hardwood floors, beautiful woodworking, recently updated primary bath with two walk-in closets a walk-in shower and a soaking tub. Home Office could also serve as a downstairs bedroom for guests who can’t navigate the stairs. In addition, the outdoor space features a beautiful covered balcony, a large covered front porch with brick floors and ceiling fans, a large back yard, a triple car garage, an expansive driveway, and as mentioned earlier - a show stopping custom covered outdoor living/dining area. Take a look at the photos and picture yourself here.' ,`Acres` = '0.306' ,`Area` = '5' ,`BuilderName` = 'Ballard Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Jackson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NORTHWOOD ESTATES SEC 1 (A0066 J E GROCE)(LAKE JACKSON) BLK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13329' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'BRANNEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE JACKSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Northwood Estates Sec 1-2-3' ,`TaxAmount` = '9602' ,`TaxRate` = '2.3371' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202568' WHERE `Matrix_Unique_ID` = '208154900' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T01:22:00.513' ,`MLSNumber` = '69622228' ,`ListAgentFullName` = 'Walter Bering' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.748580' ,`Longitude` = '-95.428025' ,`PhotoCount` = '50' ,`PostalCode` = '77019' ,`RoomCount` = '30' ,`ListPrice` = '6500000.00' ,`Status` = 'Active' ,`StreetName` = 'Chevy Chase' ,`StreetNumber` = '3320' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '7' ,`BathsHalf` = '3' ,`BedsTotal` = '6' ,`SqFtTotal` = '10296' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Situated in a prime location in River Oaks, this Georgian Colonial home blends symmetrical architectural elements with nuances of a more modern era floor plan and lifestyle. Inviting entry area with fanlight transom and a swans neck pediment over the front door. The home is richly appointed with stenciled hardwood floors in the foyer, elegant moldings throughout, a graceful descending staircase, and 12\' ceilings in the main living areas on the first floor. A walk-in wet bar is between the living room and back library room. The library room offers access to a climate-controlled wine room. The sun room has pairs of French doors that open to the backyard patio and pool area. The kitchen and family room were remodeled by Dillon Kyle for a more open living area concept. Four or five bedrooms plus a two-bedroom apartment or quarters upstairs. Third floor game room and media room. Elevator goes to all three floors. Backyard with green space, slate patio, pool, and outdoor dining areas.' ,`Acres` = '0.5165' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '5' ,`GeoMarketArea` = 'River Oaks Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 8 RIVER OAKS COUNTRY CLUB ESTATE' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '22500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2861' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Slate' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'RIVER OAKS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Georgian,Traditional' ,`Subdivision` = 'River Oaks Country Club Estate' ,`TaxAmount` = '143339' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202569' WHERE `Matrix_Unique_ID` = '210077357' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T01:22:00.513' ,`MLSNumber` = '45292604' ,`ListAgentFullName` = 'Amy Larner' ,`ListOfficeName` = 'RE/MAX Leading Edge' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.135520' ,`Longitude` = '-95.059801' ,`PhotoCount` = '31' ,`PostalCode` = '77554' ,`RoomCount` = '5' ,`ListPrice` = '499999.00' ,`Status` = 'Active' ,`StreetName` = 'Vida' ,`StreetNumber` = '22819' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '805' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The true definition of a beach bungalow! The attention to detail can not be missed throughout the home. You immediately will feel the coastal vibe as you enter through the front door. This recently updated home boasts beautiful shiplap walls. The open concept living area allows everyone to gather. The beautifully updated kitchen features a large breakfast bar, storage galore, and authentic nautical touches throughout. There are two large bedrooms on the main living area connected by an adjoining bathroom. As you head outdoors you have a fantastic outdoor deck perfect for taking in the southerly breezes. If you are looking for a great place to entertain, head downstairs to the lower level! Fantastic storage, a recently updated boat lift, and entertaining space including a fun grilling area! RV hook-ups and more! This house has been updated down to the studs! If you are looking for your perfect home, weekend retreat, or investment property, this is it! It is time for island life!!' ,`Acres` = '0.1194' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 12 LOT 5 BLK 6 TERRAMAR BEACH SEC 3' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '5200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Terramar 3' ,`TaxAmount` = '4050' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202569' WHERE `Matrix_Unique_ID` = '211380073' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T00:25:22.037' ,`MLSNumber` = '3603616' ,`ListAgentFullName` = 'Trissa Rosette' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.016162' ,`Longitude` = '-95.542320' ,`PhotoCount` = '27' ,`PostalCode` = '77379' ,`RoomCount` = '16' ,`ListPrice` = '439000.00' ,`Status` = 'Active' ,`StreetName` = 'Vintage Creek' ,`StreetNumber` = '8307' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '3618' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A New Orleans inspired beauty nestled among mature trees with modern updates! Home features lovely balcony and has 5 bedrooms w/ 2 primary suites, classic formal & dining, large gameroom, 3 full baths & 2 half! Enjoy gatherings in an open floorplan with a recently remodeled kitchen featuring modern touches. Den offers wet bar & ample seating space. Generous primary suite w/ tastefully remodeled spa-like bathroom + walk-in closet. This well-loved home has granite countertops in all wet areas plus recent flooring w/ NO CARPET on the 1st floor! Shady backyard features both picture-perfect uncovered & covered patio...you’ll want to sit for hours! A long and newly poured driveway (2021) leads to a 3-car garage! DIY much? You’ll love 3rd bay of garage outfitted w/ A/C and sink for easy clean-up. Walkable to restaurants, shops & gym, MNW offers fantastic community amenities (6 tennis courts, beautiful pool + waterplay area). So much to love about this home! Zoned to award-winning Klein ISD!' ,`Acres` = '0.2617' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 10 017*M1876900-003-010-003 MEMORIAL NORTHWEST SEC' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '693' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'THEISS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Northwest' ,`TaxAmount` = '6293' ,`TaxRate` = '2.3213' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202569' WHERE `Matrix_Unique_ID` = '211921794' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T00:58:32.607' ,`MLSNumber` = '37651104' ,`ListAgentFullName` = 'Wendy Baty' ,`ListOfficeName` = 'Provenzano Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.049249' ,`Longitude` = '-95.425162' ,`PhotoCount` = '47' ,`PostalCode` = '77566' ,`RoomCount` = '11' ,`ListPrice` = '385000.00' ,`Status` = 'Active' ,`StreetName` = 'Southern Oaks' ,`StreetNumber` = '313' ,`StreetSuffix` = '' ,`City` = 'Lake Jackson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2659' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You won\'t have to go far to find your fishing spot! What a Beauty! This large, Lake Jackson home sits on over half an acre on Oyster Creek. Almost everything has been updated with pleasing colors & a Modern Farmhouse look. Vinyl plank flooring on the main floor in 2022, shiplap walls in living & dining rooms, fresh paint, kitchen is enormous with recent backsplash, Quartz counter tops, farmhouse sink & new appliances in 2019/2020. Stainless refrigerator stays. The kitchen has a very spacious breakfast island with an updated cooktop. Garbage disposal replaced 2022. Downstairs bath updated in 2019, including plumbing & exhaust vent in 2022. Second floor windows replaced with double insulated vinyl windows. Roof replaced 2022. Siding, insulation & Hardy Plank 2021. New AC 2019. 12 x 16 building wired for electricity, covered patio, boat storage carport, fish pond complete with fish & a small relaxing waterfall. Too many updates to list! Make this gorgeous home Yours today!' ,`Acres` = '0.5482' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Jackson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Southern Oaks (Lake Jackson) Block 1, Lot 7' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '23880' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'BRANNEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE JACKSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Southern Oaks' ,`TaxAmount` = '6817' ,`TaxRate` = '2.33' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202569' WHERE `Matrix_Unique_ID` = '212192572' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T00:01:50.410' ,`MLSNumber` = '50778564' ,`ListAgentFullName` = 'Hien Luu' ,`ListOfficeName` = 'Lone Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.799751' ,`Longitude` = '-95.495251' ,`PhotoCount` = '15' ,`PostalCode` = '77055' ,`RoomCount` = '6' ,`ListPrice` = '510000.00' ,`Status` = 'Active' ,`StreetName` = 'Waterbury' ,`StreetNumber` = '8330' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1283' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this adorable home located in the heart of Spring Branch! Newly completed in the kitchen with new quartz countertops, freshly finished cabinets and stainless appliances. Zoned to excellent schools Valley Oaks Elementary and Memorial High School. NO HOA. NO FLOODING! New Refrigerator is included. Schedule your tour today!' ,`Acres` = '0.1767' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 8A BLK 1 E 1/2 LT 8 DANBURY PLACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7695' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'VALLEY OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Danbury Place' ,`TaxAmount` = '10874' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202569' WHERE `Matrix_Unique_ID` = '212281601' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T00:20:21.367' ,`MLSNumber` = '68751406' ,`ListAgentFullName` = 'Trisha Salinas' ,`ListOfficeName` = 'Lucky Money Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.054362' ,`Longitude` = '-95.377863' ,`PhotoCount` = '20' ,`PostalCode` = '77373' ,`RoomCount` = '8' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Allendale Garden' ,`StreetNumber` = '2414' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2152' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your SMART home 2414 Allendale Garden Lane!! This gorgeous 2-story home features 2,152 square feet with 4 bedrooms, 2.5 bathrooms, game room, sprinkler system, full gutters, and energy efficient stainless steel appliances. You\'ll love the perfect entertainers layout with an open concept between the living room, dining room, and kitchen. Primary suite has a spacious walk-in closet and ensuite bathroom with dual vanity. This home is just a few minutes away from the community pool/recreational area. Super close to shopping/dining and IAH/Toll/GrandParkway. This home is a true gem. Come and take a look for yourself!' ,`Acres` = '0.1345' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 2 BRECKENRIDGE WEST SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5860' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'GLORIA MARSHALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Breckenridge West' ,`TaxAmount` = '6689' ,`TaxRate` = '3.0268' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202570' WHERE `Matrix_Unique_ID` = '212486521' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T01:22:00.513' ,`MLSNumber` = '10903563' ,`ListAgentFullName` = 'Alissa Weatherstone' ,`ListOfficeName` = 'Olson Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.760770' ,`Longitude` = '-95.603783' ,`PhotoCount` = '40' ,`PostalCode` = '77077' ,`RoomCount` = '4' ,`ListPrice` = '589000.00' ,`Status` = 'Active' ,`StreetName` = 'Westerley' ,`StreetNumber` = '12526' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2964' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this newly updated home located minutes away from Terry Hershey Park, the Energy Corridor and I-10. This 4 bedroom, 3.5 bathroom home with an oversized lot, provides great space for entertainment with its open concept kitchen, dining, and family room areas. New custom soft-close cabinets, flooring, quartz countertops, movable island, and high-end stainless steel appliances make for an easy transition into this turn-key home. The large backyard with a pool and private deck overlooking the ravine, includes plenty of space to add your own touch. This home includes an all new roof, driveway, sidewalk, hardie plank siding, energy-efficient double pane windows, and PEX plumbing. This home is move in ready for you and your family!' ,`Acres` = '0.3173' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 1 ASHFORD FOREST SEC 3' ,`LotDesciption` = 'Ravine' ,`LotSize` = '13820' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '625' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ASHFORD/SHADOWBRIAR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Ashford Forest' ,`TaxAmount` = '10049' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1666202570' WHERE `Matrix_Unique_ID` = '212593502' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T01:02:14.687' ,`MLSNumber` = '14682852' ,`ListAgentFullName` = 'Mary Dover' ,`ListOfficeName` = 'Coldwell Banker Realty, Cy-Fair Office' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.957121' ,`Longitude` = '-95.599173' ,`PhotoCount` = '39' ,`PostalCode` = '77429' ,`RoomCount` = '9' ,`ListPrice` = '297900.00' ,`Status` = 'Active' ,`StreetName` = 'Serendipity' ,`StreetNumber` = '11802' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2136' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location, Location, Location! This home speaks to you as you enter the front door with the magnificent volume ceilings! The split floorplan is ideal for the primary resident who wishes to seek peace and tranquility. Boasting a yard for the entertainer and a primary bathroom befitting of a king or queen. Featuring a sleek clawfoot tub, subway tile in the shower, seamless shower door, LARGE CLOSET. Come home, put your feet up and relax because there is not much yard work to be done here, but much entertaining. Enjoy the cool fall breeze on your stone patio and set up that hammock you\'ve been dreaming about. The kitchen has ample storage and cooking space, large pantry, walk in laundry room, showcase handrails for the contemporary, yet modern design. The half bath downstairs keeps your guests happy and 3 bedrooms 1 full bath with a FLEX space upstairs gives you all the SPACE you need. The large shed in the back is great for extra storage. MOVE IN READY. Make YOUR MOVE BEFORE THE HOLIDAYS.' ,`Acres` = '0.1768' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 1 TOWER OAK BEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '675' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MILLSAP ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tower Oak Bend' ,`TaxAmount` = '4013' ,`TaxRate` = '2.1637' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202570' WHERE `Matrix_Unique_ID` = '213004065' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T01:56:34.430' ,`MLSNumber` = '41866468' ,`ListAgentFullName` = 'Andrea Curran' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.942075' ,`Longitude` = '-95.745678' ,`PhotoCount` = '33' ,`PostalCode` = '77433' ,`RoomCount` = '9' ,`ListPrice` = '500000.00' ,`Status` = 'Active' ,`StreetName` = 'Highland Country' ,`StreetNumber` = '16627' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2815' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful Lennar home, from the Brookstone Collection, in the highly sought after Bridgeland community. Large and open family room with a cast stone fireplace and large windows that offer a great view of the beautiful backyard pool. Spacious kitchen with tons of cabinet space, granite countertops, walk-in pantry and stainless steel appliances. Tranquil and private first-floor primary suite with dual granite-topped vanity, soaking tub, oversized shower enclosure with bench, and a large walk-in closet. Upstairs you will find a sizable game room, two full bathrooms and three secondary bedrooms. The amazing backyard features a beautiful pool, complete with a sheer descent waterfall, large covered patio with ceiling fan, gas connection for fire pit or grill, and an extended travertine patio area. Zoned to acclaimed Cy-Fair ISD schools.' ,`Acres` = '0.1458' ,`Area` = '25' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 2 BRIDGELAND HIDDEN CREEK SEC 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6350' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1355' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WELLS ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '12180' ,`TaxRate` = '3.4329' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202570' WHERE `Matrix_Unique_ID` = '213007479' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T01:22:00.513' ,`MLSNumber` = '96426564' ,`ListAgentFullName` = 'Dee Dee Guggenheim Howes' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.747646' ,`Longitude` = '-95.403090' ,`PhotoCount` = '36' ,`PostalCode` = '77019' ,`RoomCount` = '10' ,`ListPrice` = '1595000.00' ,`Status` = 'Active' ,`StreetName` = 'Park' ,`StreetNumber` = '2014' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4496' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This breathtaking contemporary home dazzles with chic designer style, superb indoor-outdoor living and an excellent River Oaks Area location. Ceilings soar over concrete and hardwood floors, massive windows and art walls. Positioned around a covered patio, swimming pool and summer kitchen, this home boasts stunning outdoor views. Luxurious living and dining rooms and bar aid in gracious entertaining. The open chef\'s kitchen features quartz countertops, soft-close cabinetry, Thermador stainless steel appliances opens to the living room overlooking the impeccable outdoor space. Upstairs, the owner\'s suite features a sleek bath complete with steam shower & custom walk-in closet. Secondary bedrooms are joined by work-of-art baths. Third floor provides large gym/flex space, sauna, study with private balcony, and additional bed/bath. Generator, elevator capable, whole house Savant automation. Spectacular location close to galleries, shopping, dining and parks. Schedule your tour today!' ,`Acres` = '0.0992' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'River Oaks Shopping Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 12 BLK 19 SANDYSIDE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4322' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground,Heated' ,`Range` = '' ,`RangeType` = 'Gas Range,Grill' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WOODROW WILSON MONTESSORI' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Sandyside' ,`TaxAmount` = '31412' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202570' WHERE `Matrix_Unique_ID` = '213070657' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T01:22:00.513' ,`MLSNumber` = '75942756' ,`ListAgentFullName` = 'Tammie Bell' ,`ListOfficeName` = 'TBT Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.036037' ,`Longitude` = '-95.416597' ,`PhotoCount` = '23' ,`PostalCode` = '77531' ,`RoomCount` = '8' ,`ListPrice` = '533166.00' ,`Status` = 'Active' ,`StreetName` = 'Bentwater' ,`StreetNumber` = '202' ,`StreetSuffix` = 'Lane' ,`City` = 'Clute' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3347' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Woodshore! This is a beautiful 2 story home, waiting for you! This is a 4 bedroom, 3.5 bathroom home with a game room upstairs. The kitchen is a chef\'s dream with an island that is open to the living room and has a breakfast room conveniently located for easy entertaining. The primary bedroom is downstairs and secluded with a separate shower and soaker tub. All other bedrooms are upstairs. The game room is split from the other bedrooms with a full bathroom. This home won\'t last long, schedule your private showing today!' ,`Acres` = '0.2175' ,`Area` = '5' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Clute' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WOODSHORE SEC 4 (A0066 J E GROCE) (CLUTE) BLK 1 LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9474' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'OGG ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CLUTE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodshore Sec 4 A0066 J E Gro' ,`TaxAmount` = '6223' ,`TaxRate` = '2.6231' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202571' WHERE `Matrix_Unique_ID` = '213332099' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T00:08:20.187' ,`MLSNumber` = '59676710' ,`ListAgentFullName` = 'Alexander DiSaggio' ,`ListOfficeName` = 'City Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.533586' ,`Longitude` = '-95.263725' ,`PhotoCount` = '29' ,`PostalCode` = '77581' ,`RoomCount` = '8' ,`ListPrice` = '400000.00' ,`Status` = 'Active' ,`StreetName` = 'Travis Lake' ,`StreetNumber` = '3914' ,`StreetSuffix` = 'Court' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3309' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Best price in the neighborhood! Welcome Home to the gated community of Towne Lake Estates! This home is on a cul de sac and boasts a large living area with an open floor plan. The kitchen is open to the living room perfect for entertaining and includes a gas range and large island. The formal dining room is ready for your large dining table and guests. The primary bedroom is large and has a huge walk in closet and en suite bathroom with separate shower and tub plus dual vanities. The game room is big enough for your full size pool table and lots of seating, or turn it in to your theater room. The secondary bedrooms are all large, one of them is almost as big as the primary, perfect for guests or mother in law suite. Come tour today!' ,`Acres` = '0.184' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TOWNE LAKE ESTATES SEC 2 (A0507 ACH&B) (PEARLAND) BLK 1 LOT' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8015' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '982' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'SHADYCREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH EAST' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Towne Lake Estates Sec 2' ,`TaxAmount` = '8727' ,`TaxRate` = '2.8052' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202571' WHERE `Matrix_Unique_ID` = '213447317' --> 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','213723883','1666202571','213723883','2022-10-18T01:20:14.007','57796272','Beverly Thomas','Century 21 Realty Partners','','','30.003097','-95.420686','34','77073','3','249500.00','Active','Rock','402','Drive','Houston','2','0','3','1614','Single-Family','Rare Opportunity in NORTH VIEW! Have you been searching for a unique home like this- Two Primary Bedrooms and two primary bathrooms, plus a third bedroom in a Private location in Houston. Single story w/ 2 Car attached garage. Sliding glass doors at both primary bedrooms. A floor plan with open spaces - easy to entertain. Lush and beautifully landscaped yard on an oversized corner lot w/ Underground Lawn Sprinkler. Back yard fenced. Covered back porch. 25year asphalt shingles on roof installed 10/2020.','0.2002','12','','','','','Mud,Sellers Disclosure','1','','1','Aldine Area','Central Gas','1','LT 1 BLK 11 NORTH VIEW SEC 1','Corner,Subdivision Lot','8720','Appraisal District','','445','0','','2','','0','','','','','Composition','48 - Spring','MEYER ELEMENTARY SCHOOL (SPRING)','ANDY DEKANEY H S','RICKY C BAILEY M S','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','North View','3956','2.7292','Water District','1981','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213745273','1666202571','213745273','2022-10-18T00:04:20.883','39949190','Alexander DiSaggio','City Group','','','30.459989','-95.547479','30','77318','7','150000.00','Active','Paradise Cove','15187','Drive','Willis','2','0','3','1232','Single-Family','WOW! This is a rare find. HUGE lot and backyard. Walk to Lake Conroe. Beautiful landscaped home situated in the wonderful neighborhood of Paradise Cove ready and awaiting you to make it your new home! Large primary suite with en suite bathroom including separate shower and soaking tub. Big Island kitchen, open to living area. Lots of natural light. Welcome!','0.202','39','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Lake Conroe Area','Central Electric','1','S775300 - PARADISE COVE 01, BLOCK 3, LOT 6, 7-A REPLAT #9834','Subdivision Lot','8799','Appraisal District','','150','0','','0','Electric Oven','0','','','Electric Range','','Composition','56 - Willis','PARMLEY ELEMENTARY SCHOOL','WILLIS HIGH SCHOOL','LYNN LUCAS MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Paradise Cove 01','1814','1.8448','Public Sewer,Public Water','2004','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213784172','1666202571','213784172','2022-10-18T00:46:46.183','11803014','Jincy Jose','Land & Luxe Realty','','','29.541670','-95.703653','39','77469','10','584000.00','Active','Rabb Ridge','5718','Drive','Richmond','3','1','3','3291','Single-Family','**MOTIVATED SELLER** Get ready for this brick beauty in the exclusive community of Rabb\'s Ridge Estates. This is an entertainer’s dream home, with soaring ceilings, upstairs flex areas and wet bar, large and gorgeous windows for tons of natural light and an acre of land to customize further! Step inside to find a grand living room and freshly painted walls. Floor plan with tons of living space and extra rooms to personalize to your taste. Your kitchen features granite counters, s/s appliances, huge island, and brand new cooktop. The first level has two bedrooms, including the spacious and renovated primary bath! There is so much to love in this grand, updated 3-4 bedroom home with soaring ceilings and tons of entertaining space. No HOA fees, public sewer, private well - this may be everything you\'ve been looking for! This home truly special and unique. Zoned to esteemed Lamar CISD schools! Just minutes from Crabb River Rd and all major shopping and highways!','1','30','','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','','Fort Bend South/Richmond','Central Gas','0','RABB\'S RIDGE ESTATES, LOT 14, ACRES 1.00','Subdivision Lot','','','','','0','','2','Gas Oven','0','','','Electric Cooktop','','Composition','33 - Lamar Consolidated','WILLIAMS ELEMENTARY SCHOOL (LAMAR)','GEORGE RANCH HIGH SCHOOL','RYON/READING JUNIOR HIGH SCHOOL','Appointment Required,Request Online Appointment,Vacant/Unoccupied','Appraisal District','2','Traditional','Rabbs Ridge Estates','4860','1.6948','Septic Tank,Well','1992','Appraisal District'); --> New record created successfully