Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T01:22:00.857' ,`MLSNumber` = '70029006' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.344728' ,`Longitude` = '-95.527164' ,`PhotoCount` = '45' ,`PostalCode` = '77304' ,`RoomCount` = '6' ,`ListPrice` = '291290.00' ,`Status` = 'Active' ,`StreetName` = 'Yellow Birch' ,`StreetNumber` = '764' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Now Colina Home. Buy now for August 2022. Priced to sell with impressive features at an unbeatable value. This is your opportunity to get in at the beginning and take advantage of our best pricing. Besides the large kitchen that welcomes you home, this home comes with all of the features you come to except: extensive tile/vinyl planking in all wet areas, entry and LIVING ROOM, granite in the kitchen, 42\" cabinets, stainless steel appliances to include our premium 5-burner range. 9\" under mount farm sink, 2: blinds, Garden tub and separate shower in master bath.Pex Plumbing, Lennox 16 seer A/C, Taexx pest control. All of this included for you. It is only 5 minutes from lake conroe, EZ access. to Willis, Magnolia, Huntsville, Spring, Energy Corridor and The Woodlands Mall. Work and shop in the city and come home to Wedgewood Forest. Other plans available from the $270\'s to mis $300\'s \r\nPHOTOS ARE REPRESENTATIVE' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 8 Block 3 Section 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GIESINGER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Wedgewood Forest' ,`TaxAmount` = '' ,`TaxRate` = '2.8866' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667924608' WHERE `Matrix_Unique_ID` = '205082344' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T01:22:00.857' ,`MLSNumber` = '96306093' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.345373' ,`Longitude` = '-95.524025' ,`PhotoCount` = '48' ,`PostalCode` = '77304' ,`RoomCount` = '8' ,`ListPrice` = '311565.00' ,`Status` = 'Active' ,`StreetName` = 'Yellow Birch' ,`StreetNumber` = '796' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1759' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful New Colina Home. October 2022 COMPLETION!!! 1759 SF, 4 bedroom + 3 baths. 42\" Furniture finish cabinets, granite & stainless kitchen, 9\" deep Farm sink, subway tile, recessed LED lighting, stainless gas five-burner self cleaning range, vented microwave, & dishwasher. Vinyl plank flooring-- kitchen, baths, foyer &utility room. Mahogany Door, 9\' foot ceilings. Luxury primary suite - Tub/shower shower surrounds & granite double sink, sep shower/ oversized tub. Covered rear porch, SmartHome Package, garage door opener, 3-sides Acme Brick, Tankless H2O, Pex Plumbing, Taex, 16-seer HVAC, Front gutters, rear patio gas line, cement board rear. High energy efficiency. Amenities include tennis, stocked fishing pond for Residents only, playground, arbor, meandering brook, walking trails, Minutes from I -45, Lake Conroe, shopping, restaurants, golf, & many other recreational activities. Photos are representative. Other homes available from high 270\'s to mid 300\'s' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 10 Block 3 Sec 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Wedgewood Forest' ,`TaxAmount` = '' ,`TaxRate` = '2.8866' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667924609' WHERE `Matrix_Unique_ID` = '205834068' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T01:22:00.857' ,`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`='1667924609' WHERE `Matrix_Unique_ID` = '207129640' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T01:22:00.857' ,`MLSNumber` = '87466001' ,`ListAgentFullName` = 'Walter Bering' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.753138' ,`Longitude` = '-95.443145' ,`PhotoCount` = '50' ,`PostalCode` = '77019' ,`RoomCount` = '22' ,`ListPrice` = '6000000.00' ,`Status` = 'Active' ,`StreetName` = 'Inverness' ,`StreetNumber` = '3940' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '7' ,`BathsHalf` = '4' ,`BedsTotal` = '5' ,`SqFtTotal` = '11737' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Situated on approximately 2.8 acres, this River Oaks home has been called a \'residential country club\'. It has been the setting for many grand events and a motion picture. Situated in a park-like setting, the property offers swimming pools, lighted tennis court, party pavilion, outdoor kitchen and bar, and multi-level patio areas. The outdoor party pavilion is a large covered structure with beamed ceiling, bar area, and stage. Tennis court with gallery seating area. The interior living areas are nicely appointed with detailed moldings and hardwood floors. The formal living and dining rooms offer panoramic views of the wooded landscape. Primary bedroom suite features separate dressing areas and closets, office/sitting area, and fabulous views. The lower level is ideally suited as a large game room and open entertaining area with wetbar and adjoining separate dressing rooms/pool bath. Potential exercise room on the lower level. Truly nothing else like this property in River Oaks!' ,`Acres` = '2.8' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'River Oaks Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'TRS 2B-2 & 2C BLK 92 RIVER OAKS TALL TIMBERS' ,`LotDesciption` = 'Subdivision Lot,Waterfront,Wooded' ,`LotSize` = '122100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '4708' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'RIVER OAKS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2.5' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'River Oaks Tall Timbers' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924609' WHERE `Matrix_Unique_ID` = '208150069' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T01:22:00.857' ,`MLSNumber` = '78222494' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.404660' ,`Longitude` = '-95.510165' ,`PhotoCount` = '10' ,`PostalCode` = '77318' ,`RoomCount` = '6' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Lincoln Rim' ,`StreetNumber` = '216' ,`StreetSuffix` = 'Pass' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1802' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Experience the benefits of living in an award winning urban planned development of The Woodlands Hills with miles of hiking and biking trails. Resort style amenities include adult lap pool, community meeting center, full size gym, 17 acre park, tennis courts, dog parks, splash pad and lazy river. Entertain in style and enjoy the everyday comforts of The Penmark family home plan. Begin and end each day in the perfect paradise of your Extended Owner’s Retreat, which features a refined bathroom with separate tub and shower along with a sprawling walk-in closet. Each spare bedroom provides a wonderful place for unique personalities to flourish. The chef’s specialty kitchen includes a full-function island and a walk in pantry. Your open floor plan offers an impeccable space to play host to picture-perfect memories and brilliant social gatherings. Get the most out of each day in this lovely EnergySaver™ new home plan.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5625' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Hills' ,`TaxAmount` = '' ,`TaxRate` = '3.28' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667924609' WHERE `Matrix_Unique_ID` = '208283599' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T01:22:00.857' ,`MLSNumber` = '28375166' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.404771' ,`Longitude` = '-95.510237' ,`PhotoCount` = '15' ,`PostalCode` = '77318' ,`RoomCount` = '8' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Lincoln Rim' ,`StreetNumber` = '220' ,`StreetSuffix` = 'Pass' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1622' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Experience the benefits of living in an award winning urban planned development of The Woodlands Hills with miles of hiking and biking trails. Resort style amenities include adult lap pool, community meeting center, full size gym, 17 acre park, tennis courts, dog parks, splash pad and lazy river. Timeless elegance and impeccable craftsmanship come together in the luxurious Cloverstone new home plan. Decorate and furnish your open-concept living space to perfectly fit your interior design style. The streamlined kitchen features a family gathering island and plenty of room for collaborative feast creation. Your two spare bedrooms offers large closets. Retire to the superb comfort of your Owner’s Retreat, which includes a pamper-ready bathroom and a deluxe glass enclosed shower and a walk-in closet.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1 Block 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5625' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Hills' ,`TaxAmount` = '' ,`TaxRate` = '3.28' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667924609' WHERE `Matrix_Unique_ID` = '208285017' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T01:22:00.857' ,`MLSNumber` = '21673401' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.960403' ,`Longitude` = '-95.195847' ,`PhotoCount` = '42' ,`PostalCode` = '77346' ,`RoomCount` = '18' ,`ListPrice` = '659983.00' ,`Status` = 'Active' ,`StreetName` = 'Alpenglow Lake' ,`StreetNumber` = '12307' ,`StreetSuffix` = 'Path' ,`City` = 'Humble' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3762' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOVE IN READY!! Westin Homes NEW Construction (Carter VI, Elevation F) Two Story. 5 bedrooms, 4.5 baths. Private Primary Suite with spacious double walk-in closets downstairs. Formal Dining Room and Study with Spacious Kitchen and breakfast area open to Family Room. Spacious Game Room upstairs with private Media Room. Extended covered patio and attached 2 car garage. Featuring new homes near Lake Houston and nearly 1,000 acres of wooded bliss, The Groves is a one-of-a-kind master-planned community. It is conveniently located in the acclaimed Humble ISD with easy access to Beltway 8 and Hwy 59. The Hearth Amenity Center is the center of this community and features a resort-style pool, an oversized hearth fireplace with cozy bistro seating and soft festoon lighting. Stop by the Westin Homes model home today to find out more about The Groves!' ,`Acres` = '0.207' ,`Area` = '1' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9015' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1056' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GROVES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Groves' ,`TaxAmount` = '2360' ,`TaxRate` = '3.7' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667924609' WHERE `Matrix_Unique_ID` = '209316939' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T01:22:00.857' ,`MLSNumber` = '33190253' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.405771' ,`Longitude` = '-95.508276' ,`PhotoCount` = '50' ,`PostalCode` = '77318' ,`RoomCount` = '7' ,`ListPrice` = '405000.00' ,`Status` = 'Active' ,`StreetName` = 'Winged Elm' ,`StreetNumber` = '155' ,`StreetSuffix` = 'Court' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2356' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Thornleigh combines easy elegance with the streamlined versatility to adapt to your family’s lifestyle changes through the years. Escape to the everyday vacation of your Owner’s Retreat, which includes a delightful bathroom and a deluxe walk-in closet. Your open-concept living space awaits your interior design style to create the ultimate atmosphere for special occasions and daily life. The streamlined kitchen is optimized to support solo chefs and family cooking adventures. Unique decorative flair and growing minds are equally at home in the lovely spare bedrooms. Craft the perfect specialty rooms for you and yours in the incredible downstairs sunlit study and the cheerful upstairs retreat. Experience the benefits of living in an award winning urban planned development of The Woodlands Hills with miles of hiking and biking trails. Resort style amenities include adult lap pool, full size gym, splash pad and lazy river. Home is situated on oversize corner cul-de-sac homesite.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 37 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5625' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Hills' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667924610' WHERE `Matrix_Unique_ID` = '209602766' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T01:22:00.857' ,`MLSNumber` = '12648537' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.992190' ,`Longitude` = '-95.501280' ,`PhotoCount` = '18' ,`PostalCode` = '77068' ,`RoomCount` = '4' ,`ListPrice` = '294990.00' ,`Status` = 'Active' ,`StreetName` = 'Tulip Oak' ,`StreetNumber` = '4226' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION! 2.46% LOW Tax Rate! This Manchester floorplan features an open concept kitchen with modern cabinets and countertops, open to the family room. The owner’s suite is downstairs and includes a generous sized walk-in closet and separate tub and walk-in shower in the bathroom. The upstairs features an OVERSIZED GAME ROOM perfect for entertainment or little ones to play, PLUS an extra flex room fit for a study or your choice of space!' ,`Acres` = '' ,`Area` = '13' ,`BuilderName` = 'Rausch Coleman Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S3 11-1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5066' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PAT REYNOLDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stuebner Hollow' ,`TaxAmount` = '' ,`TaxRate` = '2.46' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667924610' WHERE `Matrix_Unique_ID` = '209846583' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T01:22:00.857' ,`MLSNumber` = '55337590' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.166932' ,`Longitude` = '-95.637929' ,`PhotoCount` = '19' ,`PostalCode` = '77486' ,`RoomCount` = '9' ,`ListPrice` = '376000.00' ,`Status` = 'Active' ,`StreetName` = 'Green Meadows' ,`StreetNumber` = '553' ,`StreetSuffix` = 'Drive' ,`City` = 'West Columbia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2507' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 55337590 No Back Neighbors! BUILT BY CASTLEROCK UNDER CONSTRUCTION! Rio Grande (A-Elevation) 2-Story 4 BD 2.5 BA 3 Car Garage 2,507 sq ft! Lot Size 9,374 sq ft. High Ceilings! Open Concept! Impressive Interior Upgrades! Modern White 42\" Kitchen Cabinets! Quartz Counters! Stainless finish appliances exude refinement and elegance! Inviting Owner\'s Suite! Soaker Tub & Separate Shower! Wall of windows! Energy-Efficient! HERS Rated! No Flooding! Tankless Water Heater! Low Tax Rate 2.186! Offers a golf course family-friendly gated community, Easy Commute to Hwy 288, Exciting Pearland Town Center, Houston, Sweeny, Bay City, Angleton & Lake Jackson! Enjoy the beach just 30 mins away! CastleRock offers BRAND NEW HOMES! Spacious 1 & 2 Story plans! Quick Move-In Homes Available! Explore the natural splendor and enjoy laid-back living in Columbia Lakes where neighbors gather and beautiful memories are made. Come take a look! Schedule a tour today!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 101, Block 31, Section 3' ,`LotDesciption` = 'Greenbelt,In Golf Course Community,Subdivision Lot' ,`LotSize` = '9372' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Columbia Lakes' ,`TaxAmount` = '' ,`TaxRate` = '2.186289' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667924610' WHERE `Matrix_Unique_ID` = '210077924' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T01:22:00.857' ,`MLSNumber` = '52069998' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.992190' ,`Longitude` = '-95.501280' ,`PhotoCount` = '20' ,`PostalCode` = '77068' ,`RoomCount` = '4' ,`ListPrice` = '304990.00' ,`Status` = 'Active' ,`StreetName` = 'Tulip Oak' ,`StreetNumber` = '4231' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2362' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Meridian Floorplan - If you like an open floor plan, this is as open as it gets! Soaring 17\' ceilings in Family Room. Game Room is open to the Family Room below. Kitchen features granite counter tops and stainless appliances. Quartz counter tops in the bathrooms. Primary bedroom has a 8\' x 12\' walk in closet!!! Rausch Coleman is closed on Sundays. $400 annual HOA. 2.46% LOW Tax Rate before Homestead. No escalation clause!!!' ,`Acres` = '' ,`Area` = '13' ,`BuilderName` = 'Rausch Coleman Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S3 11-2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5175' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PAT REYNOLDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stuebner Hollow' ,`TaxAmount` = '' ,`TaxRate` = '2.59' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667924610' WHERE `Matrix_Unique_ID` = '210458627' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T01:22:00.857' ,`MLSNumber` = '30483832' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.344728' ,`Longitude` = '-95.527164' ,`PhotoCount` = '46' ,`PostalCode` = '77304' ,`RoomCount` = '10' ,`ListPrice` = '386700.00' ,`Status` = 'Active' ,`StreetName` = 'Wedgewood Park' ,`StreetNumber` = '731' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2032' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Colina Homes Model Home. Loaded with great features. 2032 plan. AVAILABLE FOR CLOSING 3 TO 6 MONTHS. Large home site backs to woods, 365 DAY RATE LOCK WITH 1X RATE FLOAT DOWN AVAILABLE. Full sod, sprinkler system, extra ceiling fans, wired security system, upgraded refrigerator, 42\" furniture finish cabinets, granite/SS kitchen, 9\" deep farm sink, recessed LED lights, gas 5-burner self cleaning range, vented microwave, dishwasher. LVP- kitchen, baths, foyer, study and utility room. Mahogany door, 9\' ceilings. Luxurious primary suite--bath/tub shower surrounds & double sink,sep. shower/ oversized garden tub, covered rear porch, garage opener, cement board rear. PEX, Taex In Wall,16 SEER HVAC, energy efficient. Residents only tennis, stocked fishing pond, playground, arbor, brook, walking trails. Minutes from I45, Willis, Magnolia, Huntsville, Spring,Lake Conroe &The Woodlands Mall, Sales office at 731 Wedgewood Park.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Block 2 Sec 1' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '10647' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Wedgewood Forest' ,`TaxAmount` = '' ,`TaxRate` = '2.8866' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667924611' WHERE `Matrix_Unique_ID` = '210977321' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T01:22:00.857' ,`MLSNumber` = '45949773' ,`ListAgentFullName` = 'Faye Ausmus' ,`ListOfficeName` = 'Ausmus Premier Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.429386' ,`Longitude` = '-95.636826' ,`PhotoCount` = '28' ,`PostalCode` = '77356' ,`RoomCount` = '7' ,`ListPrice` = '692500.00' ,`Status` = 'Active' ,`StreetName` = 'Bentwood' ,`StreetNumber` = '114' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3728' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great family Hime-High Ceilings through out, 2 bedrooms down!. Enjoy entertaining with a very large family room open to the kitchen. Kitchen features large 9\' island, Shaker Style Wood Cabinets w/soft close drawers and doors, Quartz Countertops with Waterfall sides. Beautiful Engineered Hardwood Floors, Other custom features include 8\' interior doors and 8\" Baseboards. Work from home? No problem! Spacious Study located off the front entry( or another bedroom with a full bath) . Upstairs 3 Bedrooms each with their own bath and a very Large game room with a view of the Lake at meadows Park. Large Walk in showers in each bathroom. 214 Sq. Ft lanai! Or dining area with a view of the lake at Meadows Park. Space allowed for nice Wine Room off Entry/Kitchen.walk across street to Meadows Park. Want room for a Pool- See attached idea for Lap Pool and Photo of conceptual idea. Corner Lot. Walk to the Meadows Park..... Make an appointment to see, or video your!' ,`Acres` = '0.1698' ,`Area` = '39' ,`BuilderName` = 'SK & SA HomeBuilders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BENTWATER 33, BLOCK 1, LOT 1' ,`LotDesciption` = 'Corner,In Golf Course Community,Subdivision Lot,Water View' ,`LotSize` = '7397' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Bentwater 33' ,`TaxAmount` = '405' ,`TaxRate` = '2.1898' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667924611' WHERE `Matrix_Unique_ID` = '211996729' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T02:27:13.737' ,`MLSNumber` = '73740595' ,`ListAgentFullName` = 'Jane LeMoine' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.226291' ,`Longitude` = '-95.553893' ,`PhotoCount` = '21' ,`PostalCode` = '77354' ,`RoomCount` = '6' ,`ListPrice` = '379000.00' ,`Status` = 'Active' ,`StreetName` = 'WESTWOOD NORTH' ,`StreetNumber` = '210' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ALL MEASUREMENTS NOT SEEMED TO BE RELIABLE. PLEASE MEASURE YOURSELF. NESTLED AMONGST TALL TREES IN THE DEIREABLE WESTWOOD SUBDIVISION, THIS BEAUTIFUL HOME HAS BEEN TASTEFULLY REDONE FRO, FLOOR TO CEILING. BRAND NEW DRIVE , LANDSCAPING W SPRINKLER STYSTEM. UPON ENTERING, YOU HAVE BEAUTIFUL WOOD FLOORS THAT STEP DOWN TO THE GRANDEOSO FAMILY ROOM. 30 FT CATHEDRAL CEILINGS WITH CAN LIGHTING AND ROWS OF SKYLIGHTS ALLOWING LOTS OF NATURAL LIGHT. A STONE FIREPLACE SETS THE ATMOSPHER OF A SKI LODGE.THE WALL OF WINDOWS AND FRENCH DOORS PRESENT A ZEN FEELING OF ALL NATURE. GREAT FOR ENTERTAINING. ALL NEW STAINLESS APPLIANCES AND BEAUTIFUL CABINETRY IN KITCHEN. FAUX WHITE WOOD BLINDS THROUGHOUT. REGROUND YOURSELF IN NATURE AND FEEL THE FLOW OF SPIRIT.))' ,`Acres` = '0.29' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'lot 155 Blk 9 Westwood Sec 3' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '19901' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'TOM R. ELLISOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westwood' ,`TaxAmount` = '4089' ,`TaxRate` = '2.321' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924611' WHERE `Matrix_Unique_ID` = '212635516' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T01:22:00.857' ,`MLSNumber` = '84405141' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.992190' ,`Longitude` = '-95.501280' ,`PhotoCount` = '17' ,`PostalCode` = '77068' ,`RoomCount` = '4' ,`ListPrice` = '304990.00' ,`Status` = 'Active' ,`StreetName` = 'Tulip Oak' ,`StreetNumber` = '4210' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2340' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'No Back Neighbors! 2.46% LOW Tax Rate! This Manchester floorplan features an open concept kitchen with modern cabinets and countertops, open to the family room. The owner’s suite is downstairs and includes a generous sized walk-in closet and separate tub and walk-in shower in the bathroom. The upstairs features an OVERSIZED GAME ROOM perfect for entertainment or little ones to play, PLUS an extra flex room fit for a study or your choice of space!' ,`Acres` = '' ,`Area` = '13' ,`BuilderName` = 'Rausch Coleman Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 15 - Block 1 - Section 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5125' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PAT REYNOLDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stuebner Hollow' ,`TaxAmount` = '' ,`TaxRate` = '2.46' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667924611' WHERE `Matrix_Unique_ID` = '212982250' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T01:22:00.857' ,`MLSNumber` = '21229106' ,`ListAgentFullName` = 'Meaghan Arceneaux' ,`ListOfficeName` = 'Mega Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.970021' ,`Longitude` = '-95.460797' ,`PhotoCount` = '21' ,`PostalCode` = '77541' ,`RoomCount` = '3' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Bluebonnet' ,`StreetNumber` = '311' ,`StreetSuffix` = 'Drive' ,`City` = 'Jones Creek' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2171' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEVER FLOODED! Welcome to 311 Bluebonnet. This stunning country oasis features 3 bedrooms and 1 and a half baths. Spacious kitchen with an abundance of counter and cabinet space. A lovely sunroom with surrounding windows allowing natural light. This lovely home is nestled on 2.84 acres. This home sits back off the road and features a long driveway and many mature trees and producing pecan trees. Additional outdoor amenities include an oversized shop with a an ac unit and a large deck that is perfect for entertaining. Some updates that were done in 2019 include the home was completely rewired, duct work redone, installed a new ac unit, floors, light fixtures and paint! Come out and see this beauty today!!' ,`Acres` = '2.84' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Freeport' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PEACHCREST HOMESITES (A0020 S F AUSTIN DIV 17)(JONES CREEK),' ,`LotDesciption` = 'Cleared' ,`LotSize` = '123710' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (BRAZOSPORT)' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'PEACHCREST' ,`TaxAmount` = '6822' ,`TaxRate` = '2.51243' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924611' WHERE `Matrix_Unique_ID` = '213004564' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T01:16:19.990' ,`MLSNumber` = '67424766' ,`ListAgentFullName` = 'Samuel Marshall' ,`ListOfficeName` = 'Flash Realty Solutions' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.662529' ,`Longitude` = '-95.016579' ,`PhotoCount` = '24' ,`PostalCode` = '77571' ,`RoomCount` = '3' ,`ListPrice` = '164500.00' ,`Status` = 'Active' ,`StreetName` = 'Virginia' ,`StreetNumber` = '324' ,`StreetSuffix` = 'Street' ,`City` = 'La Porte' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1252' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming home on an oversized corner lot in La Porte, just minutes from the water. The refinished original hardwood floors are a must see, along with a new roof (2022) and paint job. Beautiful mature oak trees shade the large fenced/gated yard and patio space, great for hosting get-togethers! Good starter home or investment property, priced aggressively, and ready for immediate move-in.' ,`Acres` = '0.2611' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 15 16 & 17 & S 16 FT OF LT 18 BLK 218 SAN JACINTO HOMES' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '11375' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'LA PORTE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'San Jacinto Homes' ,`TaxAmount` = '2618' ,`TaxRate` = '2.7208' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1952' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924612' WHERE `Matrix_Unique_ID` = '213116393' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T01:22:00.857' ,`MLSNumber` = '943861' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.792947' ,`Longitude` = '-95.572979' ,`PhotoCount` = '41' ,`PostalCode` = '77043' ,`RoomCount` = '6' ,`ListPrice` = '459995.00' ,`Status` = 'Active' ,`StreetName` = 'Swang Link' ,`StreetNumber` = '10976' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1801' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful new David Weekley home in Brittmoore Crossing offers first-floor living at its finest. The open-concept family room, kitchen, and dining space feature hardwood flooring and ample sunlight filtering in through energy-efficient windows. Upstairs, you\'ll find a spacious Owner\'s Retreat with a large walk-in closet and en suite bathroom. Two spare bedrooms offer ample closet space, individual style, and privacy. Expert-selected enhancements include painted cabinetry, upgraded countertops and more! End your busy day relaxing by the large community pool, strolling through the community park, or relaxing in your own backyard. Come see the low-maintenance lifestyle and amenities that await you in this delightful community near City Center.' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 29 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`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,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Brittmoore Crossing' ,`TaxAmount` = '' ,`TaxRate` = '2.67' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667924612' WHERE `Matrix_Unique_ID` = '213157749' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T01:22:00.857' ,`MLSNumber` = '82209985' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.792700' ,`Longitude` = '-95.570477' ,`PhotoCount` = '35' ,`PostalCode` = '77043' ,`RoomCount` = '6' ,`ListPrice` = '489995.00' ,`Status` = 'Active' ,`StreetName` = 'Brambling Wood' ,`StreetNumber` = '10915' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1802' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful David Weekley new home in Brittmoore Crossing offers first-floor living at its finest. Located near the pool, on a CORNER, this home features Elegant wood-look flooring and energy-efficient windows, and an abundace of light. Quartz countertops and painted cabinetry are just two of the stylish and practical upgrades applied to the tasteful kitchen. Upstairs, you\'ll find a spacious Owner\'s Retreat with a large walk-in closet,  14\' cathedral ceiling, and a delightful en suite bathroom. Two additional bedrooms, a full bath, and a full-sized laundry room round out the second floor. The second floor landing is the perfect space for that home office! Guests can easily visit and park in your Extended DRIVEWAY! Contact David Weekley’s Brittmoore Crossing Team to learn about the industry-leading warranty and low-maintenance lifestyle you’ll enjoy with this amazing new home in Houston, Texas!' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 28 Block 2' ,`LotDesciption` = 'Patio Lot,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`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,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Brittmoore Crossing' ,`TaxAmount` = '' ,`TaxRate` = '2.67' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667924612' WHERE `Matrix_Unique_ID` = '213202215' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T01:55:54.587' ,`MLSNumber` = '44048894' ,`ListAgentFullName` = 'Corina Garcia' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.033320' ,`Longitude` = '-95.223150' ,`PhotoCount` = '25' ,`PostalCode` = '77339' ,`RoomCount` = '4' ,`ListPrice` = '400000.00' ,`Status` = 'Active' ,`StreetName` = 'Deer Springs' ,`StreetNumber` = '2010' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2549' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Practically brand new home!! Ready for you to make it yours! Super nice sized backyard with detached garage. Neutral colors and primary bedroom on first floor.' ,`Acres` = '0.2577' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 33 TRAILWOOD VILLAGE SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11224' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '390' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'FOSTER ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Trailwood Village Sec 05' ,`TaxAmount` = '3694' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924612' WHERE `Matrix_Unique_ID` = '213326940' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T01:13:11.750' ,`MLSNumber` = '69626906' ,`ListAgentFullName` = 'Samuel Marshall' ,`ListOfficeName` = 'Flash Realty Solutions' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.662701' ,`Longitude` = '-95.465615' ,`PhotoCount` = '22' ,`PostalCode` = '77035' ,`RoomCount` = '5' ,`ListPrice` = '359000.00' ,`Status` = 'Active' ,`StreetName` = 'Doud' ,`StreetNumber` = '10819' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1784' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful remodel in the heart of the ever-popular Westbury subdivision! Not only is it zoned to highly regarded Kolter Elementary, it is also just minutes from Meyerland Plaza, NRG Stadium, and the med center. As for the house, Buyer\'s will be able to tell all the little details that were considered during this comprehensive rehab. Starting with the exterior, you will notice a new roof (2022), AC unit (2022), garage doors (2022), Low-E windows, shaker-style shutters, and paint. Inside, updates include brand new designer tile, LVP flooring, new custom shaker-style, soft-close cabinetry, quartz countertops, and SS appliances (2022). The optimized floorplan boasts a dining area, living area, oversized kitchen island, study/office, and in-house mud/utility room. No knowledge of flooding, and not in a flood zone, per Seller.' ,`Acres` = '0.1653' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 24 BLK 5 WESTBURY SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KOLTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Westbury Sec 01' ,`TaxAmount` = '5493' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924613' WHERE `Matrix_Unique_ID` = '213584677' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T01:22:00.857' ,`MLSNumber` = '37034430' ,`ListAgentFullName` = 'Dee Dee Guggenheim Howes' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.749819' ,`Longitude` = '-95.413174' ,`PhotoCount` = '14' ,`PostalCode` = '77019' ,`RoomCount` = '12' ,`ListPrice` = '1892000.00' ,`Status` = 'Active' ,`StreetName` = 'Stanmore' ,`StreetNumber` = '2203' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2640' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss this outstanding opportunity to acquire a fantastic future lot or remodel opportunity in coveted River Oaks on the Stanmore Courtyards. The two-story dwelling features expansive living and dining rooms, a large kitchen with breakfast room, & three bedrooms, including a guest suite with full bath on the first floor. Charming details and light filled windows run throughout this 3 BD/3 BA home. The just under 10,000’ lot has mature trees & features amazing frontage to Stanmore Drive on the courtyards. Enjoy easy access to great shopping, River Oaks Country Club and close proximity to Memorial Park, and The Galleria. Zoned for top-rated Houston ISD schools, including River Oaks Elementary.' ,`Acres` = '0.2282' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Mock Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'River Oaks Area' ,`HeatSystem` = 'Central Electric,Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 & TR 17 BLK 42 RIVER OAKS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9942' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2357' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`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' ,`TaxAmount` = '31580' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1936' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924613' WHERE `Matrix_Unique_ID` = '213664702' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T01:22:00.857' ,`MLSNumber` = '49066097' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.792612' ,`Longitude` = '-95.572813' ,`PhotoCount` = '10' ,`PostalCode` = '77043' ,`RoomCount` = '8' ,`ListPrice` = '498885.00' ,`Status` = 'Active' ,`StreetName` = 'Swang Link' ,`StreetNumber` = '10979' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2347' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful new David Weekley home in Brittmoore Crossing offers first-floor living at its finest. The open-concept family room, kitchen, and dining space feature hardwood flooring and ample sunlight filtering in through energy-efficient windows. Upstairs, you\'ll find a spacious Owner\'s Retreat with a large walk-in closet and en suite bathroom. Two spare bedrooms offer ample closet space, individual style, and privacy. Continue to the third floor and find a game room retreat with 4th Bedroom and Full Bath! Expert-selected enhancements include painted cabinetry, upgraded countertops and more! End your busy day relaxing by the large community pool, strolling through the community park, or relaxing in your own backyard. Come see the low-maintenance lifestyle and amenities that await you in this delightful community near City Center.' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 16 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`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,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Brittmoore Crossing' ,`TaxAmount` = '' ,`TaxRate` = '2.67' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667924613' WHERE `Matrix_Unique_ID` = '213667505' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T01:22:00.857' ,`MLSNumber` = '84050177' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.792948' ,`Longitude` = '-95.572917' ,`PhotoCount` = '31' ,`PostalCode` = '77043' ,`RoomCount` = '7' ,`ListPrice` = '519995.00' ,`Status` = 'Active' ,`StreetName` = 'Swang Link' ,`StreetNumber` = '10972' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2406' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful David Weekley new home in Brittmoore Crossing offers first-floor living at its finest. Elegant Wood-look flooring and energy-efficient windows create a refined foundation for your personal design style. Upgraded countertops and painted cabinetry are just two of the stylish and practical upgrades applied to the tasteful kitchen. Upstairs, you\'ll find a spacious Owner\'s Retreat with a large walk-in closet, and a delightful en suite bathroom. Two additional bedrooms, a full bath, and a full-sized laundry room round out the second floor. Continue to the 3rd Floor for a private game room with ajoining 4th Bedroom & 3rd Bath!Enjoy the privacy of your generous backyard! Contact David Weekley’s Brittmoore Crossing Team to learn about the industry-leading warranty and low-maintenance lifestyle you’ll enjoy with this amazing new home in Houston, Texas!' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 31 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`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,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Brittmoore Crossing' ,`TaxAmount` = '' ,`TaxRate` = '2.67' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667924613' WHERE `Matrix_Unique_ID` = '213669534' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T01:22:00.857' ,`MLSNumber` = '14079291' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.792950' ,`Longitude` = '-95.572825' ,`PhotoCount` = '9' ,`PostalCode` = '77043' ,`RoomCount` = '7' ,`ListPrice` = '539995.00' ,`Status` = 'Active' ,`StreetName` = 'Swang Link' ,`StreetNumber` = '10966' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2347' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful David Weekley new home in Brittmoore Crossing offers first-floor living at its finest. Luxury Wood-Look flooring and energy-efficient windows create a refined foundation for your personal design style. Quartz countertops and painted cabinetry are just two of the stylish and practical upgrades applied to the tasteful kitchen. Upstairs, you\'ll find a spacious Owner\'s Retreat with a large walk-in closet,  14\' cathedral ceiling, and a delightful en suite bathroom. Two additional bedrooms, a full bath, and a full-sized laundry room round out the second floor. Continue to the Game Room on the third floor for movie night and 4th Bedroom and 3rd Bathroom! Contact David Weekley’s Brittmoore Crossing Team to learn about the industry-leading warranty and low-maintenance lifestyle you’ll enjoy with this amazing new home in Houston, Texas!' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 38 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`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,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Brittmoore Crossing' ,`TaxAmount` = '' ,`TaxRate` = '2.67' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667924613' WHERE `Matrix_Unique_ID` = '213671397' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T01:22:00.857' ,`MLSNumber` = '41225374' ,`ListAgentFullName` = 'Tanna Villarreal' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.270450' ,`Longitude` = '-95.477392' ,`PhotoCount` = '40' ,`PostalCode` = '77304' ,`RoomCount` = '6' ,`ListPrice` = '579000.00' ,`Status` = 'Active' ,`StreetName` = 'Timber Voyage' ,`StreetNumber` = '580' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2627' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Find your new home in this modern beauty sitting on over 1/4 of an acre of private backyard bliss! Located in a quiet cul-de-sac and backing up to a reserve, you will always have the peace and quiet you crave. Add a pool or just enjoy the views and sounds of nature. The beauty doesn\'t stop on the outside though. Interior features include upgraded lighting and energy efficiency improvements, designer accent paint, quartz countertops, custom window treatments, a built-in electric fireplace and so so much more!' ,`Acres` = '0.2804' ,`Area` = '19' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 17 BLOCK 1' ,`LotDesciption` = 'Greenbelt,Wooded' ,`LotSize` = '12214' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1072' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Central Park' ,`TaxAmount` = '11111' ,`TaxRate` = '3.086' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924614' WHERE `Matrix_Unique_ID` = '213807240' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T01:22:00.857' ,`MLSNumber` = '54154040' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.792800' ,`Longitude` = '-95.573476' ,`PhotoCount` = '8' ,`PostalCode` = '77043' ,`RoomCount` = '6' ,`ListPrice` = '494995.00' ,`Status` = 'Active' ,`StreetName` = 'Sloane Manor' ,`StreetNumber` = '1224' ,`StreetSuffix` = 'Trace' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1812' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful David Weekley new home in Brittmoore Crossing offers first-floor living at its finest. Luxury Wood-Look flooring and energy-efficient windows create a refined foundation for your personal design style. Granite countertops and painted cabinetry are just two of the stylish and practical upgrades applied to the tasteful kitchen. Upstairs, you\'ll find a spacious Owner\'s Retreat with a large walk-in closet, 14\' cathedral ceiling, and a delightful en suite bathroom. Two additional bedrooms, a full bath, and a full-sized laundry room round out the second floor. The second floor landing is the perfect space for that home office!Contact David Weekley’s Brittmoore Crossing Team to learn about the industry-leading warranty and low-maintenance lifestyle you’ll enjoy with this amazing new home in Houston, Texas!' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 25 Block 01' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`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,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Brittmoore Crossing' ,`TaxAmount` = '' ,`TaxRate` = '2.67' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667924614' WHERE `Matrix_Unique_ID` = '213942303' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T01:22:00.857' ,`MLSNumber` = '73924451' ,`ListAgentFullName` = 'Meaghan Arceneaux' ,`ListOfficeName` = 'Mega Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.061669' ,`Longitude` = '-95.442986' ,`PhotoCount` = '27' ,`PostalCode` = '77566' ,`RoomCount` = '3' ,`ListPrice` = '239900.00' ,`Status` = 'Active' ,`StreetName` = 'Anchusa' ,`StreetNumber` = '107' ,`StreetSuffix` = 'Street' ,`City` = 'Lake Jackson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1840' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Hit the brakes, you\'re home! This Lake Jackson charmer is hitting the market showcasing 3 bedrooms, 2 bathrooms, and an office. From the large front porch to the privacy fenced back yard- this home has it all! Upon entry take note of the wood beams and the floor to ceiling bricked fire place. Open concept between living area and kitchen make this the ideal place to host friends and family. Kitchen features quartz countertops, all wood cabinetry, and tons of storage! Great sized bedrooms, and updated restrooms make this home ideal and move in ready. The backyard has a large concrete patio that overlooks the yard and makes the perfect hang out spot! Schedule your tour today and see for yourself what all this home has to offer!' ,`Acres` = '0.2692' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Jackson' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TANGLEWOOD SEC 3 (LAKE JACKSON), BLOCK 14, LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11726' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`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` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'TANGLEWOOD' ,`TaxAmount` = '3497' ,`TaxRate` = '2.192612' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924614' WHERE `Matrix_Unique_ID` = '213994490' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T01:22:00.857' ,`MLSNumber` = '34194743' ,`ListAgentFullName` = 'Meaghan Arceneaux' ,`ListOfficeName` = 'Mega Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.039113' ,`Longitude` = '-95.433996' ,`PhotoCount` = '18' ,`PostalCode` = '77566' ,`RoomCount` = '3' ,`ListPrice` = '169000.00' ,`Status` = 'Active' ,`StreetName` = 'Winding Way' ,`StreetNumber` = '710' ,`StreetSuffix` = '' ,`City` = 'Lake Jackson' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '995' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this Lake Jackson charmer. Centrally located and situated on a nice size, shaded lot. This 3 bedroom 1 bathroom home has ALL of the updates your looking for AND more! All plumbing lines replaced in 2012. All electrical rewired in 2015. All new HVAC AND ductwork. All NEW insulation in 2015. All flooring and paint 2015 & 2022. NEW water heater 2015. New ROOF 2015. Exterior wood repair and paint 2015. Looking for something move in ready and problem free?! This home is the home for you! Enjoy this screened breeze way and large deck over looking your back yard. This home is set up for the person who enjoys to entertain. Lake Jackson school zones. No flooding. Close to schools, shopping, entertainment, and more!' ,`Acres` = '0.2126' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Jackson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'AREA B-C-D-E-G-H-J-K-L ETC (LAKE JACKSON) BLK 5 LOT 50 AREA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9260' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'BEUTEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE JACKSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'LAKE JACKSON (MID-RNG)' ,`TaxAmount` = '1973' ,`TaxRate` = '2.192612' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1943' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924614' WHERE `Matrix_Unique_ID` = '214002996' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T01:34:32.210' ,`MLSNumber` = '62329286' ,`ListAgentFullName` = 'Kina Jefferson' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.685453' ,`Longitude` = '-95.370481' ,`PhotoCount` = '15' ,`PostalCode` = '77021' ,`RoomCount` = '5' ,`ListPrice` = '229999.00' ,`Status` = 'Active' ,`StreetName` = 'Noah' ,`StreetNumber` = '3617' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '962' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION! LOCATION! LOCATION! Located in South Medical Center area. Easy access to 288, 610, and minutes away from the Medical Center, NRG Stadium, Downtown, University of Houston, and Texas State University. This house features 3 Bedroom, 1 bathroom, 1 car garage, large backyard for entertaining. Recently remodeled with granite countertops and stainless steel appliances, tiled bathroom and laundry room. No carpet throughout the house.' ,`Acres` = '0.1148' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 19 BLK 36 SOUTH END SUNNYSIDE U/R' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WHIDBY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'South End Sunnyside U/R' ,`TaxAmount` = '2259' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924615' WHERE `Matrix_Unique_ID` = '214076400' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T01:22:00.857' ,`MLSNumber` = '37555726' ,`ListAgentFullName` = 'Kristina Davidson' ,`ListOfficeName` = 'Executive Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.622764' ,`Longitude` = '-96.411667' ,`PhotoCount` = '27' ,`PostalCode` = '77807' ,`RoomCount` = '9' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Coyotillo' ,`StreetNumber` = '4708' ,`StreetSuffix` = 'Way' ,`City` = 'Bryan' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2313' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Motivated Seller ..Check out this meticulously maintained hm that is loaded with upgrades galore!Pride of ownership shows in this 4/2.1 hm +game room & office.Reck the benefits of super low utility bills w/32 solar panels (not to mention the tax credit you will get).Sellers keep the hm @ 70 EVERY day & night they are a family of 5.All utilities trash,sewer,electric & water avg about $150.00 a month WOW..Hm comes equipped w/a Vivid security system including 1 outdoor front camera,1 outdoor camera in backyard and one camera you can put where you like plus a doorbell.OOO also it has a smoke alarm that notifies the local fire dept ASAP.Some upgrades include 42”cabinets,recessed lighting throughout,upgraded carpet and padding,gutters on front,sprinkler system in front & back yard.Enjoy your morning coffee or wind down @ night with a glass of wine on the extended 15x10 back patio. This floor plan is no longer offered by the builder. Call today for a private showing.' ,`Acres` = '0.1148' ,`Area` = '61' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ALAMOSA SPRINGS PH 1, BLOCK 3, LOT 14' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5001' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '148 - Bryan' ,`SchoolElementary` = 'MARY BRANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRYAN HIGH SCHOOL' ,`SchoolMiddle` = 'STEPHEN F. AUSTIN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Alamosa Springs' ,`TaxAmount` = '2659' ,`TaxRate` = '2.3493' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924615' WHERE `Matrix_Unique_ID` = '214135948' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T01:22:00.857' ,`MLSNumber` = '10817468' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.792947' ,`Longitude` = '-95.572948' ,`PhotoCount` = '11' ,`PostalCode` = '77043' ,`RoomCount` = '6' ,`ListPrice` = '474995.00' ,`Status` = 'Active' ,`StreetName` = 'Swang Link' ,`StreetNumber` = '10974' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1812' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful David Weekley new home in Brittmoore Crossing offers first-floor living at its finest. Located in Phase 2 with no rear neighbors, this home features Elegant wood-look flooring and energy-efficient windows, and an abundance of light. Quartz countertops and painted cabinetry are just two of the stylish and practical upgrades applied to the tasteful kitchen. Upstairs, you\'ll find a spacious Owner\'s Retreat with a large walk-in closet,  14\' cathedral ceiling, and a delightful en suite bathroom. Two additional bedrooms, a full bath, and a full-sized laundry room round out the second floor. The second floor landing is the perfect space for that home office! Enjoy a relaxing evening in your LARGE backyard with NO Rear neighbors. Contact David Weekley’s Brittmoore Crossing Team to learn about the industry-leading warranty and low-maintenance lifestyle you’ll enjoy with this amazing new home in Houston, Texas!' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 30 Block 01' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`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,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Brittmoore Crossing' ,`TaxAmount` = '' ,`TaxRate` = '2.67' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667924615' WHERE `Matrix_Unique_ID` = '214278673' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T01:08:09.947' ,`MLSNumber` = '3049507' ,`ListAgentFullName` = 'Vianey Del Castillo' ,`ListOfficeName` = 'Select Pro Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.822137' ,`Longitude` = '-95.800222' ,`PhotoCount` = '29' ,`PostalCode` = '77493' ,`RoomCount` = '4' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Alberelli' ,`StreetNumber` = '3242' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1704' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come and see what this beautiful home has to offer. Spacious one story floor plan. Open concept kitchen, living and dining space perfect for entertaining and family time. Beautiful kitchen area with 42 inch cabinets with granite countertops. Large Master bedroom with in suit and walk-in closet. Secondary bedrooms are privately situated away from the owners retreat \r\nThis community has an amenity center with a resort-style pool as well as two sparkling lakes open for water sports. A new HEB coming soon. Camillo Lakes’ excellent location off the Grand Parkway and Interstate 10 puts you near favored Katy attractions such as Typhoon Lagoon as well as shopping and dining at Katy Mills Mall. Minutes to TX-99 and I-10 Call and make an appointment today!!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Legend Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 31 BLK 2 CAMILLO LAKES SEC 3' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '4950' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'LEONARD ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Camillo Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924615' WHERE `Matrix_Unique_ID` = '214337830' --> 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','214510945','1667924615','214510945','2022-11-08T01:58:54.277','88714094','Conway Shim','REALM Real Estate Professional','','','29.840166','-95.713524','46','77449','4','339000.00','Active','Cypress Bough','19646','Drive','Katy','2','1','4','2110','Single-Family','','0.2205','25','Royce Homes','','','','Sellers Disclosure','1','','1','Bear Creek South','Central Gas','1','LT 12 BLK 1 CYPRESS MEADOW SEC 4','Subdivision Lot','9605','Appraisal District','','300','0','','2','','0','','','','','Composition','13 - Cypress-Fairbanks','M ROBINSON ELEMENTARY SCHOOL','CYPRESS PARK HIGH SCHOOL','THORNTON MIDDLE SCHOOL (CY-FAIR)','Supra Keybox','Appraisal District','2','Traditional','Cypress Meadow','6197','2.796','Public Sewer,Public Water','2001','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','214510964','1667924615','214510964','2022-11-08T01:25:08.487','88292535','Lisa Gregory','Coldwell Banker Realty','','','29.454459','-94.627662','41','77650','8','1300000.00','Active','Gulf','1986','','Crystal Beach','3','1','3','2088','Single-Family','Stunning beachfront property with exceptional high-end finishes, expansive lot and breathtaking Gulf views! This 3 bedroom/3 bath property features all the amenities for full-time living or a second home. Spacious family room is light, bright and airy--with fireplace, exquisite furnishings and a wall of windows to enjoy the beachfront views. The kitchen--open to the family room and dining area--offers granite countertops, stainless appliances, beautiful fixtures, bar seating and expansive counter and storage space. Master suite features Gulf views, fireplace and a beautiful master bath with dual sinks, separate shower and tub! Two secondary bedrooms are finished with amazing custom details and include convenient ensuite baths. Outside, large covered and uncovered deck areas provide the perfect spot to relax and enjoy the restorative sights and sounds of the Gulf. Oversized garage, hot tub, bar area and outdoor shower are additional bonuses. Home sells furnished with minimal exclusions.','0.7658','33','','','Electric Dryer Connections,Washer Connections','','Exclusions,Sellers Disclosure','1','','2','Crystal Beach','Central Electric','0','ABST 179 PAGE 16 LOTS 9,10 & W 16.6 FT OF LOT 11 BLK 1 LOWRY','Cul-De-Sac,Water View,Waterfront','33358','Appraisal District','','','0','','1','Electric Oven','0','','','Electric Range','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required,Request Online Appointment','Appraisal District','1','Traditional','Patton Beach','11990','1.6103','Public Water','2010','Appraisal District'); --> New record created successfully