Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T09:08:25.047' ,`MLSNumber` = '26946490' ,`ListAgentFullName` = 'James Green' ,`ListOfficeName` = 'Green & Associates Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.467374' ,`Longitude` = '-95.567470' ,`PhotoCount` = '42' ,`PostalCode` = '77318' ,`RoomCount` = '10' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'Carmel' ,`StreetNumber` = '15498' ,`StreetSuffix` = 'Drive' ,`City` = 'Willis' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4833' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great home with a lot of recent updates located in Corinthian Point, just a short walk to Lake Conroe!!\r\nSituated on two lots with a drive through garage, this house has two bedrooms that can be used as the master bedroom, one downstairs and one upstairs. Downstairs you have a nice open kitchen with granite counter tops overlooking the breakfast area, living room and dining area. Tiled floors in the living area with sunk in seating area around the fireplace. Secondary living area could be used as a den or home office. Two spare bedrooms are also located downstairs. Entering the stairs from the front hallway will lead you up to a private master suite, large walk-in shower, oversized tub with double sinks and granite counters and a walk-in closet, outside the suite you will find a large, covered balcony overlooking the back yard. Above the downstairs master bedroom is a large 26x26 game room with half bath. Great neighborhood with lots of amenities!!' ,`Acres` = '0.4472' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CORINTHIAN POINT 02, BLOCK 16, LOT 239 & 240' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '19481' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '81' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'PARMLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Corinthian Point 02' ,`TaxAmount` = '7613' ,`TaxRate` = '2.2463' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778612' WHERE `Matrix_Unique_ID` = '208246626' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T08:33:14.890' ,`MLSNumber` = '92534403' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.833170' ,`Longitude` = '-95.856687' ,`PhotoCount` = '26' ,`PostalCode` = '77494' ,`RoomCount` = '15' ,`ListPrice` = '564657.00' ,`Status` = 'Active' ,`StreetName` = 'Sarasota Shore' ,`StreetNumber` = '827' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3040' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Ellicott, Elevation A) CURRENTLY BEING BUILT. Two story. 4 bedrooms, 3.5 baths. Primary suite with large walk-in closet. Second bedroom on first floor with private bath. First floor study and informal dining adjacent to the island kitchen. Upstairs additional 2 bedrooms, bathroom, game room and media room. Covered patio and attached 2 car garage. Located a few miles north of Interstate 10 and west of the Grand Parkway in thriving Katy, Sunterra is an inviting 1,039-acre master-planned community featuring home designs that fit your lifestyle, Sunterra is a launch pad for family adventures. Splash, play, paddleboard, build sandcastles and more at our gorgeous Crystal Lagoons® amenity. Designed to fit your lifestyle, the master plan calls for approximately 2,200 homes, lakes, parks, playgrounds and an expansive Amenity Village with a clubhouse and a pool overlooking the lagoon. Stop by the Westin Homes sales model to learn more about Sunterra!' ,`Acres` = '' ,`Area` = '25' ,`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` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 15 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6926' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BRYANT ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.53' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664778612' WHERE `Matrix_Unique_ID` = '209026109' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T08:44:05.310' ,`MLSNumber` = '73151345' ,`ListAgentFullName` = 'Daryl Pavlicek' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.699044' ,`Longitude` = '-95.829289' ,`PhotoCount` = '18' ,`PostalCode` = '77494' ,`RoomCount` = '7' ,`ListPrice` = '379900.00' ,`Status` = 'Active' ,`StreetName` = 'Salt Creek' ,`StreetNumber` = '26110' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2516' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful one story home in a cul-de-sac lot. Rotunda entrance with tile. Archway into the formal dining and game room/media. Game room can easily be converted into a 4th bedroom. Butlers pantry leading into the kitchen. Great for entertaining. Outdoor space touts covered patio and extended pressed stone patio.' ,`Acres` = '0.2082' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CINCO RANCH SOUTHWEST SEC 15, BLOCK 7, LOT 20' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9068' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'STANLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEVEN LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'SEVEN LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Cinco Ranch Southwest Sec 15' ,`TaxAmount` = '8717' ,`TaxRate` = '2.7845' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778612' WHERE `Matrix_Unique_ID` = '209518292' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T08:12:17.263' ,`MLSNumber` = '98931110' ,`ListAgentFullName` = 'Gaye Hale' ,`ListOfficeName` = 'Berkshire Hathaway HomeServicePremier Properties' ,`SellingAgentFullName` = 'Brandy Zimos' ,`SellingOfficeName` = 'Keller Williams Realty -SW' ,`Latitude` = '29.654213' ,`Longitude` = '-95.742463' ,`PhotoCount` = '29' ,`PostalCode` = '77406' ,`RoomCount` = '10' ,`ListPrice` = '675000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Prairie Manor' ,`StreetNumber` = '8607' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4202' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fabulous Darling home in Long Meadow Farms with soaring ceilings, crown molding. plantation shutters, design paint, hardwood and tile flooring. The gourmet kitchen is a chefs delight with endless countertop space, cabinets, a large breakfast island, walk in pantry and utility room with access to primary closet. Beautiful primary suite with huge walk in closet, private ensuite with double vanities, stand alone shower and luxurious soaking tub. Additionally there is a Jr Suite downstairs with a walk in closet waiting for your guests. Upstairs has a large game room and media room with 3 bedrooms and 2 full baths. This home has been meticulously loved and cared for in every aspect.' ,`Acres` = '0.2126' ,`Area` = '37' ,`BuilderName` = 'Darling Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LONG MEADOW FARMS SEC 18, BLOCK 2, LOT 49' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9262' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PECAN GROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'BOWIE MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Long Meadow Farms Sec 18' ,`TaxAmount` = '10336' ,`TaxRate` = '2.4929' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1664778612' WHERE `Matrix_Unique_ID` = '209953703' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T08:55:11.280' ,`MLSNumber` = '53721762' ,`ListAgentFullName` = 'Robert (Bob) Murdock' ,`ListOfficeName` = 'Bernstein Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.986300' ,`Longitude` = '-95.188725' ,`PhotoCount` = '35' ,`PostalCode` = '77346' ,`RoomCount` = '16' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar Breaks' ,`StreetNumber` = '12443' ,`StreetSuffix` = 'Court' ,`City` = 'Humble' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3555' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Dramatic 2 story porch entry & leaded glass front door opens to the 2 story foyer. Foyer is flanked by the formal dining to one side & a study with French doors to the other. Primary bedroom & second bedroom both on the ground floor.Secondary bedroom w/direct access to a full bath.Family room is open to the large island kitchen. Fireplace is on an interior wall so unobstructed views provided out the windows to the back yard.Spacious primary bedroom also w/views to the back yard has a large bath w/whirlpool tub & separate shower.Entire first floor is either tile or engineered wood,even includes wood on the stairs to the second floor.Highly desirable quiet cul-de-sac location,yet quick access to all of the arterial streets for shopping & restaurants.Upstairs starts w/a large game room.Game room is flanked by the 3 additional bedrooms.One pair has a jack & jill bath between them & the 4th bath completes the 2nd floor.Seller leaving the washer/dryer, refrigerator & free standing freezer.' ,`Acres` = '0.1971' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 1 EAGLE SPRINGS SEC 10' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8584' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'EAGLE SPRINGS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'TIMBERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Eagle Springs' ,`TaxAmount` = '10436' ,`TaxRate` = '2.9726' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778612' WHERE `Matrix_Unique_ID` = '210264572' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T08:05:24.523' ,`MLSNumber` = '65362238' ,`ListAgentFullName` = 'William Lasar' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.054905' ,`Longitude` = '-95.723833' ,`PhotoCount` = '27' ,`PostalCode` = '77377' ,`RoomCount` = '9' ,`ListPrice` = '357500.00' ,`Status` = 'Active' ,`StreetName` = 'Golden Lariat' ,`StreetNumber` = '19434' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1743' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Outstanding Beazer Home with multiple upgrades. One Story, 3 Bedroom, 2 Bath 1673 SF. Gss Fireplace, Ceramic Wood Looking Floors, Carpet in bedrooms, Spacious Primary bedroom with equally spacious Primary Bathroom witha large walk-in Shower. Gourmet Island Kitchen with Quartz Countertops and Walk-in Pantry. 42\" Upper Cabinets. Stainless Steel Appliances, includes Refrigerator and Washer and Dryer. Large corner lot. Easy acess to HWY 99 Grand Parkway. The \'Armira Subdivision is close to a variety of popular restaurants and shopping centers. Tomball ISD.' ,`Acres` = '0.176' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 40 BLK 2 AMIRA SEC 3' ,`LotDesciption` = 'Corner' ,`LotSize` = '7666' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Amira Sec 3' ,`TaxAmount` = '8948' ,`TaxRate` = '3.4925' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778613' WHERE `Matrix_Unique_ID` = '210273634' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T09:35:13.470' ,`MLSNumber` = '65306587' ,`ListAgentFullName` = 'Kerry Wise' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.686730' ,`Longitude` = '-95.797907' ,`PhotoCount` = '46' ,`PostalCode` = '77406' ,`RoomCount` = '12' ,`ListPrice` = '539900.00' ,`Status` = 'Active' ,`StreetName` = 'Menaggio' ,`StreetNumber` = '11114' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3273' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PRICED TO SELL! STUNNING Lakes of Bella Terra home is within walking distance of the schools and community pool. The beautiful home includes premium designer finishes, and an expansive layout perfect for comfortable inside and outdoor living and entertaining. The great room has soaring ceilings accented with oversized windows overlooking a lush patio. The gracious foyer flows past a study and formal dining room with a butler\'s pantry and chef\'s kitchen with stainless steel appliances. The owner\'s suite boasts a spa bath and large walk-in closet. BUT WAIT! There is a second bedroom and full bath downstairs along with 3 more bedrooms upstairs. gameroom and a bathrooms with a Jack & Jill. The patio is a favorite with travertine tile and both front and backyard are professionally landscaped with night lights. Iron staircase, wooden garage door, designer mirrors, upscale lighting and both A/C units are new! READY! FURNISHINGS ARE ALSO FOR SALE.' ,`Acres` = '0.1919' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LAKES OF BELLA TERRA SEC 1, BLOCK 2, LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8359' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUBENAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes Of Bella Terra Sec 1' ,`TaxAmount` = '9110' ,`TaxRate` = '3.0848' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778613' WHERE `Matrix_Unique_ID` = '210548574' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T08:12:29.947' ,`MLSNumber` = '12946418' ,`ListAgentFullName` = 'Kourtney Scroggins' ,`ListOfficeName` = 'Designed Realty Group' ,`SellingAgentFullName` = 'Linda Tello' ,`SellingOfficeName` = 'Berkshire Hathaway HomeServicePremier Properties' ,`Latitude` = '30.063333' ,`Longitude` = '-95.210365' ,`PhotoCount` = '40' ,`PostalCode` = '77339' ,`RoomCount` = '10' ,`ListPrice` = '469500.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Middle Creek' ,`StreetNumber` = '2402' ,`StreetSuffix` = 'Drive' ,`City` = 'Kingwood' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3447' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this dreamy home nestled in the desirable Bear Branch Village of The Livable Forest! Eye catching black and whites show off a stunning elevation at the exterior. A light, airy space awaits you as you enter the door of your new home. Lofty ceilings will truly make the home feel spacious. Toned gray walls pair beautifully with the flooring to show off the modern, open-concept floor plan you have been dreaming of! The living room displays a cozy corner fireplace with a beautiful stone and batten border. A stunning formal dining is at the entry and leads into the spacious and bright kitchen; inviting everyone to enjoy a space together at the heart of the home. The primary suite is nestled at the rear of the home with dreamlike bath. Four additional bedrooms are situated down the left corridor of the home, offering privacy away from the primary suite. This home is such a rare find in one of the original communities of Kingwood. Come fall in love and live life in the forest!' ,`Acres` = '0.24' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 30 BEAR BRANCH VILLAGE SEC 3' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '10455' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'BEAR BRANCH ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bear Branch Village' ,`TaxAmount` = '8536' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778613' WHERE `Matrix_Unique_ID` = '210752255' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T08:55:24.463' ,`MLSNumber` = '29270833' ,`ListAgentFullName` = 'Shara Hymowitz' ,`ListOfficeName` = 'Houston Home Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819802' ,`Longitude` = '-95.420456' ,`PhotoCount` = '13' ,`PostalCode` = '77018' ,`RoomCount` = '9' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'West 35th Street' ,`StreetNumber` = '909-B' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2706' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'From award-winning homebuilder, ROC Homes, this 3-story freestanding new construction features a rare \"1st Floor Lifestyle\" in the heart of Garden Oaks. The 1st floor features your kitchen, living and casual dining space, and Primary and 2 bedrooms are on the 2nd floor, 4th bedroom, study, full bathroom and game room are on the third. Enormous Balcony! Home is estimated to be complete by August 2022, so now is the perfect time to come in our ROC Studio and personalize your finishes! \r\n\r\nOur intimate Oak Grove Park community includes an exclusive Pergola with picnic area, and is in a walkable neighborhood surrounded by family-friendly local shops, restaurants and breweries. It\'s also walking distance from American Legion Park with a baseball/softball field, and it\'s close to major freeways so work will be closer to home and the commute to meet friends and family short.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'ROC Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'na' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1880' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GARDEN OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Garden Oaks' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664778613' WHERE `Matrix_Unique_ID` = '210805490' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T08:34:36.210' ,`MLSNumber` = '71505016' ,`ListAgentFullName` = 'Matthew Everett' ,`ListOfficeName` = 'Matthew Everett Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.687575' ,`Longitude` = '-95.474014' ,`PhotoCount` = '41' ,`PostalCode` = '77096' ,`RoomCount` = '7' ,`ListPrice` = '609000.00' ,`Status` = 'Active' ,`StreetName` = 'Darnell' ,`StreetNumber` = '5218' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3050' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Traditional exterior with an interior that has been modernized and custom fitted, beautiful finishes. Sought after schools, open concept living area, close to everything, custom cabinetry throughout, walk-in closets, huge master bathroom, upstairs entertainment room with it\'s own private bedroom and shower, perfect for a teenager, giant oak trees. Looks modern but has tons of charm. Must see!' ,`Acres` = '0.1974' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Meyerland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 23 MEYERLAND SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '411' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Ranch' ,`Subdivision` = 'Meyerland' ,`TaxAmount` = '13984' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778613' WHERE `Matrix_Unique_ID` = '210907975' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T08:21:55.237' ,`MLSNumber` = '77135063' ,`ListAgentFullName` = 'Gustavo Alvarado' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.825407' ,`Longitude` = '-95.410923' ,`PhotoCount` = '12' ,`PostalCode` = '77018' ,`RoomCount` = '4' ,`ListPrice` = '1350000.00' ,`Status` = 'Active' ,`StreetName` = '42nd' ,`StreetNumber` = '703' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Coming soon- Beautiful NEW construction! CORNET LOT! Two-story Modern Luxury house! It features four bedrooms, three bathrooms and one half-bath. HIGH Ceilings, with an amazing wide entryway. In the entrance you will see a beautiful custom wood work in the stairs, something unique! Hardwood/ flooring. Elegant kitchen, with custom counter tops, Island with quartz, top brands of stainless steel appliances. Large living room with gorgeous fireplace. Spacious primary bedroom downstairs with double sinks, separate shower and tub, and large walk-in-closet. Formal study. Upstairs 3 bedrooms, This a DREAM HOME, you must come and see it by yourself, you will not be disappointed, top in quality and luxury! Perfect LOT FOR A POOL. Approximate Completion Date: October/24/2022 Sample pictures are from previous constructions. NO flood zone!' ,`Acres` = '0.3492' ,`Area` = '9' ,`BuilderName` = 'Great Happens LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Garden Oaks' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 3 & 4 BLK 28 GARDEN OAKS SEC 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '15210' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GARDEN OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Colonial,Ranch,Spanish,Traditional' ,`Subdivision` = 'Garden Oaks Sec 02' ,`TaxAmount` = '7864' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664778613' WHERE `Matrix_Unique_ID` = '210919577' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T09:22:06.690' ,`MLSNumber` = '44270485' ,`ListAgentFullName` = 'Roston Veal' ,`ListOfficeName` = 'Legacy Homes & Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.136849' ,`Longitude` = '-95.380684' ,`PhotoCount` = '39' ,`PostalCode` = '77386' ,`RoomCount` = '13' ,`ListPrice` = '387500.00' ,`Status` = 'Active' ,`StreetName` = 'Pinewood Bend' ,`StreetNumber` = '3717' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2492' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this gem in the highly sought after Imperial Oaks subdivision in Spring, Texas! This beautiful two-story has it all! It all starts from the grand entry in the foyer, to the dining room, kitchen with a pantry and adjoining breakfast nook, family room, and functional walk-in utility room. The first floor owner\'s bedroom features an en suite bathroom with dual sinks, stand-up shower along with a soaker tub and a generous walk-in closet. The second floor features a spacious game room, three additional secondary bedrooms, and a full bathroom,.' ,`Acres` = '0.141' ,`Area` = '15' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S504221 - FALLS AT IMPERIAL OAKS 21, BLOCK 1, LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6141' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BRADLEY ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Falls At Imperial Oaks 21' ,`TaxAmount` = '9360' ,`TaxRate` = '3.1987' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778614' WHERE `Matrix_Unique_ID` = '210950985' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T09:12:16.097' ,`MLSNumber` = '56736597' ,`ListAgentFullName` = 'Neal Sanford' ,`ListOfficeName` = 'Realty Kings Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.935656' ,`Longitude` = '-95.323015' ,`PhotoCount` = '32' ,`PostalCode` = '75862' ,`RoomCount` = '3' ,`ListPrice` = '67900.00' ,`Status` = 'Active' ,`StreetName` = 'Whippoorwill' ,`StreetNumber` = '44' ,`StreetSuffix` = 'Lane' ,`City` = 'Trinity' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1008' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home is vintage mobile in pocket neighborhood within larger resort lake side community. Home has been updated with hard surface vinyl in the living, dining and kitchen, Pex water lines, new electric panel, mini-split heat and air units, recent carpet in bedrooms, updated kitchen cabinets. Hall bath has dual vanity with tub/shower combo. Primary bedroom has large windows overlooking private green space teaming with deer and other wildlife. Covered front porch for outside entertaining in this very sociable neighborhood. This represents a unique opportunity to enjoy a carefree lifestyle in a lake side resort community which offers an 18-hole golf course, country club, pro shop, exercise facility, bar and grill, pools, tennis courts, RV park, 9 interior lakes and so much more. All for less than many cars. Come out to see this home and affordable lifestyle today!' ,`Acres` = '0.0874' ,`Area` = '42' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '1' ,`Legal` = 'WESTWOOD SHORES SECTION 01, BLOCK 20 LOT 20' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3806' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2244' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Lockbox Right Side,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westwood Shores Sec 1' ,`TaxAmount` = '576' ,`TaxRate` = '2.5863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778614' WHERE `Matrix_Unique_ID` = '211156862' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T08:59:24.980' ,`MLSNumber` = '66088605' ,`ListAgentFullName` = 'Michael Vo' ,`ListOfficeName` = 'Liv Texas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.702456' ,`Longitude` = '-95.622261' ,`PhotoCount` = '17' ,`PostalCode` = '77083' ,`RoomCount` = '6' ,`ListPrice` = '199000.00' ,`Status` = 'Active' ,`StreetName` = 'Quetzal' ,`StreetNumber` = '13526' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1544' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**PRICED TO SELL** Rare find in Bellaire/Mission Bend with amazing potential! \"AS IS\" FIXER UPPER! 3 bedroom, 2 bathroom, one story home. With some TLC and updates, this house can attract some serious attention! One of the few houses available in the area. Only a few minutes to Westpark Tollway. Come check it out and make an offer today!' ,`Acres` = '0.1154' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 1 PHEASANT RUN SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5027' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '410' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'LIESTMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'KILLOUGH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pheasant Run Sec 01' ,`TaxAmount` = '3538' ,`TaxRate` = '2.397' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664778614' WHERE `Matrix_Unique_ID` = '211168127' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T08:02:38.820' ,`MLSNumber` = '37853477' ,`ListAgentFullName` = 'Lacey Lewis' ,`ListOfficeName` = 'SENTRAL PROPERTIES' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.668117' ,`Longitude` = '-95.365186' ,`PhotoCount` = '40' ,`PostalCode` = '77051' ,`RoomCount` = '9' ,`ListPrice` = '334900.00' ,`Status` = 'Active' ,`StreetName` = 'Elmwood' ,`StreetNumber` = '4215' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This amazing new construction modern home has lots of luxury upgrades! *5000 sq ft FULL SIZE LOT!! Breathtaking entry, open floor plan, luxury bamboo wood flooring, 10 ft ceilings, upgraded quartz countertops and quartz kitchen backsplash, Kitchen has lots of natural light opening into a covered patio with a huge private yard. Master bath has gorgeous textured wall tile, Stand alone soaking tub, separate full glass frameless shower. Upgraded stained red oak stairs, stainless steel appliances, ceiling fans throughout, one of a kind laundry room w/sink and a bonus 2nd floor dedicated office/desk area. Just minutes from the Medical Center, downtown, Hobby airport, Houston Zoo and more.' ,`Acres` = '0.1148' ,`Area` = '3' ,`BuilderName` = 'Sentral Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK H SUNNYSIDE COURTS' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BASTIAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Back' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunnyside Courts' ,`TaxAmount` = '932' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664778614' WHERE `Matrix_Unique_ID` = '211332322' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T08:10:56.690' ,`MLSNumber` = '30357447' ,`ListAgentFullName` = 'Juvy Sudario' ,`ListOfficeName` = 'Prime Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.648734' ,`Longitude` = '-95.214420' ,`PhotoCount` = '19' ,`PostalCode` = '77034' ,`RoomCount` = '4' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Princess' ,`StreetNumber` = '162' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1279' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Renovated one story, 3-4 bedroom, 2 bathroom, 2 car attached garage in the Arlington Heights Subdivision. Open concept kitchen, dining and living areas. Front room can be a bedroom, game room, family room or office. Kitchen features soft closed cabinets, single bowl stainless steel kitchen sink, pull-down dual function sprayer faucet, granite countertops, island with underneath storage, stainless steel gas range, hood & dishwasher and pantry. New doors, windows, fixtures, insulation, air ducts, ceiling fans, 2\" blinds, waterproof vinyl plank & tile flooring, and so much more. Fresh paint in the interior and exterior. PEX plumbing. Conveniently located near SH 3, I-45 and Beltway 8 providing easy access to restaurants and stores. Foundation leveled with transferable service agreement.' ,`Acres` = '0.1616' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 15 BLK 25 ARLINGTON HEIGHTS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7040' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'PEARL HALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SOUTH HOUSTON HIGH SCHOOL' ,`SchoolMiddle` = 'MILLER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Arlington Heights Sec 02' ,`TaxAmount` = '3331' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778614' WHERE `Matrix_Unique_ID` = '211428545' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T09:59:32.863' ,`MLSNumber` = '74555007' ,`ListAgentFullName` = 'Katey Sada' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.918635' ,`Longitude` = '-95.580070' ,`PhotoCount` = '32' ,`PostalCode` = '77064' ,`RoomCount` = '6' ,`ListPrice` = '449999.00' ,`Status` = 'Active' ,`StreetName` = 'White Oak Trail' ,`StreetNumber` = '10127' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4107' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home located in the well-established area of Willow Pointe. This floor plan has it all; five oversized bedrooms, huge game room AND media room (or optional 6th bedroom!!), both formals, high ceilings, large kitchen, downstairs study/office and a primary en-suite that offers built-ins, jetted tub, separate shower, double sink and a large walk-in closet. Home has been upgraded with tankless instant hot water heater, marble floors and columns downstairs, tile and granite countertops in kitchen, wood laminate floors, NEW carpet upstairs AND fresh paint throughout. HOME DID NOT FLOOD in Ike, Harvey, Freeze, or ever, per Seller. Great location with quick access to 290, Beltway 8, hospitals, shopping, dining and more! Zoned to Cy-Fair ISD! Don\'t miss out!' ,`Acres` = '0.1446' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Jersey Village' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 2 WILLOW POINTE SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '499' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'BANG ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'CAMPBELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Willow Pointe' ,`TaxAmount` = '7312' ,`TaxRate` = '2.641' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778614' WHERE `Matrix_Unique_ID` = '211493920' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T08:33:13.160' ,`MLSNumber` = '75793064' ,`ListAgentFullName` = 'Salvador Caballero' ,`ListOfficeName` = 'ListWithFreedom.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.536531' ,`Longitude` = '-95.397126' ,`PhotoCount` = '21' ,`PostalCode` = '77578' ,`RoomCount` = '10' ,`ListPrice` = '460000.00' ,`Status` = 'Active' ,`StreetName` = 'Duffy' ,`StreetNumber` = '3515' ,`StreetSuffix` = 'Lane' ,`City` = 'Manvel' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4169' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A MUST SEE THAT WON\'T LAST LONG!!! ALL BRICK HOME in like-new condition! The home\'s LARGE kitchen with granite counters and lots of storage is the focal point of this 5/4/2 on a HUGE corner lot. Dramatic high ceilings at entryway, wood floors at dining, master, formal dining and living areas. Master bedroom and a secondary bedroom on the ground floor and an additional 3 bedrooms, game room and theatre room on the second. Covered patio with big backyard for kids to play. Excellent location! Minutes to Hwy 288, Beltway 8, Medical Center, Downtown. Close to shopping mall, grocery stores and eateries.' ,`Acres` = '0.1968' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SOUTHFORK SEC 5 (A0540 A C H & B) BLK 3 LOT 17' ,`LotDesciption` = 'Corner' ,`LotSize` = '8573' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '540' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'RED DUKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHADOW CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MCNAIR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Southfork Sec 5 A0540 A C H &' ,`TaxAmount` = '7967' ,`TaxRate` = '2.8294' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778615' WHERE `Matrix_Unique_ID` = '211502371' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T09:51:49.190' ,`MLSNumber` = '43955330' ,`ListAgentFullName` = 'Binu Alex' ,`ListOfficeName` = 'MIH REALTY, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.634267' ,`Longitude` = '-95.700844' ,`PhotoCount` = '50' ,`PostalCode` = '77407' ,`RoomCount` = '7' ,`ListPrice` = '669000.00' ,`Status` = 'Active' ,`StreetName` = 'Ardmay' ,`StreetNumber` = '18403' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3145' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'INCREDIBLE 2020 Two story Highland Home on OVERSIZED LOT in Aliana! FALL IN LOVE THE MOMENT YOU ENTER this Showplace! Open concept family room with HIGH CEILINGS ,Formal Dining, The kitchen features granite counters, a large island with seating, on-trend dark wood cabinets, SS appliances, and a bright and airy breakfast room. Retreat to the downstairs primary with an en-suite with dual sinks, a separate glassed-in shower, and a large walk-in closet. Downstairs secondary bedroom and full bath toward the front of the house is the ultimate in privacy for guests. Upstairs, gather in the game room with a media room ,Two more secondary bedrooms share a bathroom. Don\'t miss the fully fenced backyard with a covered patio and lots of green space, perfect for entertaining! Video tour available online. Showing starts only from 9/24' ,`Acres` = '0.3875' ,`Area` = '37' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ALIANA SEC 65, BLOCK 2, LOT 12' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '16880' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1296' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'MALALA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Aliana Sec 65' ,`TaxAmount` = '12152' ,`TaxRate` = '3.0329' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664778615' WHERE `Matrix_Unique_ID` = '211545938' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T08:10:36.567' ,`MLSNumber` = '8237410' ,`ListAgentFullName` = 'Keri Dillard' ,`ListOfficeName` = 'RE/MAX 5 Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.656202' ,`Longitude` = '-95.094093' ,`PhotoCount` = '45' ,`PostalCode` = '77571' ,`RoomCount` = '9' ,`ListPrice` = '344900.00' ,`Status` = 'Active' ,`StreetName` = 'Caddo' ,`StreetNumber` = '9206' ,`StreetSuffix` = 'Court' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2471' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*Pride of ownership* Welcome home to this 5 bedrooms 2.5 bath 2 car garage spacious house located on a Cul-de-sac. Leaded glass front door with Ring doorbell. Grand open entry with vaulted ceilings. Large family den and large kitchen with granite counter tops and tile backsplash. Primary bedroom is down with en-suite bathroom that has a jetted tub and glass stand up shower. 4 secondary bedrooms upstairs, tiled bathroom. All rooms have walk in closets. 14x30 patio was built on in 2014 and has a firepit and utility lines already ran for an outdoor kitchen. 10x12 storage shed. Tile throughout downstairs and bathrooms with new carpet in bedrooms. Garage has been carpeted and used a game room. (Pool room) could be turned back if buyer chooses. Both attics have been decked.' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 60 BLK 1 PECAN CROSSING S EC 3' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7311' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '179' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'HERITAGE ELEMENTARY SCHOOL (LA PORTE)' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Pecan Crossing' ,`TaxAmount` = '6826' ,`TaxRate` = '2.7208' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778615' WHERE `Matrix_Unique_ID` = '211748821' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T09:45:36.790' ,`MLSNumber` = '29730861' ,`ListAgentFullName` = 'Shannon Patton' ,`ListOfficeName` = 'Prestige Properties Texas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.821195' ,`Longitude` = '-95.781346' ,`PhotoCount` = '32' ,`PostalCode` = '77493' ,`RoomCount` = '8' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Quarry Path' ,`StreetNumber` = '23438' ,`StreetSuffix` = 'Way' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2270' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this beautiful four-bedroom two-bathroom home located in Morton Creek Ranch. This stunning floor plan is a showstopper with the beautiful water view and NO back yard neighbors. NO BACK NEIGHBORS!!!\r\nThis backyard is ready for entertaining. Vinyl plank floors, new appliances, granite counters with island kitchen & so much more. The open floor plan is terrific for entertaining. Walk-in closets in spacious bedrooms. Easy access to I-10 & Grand Parkway, plus minutes from retail, dining and entertainment. Too many details to list and a home you must see. Located in the highly sought after KISD. Schedule a showing today, this home won\'t last long!!!' ,`Acres` = '0.1488' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 1 MORTON CREEK RANCH SEC 5' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '6480' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '595' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'LEONARD ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Morton Creek Ranch' ,`TaxAmount` = '7926' ,`TaxRate` = '3.3333' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778615' WHERE `Matrix_Unique_ID` = '211767770' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T09:02:36.610' ,`MLSNumber` = '3746772' ,`ListAgentFullName` = 'Cathy Nguyen' ,`ListOfficeName` = 'The Nguyens & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.074862' ,`Longitude` = '-95.209084' ,`PhotoCount` = '22' ,`PostalCode` = '77339' ,`RoomCount` = '3' ,`ListPrice` = '245000.00' ,`Status` = 'Active' ,`StreetName` = 'Sherwood Hollow' ,`StreetNumber` = '2238' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1754' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming well maintained brick home in the Sherwood Trails neighborhood. Laminate flooring and tile throughout home and in wet areas for updated look and low maintenance care. Spacious open living, dining, and kitchen area make entertaining a dream. Vaulted ceiling in family room and fireplace make the family room the heart of the home. Master bedroom has en-suite bathroom and walk-n closet. Fully fenced backyard adds additional out door living space to this beautiful home. Conveniently located with easy accessibility to freeways makes this a home that can\'t be missed. Come view this charming home today.' ,`Acres` = '0.1433' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 817 BLK 5 SHERWOOD TRAILS SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6240' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '365' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'WOODLAND HILLS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sherwood Trails Sec 04' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778615' WHERE `Matrix_Unique_ID` = '211945788' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T09:04:41.220' ,`MLSNumber` = '42478963' ,`ListAgentFullName` = 'Melinda Zuber' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.281108' ,`Longitude` = '-95.490191' ,`PhotoCount` = '26' ,`PostalCode` = '77304' ,`RoomCount` = '6' ,`ListPrice` = '298000.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Gate' ,`StreetNumber` = '406' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1896' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 bedrooms and 2 baths one story in popular Woodhaven Forest conveniently located on the south loop 336 just minutes to I-45. Huge primary room with garden tub and separate shower. Formal dining area. Open kitchen concept to living area and breakfast room. Beautiful arches and art niches. Utility room in house. Covered back yard patio with fenced back yard backing to green belt. Home has been well cared for and is the original owner.' ,`Acres` = '0.1263' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WOODHAVEN FOREST 01, BLOCK 2, LOT 41' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5501' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '363' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodhaven Forest' ,`TaxAmount` = '4297' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778616' WHERE `Matrix_Unique_ID` = '212062926' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T09:24:46.980' ,`MLSNumber` = '29432794' ,`ListAgentFullName` = 'Caroline Schlemmer' ,`ListOfficeName` = 'Compass RE Texas, LLCHeights' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.787069' ,`Longitude` = '-95.403645' ,`PhotoCount` = '36' ,`PostalCode` = '77007' ,`RoomCount` = '9' ,`ListPrice` = '879000.00' ,`Status` = 'Active' ,`StreetName` = '9th' ,`StreetNumber` = '607' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2459' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 607 west 9th St, this incredible Heights home offers the beloved Craftsman style with a great floor plan for entertaining plus a garage apartment and many energy efficient features including solar panels! The kitchen with large center island overlooks the breakfast and living room and features Thermador appliances, marble counters and butler’s pantry with separate sink & wine refrigerator. Energy efficient features include: Solar panels, tankless hot water heater, smart home switches, LED lighting, nest thermostats & electric car outlet. The additional 480 sf* garage apt was updated in 2021 w/ new flooring, kitchenette, bathroom vanity & shower and a mini split AC system. Beautifully landscaped exterior with garden and space for dining under the twinkle lights. Last, but not least is the amazing walkability! Ideally located less than a block to the hike & bike trail provides easy access to M-K-T, Lawrence Park, Heights Mercantile, 11th St restaurants & much more! *per HCAD' ,`Acres` = '0.0803' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK 236 HOUSTON HEIGHTS 62ND AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Craftsman' ,`Subdivision` = 'Houston Heights' ,`TaxAmount` = '15960' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778616' WHERE `Matrix_Unique_ID` = '212122973' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T09:39:42.597' ,`MLSNumber` = '66189242' ,`ListAgentFullName` = 'Yvonne Chauvin' ,`ListOfficeName` = 'Compass RE Texas, LLCKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.900321' ,`Longitude` = '-95.712488' ,`PhotoCount` = '50' ,`PostalCode` = '77433' ,`RoomCount` = '11' ,`ListPrice` = '535000.00' ,`Status` = 'Active' ,`StreetName` = 'Stanton Lake' ,`StreetNumber` = '20222' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3499' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This incredible and unique home lives in a manned and gated subdivision of Canyon Lakes West. The backyard has beautiful pool with waterfall, which overlooks the community lake. There is a walking trail around the lake right outside your back gate, so when you’re done cooling off in the pool, you can take an evening stroll around the lake. The backyard faces East, so it is nicely shaded in the afternoon. \r\nThere are TWO BEDROOMS DOWNSTAIRS. One primary- with all the luxuries that modern buyer expects, and the other has its own bathroom. Very sough after floorplan! The kitchen is magnificent! It has plenty of counter space, center island, breakfast bar, lots of cabinetry and is open to the family room and breakfast room. Downstairs, you will also find a dining room and an office. Upstairs are remaining 2 bedrooms and a generous size game room. You will love this home and you will love this community, so make an appointment to see it today!' ,`Acres` = '0.2478' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 2 CANYON LAKES WEST SEC 8' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '10795' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1533' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Slate' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ANDRE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Lakes West Sec 8' ,`TaxAmount` = '11631' ,`TaxRate` = '3.041' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778616' WHERE `Matrix_Unique_ID` = '212180583' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T08:46:37.500' ,`MLSNumber` = '73041648' ,`ListAgentFullName` = 'Lorena Gonzalez' ,`ListOfficeName` = 'Gold Quest Realty- Galleria' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.076922' ,`Longitude` = '-95.468905' ,`PhotoCount` = '19' ,`PostalCode` = '77388' ,`RoomCount` = '3' ,`ListPrice` = '243000.00' ,`Status` = 'Active' ,`StreetName` = 'Meadowhill' ,`StreetNumber` = '21619' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1726' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nice 3 Bedroom house zone to Klein ISD school district. Tile floor in living and dining area. Large master bedroom with extra space. Granite countertops in kitchen and baths. Large backyard with mature trees. Come see it!' ,`Acres` = '0.2344' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 8 017*D6031700-002-008-003 DOVE MEADOWS SEC 2 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10209' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KREINHOP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'SCHINDEWOLF INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'No Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Dove Meadows Sec 02 R/P' ,`TaxAmount` = '4893' ,`TaxRate` = '2.804' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778616' WHERE `Matrix_Unique_ID` = '212182038' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T09:50:18.103' ,`MLSNumber` = '57001593' ,`ListAgentFullName` = 'Maricela Benton' ,`ListOfficeName` = 'Lea Homes Realty INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.712558' ,`Longitude` = '-95.061840' ,`PhotoCount` = '30' ,`PostalCode` = '77351' ,`RoomCount` = '3' ,`ListPrice` = '306950.00' ,`Status` = 'Active' ,`StreetName` = 'Village Cove' ,`StreetNumber` = '166' ,`StreetSuffix` = 'Loop' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1809' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lea Homes is offering this 3 bedroom and 2 bath signature series home that features a modern theme with trend conscious colors and designer floors. The home has 10-foot ceilings throughout home and 11-foot ceilings in family room and master. The kitchen features upgraded quartz counter-tops, brush nickel faucets, hardware and door levers, also upgraded Samsung appliance package. Dining room has a modern chandelier and living room and master bedroom have trendy ceiling fans. The master bathroom includes an oversize fully tiled walk-in shower with a bench seat and separate garden tub with an added window for natural lighting. The antique porcelain tile floors and designer mirrors in both bathrooms make it a real treat after a long day. An efficient Carrier HVAC system with digital thermostat will keep your electricity bills low. The subdivision has a private boat ramp and swimming pool' ,`Acres` = '0.1964' ,`Area` = '44' ,`BuilderName` = 'LEA HOMES INC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE LIVINGSTON VILLAGE SECTION 12 LOT 64' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '26' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Lake Livingston Village' ,`TaxAmount` = '44' ,`TaxRate` = '2.0361' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664778616' WHERE `Matrix_Unique_ID` = '212186890' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T09:06:04.807' ,`MLSNumber` = '43303651' ,`ListAgentFullName` = 'Candice Webb' ,`ListOfficeName` = 'Realty ONE Group Iconic' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.274884' ,`Longitude` = '-95.539766' ,`PhotoCount` = '50' ,`PostalCode` = '77316' ,`RoomCount` = '8' ,`ListPrice` = '347000.00' ,`Status` = 'Active' ,`StreetName` = 'Fox Trail' ,`StreetNumber` = '144' ,`StreetSuffix` = 'Road' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1718' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully maintained Perry Home located on a cul-de-sac street w/NO rear neighbors in the prestigious master-planned community of Woodforest loaded w/amenities! This Flexible & functional open floor plan feels like home the moment you walk in, w/hardwood floors & high ceilings that make the house feel luxurious & large, a spacious front Dining Room, or a quiet Study w/upgraded plantation shutters. The kitchen has plenty of cabinet space & storage, granite countertops, & SS appliances w/upgraded hardware, under cabinet lighting, & gray painted Island/breakfast bar perfect for family dining & entertainment. A custom faux brick painted archway separates the Breakfast area & living room to maximize space w/ custom industrial shelves & Mounted TV in the family room included! Primary bedroom boasts a wall of windows, en-suite bathroom, Dual Sinks, garden tub, separate shower, & walk-in closet. Custom painted an accent wall in the Secondary bedroom & private backyard w/Covered Patio!' ,`Acres` = '0.1374' ,`Area` = '39' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S965264 - WOODFOREST 64, BLOCK 1, LOT 8' ,`LotDesciption` = 'Greenbelt,In Golf Course Community,Subdivision Lot' ,`LotSize` = '5983' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1265' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest' ,`TaxAmount` = '6276' ,`TaxRate` = '2.6888' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778616' WHERE `Matrix_Unique_ID` = '212234732' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T09:37:00.420' ,`MLSNumber` = '82921853' ,`ListAgentFullName` = 'Danielle Thurman' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.691603' ,`Longitude` = '-95.713551' ,`PhotoCount` = '34' ,`PostalCode` = '77407' ,`RoomCount` = '6' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Euphonia Glade' ,`StreetNumber` = '7823' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1838' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic opportunity to own this amazing one-story home with 3 bedrooms, 2 baths, and a 2 car attached garage built in 2018. Prepare to fall in love with this open concept floorplan that offers a dedicated office with French doors and a spacious family room that is open to the kitchen with SS appliances, an island/breakfast bar, and ample cabinet and counter space. Private first-floor primary bedroom with en-suite bath, two additional generous sized bedrooms in the home. Enjoy the outdoors in the spacious backyard space that offers a large covered patio and plenty of room for a play area, or for gardening. All this coupled with close proximity to shopping and dining will make this a place you want to call home!' ,`Acres` = '0.124' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND VISTA SEC 26, BLOCK 3, LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Vista Sec 26' ,`TaxAmount` = '5369' ,`TaxRate` = '2.4297' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778617' WHERE `Matrix_Unique_ID` = '212338678' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T09:58:56.517' ,`MLSNumber` = '92640070' ,`ListAgentFullName` = 'Amanda Howton-Mitchell' ,`ListOfficeName` = 'CyHou Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.621780' ,`Longitude` = '-95.172722' ,`PhotoCount` = '39' ,`PostalCode` = '77331' ,`RoomCount` = '4' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'State Highway 156' ,`StreetNumber` = '10211' ,`StreetSuffix` = '' ,`City` = 'Coldspring' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2676' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this beautiful rustic oasis nestled down your private drive. This amazing Log home is 4-5 bedrooms. Newly renovated to match its country charm. Flex space is spacious and could be used as an additional room or game room. The open concept living/dining is adorned with vaulted ceilings and rustic wooden beams throughout. Expansive island offers room for additional dining and prep space. In this entertainers dream home your eye will immediately gravitate to the breathtakingly gorgeous rock fireplace upon entry. The 9+ acres is fully fenced and cross fenced to allow for a multitude of livestock capabilities. Home has a large enclosed barn with stalls. Large carport to store your vehicles and equipment. Property boasts a pond that adds to the long list of rustic beauty. Property is equipped with RV hookup. Lake Livingston is just a few short miles down the road and you’ll be enjoying all the water recreation it has to offer. You’ll love this southern country beauty.' ,`Acres` = '9.131' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A028 DRURY MCGEE, TRACT 212.3, ACRES 9.131' ,`LotDesciption` = 'Cleared,Other,Wooded' ,`LotSize` = '397746' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style,Ranch' ,`Subdivision` = 'N/A' ,`TaxAmount` = '4952' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778617' WHERE `Matrix_Unique_ID` = '212397553' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T09:22:47.983' ,`MLSNumber` = '9028357' ,`ListAgentFullName` = 'Leticia Balderrama' ,`ListOfficeName` = 'RE/MAX ONE - Premier' ,`SellingAgentFullName` = 'Taneeka Hawkins' ,`SellingOfficeName` = 'JPAR - The Sears Group' ,`Latitude` = '29.843551' ,`Longitude` = '-95.168073' ,`PhotoCount` = '39' ,`PostalCode` = '77049' ,`RoomCount` = '10' ,`ListPrice` = '325000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Scenic Sky' ,`StreetNumber` = '14818' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful spacious home that features 5 bedrooms, 2.5 baths, media room and large game room. This split plan gives you a spacious formal dining room as you walk in the home. This will lead you to the large open floor plan of the kitchen and living room. The primary bedroom is downstairs and is very roomy and ready for your large furniture. Upstairs you will find 4 more bedrooms and a large game room and media room ready for those movie nights. Don\'t miss out on this beauty.' ,`Acres` = '0.1085' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 3 EDGEWOOD VILLAGE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4725' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '345' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'SHELDON LAKEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'C.E. KING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Edgewood Village Sec 3' ,`TaxAmount` = '9131' ,`TaxRate` = '3.6393' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778617' WHERE `Matrix_Unique_ID` = '212407481' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T08:37:48.620' ,`MLSNumber` = '42318286' ,`ListAgentFullName` = 'Andrea Bustamante' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.480784' ,`Longitude` = '-95.457924' ,`PhotoCount` = '33' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '310000.00' ,`Status` = 'Active' ,`StreetName` = 'Barstow Drive' ,`StreetNumber` = '1014' ,`StreetSuffix` = '' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1688' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ready to Move-In! This spectacular 2021 Built One-story home with 3 bedrooms, office and 2 bathrooms features a modern open concept layout perfect for entertaining family and friends. Large granite island kitchen with elegant espresso cabinets. Modern Whirlpool Stainless Steal appliances in the kitchen. Ceiling Fans in every bedroom and Sprinkler system installed. Engineered Vinyl Plank flooring in most areas. This beautiful home has a spacious covered patio and front porch with stone and brick accent. Built with high quality materials and very well maintained. Refrigerator included. This energy-efficient home feels like Brand-new. Zoned to Fort Bend ISD with great access to Downtown, Medical Center, Hobby Airport and more!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Glendale Lakes Sec 7, Block 2, Lot 17' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Glendale Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.18' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664778617' WHERE `Matrix_Unique_ID` = '212452580' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T09:25:52.420' ,`MLSNumber` = '70029640' ,`ListAgentFullName` = 'Martha Cornejo' ,`ListOfficeName` = 'RE/MAX Real Estate Assoc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.613472' ,`Longitude` = '-95.723586' ,`PhotoCount` = '36' ,`PostalCode` = '77406' ,`RoomCount` = '9' ,`ListPrice` = '349000.00' ,`Status` = 'Active' ,`StreetName` = 'Woven Wood' ,`StreetNumber` = '2423' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2004' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOOK NO MORE - YOU HAVE FOUND IT! The house of your dreams waiting on the perfect subdivision of The Grove part of the after sought community of Pecan Grove. Walk onto a newly designed floor plan. Entering this gorgeous home you will find a fourth room to your right that can also be your study room, and to your left you will find a spacious private utility room that allows you access to the garage. Continue walking onto the amazing kitchen with brand new quartz counter tops with touchless water faucet and soft close kitchen cabinets. Don\'t miss the newly added pantry room. Stare all you want to the polish porcelain fireplace. On the master bedroom gawk at the texture porcelain tile accent wall - you will definitely love it! Make sure you don\'t miss the massive master walk in closet and the beautifully renovated bathroom with the sliding frameless shower door. Waterproof and scratch resistant laminate floors. This home will not disappoint! Call for your private tour today.' ,`Acres` = '0.1622' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'THE GROVE SEC 3, BLOCK 16, LOT 51' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '7066' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '195' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'The Grove Sec 3' ,`TaxAmount` = '4957' ,`TaxRate` = '2.3298' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778617' WHERE `Matrix_Unique_ID` = '212488786' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T09:12:53.363' ,`MLSNumber` = '24499891' ,`ListAgentFullName` = 'Meriam Shaw' ,`ListOfficeName` = 'Keller Williams Elite' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.909136' ,`Longitude` = '-95.082271' ,`PhotoCount` = '36' ,`PostalCode` = '77532' ,`RoomCount` = '8' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Chamfer' ,`StreetNumber` = '907' ,`StreetSuffix` = 'Way' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2040' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You must see this warm and cozy abode with NO BACK NEIGHBOR! This home has 4 Bedrooms and 2 Full bath with improved attic Storage approximately 500 sqft. Enjoy the Covered back patio & 3 CAR GARAGE. This home comes with generator it’s very well maintained. Located at Newport Subdivision that features a wide golf course, a beautiful lake, outdoor pool, an open tennis court and a playground that your kids will enjoy. Make an Appointment Today!' ,`Acres` = '0.1635' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Gas,Other Heating' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 5 NEWPORT SEC 8 PAR R/P' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '7143' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '480' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'CROSBY ELEMENTARY SCHOOL (CROSBY)' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Newport' ,`TaxAmount` = '6146' ,`TaxRate` = '2.7105' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778618' WHERE `Matrix_Unique_ID` = '212530572' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T09:33:44.970' ,`MLSNumber` = '51938773' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.523120' ,`Longitude` = '-95.750030' ,`PhotoCount` = '8' ,`PostalCode` = '77469' ,`RoomCount` = '6' ,`ListPrice` = '324990.00' ,`Status` = 'Active' ,`StreetName` = 'Sunbreeze' ,`StreetNumber` = '7103' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2045' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Eureka floorplan - Welcome home to this spacious open single story floorplan! Sparkling white kitchen cabinets with grey quartz countertops open to family room and large dining area! Main bathroom features upgraded tub/shower combo. Over sized back patio with large backyard on a 60\' lot' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 40, Block 2, Section 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6976' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'THOMAS ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunset Crossing' ,`TaxAmount` = '' ,`TaxRate` = '3.314' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664778618' WHERE `Matrix_Unique_ID` = '212720344' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T08:46:44.927' ,`MLSNumber` = '66754138' ,`ListAgentFullName` = 'Christa Hoogeboom' ,`ListOfficeName` = 'Sparrow Realty' ,`SellingAgentFullName` = 'Kitten Strahan' ,`SellingOfficeName` = 'Leopold & Strahan Realty Group' ,`Latitude` = '29.409580' ,`Longitude` = '-94.908590' ,`PhotoCount` = '29' ,`PostalCode` = '77590' ,`RoomCount` = '12' ,`ListPrice` = '400000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = '26th' ,`StreetNumber` = '906' ,`StreetSuffix` = 'Avenue' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2674' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home. Where to begin? Fully renovated interior/exterior Ranch Style 1 story home that\'s just gorgeous! Tons of light floods in thru all the windows in the heart of the home-kitchen,LR,DR,breakfast and the sun room. Yes, I said SUNROOM-indoor w fans, view of the LR/Backyard and 4th bedroom which makes for either a lovely stay for a guest or an awesome Study w a View! Tons of designer touches and all the things you\'ve seen on HGTV-Calcutta Quartz, eat-in island peninsula, stacked stone FP w wood mantle, lux vinyl wood planks floors thru-out, new stainless appliances, huge utility room w room for a deep freeze or second refrigerator, wrought iron new faucets and fixtures, LED lighting, Master suite has vaulted ceilings, custom tile surround and a soaker garden tub, plus a huge 3 car garage w 2 work spaces AND a lg half bath w extra storage! And the curb appeal and the yard. Wow! Sprinklers, ready for gas grill, fruit trees, tons landscaping and flower beds. You gotta\' see it!' ,`Acres` = '0.3936' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 167 PAGE 4 LOT 19 & W 42 FT OF LOT 23 BLK 4 SWALLOWS ME' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '17145' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'ROOSEVELT-WILSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TEXAS CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BLOCKER MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,No Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Swallows Meadow' ,`TaxAmount` = '7275' ,`TaxRate` = '2.5335' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1664778618' WHERE `Matrix_Unique_ID` = '212724147' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T08:21:05.643' ,`MLSNumber` = '24261779' ,`ListAgentFullName` = 'Jamie McMartin' ,`ListOfficeName` = 'Compass RE Texas, LLCKaty' ,`SellingAgentFullName` = 'Christa Burgess' ,`SellingOfficeName` = 'RE/MAX Cinco Ranch' ,`Latitude` = '29.726506' ,`Longitude` = '-95.764990' ,`PhotoCount` = '37' ,`PostalCode` = '77450' ,`RoomCount` = '14' ,`ListPrice` = '699000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Arbor Stream' ,`StreetNumber` = '22619' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4107' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DON’T FORGET TO CHECK OUT THE VIRTUAL WALK-THROUGH ~ Everything you have ever wanted is featured in this beautiful home. Welcome home to 22619 Arbor Stream located in the highly desired Cinco Ranch Cinco Forest. Located on a culdesac street and backing to the nature preserve hike/bike trails this home is on a prime lot. This beauty features two primaries down, pool, spa, covered patio, & more. The chef in the family will love quartz countertops, gas connections in the island, butler’s pantry, & 2 walk-in pantries. The rest of the beautiful home features a sunroom, gameroom, study, & formal dining. The primary bath features an oversized shower, dual vanities, deep soaking tub & two closets. Whole house generator. Zoned to Katy ISD, Williams Elementary, Beck JH, & Cinco Ranch HS. Minutes from 3 golf courses, great dining, & shopping. Easy access to Grand Parkway, Westpark Toll & I-10. Check it out today.' ,`Acres` = '0.2504' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CINCO RANCH CINCO FOREST SEC 1, BLOCK 1, LOT 65' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '10908' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1075' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WILLIAMS ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'BECK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cinco Ranch Cinco Forest' ,`TaxAmount` = '12208' ,`TaxRate` = '2.4395' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778618' WHERE `Matrix_Unique_ID` = '212738216' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T09:05:31.127' ,`MLSNumber` = '20210038' ,`ListAgentFullName` = 'Jameka Johnson' ,`ListOfficeName` = 'GRIFFIN LOCATIONS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.930520' ,`Longitude` = '-95.244739' ,`PhotoCount` = '27' ,`PostalCode` = '77396' ,`RoomCount` = '3' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Wortham Stream' ,`StreetNumber` = '14811' ,`StreetSuffix` = 'Court' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2632' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to a BEAUTIFUL 1.5 story home! This home provides 3 bedrooms, 2.5 bathrooms, office, dining, breakfast nook, open concept kitchen with great island, upstairs loft/game area, oversized backyard, and patio. 14811 Wortham Stream Ct exterior is majority 4 sided brick with a front stone gorgeous elevation. Neighborhood conveniently comes with lavish amenities such as a clubhouse, golf club, park & trails, pools, sports complex, baseball, sand volleyball, playground areas, and tennis. The Fall Creek Community is within 20 minutes from downtown and close to major highways such as beltway 8, Hwy 59, Hwy 45, Hwy 90, and Hardy Toll Road. Great location within 10 minutes from IAH Airport. Quick access to Dining & Entertainment. Home includes stainless steel appliances. Schedule Tour For Your Home Today!' ,`Acres` = '0.1584' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fall Creek Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 1 EAGLE CREEK SEC 1' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1090' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'AUTUMN CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Eagle Crk Sec 01' ,`TaxAmount` = '8542' ,`TaxRate` = '3.0673' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778618' WHERE `Matrix_Unique_ID` = '212739409' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T09:58:48.450' ,`MLSNumber` = '51622915' ,`ListAgentFullName` = 'Stephanie Vega' ,`ListOfficeName` = 'Exceed Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.861889' ,`Longitude` = '-95.691058' ,`PhotoCount` = '32' ,`PostalCode` = '77449' ,`RoomCount` = '3' ,`ListPrice` = '237000.00' ,`Status` = 'Active' ,`StreetName` = 'Willow Bluff' ,`StreetNumber` = '6231' ,`StreetSuffix` = 'Road' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1251' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come tour this tastefully remodeled home located in the established Brenwood Park Subdivision. This home features high ceilings, open floor plan and kitchen large enough to entertain your guests. Kitchen includes new countertops, peninsula and spacious island and modern backsplash. Primary bathroom features oversized walk in frameless shower with a bench and double sink vanity. Other upgrades include water heater (2019), HVAC with all new air ducting (2020), modern accent fireplace wall and upstairs carpet (2021). Backyard is spacious and includes a large storage room that can be multi-purposed.' ,`Acres` = '0.1056' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 6 BRENWOOD SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '495' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MCFEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (CY-FAIR)' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Brenwood Sec 01' ,`TaxAmount` = '3541' ,`TaxRate` = '2.641' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778619' WHERE `Matrix_Unique_ID` = '212750770' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T09:48:34.270' ,`MLSNumber` = '97281879' ,`ListAgentFullName` = 'Ryan Dooley' ,`ListOfficeName` = 'CRD Realty' ,`SellingAgentFullName` = 'Rhonda Smith' ,`SellingOfficeName` = 'Coldwell Banker Realty' ,`Latitude` = '30.307956' ,`Longitude` = '-95.502368' ,`PhotoCount` = '19' ,`PostalCode` = '77304' ,`RoomCount` = '5' ,`ListPrice` = '255000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Lost Pine' ,`StreetNumber` = '2036' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1326' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This well maintained home is truly a must see with plenty of owner upgrades that make it stand out. The home recently received a fresh coat of paint on the interior and exterior. The kitchen features Quartz countertops along with a single bowl stainless steel undermount kitchen sink. Flooring consists of a beautiful laminate floor in the bedrooms and living areas with gorgeous wood look tile flooring in the bathrooms. The owner has also added a Rheem Performance Platinum 8.4 GPM gas Tankless Water Heater along with a Aquasure Harmony Water Softener. The home also has a Rain Bird Sprinkler System for the front & backyard. There is also a covered backyard patio to enjoy your coffee on those cool Fall mornings. Oh and did I mention, no neighbors behind and the backyard has a 7 year peach tree?! This is just a sampling of the features found in this home, see the rest for yourself! Schedule your showing today!' ,`Acres` = '0.1263' ,`Area` = '19' ,`BuilderName` = 'La Jolla Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S799100 - PINEWOOD FOREST, BLOCK 1, LOT 29, ACRES 0.126' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '390' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'RICE ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pinewood Forest' ,`TaxAmount` = '3295' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778619' WHERE `Matrix_Unique_ID` = '212824334' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T09:28:44.533' ,`MLSNumber` = '51400670' ,`ListAgentFullName` = 'Shawn Saxton' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.029314' ,`Longitude` = '-95.612032' ,`PhotoCount` = '37' ,`PostalCode` = '77377' ,`RoomCount` = '6' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Beaverdell' ,`StreetNumber` = '18239' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1331' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HURRY! COME CHECK THIS ONE OUT! READY FOR YOUR PERSONAL TOUCH! GREAT AND VERY POPULAR FLOORPLAN IN WESTBOURNE... 3 BEDROOM, 2 BATH AND 2 CAR GARAGE! BEAUTIFUL CURB APPEAL! THIS HOME OFFERS LAMINATE FLOORING THROUGHOUT! NEWER ROOF, A/C AND WATER HEATER! FRIDGE INCLUDED! WATER SOFTNER! NICELY LANDSCAPED FRONT AND BACKYARD! BACKYARD OFFERS SHADE AND A SMALL WATER FEATURE/POND! WALKING DISTANCE TO ONE OF THE MANY PARKS WESTBOURNE OFFERS! TOP RATED TOMBALL SCHOOLS ARE ALSO IN WALKING DISTANCE! CLOSE PROXIMITY TO 249, 99 AND BELTWAY! CALL TODAY!' ,`Acres` = '0.1037' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 67 BLK 7 WESTBOURNE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4518' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'WILLOW CREEK ELEMENTARY SCHOOL (TOMBALL)' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'WILLOW WOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westbourne' ,`TaxAmount` = '4272' ,`TaxRate` = '2.5764' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778619' WHERE `Matrix_Unique_ID` = '212824762' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T09:00:08.473' ,`MLSNumber` = '8745493' ,`ListAgentFullName` = 'Chandal Franger' ,`ListOfficeName` = 'RE/MAX ONE - Premier' ,`SellingAgentFullName` = 'Melissa Sumrall' ,`SellingOfficeName` = 'Keller Williams Elite' ,`Latitude` = '29.842396' ,`Longitude` = '-94.857681' ,`PhotoCount` = '34' ,`PostalCode` = '77523' ,`RoomCount` = '9' ,`ListPrice` = '389900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Ronnie' ,`StreetNumber` = '3402' ,`StreetSuffix` = 'Drive' ,`City` = 'Mont Belvieu' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2007' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Pride in home ownership shows inside and outside of this beautiful listing. This home is located in the highly sought after Barbers Hill Independent school district in Crown Colony subdivision, that has NO HOA! This home has 3 bedrooms & 2 bathrooms. The flex room can be used as an office or a formal dining room, possibilities are endless. This home sits on just under half an acre with plenty of room for a pool. It also has a storage building for tools,lawnmower or toys. Don\'t wait! Make your appointment to see this awesome listing today.' ,`Acres` = '0.482' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 5 CROWN COLONY SEC 3 PHASE 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '20996' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL NORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL NORTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Crown Colony Sec 03 Ph 01' ,`TaxAmount` = '5808' ,`TaxRate` = '2.1487' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778619' WHERE `Matrix_Unique_ID` = '212859729' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T08:16:30.947' ,`MLSNumber` = '28241668' ,`ListAgentFullName` = 'Alex Rezende' ,`ListOfficeName` = 'AroundTown Properties Inc' ,`SellingAgentFullName` = 'Rayne Leonard' ,`SellingOfficeName` = 'RAYNE REALTY' ,`Latitude` = '30.096628' ,`Longitude` = '-94.861763' ,`PhotoCount` = '49' ,`PostalCode` = '77535' ,`RoomCount` = '10' ,`ListPrice` = '490000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'County Road 638' ,`StreetNumber` = '147' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2567' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come enjoy the country living in the growing community of Dayton! This stunning, one of a kind ranch style home features 3/5 bedrooms and two full baths sitting on 2 unrestricted acres just 40 minutes away from the heart of Downtown! The backyard oasis features an in-ground heated pool & hot tub (2020), a huge covered patio w/ a wood beam vaulted ceiling, a 30x40 workshop w/ a separate room for crafts, a 30x30 horse barn w/ cement flooring & a 30 amp RV hookup, a FULLY STOCKED pond great for fishing, canoeing or relaxing. The kitchen features elegant Granite countertops, built-in SS appliances, popular white-wood cabinets, a copper finished deep sink & SO much more! Plenty of room to host friends and family whether it be in the backyard under the covered patio and into the sun room, upstairs in the game room and bonus room or in the family room with the stone accented fireplace! Spacious Primary bedroom with room for seating and a MUST SEE primary bath. Spacious secondary bedrooms.' ,`Acres` = '2' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'OAK RIDGE, SEC 1, LOT 5-B, ACRES 2.0' ,`LotDesciption` = 'Cleared,Water View,Wooded' ,`LotSize` = '87120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'RICHTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Ranch' ,`Subdivision` = 'Oak Ridge' ,`TaxAmount` = '6821' ,`TaxRate` = '1.7512' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778619' WHERE `Matrix_Unique_ID` = '212862427' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T08:02:21.037' ,`MLSNumber` = '93688242' ,`ListAgentFullName` = 'Janice Foteh' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.824141' ,`Longitude` = '-95.464334' ,`PhotoCount` = '28' ,`PostalCode` = '77092' ,`RoomCount` = '7' ,`ListPrice` = '435900.00' ,`Status` = 'Active' ,`StreetName` = 'Lamonte' ,`StreetNumber` = '4946' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1507' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Complete new renovation on this 4 bedroom/2 bath home. The updates were designed to keep the 1950\'s charm of the home by grooming the large mature trees & restoring and refinishing the original hardwood floors. New Retro Terrazzo floor in the kitchen/breakfast area. New cabinets in the kitchen and baths. New tile & Quartz in kitchen, Updated master and guest bathrooms with new Quartz & glass tile work in both baths, New stainless appliances, New complete a/c system, double-pane windows, electric fire place, all new solid interior doors , New door fixtures, New plumbing fixtures, New lighting fixtures inside and out, smoke detectors, New garage door and opener, Pex piping, Modern paint colors on interior and exterior and Roof is 2 years old.' ,`Acres` = '0.1589' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 2 MANGUM MANOR SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '6920' ,`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` = 'WAINWRIGHT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Mangum Manor Sec 01' ,`TaxAmount` = '4534' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778619' WHERE `Matrix_Unique_ID` = '212873097' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T08:44:42.250' ,`MLSNumber` = '8659020' ,`ListAgentFullName` = 'Michael Flores' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.781284' ,`Longitude` = '-95.381177' ,`PhotoCount` = '27' ,`PostalCode` = '77009' ,`RoomCount` = '4' ,`ListPrice` = '515500.00' ,`Status` = 'Active' ,`StreetName` = 'Wendel' ,`StreetNumber` = '808' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1526' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 4 bed/2 bath single-story design in Greater Heights area; minutes from the heart of Downtown Houston & endless premier shopping, dining & entertainment. Features gleaming hardwood floors & original charm. Great opportunity to create your dream home utilizing the large footprint & solid bones. Former duplex with covered front porch and dual front doors to welcome you inside. Chef\'s kitchen with room for breakfast table. Gated driveway leads to porte-cochere/carport & backyard with storage shed. Blocks from Stude Park, Pool & Community Center. Near I-10 & I-45 for easy commute. No MUD tax or HOA dues!' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 15 WOODLAND TERRACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodland Terrace' ,`TaxAmount` = '10401' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778620' WHERE `Matrix_Unique_ID` = '212877235' --> 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','212918533','1664778620','212918533','2022-10-02T08:44:32.017','15541939','Rashad Pride','5th Stream Realty','','','29.982612','-95.720230','43','77429','11','396703.00','Active','Dawntreader','19303','Drive','Cypress','3','1','5','3380','Single-Family','Take a look at this beautiful upgraded home in the lovely Villages of Cypress Lakes community. Home is located minutes from 290 and zoned to some of the best schools in Cypress. This rare find features 5 spacious rooms, 3.5 bathrooms with walk in closets and 2 dining rooms. Covered Patio, sprinkler system, new roof installed in 2021, two AC units to keep this spacious home cool in the summer.','0.1414','35','','','','','Mud,Sellers Disclosure','1','','1','Cypress North','Central Gas','1','LT 39 BLK 2 VILLAGES OF CYPRESS LAKES SEC 10','Subdivision Lot','6160','Appraisal District','','640','0','','2','Convection Oven','0','','','Gas Cooktop','','Other','13 - Cypress-Fairbanks','AULT ELEMENTARY SCHOOL','BRIDGELAND HIGH SCHOOL','SALYARDS MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox','Appraisal District','2','Traditional','Villages/Cypress Lakes Sec 10','8413','3.061','Public Water','2006','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T08:11:57.997' ,`MLSNumber` = '15197050' ,`ListAgentFullName` = 'Meriam Shaw' ,`ListOfficeName` = 'Keller Williams Elite' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.806677' ,`Longitude` = '-94.906842' ,`PhotoCount` = '33' ,`PostalCode` = '77521' ,`RoomCount` = '6' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Chase' ,`StreetNumber` = '10014' ,`StreetSuffix` = 'Court' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1833' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! Come and see this beautiful property with 4 Bedrooms with ceiling fans and 2 Full Bath. The large master bedroom is complete with on suite bath and walk-in closets. This home has a large family room that your family will enjoy. This house features 2 Car garage with recent upgrades that include large 4 inch gutters around the house, concrete patio backyard, newly painted kitchen cabinets, new front door, solar screens to all windows, and a 350 sq ft patio at back yard. Property is located in the quiet community of Lynnwood. Make an Appointment Today!' ,`Acres` = '0.126' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Chambers County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BK 1 LT 4 LYNNWOOD SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5489' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CLARK ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lynnwood Sec 3' ,`TaxAmount` = '6559' ,`TaxRate` = '2.9232' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778620' WHERE `Matrix_Unique_ID` = '212926174' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T08:17:16.000' ,`MLSNumber` = '78889879' ,`ListAgentFullName` = 'Tiffany Bean' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.922971' ,`Longitude` = '-95.668652' ,`PhotoCount` = '31' ,`PostalCode` = '77095' ,`RoomCount` = '8' ,`ListPrice` = '440000.00' ,`Status` = 'Active' ,`StreetName` = 'Heron Meadows' ,`StreetNumber` = '10111' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GATE CODE FOR OPEN HOUSE SAT 10/1 1-4PM IS: 50216 Rare opportunity to live right on a golf course! This gorgeous 4BD, 3BTH home sits on the 7th fairway and offers sweeping 2-story panoramic views of the golf course and private access to the course. Located in the sought-after Stone Gate community, the area provides the perfect balance of modern amenities and convenience with access to 2,000 acres of lakes, golfing, parks, excellent schools, proximity to interstate 290 and 99, world-class shopping and dining at Towne Lakes Boardwalk and the Outlet Mall. The home features a 46’ x 16’ covered patio with brick columns, modern upgraded fixtures, beautiful macadamia porcelain tiles, custom molding, enlarged living room, study with charming french doors, floor-to-ceiling built-in shelving, updated Rheem AC, and best of all, a new 50-year roof and extensive privacy with mature Oak and Crepe Myrtle trees surrounding the home.' ,`Acres` = '0.2319' ,`Area` = '8' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 49 BLK 1 STONE GATE SEC 15' ,`LotDesciption` = 'In Golf Course Community,On Golf Course,Subdivision Lot' ,`LotSize` = '10101' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1140' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'BIRKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'SPILLANE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stone Gate Sec 15' ,`TaxAmount` = '7454' ,`TaxRate` = '2.561' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778620' WHERE `Matrix_Unique_ID` = '212947915' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T08:02:49.367' ,`MLSNumber` = '19140535' ,`ListAgentFullName` = 'Joy Samuel' ,`ListOfficeName` = 'Prompt Realty & Mortgage, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.531733' ,`Longitude` = '-95.472538' ,`PhotoCount` = '0' ,`PostalCode` = '77545' ,`RoomCount` = '4' ,`ListPrice` = '529000.00' ,`Status` = 'Active' ,`StreetName` = 'San Bernard' ,`StreetNumber` = '2727' ,`StreetSuffix` = 'Drive' ,`City` = 'Fresno' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2889' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Never lived ready to move in One of a kind unique spacious single story Ashton woods Hanover model. No more lots available to build this model. 40k upgrades. Incredible 4-bedroom 3.5 bath, tandem three car garage, 8\' doors everywhere, high ceiling, formal dining, wow !!!!huge kitchen island open to family room, 42\" cabinets, pull out double trash can under the countertop, remote controlled fireplace, large utility, Gameroom/media room, bedrooms and family rooms are with carpet, entry dining etc. with tiles, covered patio with gas line, hot/cold water line for outside kitchen, sprinkler system, garage door opener, 2\" fox wood blinds for all windows. see to believe .........!!!!! . Fort bend School district and utilities even though in Fresno.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'AW' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7, Block 2 Shipman\'s Cove sec-2' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'GOODMAN ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'HIGHTOWER HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Shipman\'s Cove' ,`TaxAmount` = '' ,`TaxRate` = '3.29' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664778620' WHERE `Matrix_Unique_ID` = '212968717' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T09:33:25.423' ,`MLSNumber` = '71151002' ,`ListAgentFullName` = 'Safa Kharsa' ,`ListOfficeName` = 'United Real Estate' ,`SellingAgentFullName` = 'Derek Mroz' ,`SellingOfficeName` = 'The Reyna Realty Group' ,`Latitude` = '29.860675' ,`Longitude` = '-95.424522' ,`PhotoCount` = '28' ,`PostalCode` = '77091' ,`RoomCount` = '10' ,`ListPrice` = '290000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Utah' ,`StreetNumber` = '6721' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1505' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for an affordable home that doesn\'t feel like a box? This is the house for you! Designer finishes, 14.5\' tall vaulted ceilings, 12\' long butcherblock kitchen island, LED lighting, barn door, stainless steel appliances, modern tile, and soft close drawers/ doors! 3 bedrooms, 2.5 baths plus an attached 1 car garage. Beautifully landscaped front and back yards! Get in on the Acres Homes boom before it\'s too late. Many lots on this same street are under development!' ,`Acres` = '0.0689' ,`Area` = '9' ,`BuilderName` = 'Green Tech Houses' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 17 BLK 17 HIGHLAND HEIGHTS' ,`LotDesciption` = 'Other' ,`LotSize` = '3000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WESLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Highland Heights' ,`TaxAmount` = '420' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664778620' WHERE `Matrix_Unique_ID` = '212998987' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T09:46:10.970' ,`MLSNumber` = '94085950' ,`ListAgentFullName` = 'Wes Sheets' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.776887' ,`Longitude` = '-95.631381' ,`PhotoCount` = '39' ,`PostalCode` = '77414' ,`RoomCount` = '5' ,`ListPrice` = '355000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 201' ,`StreetNumber` = '705' ,`StreetSuffix` = '' ,`City` = 'Sargent' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1064' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Bring your fishing poles and make Sargent your home. Mostly furnished, this 3 bedroom 2 bath house features excellent views, a private boat ramp, a pier with fish cleaning station, and a bulkhead all built in 2021. You\'ll have ample room for your family and friends to enjoy their time here. The large deck is a perfect place to enjoy the morning and watch beautiful sunrises over the Gulf of Mexico. There\'s plenty of storage below the house for your tools, fishing equipment and other needs as well as an outdoor shower. With a great location on a good canal you\'ll be set to take the boat fishing to the ICW, East Matagorda Bay, Mitchell\'s Cut and many other great spots, or just fish and crab off your pier. \r\n\r\nThis would make a great vacation rental option for those that would like to offset some of the costs of ownership.' ,`Acres` = '0.109' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'DOWNEY CANEY CREEK SEC 2, BLOCK 2, LOT 65' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '4750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '12' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '134 - Van Vleck' ,`SchoolElementary` = 'VAN VLECK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'VAN VLECK HIGH SCHOOL' ,`SchoolMiddle` = 'O H HERMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Downey Caney Creek Sec 2' ,`TaxAmount` = '3499' ,`TaxRate` = '2.3895' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778621' WHERE `Matrix_Unique_ID` = '213005284' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T08:23:26.370' ,`MLSNumber` = '72270514' ,`ListAgentFullName` = 'Sony Kohli' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.668531' ,`Longitude` = '-95.510864' ,`PhotoCount` = '23' ,`PostalCode` = '77071' ,`RoomCount` = '4' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Braes Meadow' ,`StreetNumber` = '7610' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2395' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'INVESTEMENT PROPERTY. Investors welcome. This 4-bedroom, 2 full baths with private backyard pool and detached 2-car garage has a lot to offer for homeowner. There is a lot of opportunity to convert this property into a beautiful home by doing some renovations like paint, flooring, landscaping, pool maintenance or other changes as per personal preferences. This is a very quiet and beautiful neighborhood with easy access to all major freeways. This property is perfect for that buyer looking for their next investment. Act fast before this house is off the market!' ,`Acres` = '0.2204' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 33 BLK 5 MAPLEWOOD WEST R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '380' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MILNE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHARPSTOWN HIGH SCHOOL' ,`SchoolMiddle` = 'WELCH MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,No Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Maplewood West Rep' ,`TaxAmount` = '6286' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778621' WHERE `Matrix_Unique_ID` = '213012602' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T09:35:15.403' ,`MLSNumber` = '7101875' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.618597' ,`Longitude` = '-97.211361' ,`PhotoCount` = '22' ,`PostalCode` = '76708' ,`RoomCount` = '3' ,`ListPrice` = '321865.00' ,`Status` = 'Active' ,`StreetName` = 'Guadalupe' ,`StreetNumber` = '7000' ,`StreetSuffix` = 'Street' ,`City` = 'Waco' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1665' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Fargo plan is a one-story home featuring 4 bedrooms, 2 baths, and 2 car-garage. The long foyer leads to the open kitchen and breakfast area. The kitchen includes a breakfast bar, stainless steel appliances, corner pantry and opens to the family room. Bedroom 1 features a sloped ceiling and attractive bathroom with water closet and spacious walk-in closet. The standard rear covered patio is located off the breakfast area. You’ll enjoy added security in your new DR Horton home with our Home is Connected features, including lights, thermostat and locks, all from your cellular device. DR Horton also includes an Amazon Echo Dot to make voice activation a reality in your new Smart Home on select homes. With D.R. Horton\'s simple buying process and ten-year limited warranty, there\'s no reason to wait. (Prices, plans, dimensions, specifications, features, and availability are subject to change without notice obligation)' ,`Acres` = '' ,`Area` = '83' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = '15/7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '20' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '358 - Bosqueville' ,`SchoolElementary` = 'BOSQUEVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BOSQUEVILLE SCHOOL SECONDARY SCHOOL' ,`SchoolMiddle` = 'BOSQUEVILLE SCHOOL SECONDARY SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Rivers Crossing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664778621' WHERE `Matrix_Unique_ID` = '213015559' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T08:18:25.030' ,`MLSNumber` = '84957694' ,`ListAgentFullName` = 'Darrell Anderson' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Darrell Anderson' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.699964' ,`Longitude` = '-95.748503' ,`PhotoCount` = '31' ,`PostalCode` = '77407' ,`RoomCount` = '7' ,`ListPrice` = '385000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Indigo Field' ,`StreetNumber` = '21111' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2714' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to 21111 Indigo Field! Gorgeous open concept with many upgrades. Primary suite is down with a huge walk-in closet. Primary bathroom with double sinks, separate shower and whirlpool. High Ceilings, fireplace, ceramic floors in living room. Do not forget the gameroom!! Make plans to tour this home, it does NOT disappoint!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKEMONT SEC 13, BLOCK 2, LOT 1, 50.000000% UDI' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MCNEILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakemont' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778621' WHERE `Matrix_Unique_ID` = '213045133' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T09:26:56.847' ,`MLSNumber` = '18055484' ,`ListAgentFullName` = 'Daniel DiPetta' ,`ListOfficeName` = 'Bayou City Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.869982' ,`Longitude` = '-95.663338' ,`PhotoCount` = '24' ,`PostalCode` = '77084' ,`RoomCount` = '6' ,`ListPrice` = '289999.00' ,`Status` = 'Active' ,`StreetName` = 'Hunterstone' ,`StreetNumber` = '6403' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2105' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come take a look at this freshly remodeled property tucked away in a mature neighborhood of Cypress! This property includes many upgrades which are; new roof, new AC, new flooring, new paint, new appliances, quartz counter tops, remodeled bathrooms, and many more! Property sits on a spacious corner lot with nice back yard deck. Schedule a showing to view before it\'s gone, guaranteed to sell!' ,`Acres` = '0.1572' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 2 STONE CREEK SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6849' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HOLMSLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LANGHAM CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'KAHLA MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Stone Creek Sec 03' ,`TaxAmount` = '6536' ,`TaxRate` = '3.071' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778621' WHERE `Matrix_Unique_ID` = '213066758' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T09:15:52.780' ,`MLSNumber` = '52728312' ,`ListAgentFullName` = 'Nancy Gardner' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.400681' ,`Longitude` = '-95.619229' ,`PhotoCount` = '49' ,`PostalCode` = '77356' ,`RoomCount` = '10' ,`ListPrice` = '945000.00' ,`Status` = 'Active' ,`StreetName` = 'Waterfront' ,`StreetNumber` = '118' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '3' ,`BedsTotal` = '3' ,`SqFtTotal` = '4319' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning custom home on spectacular corner lot in the highly coveted, gated enclave of The Estates of Walden on Lake Conroe. Gracious family home that is also perfect for entertaining. Situated on 1.38 acres, this home is arguably on the nicest interior lot in The Estates. Lovely mature pecan trees grace the front and side yards and provide shade. Inside, rooms are generously proportioned, have high ceilings with crown molding and are light and airy. Beautiful European oak hardwood floors have recently been installed throughout with the exception of the bathrooms and utility room. Italian tile has replaced original floor covering in the kitchen and breakfast room. Hunter Douglas remote control window coverings are on all windows across the back of property. The kitchen has all new appliances including a Thermidor 5 burner gas cooktop and Bosch double oven and refrigerator. Community amenities include Lake Conroe, golf course, tennis, yacht club, marina, pool & workout center.' ,`Acres` = '1.3673' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'THE ESTATES OF WALDEN, BLOCK 1, LOT 57' ,`LotDesciption` = 'Corner,In Golf Course Community,Subdivision Lot' ,`LotSize` = '59559' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MADELEY RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'The Estates Of Walden' ,`TaxAmount` = '11942' ,`TaxRate` = '2.1392' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778622' WHERE `Matrix_Unique_ID` = '213081490' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T09:36:50.233' ,`MLSNumber` = '32090183' ,`ListAgentFullName` = 'Daniel Rickert' ,`ListOfficeName` = '1st Texas, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.343428' ,`Longitude` = '-94.988915' ,`PhotoCount` = '22' ,`PostalCode` = '77563' ,`RoomCount` = '4' ,`ListPrice` = '129900.00' ,`Status` = 'Active' ,`StreetName` = 'Texas St' ,`StreetNumber` = '6519' ,`StreetSuffix` = 'Street' ,`City` = 'Hitchcock' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1197' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! Don\'t miss this cute home sporting three bedrooms two full bathrooms . Lots of room in the backyard for pets or perfect for a play set. Move in ready with new carpet, fresh interior paint and updated canned lights. Brand-new house being build on the empty lot next-door. Easy access to HWY 6.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hitchcock' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 26 PAGE 5 N 27 FT OF LOT 4 & S 27.3 FT OF LOT 5 (4-1) B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7358' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '26 - Hitchcock' ,`SchoolElementary` = 'HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HITCHCOCK HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (HITCHCOCK)' ,`ShowInstructions` = 'Lockbox Front,No Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunnyside' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778622' WHERE `Matrix_Unique_ID` = '213096889' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T08:39:37.757' ,`MLSNumber` = '95811441' ,`ListAgentFullName` = 'Maricela Benton' ,`ListOfficeName` = 'Lea Homes Realty INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.830596' ,`Longitude` = '-95.131839' ,`PhotoCount` = '42' ,`PostalCode` = '77360' ,`RoomCount` = '3' ,`ListPrice` = '316950.00' ,`Status` = 'Active' ,`StreetName` = 'Cattle' ,`StreetNumber` = '273' ,`StreetSuffix` = 'Drive' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1811' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lea Homes is offering this 3 bedroom, 2 bath signature series home that features a modern theme with trend conscious colors and 8 ft plank flooring throughout entire home (no carpet). The home sits on a large lot with a privacy fenced backyard. The home has 10-foot ceilings throughout and 11-foot ceilings in family room and extra-large primary bedroom. The kitchen features upgraded quartz countertops, 42-inch cabinets, brush nickel faucets, hardware and door levers, also a Samsung appliance package. Dining room has a modern chandelier and living room and primary bedroom have trendy ceiling fans. The primary bathroom includes an oversize fully tiled walk-in shower with a built-in seat and an added window for light. The antique porcelain tile floors and designer mirrors make it a real treat after a long day. An efficient Carrier HVAC system with digital thermostat will keep your electricity bills low. The subdivision has a private boat ramp for homeowners.' ,`Acres` = '0.1964' ,`Area` = '44' ,`BuilderName` = 'LEA HOMES INC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Texas Acres SEC 3 BLK 13 LOT 15' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '8625' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '26' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Texas Acres' ,`TaxAmount` = '44' ,`TaxRate` = '2.0361' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664778622' WHERE `Matrix_Unique_ID` = '213125639' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T08:42:42.833' ,`MLSNumber` = '67199779' ,`ListAgentFullName` = 'Bertha Flores' ,`ListOfficeName` = 'Homes Of Huntsville, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.691865' ,`Longitude` = '-95.442176' ,`PhotoCount` = '0' ,`PostalCode` = '77320' ,`RoomCount` = '8' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Needle' ,`StreetNumber` = '25' ,`StreetSuffix` = 'Drive' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2260' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This all brick 3 bedroom, 2 bath home is on a shaded spacious lot surrounded by mature trees and a circle driveway. It has recently been remodel and update with tile and carpet. All 3 bedrooms have carpet and both bathrooms are tastefully done in contemporary tile and paint. The living/dining areas have wood floors and form an open area ideal for entertaining.\r\nA 1 bedroom 1 bath apartment is attached to the main house and behind the house is a 1 bedroom 1 bath apartment. All 3 dwellings were being used as rentals until recently. The 2 apartments are ideal rental income that the new buyers can use as a source of income. All measurements must be verified by buyer as they are approximate and taken from Walker Appraisal District. Total square footage of 2260 includes all 3 dwellings i.e. Main home 1288 sf, attached apartment 552 sf and detached apartment 420 sf.' ,`Acres` = '' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Watson Lake - Sec 1, Block 4, Lot 13 & 14' ,`LotDesciption` = 'Wooded' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'ESTELLA STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Lockbox Right Side,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Rural' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778622' WHERE `Matrix_Unique_ID` = '213128542' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T09:07:01.293' ,`MLSNumber` = '29809494' ,`ListAgentFullName` = 'Andrea Cadavid' ,`ListOfficeName` = 'Cadavid Properties Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.915200' ,`Longitude` = '-95.084213' ,`PhotoCount` = '26' ,`PostalCode` = '77532' ,`RoomCount` = '8' ,`ListPrice` = '348500.00' ,`Status` = 'Active' ,`StreetName` = 'Awning' ,`StreetNumber` = '1003' ,`StreetSuffix` = 'Court' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2086' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'OPEN HOUSE FOR 10/2 has been CANCELLED. Welcome home to this gorgeous BRAND NEW one story, 4 bedrooms, 2.5 bath home in the established Newport Community! This beautiful home features true craftsmanship through out, starting with the iron front door, wood like tile floor in all the main areas, nice bright and open kitchen to family room, statement chandeliers, high tiered ceilings, bright quartz counter tops, accent tile in both bathrooms, soft-close cabinets, and so many more features! If you love being outdoors this community has a lot to offer, from the tennis courts to the duck pond, to the many wooded trials, the clubhouse, pool, playgrounds, and golf course. Seller is also offering a $2500 contribution towards buyer\'s closing cost! Schedule a showing today!' ,`Acres` = '0.2039' ,`Area` = '1' ,`BuilderName` = 'Lantern Lane Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 9 NEWPORT SEC 7' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8880' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '55' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'CROSBY ELEMENTARY SCHOOL (CROSBY)' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Newport Sec 07' ,`TaxAmount` = '1001' ,`TaxRate` = '2.7105' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664778622' WHERE `Matrix_Unique_ID` = '213128805' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T09:28:19.560' ,`MLSNumber` = '62340357' ,`ListAgentFullName` = 'Christi Byrd' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.958695' ,`Longitude` = '-95.559631' ,`PhotoCount` = '44' ,`PostalCode` = '77422' ,`RoomCount` = '4' ,`ListPrice` = '600000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 819' ,`StreetNumber` = '4916' ,`StreetSuffix` = '' ,`City` = 'Brazoria' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2681' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Own your own piece of paradise on the San Bernard River. This ranch style resort has plenty of room for relaxing or entertaining. The beautiful 5.11 acres offers 115\' of river frontage, pier and a medium duty bulkhead. Step inside to the 4 bedroom, 2 bath home and find that rustic Texas charm. Primary bedroom is located on the 1st floor as well as 2 additional bedrooms. The 4th 500 sq. foot bedroom is located upstairs for privacy. The kitchen is open to the family room and provides a double oven, microwave, dishwasher and refrigerator. The granite countertops add the perfect touch and has plenty of counter space for the chef in the family. Sit by the cozy fireplace on those cool nights and look out at the serene views of the river. Come make this home yours for the holidays. Property has never flooded.' ,`Acres` = '5.11' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'RIVER FRONT-SAN BERNARD S/D (A0041 J H BELL) LOT 44' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '21222591' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '51 - Sweeny' ,`SchoolElementary` = 'SWEENY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SWEENY HIGH SCHOOL' ,`SchoolMiddle` = 'SWEENY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'River Front-San Bernard Sub' ,`TaxAmount` = '8318' ,`TaxRate` = '2.0957' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778622' WHERE `Matrix_Unique_ID` = '213167898' --> 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','213204081','1664778623','213204081','2022-10-02T08:09:07.647','47893394','Aaron Jistel','Listing Spark','','','30.729343','-95.521210','18','77320','7','229000.00','Active','Johnson','301','Road','Huntsville','2','0','3','1568','Single-Family','BRAND NEW never lived in 2022 mobile home on almost a full acre! Beautiful, spacious interior includes wood laminate flooring throughout. Huge living room with kitchen/living room open concept. Huge master bedroom and master bath. Nice new pergola on top of the hill with great views to enjoy! New 8x8 deck off the back. Property is private and secluded with no neighbors to the back or the left and a new privacy fence to the right. Nice park like scenery from the back deck. Property does not flood. Minutes to I-45. Plenty of room for family and pets! Cash back at closing can be negotiated for a storage building or garage if desired! *Note: Interior photos are staged to give ideas.','0.85','43','Clayton Homes','','','','No Disclosures','','','','Huntsville Area','Central Electric','0','MCMILLIAN T P (A-388), TRACT 43.2, ACRES 0.85','Other','37026','Other','','','1','Never Lived In','0','Electric Oven','0','','','','','Composition','64 - Huntsville','SCOTT JOHNSON ELEMENTARY SCHOOL','HUNTSVILLE HIGH SCHOOL','MANCE PARK MIDDLE SCHOOL','Supra Keybox','Seller','1','Other Style','Mcmillian','500','1.9609','Public Sewer,Public Water','2022','Seller'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T09:27:08.470' ,`MLSNumber` = '33948503' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.919777' ,`Longitude` = '-95.082564' ,`PhotoCount` = '10' ,`PostalCode` = '77523' ,`RoomCount` = '9' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Spinnaker' ,`StreetNumber` = '16303' ,`StreetSuffix` = 'Drive' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1932' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BRAND NEW CONSTRUCTION by Lennar Homes, Wildflower Collection \'\'Clover II\" Elevation C in Newport! This single-story home showcases a generous open floorplan shared between the family room, dining room and kitchen, leading directly to a covered patio for seamless indoor-outdoor living. A flex room off the foyer is perfect as a home office or bonus room. Four bedrooms complete this home.' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0001 BLK 005 LOT 005' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'CROSBY ELEMENTARY SCHOOL (CROSBY)' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Newport' ,`TaxAmount` = '' ,`TaxRate` = '3.01' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664778623' WHERE `Matrix_Unique_ID` = '213207338' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T08:08:13.157' ,`MLSNumber` = '22345011' ,`ListAgentFullName` = 'Kelley Brouillette' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.635574' ,`Longitude` = '-95.766749' ,`PhotoCount` = '33' ,`PostalCode` = '77406' ,`RoomCount` = '5' ,`ListPrice` = '349000.00' ,`Status` = 'Active' ,`StreetName` = 'Fox Vale' ,`StreetNumber` = '2911' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1674' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Showings start Monday October 3 on this gently lived in Devon Builders\' home with over-sized cup-de-sac and tree lined back yard. Stone and brick front elevation, with all four sides of the home brick! New extended back patio for entertaining. Home has wood tile flooring throughout all rooms except bedrooms and office with frize carpet. Granite on all counters! Upgraded tile in bath areas and shower. Office has French doors. Island kitchen with large walk-in pantry. 5 Burner gas cooktop and all stainless appliances. Tankless hot water heater! Front and back yard sprinkler system. Low E double paned windows, smart thermostat and smart home wired. Pride of ownership shows on this one!' ,`Acres` = '0.1824' ,`Area` = '37' ,`BuilderName` = 'Devon Street' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MCCRARY MEADOWS SEC 2, BLOCK 1, LOT 70' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7947' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Mccrary Meadows' ,`TaxAmount` = '3060' ,`TaxRate` = '2.8548' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664778623' WHERE `Matrix_Unique_ID` = '213210166' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T09:59:41.723' ,`MLSNumber` = '289723' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.033787' ,`Longitude` = '-95.493729' ,`PhotoCount` = '33' ,`PostalCode` = '77379' ,`RoomCount` = '4' ,`ListPrice` = '302000.00' ,`Status` = 'Active' ,`StreetName` = 'Cobble' ,`StreetNumber` = '5222' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2491' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this gorgeous neighborhood! You don’t want to miss this home. The kitchen boasts generous counter space, a breakfast bar, tile backsplash, and sleek countertops, making cooking and entertaining a delight. Flow into the main living area, featuring a fireplace and well placed windows for natural lighting. The main bedroom and bathroom give you the perfect space for everyday living. Relax with your favorite drink in the fenced in backyard with a patio and lush grass. Don\'t miss this incredible opportunity. This home has been virtually staged to illustrate its potentia' ,`Acres` = '0.2152' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 1 TERRANOVA SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9374' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '603' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BENFER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'STRACK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Terra Nova Sec 01' ,`TaxAmount` = '5636' ,`TaxRate` = '2.3266' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1664778623' WHERE `Matrix_Unique_ID` = '213210844' --> 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','213213708','1664778623','213213708','2022-10-02T09:34:23.393','84520520','Blanca Llanez','HomeSmart','','','30.015129','-95.320974','23','77338','5','234900.00','Active','Fox Glen','20307','Lane','Humble','2','0','3','1418','Single-Family','GORGEOUS, UPDATED KITCHEN AND AMAZING HALL BATHROOM. Enjoy your holidays in your beautiful 3/2/2 one-story with open floor plan and huge back yard and deck. Great for entertaining. Preparing meals in your beautiful kitchen with granite counters, tiled backsplash, and cabinets galore will be a joy. New wine-fridge. Appliances about 3 years old. Fridge stays. A/c unit and central heat were replaced. Other new items: Sliding patio door, kitchen sink and faucet. New Roof 2019. Primary bedroom has an additional 8x10 space for study, office, nursury, etc. There\'s also a nice private patio outside the primary bedroom. All walk-in closets in bedrooms. Measurements are approximate - please verify all measurements and information. Located in established neighborhood. Just a few blocks to the community center. Location, location, location! Convenient, close to Bush airport, shopping, freeways. Come see and make this your new home!','0.1612','12','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','1','Humble Area West','Central Electric','1','LT 2 BLK 5 FOXWOOD SEC 2','Subdivision Lot','7020','Appraisal District','','325','0','','2','','0','','','Electric Range','','Composition','1 - Aldine','CYPRESSWOOD ELEMENTARY SCHOOL (ALDINE)','NIMITZ HIGH SCHOOL (ALDINE)','JONES MIDDLE SCHOOL (ALDINE)','Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Foxwood Sec 02','4377','2.7734','Water District','1977','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','213216439','1664778623','213216439','2022-10-02T08:51:37.750','18318345','Gary Wander','RE/MAX Southwest','','','29.694612','-95.539129','19','77036','11','315000.00','Active','Sharpcrest','8807','Street','Houston','2','0','4','2348','Single-Family','LOCATION - LOCATION - LOCATION !!! Beautifully updated (roof, A/C, interior paint, flooring) and ready for you to make this your HOME SWEET HOME!','0.2646','21','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Sharpstown Area','Central Gas','1','LT 14 BLK 41 SHARPSTOWN COUNTRY CLUB TERRACE SEC 3','Subdivision Lot','11525','Appraisal District','','250','0','','2','Double Oven,Electric Oven','0','','','Gas Cooktop','','Composition','27 - Houston','WHITE ELEMENTARY SCHOOL','SHARPSTOWN HIGH SCHOOL','SUGAR GROVE MIDDLE SCHOOL','Lockbox Front','Appraisal District','1','Traditional','Sharpstown Country Club Terrace','6046','2.3307','Public Sewer,Public Water','1967','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','213216890','1664778623','213216890','2022-10-02T09:42:20.967','75275519','Shea Soler','Keller Williams Platinum','','','29.796273','-95.498989','36','77055','3','535000.00','Active','Panatella','8529','Drive','Houston','2','0','3','1701','Single-Family','The first families moved to Spring Branch in 1953 & back then, it felt they were moving to the country.This community is amongst the oldest in Houston. Now this coveted quaint community is undergoing a rebirth or transformation of multi-million dollar properties being built thru-out this small community. This property is situated in the coveted back part of the community within walking distance of the Moritz Pech Family Park & the streets are lined w/magnificent oak sentinels.\r\nThe structure on this property is a tear down.It is the land that is of value.The overall Spring Branch area is undergoing a broad revitalization as families move to the area and renovate older homes or build new homes on existing lots to take advantage of all the area has to offer. The Spring Branch Management District is making great strides to beautify the area, strengthen business relations, improve transportation, and enhance security in the area for families. Come discover this hidden gem...come home!','0.2089','24','','','','','Sellers Disclosure','','','1','Spring Branch','Central Gas','0','TR 132 BLK 7 SPRING OAKS R/P','Subdivision Lot','9100','Appraisal District','','20','0','','','','0','','','','','Composition','49 - Spring Branch','VALLEY OAKS ELEMENTARY SCHOOL','MEMORIAL HIGH SCHOOL (SPRING BRANCH)','LANDRUM MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Spring Oaks R/P','11110','2.4415','Public Sewer,Public Water','1952','Appraisal District'); --> New record created successfully