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-09-25T21:48:40.100' ,`MLSNumber` = '48681903' ,`ListAgentFullName` = 'Debbie Jones' ,`ListOfficeName` = 'Waller County Land Co.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.074678' ,`Longitude` = '-95.780331' ,`PhotoCount` = '32' ,`PostalCode` = '77447' ,`RoomCount` = '6' ,`ListPrice` = '349000.00' ,`Status` = 'Active' ,`StreetName` = 'Barrel Run' ,`StreetNumber` = '20450' ,`StreetSuffix` = 'Drive' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1838' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HUGE corner lot with a charming home. This premium lot is one of the largest lots in Bauer Landing. This beautiful home has great curb appeal with an attractive brick & stone elevation. You\'ll feel a warm welcome from the minute you step inside. Tastefully decorated & boasting neutral tones, this spacious floor plan has a nice flow. It offers a great open space for entertaining & family gatherings. You will love the large kitchen with lots of dark rich cabinetry, granite countertops & a breakfast bar. The master suite is well located separately from the secondary bedrooms & is complete with a large ensuite. The master ensuite features a double vanity, separate tub & shower & lots of closet space. You\'ll enjoy coffee & cookouts on the extended back patio. There is plenty of room to roam in this huge yard. Add a pool & create a tropical retreat! This large corner lot is complete with a 13-station sprinkler system & a 12X8 storage/garden shed. Well located w/easy access to Hwy 290 & 99.' ,`Acres` = '0.3833' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 2 BAUER LANDING SEC 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '16697' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'EVELYN TURLINGTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bauer Landing Sec 2' ,`TaxAmount` = '6756' ,`TaxRate` = '2.8556' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185670' WHERE `Matrix_Unique_ID` = '207441498' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T20:55:33.757' ,`MLSNumber` = '77331631' ,`ListAgentFullName` = 'Rusty Shannon' ,`ListOfficeName` = 'Patti Shannon Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.506432' ,`Longitude` = '-95.177706' ,`PhotoCount` = '50' ,`PostalCode` = '77546' ,`RoomCount` = '12' ,`ListPrice` = '899000.00' ,`Status` = 'Active' ,`StreetName` = 'Butler' ,`StreetNumber` = '2004' ,`StreetSuffix` = 'Drive' ,`City` = 'Friendswood' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3559' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Pilots! Your opportunity to purchase a 2 story, metal roofed home & hangar that has never flooded, w/ a Beautiful pool & hot tub, on the Gorgeous Aviation Polly Ranch Estates runway. Close to dining & shopping - close to Houston & a very Active flying Community. This 1981 built home sits on .5510 acres with a 2500 sq ft, well lighted, Aircraft Hangar complete with a 45 ft x 14 high Bi-Fold Wilson Hangar Door, an automatic RV roll up door at 10Wx12H, a full bath & air conditioned pilot lounge, & concrete ramp with multiple tie downs. The Airport Identifier is 7XS0 & has a well maintained 2,700 ft asphalt, lighted 11/29 runway. This home has all of the traditional features from its era like a Formal Living & Formal Dining. A separate Family room with a gas log fireplace for comfort. Large primary bedroom & bath are down while the other 3 bedrooms are up. Huge Gameroom with half bath above the garage. Relax on the rear patio while the grand children swim. #SearchTexasAirparks' ,`Acres` = '0.551' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 151 PAGE 11 LOT 116 POLLY RANCH ESTATES REPLAT' ,`LotDesciption` = 'Airpark,Subdivision Lot' ,`LotSize` = '24000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'WESTWOOD ELEMENTARY SCHOOL (FRIENDSWOOD)' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Photos/No Videos,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Polly Ranch Estates Rep' ,`TaxAmount` = '10448' ,`TaxRate` = '2.2832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185670' WHERE `Matrix_Unique_ID` = '207751795' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T21:15:31.073' ,`MLSNumber` = '91644088' ,`ListAgentFullName` = 'Cindy Case' ,`ListOfficeName` = 'Douglas Elliman Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.735436' ,`Longitude` = '-95.453792' ,`PhotoCount` = '47' ,`PostalCode` = '77027' ,`RoomCount` = '11' ,`ListPrice` = '2995000.00' ,`Status` = 'Active' ,`StreetName` = 'Shetland' ,`StreetNumber` = '4542' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '5777' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'With stunning curb appeal this unique contemporary modern home boast features surpassing other homes. Situated in the most desirable section of Afton Oaks with beautiful mature tree lined streets close to major retail/restaurants/ Med Ctr. w/easy access to major highways, 24/7 private patrol, active Civic Club. This smart home features 100% LED lighting, Moes WIFI lighting system, an impressive 2 story entry w/ floating LED lit staircase, LED lit suspended ceiling, 14’ entry chandelier, 60” LED lit fireplace, prewired for electrical shades, custom vertical open cabinetry, Viking appliances, XL pantry & second refrigerator area, ultra-custom refrigerated wine room, elevator, primary bedroom w/ 2 XL closets, 2 commodes, LED rain-head. Outdoor: covered summer kitchen, full bath & storage closet. Garage 12’ ceilings, storage, wired for EV. Solid built construction/foundation w/ steel framing, 2x6 studs, 5” thick custom cut limestone exterior, RAM aluminum windows, 4 zone 16 SEER HVAC.' ,`Acres` = '' ,`Area` = '16' ,`BuilderName` = 'Payton Homes, LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Royden Oaks/Afton Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 24 BLOCK 6 AFTON OAKS SECTION 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Grill' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SCHOOL AT ST GEORGE PLACE' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Photos/No Videos,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Afton Oaks' ,`TaxAmount` = '' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664185671' WHERE `Matrix_Unique_ID` = '208044140' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T21:20:38.733' ,`MLSNumber` = '31813412' ,`ListAgentFullName` = 'Alessandra Isola' ,`ListOfficeName` = 'HOUSTON TOP REALTY' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.571402' ,`Longitude` = '-95.612967' ,`PhotoCount` = '35' ,`PostalCode` = '77479' ,`RoomCount` = '9' ,`ListPrice` = '700000.00' ,`Status` = 'Active' ,`StreetName` = 'Pipers' ,`StreetNumber` = '95' ,`StreetSuffix` = 'Walk' ,`City` = 'Sugar Land' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3665' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FINAL NEW PRICE TO SELL AS IS! Gorgeous CORNER LOT in the very desirable SWEETWATER subdivision. \r\nSpacious 3 bedrooms, study or game room easy convertible in the 4th bedroom, 4 and 1/2 baths, upstairs game room with balcony. Huge living room with natural lighting, study with built-in shelves, large formal dining room and updated kitchen with granite countertops, water softener, detached 3 cars garage, pool and spa.' ,`Acres` = '0.3383' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SWEETWATER SEC 1, BLOCK 7, LOT 6' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '14735' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2132' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'COLONY BEND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sweetwater Sec 1' ,`TaxAmount` = '13771' ,`TaxRate` = '2.1584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185671' WHERE `Matrix_Unique_ID` = '208129640' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T20:51:48.573' ,`MLSNumber` = '74044435' ,`ListAgentFullName` = 'Danny Barrett' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.686021' ,`Longitude` = '-95.166544' ,`PhotoCount` = '33' ,`PostalCode` = '77331' ,`RoomCount` = '4' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Marina Trl' ,`StreetNumber` = '444' ,`StreetSuffix` = '' ,`City` = 'Coldspring' ,`BathsFull` = '1' ,`BathsHalf` = '2' ,`BedsTotal` = '1' ,`SqFtTotal` = '3120' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A unique 3,120 sf barndominium that sits on 4 lots in a peaceful lakeside community. The property has electric, public water, and its own septic system. All 4 lots are adjoining. Each are approximately 10,500 sf, equaling 41,992 sf, or .964 acres. One has a poured slab for a garage, prepped with power and ready for completion. The building has stained cement floors on the lower level, a fully decked loft overlooking the main living area, 1 bedroom with an ensuite, 2 half baths, a large kitchen and prep area with 2 sinks, covered porches on all 4 sides, and more. The subdivision offers a community center, swimming pool, boat launch and a marina. The property has tremendous potential and with your vision and creativity can be a beautiful residential property customized to your style of lake living.' ,`Acres` = '0.964' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '1' ,`Legal` = 'HOLIDAY SHORES SUB 1, BLOCK 8, LOT 10, 11, 12 & 15 SECTION 2' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot,Water View' ,`LotSize` = '41992' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '110' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Barndominium' ,`Subdivision` = 'Holiday Shores Sub 1' ,`TaxAmount` = '2921' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185671' WHERE `Matrix_Unique_ID` = '208267341' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T20:06:55.027' ,`MLSNumber` = '14567085' ,`ListAgentFullName` = 'Carol Knott Tefft' ,`ListOfficeName` = 'RE/MAX Integrity' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.112592' ,`Longitude` = '-95.392282' ,`PhotoCount` = '30' ,`PostalCode` = '77386' ,`RoomCount` = '9' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Hidden Spring Falls' ,`StreetNumber` = '2707' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1907' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful and functional describes this great one story in a quiet but accessible area of Fox Run, zoned to award winning Conroe ISD. From the moment you step into the home from the covered front porch area, you will love that there is no carpet. Its split plan allows for privacy in the large primary bedroom. Secondary bedrooms are near the front of the home and are laid out well to accommodate furnishings. The large dining room offers flexibility for multiple uses but easily could handle a crowd on special occasions. You will love the openness of the kitchen to the spacious family room. This kitchen has recently replaced appliances including a refrigerator. Fresh paint and many recent updates have just been completed. Don\'t miss your opportunity to call this home. The location near Grand Parkway is near restaurants, shopping, and fantastic accessibility to The Woodlands, Hardy Toll Road and I-45.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'KB' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'FOX RUN 08, BLOCK 1, LOT 32' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5252' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '315' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'FORD ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'FOX RUN 08' ,`TaxAmount` = '4820' ,`TaxRate` = '2.82' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185671' WHERE `Matrix_Unique_ID` = '209145941' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T20:59:41.217' ,`MLSNumber` = '9502846' ,`ListAgentFullName` = 'Markesha Smith' ,`ListOfficeName` = 'Rochelle Marquee Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.724117' ,`Longitude` = '-95.379850' ,`PhotoCount` = '35' ,`PostalCode` = '77004' ,`RoomCount` = '10' ,`ListPrice` = '2300000.00' ,`Status` = 'Active' ,`StreetName` = 'Southmore' ,`StreetNumber` = '1819' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Houston' ,`BathsFull` = '6' ,`BathsHalf` = '2' ,`BedsTotal` = '6' ,`SqFtTotal` = '6200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A Must See…Modern architectural wonder nestled in the heart of the museum district. The perfect embrace of form and nature, the lofty picture windows and multilevel patios encourage indoor and outdoor living. Outfitted with hand-picked imported hardware and finishes the home prioritizes ease with a fully integrated Smart Home system. Whether you’re entertaining or looking for a bit of R&R the spa grade sauna, chef’s kitchen, home theater and courtyard pool, meet the need. In addition to the main house, the accompanying secondary house boasts two full bedrooms with en-suites and living.  The home is located within walking distance of Houston’s top-rated restaurants and medical district.\r\n\r\n**Please Note** The guesthouse has a different address but is included in the sale of the home. 1822 Palm St' ,`Acres` = '0.2255' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rice/Museum District' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 BLK 1 & E 14 FT LT 9 BLK 4 & LTS 6 & 7 BLK 1 & PALM PLA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9824' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MACGREGOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Southmore Terrace 02' ,`TaxAmount` = '32922' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1664185671' WHERE `Matrix_Unique_ID` = '209187922' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T20:53:14.917' ,`MLSNumber` = '5777182' ,`ListAgentFullName` = 'Salah Kaspo' ,`ListOfficeName` = 'RE/MAX Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.736768' ,`Longitude` = '-95.475226' ,`PhotoCount` = '38' ,`PostalCode` = '77056' ,`RoomCount` = '8' ,`ListPrice` = '599990.00' ,`Status` = 'Active' ,`StreetName` = 'Val Verde' ,`StreetNumber` = '5528' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3250' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Absolute must see! Beautiful single-family home in a privately gated enclave, situated on the only true cul-de-sac in St George Place! Beautiful pocket park just steps outside your gate. Walk to excellent public schools a block away (School at St George Place and Mandarin Immersion Magnate School), world class retail at the Galleria, and hands-down the best restaurants in Houston! Home has 3 HUGE bedrooms, 3.5 baths, and unbelievable closet space. Come see the gourmet Kitchen w/ SS appliances, granite countertops throughout the home, open floorplan, and oversized 2 car garage! Maintenance free backyard is incredibly spacious and was completely renovated with new paver stone patio and fence! HOA fee covers all landscaping, private trash/recycling service, common area maintenance, and mosquito prevention. Come view the best location in Uptown to see everything this incredible property has to offer!' ,`Acres` = '' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Galleria' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 1 VILLA DE FIORI' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '3226' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SCHOOL AT ST GEORGE PLACE' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'VILLA DE FIORI' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185671' WHERE `Matrix_Unique_ID` = '209370595' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T21:39:32.700' ,`MLSNumber` = '58380603' ,`ListAgentFullName` = 'Sal Conda' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.560405' ,`Longitude` = '-95.570912' ,`PhotoCount` = '23' ,`PostalCode` = '77459' ,`RoomCount` = '6' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Shady' ,`StreetNumber` = '4411' ,`StreetSuffix` = 'River' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2714' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Price Reduced!! Ready to move-in! Refrigerator, washer & dryer included. Beautiful One- story home nestled in Riverstone subdivision. Handicap access doorway. Four bedrooms and 3 full bath plus formal living and dining room with no back neighbors for total privacy. Quick access to Highway 6 & 59.' ,`Acres` = '0.2101' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'THE TERRACE AT RIVERSTONE SEC 1, BLOCK 1, LOT 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9153' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1110' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'AUSTIN PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverstone' ,`TaxAmount` = '' ,`TaxRate` = '2.74' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185672' WHERE `Matrix_Unique_ID` = '209803878' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T21:57:48.060' ,`MLSNumber` = '72510033' ,`ListAgentFullName` = 'Brittany Johnson' ,`ListOfficeName` = 'Styled Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.043415' ,`Longitude` = '-95.451688' ,`PhotoCount` = '50' ,`PostalCode` = '77388' ,`RoomCount` = '11' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Hendricks Lakes' ,`StreetNumber` = '2614' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2883' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in the highly desirable gated community of Lakes of Cypress Forest. This resort style community includes walking trails, pristine lakes, parks and a community pool with a splash feature. This one story, 4 bedroom, 2 bath home shows perfectly. The impressive primary suite includes a sitting area, hardwood flooring, two large walk-in closets, double vanity sinks, jetted tub for soaking and a separate shower. The oversized living area has high ceilings, a stone fireplace, built-in shelving and 3 floor to ceiling windows to allow all the natural light.The kitchen overlooks the breakfast and family room and includes stainless steel appliances, granite counter tops and a large island. Kitchen refrigerator and washer/dryer included. The entire home is freshly painted 6/4/22. Never flooded, Brand new AC, tankless water heater and exterior backyard fence installed. Minutes from I-45, 99, the Hardy Toll, The Woodlands, Exxon\'s campus and Bush Intercontinental Airport.' ,`Acres` = '0.1982' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 3 LAKES OF CYPRESS FOREST SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8633' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'LEMM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'STRACK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes Cypress Forest Sec 01' ,`TaxAmount` = '8150' ,`TaxRate` = '2.484' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185672' WHERE `Matrix_Unique_ID` = '209844759' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T21:02:01.147' ,`MLSNumber` = '89771518' ,`ListAgentFullName` = 'Ali Guven' ,`ListOfficeName` = 'REB365' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.649689' ,`Longitude` = '-95.595130' ,`PhotoCount` = '11' ,`PostalCode` = '77477' ,`RoomCount` = '8' ,`ListPrice` = '309900.00' ,`Status` = 'Active' ,`StreetName` = 'Brook Meadows' ,`StreetNumber` = '12410' ,`StreetSuffix` = 'Lane' ,`City` = 'Meadows Place' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2114' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION, LOCATION, LOCATION! Welcome to 12410 Brook Meadows Ln, ZONED to top rated FORT BEND ISD schools, including the brand new Meadows Elementary School. Fridge, washer & dryer are included.\r\nLow Tax rate of 2.5% and NO HOA !!! This beauty won\'t last long. Schedule your tour today!' ,`Acres` = '0.1255' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Stafford Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'MEADOWGLEN SEC 2, BLOCK 10, LOT 32' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5468' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'MEADOWS ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Lockbox Right Side,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Meadowglen' ,`TaxAmount` = '5413' ,`TaxRate` = '2.4949' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185672' WHERE `Matrix_Unique_ID` = '209926429' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T21:08:11.160' ,`MLSNumber` = '32858413' ,`ListAgentFullName` = 'Banessa Tafolla' ,`ListOfficeName` = 'Ambrosi Realty INC.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.863376' ,`Longitude` = '-95.705471' ,`PhotoCount` = '11' ,`PostalCode` = '77449' ,`RoomCount` = '9' ,`ListPrice` = '299999.00' ,`Status` = 'Active' ,`StreetName` = 'Paddle Wheel' ,`StreetNumber` = '6218' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2614' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Very large home with three beds and a game room up and the primary down. Detached garage and wood deck out back. Located in a quite cul-de-sac as well.' ,`Acres` = '0.2229' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 5 BEAR CREEK PLANTATION 1 R/P' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '9708' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '460' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`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` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bear Creek Plantation 01 R/P' ,`TaxAmount` = '5552' ,`TaxRate` = '2.671' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185672' WHERE `Matrix_Unique_ID` = '210018415' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T21:36:52.257' ,`MLSNumber` = '86015009' ,`ListAgentFullName` = 'Alya Dawood' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.813879' ,`Longitude` = '-95.680816' ,`PhotoCount` = '36' ,`PostalCode` = '77084' ,`RoomCount` = '5' ,`ListPrice` = '279900.00' ,`Status` = 'Active' ,`StreetName` = 'Clipper Winds' ,`StreetNumber` = '3118' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2008' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Never Flooded. Beautiful 2 story, 4 bedrooms, 2 and 1/2 baths and 2 car garage home in Barkers Crossing. Its conveniently located close to Barker Cypress and few miles from I10. The primary bedroom has a private ensuite with a separate tub and shower, and a walk-in closet. The kitchen has spacious cabinetry, beautiful Quartz countertops, Quarts backsplash and a pantry. Large family room downstairs with dining area, in-home laundry and half bath. Don\'t miss this opportunity to live in this gorgeus quiet neighborhood.' ,`Acres` = '0.1085' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 3 BARKERS CROSSING SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4725' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '385' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'SCHMALZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MAYDE CREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Barkers Crossing Sec 1' ,`TaxAmount` = '4590' ,`TaxRate` = '2.487' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185672' WHERE `Matrix_Unique_ID` = '210281039' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T20:28:37.550' ,`MLSNumber` = '70504235' ,`ListAgentFullName` = 'Demetra Carlson' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.803832' ,`Longitude` = '-95.518088' ,`PhotoCount` = '48' ,`PostalCode` = '77080' ,`RoomCount` = '11' ,`ListPrice` = '489999.00' ,`Status` = 'Active' ,`StreetName` = 'Spring Branch' ,`StreetNumber` = '9301' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2560' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION, LOCATION LOCATION! WHAT IS MORE IMPORTANT THAN LOCATION? NOT FLOODING! THIS BEAUTY DID NOT FLOOD! 8 HURRICANES AND NEVER FLOODED! WONDERFUL LARGE HOME ON A HUGE WOODED PRIVATE LOT WITH NO BACK NEIGHBORS FOR COMPLETE PRIVACY! TWO MASTER BEDROOMS! UPDATED KITCHEN AND BATHROOMS-HARDWOODS AND TILE THROUGHOUT! ADDITIONAL UPSTAIRS MASTER HAS EXECUTIVE BATH & PRIVATE DECK OVERLOOKING BACKYARD, POOL WITH STAIRS TO BACKYARD. SEVERAL PATIOS AROUND HOME. DON\'T MISS THIS GEM WITH LOTS OF ROOM TO SPREAD OUT AND ENTERTAIN! CLOSE TO BUNKERHILL SHOPPING, MEMORIAL CITY MALL, CITY CENTER, MEMORIAL HOSPITAL! GETTING TO THE HEIGHTS OR DOWNTOWN IS A BREEZE!! DID I MENTION LOCATION??' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 33 BLK 6 SPRING BRANCH OAKS' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '14300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '20' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'SPRING BRANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING WOODS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Branch Oaks' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185672' WHERE `Matrix_Unique_ID` = '210406359' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T20:47:41.177' ,`MLSNumber` = '36536456' ,`ListAgentFullName` = 'Lucy Aguirre Moore' ,`ListOfficeName` = 'Kino Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.777506' ,`Longitude` = '-94.921432' ,`PhotoCount` = '38' ,`PostalCode` = '77521' ,`RoomCount` = '12' ,`ListPrice` = '900000.00' ,`Status` = 'Active' ,`StreetName` = 'Spring' ,`StreetNumber` = '5011' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '5847' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning recently remodeled colonial home sits on 3.4 acres. The grand living space w /soaring ceilings looks out onto a breathtaking view of the Cedar Bayou, swimming pool, & private creek. Elegant French doors allow abundance of natural light in & easy access to the wrapped around porch. Impressive kitchen has a double island & quartz countertops, custom cabinetry, 6 burner/2 oven Fisher & Paykel range wrapped in stone wall w/decorative backsplash & water pot filler. The cuddly master bedroom is adorned w/ double French doors allowing access to the front/side yard. Large master suite bath features his & her sinks, a large shower, & free standing soaking tub. Spacious secondary bedrooms have nice views of the property & bayou. Other highlights include & not limited to engineered wood flooring, speakers, elevator & utility elevator, extra storage. The spacious guest house is fully equipped with a living room/ breakfast area/kitchen/one bedroom w/extra room/full bathroom/storage.' ,`Acres` = '3.4403' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 5A-1 ABST 69 C SMITH' ,`LotDesciption` = 'Water View,Wooded' ,`LotSize` = '149859' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven,Freestanding Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'CEDAR BAYOU J H' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'Christian Smith Surv Sec-Four' ,`TaxAmount` = '28586' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185673' WHERE `Matrix_Unique_ID` = '210549990' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T21:06:24.533' ,`MLSNumber` = '21196503' ,`ListAgentFullName` = 'Tiffany Curry' ,`ListOfficeName` = 'BHHS Tiffany Curry & Co., REALTORS' ,`SellingAgentFullName` = 'Joe Haas' ,`SellingOfficeName` = 'The Wolf Real Estate Group' ,`Latitude` = '29.560437' ,`Longitude` = '-95.436083' ,`PhotoCount` = '43' ,`PostalCode` = '77584' ,`RoomCount` = '16' ,`ListPrice` = '545000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Greenblade' ,`StreetNumber` = '2712' ,`StreetSuffix` = 'Court' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4547' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GORGEOUS 2-STORY PERRY HOME w/5 bedroom/3.5 bath/3-car on a great lot in Shadow Creek Ranch. RARE ONE-OF-A-KIND home is the only home w/ this floorplan in the community! Great NEXT-GEN home features 2-PRIMARY BEDROOMS & 2-OFFICES! 1st Primary suite downstairs w/a large walk-in-closet & oversized primary\'s bath. Formal Dining, Butler\'s Pantry, Study, Family Room w/fireplace; granite island kitchen, extended covered patio & Breakfast area. Upstairs your entertaining begins w/an enormous Game Room perfect for reading/crafting/hanging out or watching tv. Upstairs also features a 2nd Study, 4 bedrooms w/spacious closets & an extra large storage closet. Huge backyard w/tons of space for a pool & playground perfect for pets, kids & gardening! Community features Splash Pads, Pools, Basketball, Tennis, Soccer, Walking Trails, Lakes, Clubhouse & more! Minutes to HWY 288, New Toll, Pearland Town Center, Grocery Stores, Restaurants, Medical Center, Downtown Houston & more! NEVER FLOODED!!!' ,`Acres` = '0.2182' ,`Area` = '38' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SHADOW CREEK RANCH SF-53, BLOCK 2, LOT 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9504' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '999' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BLUE RIDGE ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'WILLOWRIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'MCAULIFFE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadow Creek Ranch' ,`TaxAmount` = '13110' ,`TaxRate` = '3.2123' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185673' WHERE `Matrix_Unique_ID` = '210797953' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T21:45:06.053' ,`MLSNumber` = '67858930' ,`ListAgentFullName` = 'Priscilla Lopez-Garcia' ,`ListOfficeName` = 'Prime Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.792439' ,`Longitude` = '-95.434702' ,`PhotoCount` = '27' ,`PostalCode` = '77008' ,`RoomCount` = '7' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Timbergrove Heights' ,`StreetNumber` = '3331' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1985' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful freestanding home in the charming, cozy gated community of Timbergrove Heights. The second floor living area boasts soaring 12-ft ceilings, crown moulding, bluetooth surround sound, and epic 10-ft glass sliding trifold doors that open out from your living room to oversized balcony with gas/water hookup. The kitchen features SS Bosch appliances, prep-island, double trash-bin, and custom high quality soft close pull-out drawers. The spacious primary suite holds three walk in closets and leads into a 5 star spa- like bathroom. Equal distribution wifi installed on every level. Hardwood floors, 2- car garage, custom window shades included, upgraded fixtures included, fully wired smart home, washer/dryer included... truly a must see! Come be a part of the Heights boom! Home has gated front yard. Jaycee park is only a 5 min walk away w/ basketball/tennis courts, walking trails, playground.' ,`Acres` = '0.0347' ,`Area` = '9' ,`BuilderName` = 'InTown Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Timbergrove/Lazybrook' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 4 TIMBERGROVE HEIGHTS' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '1512' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,Lockbox Right Side,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,French,Traditional' ,`Subdivision` = 'Timbergrove Heights' ,`TaxAmount` = '10407' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185673' WHERE `Matrix_Unique_ID` = '210855589' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T21:02:37.167' ,`MLSNumber` = '29471410' ,`ListAgentFullName` = 'Zaran Engineer' ,`ListOfficeName` = 'Cornerstone Prop Mngt, Inc,' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.703214' ,`Longitude` = '-95.367893' ,`PhotoCount` = '8' ,`PostalCode` = '77021' ,`RoomCount` = '7' ,`ListPrice` = '409000.00' ,`Status` = 'Active' ,`StreetName` = 'Illinois' ,`StreetNumber` = '6309' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1967' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ASK LISTING AGENT FOR DETAILS. THIS BRAND NEW CONTEMPORARY 2 STORY HOME CONTAINING 3 BEDROOMS, 2 1/2 BATHROOMS, A STUDY/HOME OFFICE ON THE FIRST FLOOR, AND A 2 CAR ATTACHED GARAGE. IT HAS A GREAT LOCATION RIGHT BY THE MEDICAL CENTER, UNIV OF HOUSTON, TSU, RICE UNIV., HERMAN PARK & MUSEUM DISTRICT! Unlike other such new developments, this one is located very close to shopping centers, multiple grocery stores, pharmacies, restaurants etc. Just minutes for highway 288, this newly constructed home offers an open living area with wood flooring, a living area with double doors leading to backyard. Modern kitchen featuring European cabinets , quartz countertops , stainless steel appliances, large kitchen island, porcelain tiles, seamless shower stall, Free standing tub in primary bathroom, etc. etc. No restrictions and no HOA. A MUST SEE! Home will be completed by 9/15/22, will not last long on the market.' ,`Acres` = '' ,`Area` = '4' ,`BuilderName` = 'BG Building Group' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Riverside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 1 PARK AT ILLINOIS STREET' ,`LotDesciption` = 'Other' ,`LotSize` = '2442' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'THOMPSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'SOUTHLAND PLACE 2ND PAR R/P & OTHERS' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664185673' WHERE `Matrix_Unique_ID` = '210956998' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T21:14:29.970' ,`MLSNumber` = '90799021' ,`ListAgentFullName` = 'Vu Le' ,`ListOfficeName` = 'Intercontinental Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.721173' ,`Longitude` = '-95.621589' ,`PhotoCount` = '50' ,`PostalCode` = '77082' ,`RoomCount` = '5' ,`ListPrice` = '279990.00' ,`Status` = 'Active' ,`StreetName` = 'Luton Park' ,`StreetNumber` = '3426' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2017' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wow! Come take a look at this remodeled home just like new! Per previous seller, this home has never flooded! Beautiful new counters, sink, all new appliances, brand new 30 yrs roof and AC unit. painted cabinetry with new pulls in kitchen that opens into the living area! Gorgeous tile flooring throughout home with brand new carpet in two of the bedrooms. remodel stand up shower with frame less sliding door in primary bath. Both bathrooms have been completely redone. Updated light fixtures and ceiling fans in home! Huge backyard perfect for the kids! Low tax rate and low HOA! Must see to appreciate! Garage has been converted to one big room. Perfect for family entertainment room (Karaoke room or large family game room) or can even convert to two small extra room for share room rental (perfect for extra income)' ,`Acres` = '0.1653' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 42 BLK 1 PARKRIDGE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'HEFLIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'O\'DONNELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkridge Sec 01' ,`TaxAmount` = '4213' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185673' WHERE `Matrix_Unique_ID` = '211074771' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T20:38:50.330' ,`MLSNumber` = '34980141' ,`ListAgentFullName` = 'Brenda Wagner' ,`ListOfficeName` = 'Virginia Malone & Assoc.,' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.834412' ,`Longitude` = '-94.720981' ,`PhotoCount` = '49' ,`PostalCode` = '77597' ,`RoomCount` = '13' ,`ListPrice` = '595000.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Hollow' ,`StreetNumber` = '310' ,`StreetSuffix` = 'Road' ,`City` = 'Wallisville' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3234' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'REDUCTION!!!! REDUCTION!!!! BARNDOMINIUM - An amazing county setting located 2 miles from I-10. Pine Hollow is a one way in/out street where you will find the home of your dreams. This beautiful Barndominium sits on 2.5 partially wooded acres. The main level shows off very open kitchen, dining and den area. Office, large master bedroom and bath (an amazing shower), mud room complete with shower and toilet. Venturing upstairs entering in the large game room with a landing overlooking the spacious warehouse (exit stairs). Three spacious bedrooms, jack and jill bath for 2 of the bedrooms. Everyone dreams for a place for their toys this home has 3000sq.ft. warehouse (insulated) 2 large doors. The covered back patio is a place to enjoy your morning or afternoons or just sit and enjoy your firepit. This is a must see make your appointment today. This type of property doesn\'t come on the market often don\'t miss out.' ,`Acres` = '2.5' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '171 TR 10-13 N D LABADIE (TR 13 SHERMAN CLARK S/D)' ,`LotDesciption` = 'Wooded' ,`LotSize` = '108917' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '4 - Anahuac' ,`SchoolElementary` = 'ANAHUAC ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANAHUAC HIGH SCHOOL' ,`SchoolMiddle` = 'ANAHUAC MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Barndominium' ,`Subdivision` = 'Sherman Clark Sub' ,`TaxAmount` = '7996' ,`TaxRate` = '2.6602' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185673' WHERE `Matrix_Unique_ID` = '211151611' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T20:01:12.190' ,`MLSNumber` = '66366237' ,`ListAgentFullName` = 'Shirley Kopecky' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.800229' ,`Longitude` = '-95.465053' ,`PhotoCount` = '38' ,`PostalCode` = '77055' ,`RoomCount` = '12' ,`ListPrice` = '639900.00' ,`Status` = 'Active' ,`StreetName` = 'Teluco' ,`StreetNumber` = '6509' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2611' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Floor plans in MLS documents; virtual tour of garage apt/quarters is posted. Great Location near I-10, Loop 610, & Hwy 290 + outside 100 & 500 yr flood plains!! High lot value ($400k-$450k recently); Aug. 2015 (refi) appraisal = $606k when lot value = $200k & before many additional improvements! Home is extensively updated & features real hardwood floors, crown molding + an oversized 2 car garage with an upscale apartment/quarters & more! Main home boasts a 2 story great room & a dramatic ceiling! Main bedroom has a large, real wood custom closet with built-ins & nearly pristine, never lived-on luxe carpet !! Two (of 4) bedrooms & bathrooms are downstairs! The large office/library could double as: wine room, media room, 2nd eating area. Kitchen has gently used Viking gas range + Viking dishwasher. 3 Recent HVAC units with sanitizing UV lights.\r\nGarage & garage apt. were constructed in 1999; home further enlarged in 2003.\r\nNew construction in subdivision = $1Million++\r\nOwner/Agent' ,`Acres` = '0.1865' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 23 WESTVIEW TERRACE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8125' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '10' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HOUSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Westview Terrace Sec 02' ,`TaxAmount` = '8956' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1949' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185674' WHERE `Matrix_Unique_ID` = '211498410' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T20:56:13.397' ,`MLSNumber` = '23140785' ,`ListAgentFullName` = 'Tina Hodde' ,`ListOfficeName` = 'Brenham Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.176564' ,`Longitude` = '-96.445307' ,`PhotoCount` = '26' ,`PostalCode` = '77833' ,`RoomCount` = '3' ,`ListPrice` = '634500.00' ,`Status` = 'Active' ,`StreetName` = 'Rolling Valley LN' ,`StreetNumber` = '3370' ,`StreetSuffix` = 'Lane' ,`City` = 'Brenham' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2836' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Discover upscale living and immaculate interiors as you enter this “Beautiful Executive Style Home”! This one story home offers, “Soaring Ceilings, Lots of Light and Walls of Glass over looking a crystal clear blue swimming pool, 3 bedrooms, 2.5 baths and an office/study or flex room. The gourmet kitchen offers granite countertops, a large island, smooth top electric cooktop that is also plumbed for gas, Built-in Microwave and Wall Oven, stainless steel sink and pantry. The Principle Bdrm is spacious with trayed ceiling, lots of windows, a large walk through closet, Master closet is huge, Principal Bath offers, Double Vanities, jetted Soaking Tub and Walk-in Shower. Two guest bedrooms share a full bath, while the flex room shares a half bath. EXTRAS AND UPGRADES: Built-in Bookshelves in Family Room, Outdoor pool and Gazebo….. Kitchen with Granite Counter Tops, 2 Car Attached Garage, alarm.\r\n Seller Needs 1 Hour Showing Notice!!! Text Tina Hodde Agent listing for showing instructions!' ,`Acres` = '1.057' ,`Area` = '58' ,`BuilderName` = 'Union Hill Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S5032 - ROLLING RIDGE ESTATES, LOT 1, ACRES 1.057' ,`LotDesciption` = 'Corner' ,`LotSize` = '45999' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Enclosed,Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '137 - Brenham' ,`SchoolElementary` = 'BISD DRAW' ,`SchoolHigh` = 'BRENHAM HIGH SCHOOL' ,`SchoolMiddle` = 'BRENHAM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rolling Ridge Estates' ,`TaxAmount` = '7321' ,`TaxRate` = '1.5429' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1664185674' WHERE `Matrix_Unique_ID` = '211704518' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T20:11:26.980' ,`MLSNumber` = '46312529' ,`ListAgentFullName` = 'Lana Keeney' ,`ListOfficeName` = 'Texas Legacy Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.017823' ,`Longitude` = '-95.633124' ,`PhotoCount` = '47' ,`PostalCode` = '77429' ,`RoomCount` = '9' ,`ListPrice` = '599999.00' ,`Status` = 'Active' ,`StreetName` = 'Silver Willow' ,`StreetNumber` = '15007' ,`StreetSuffix` = 'Circle' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3127' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CUSTOM BUILT K Hovnanian Home, nestled in the highly sought after gated community of Enclave at Northpointe. This spacious 2 story home features 4 bedrooms, 4 full bathrooms and sits on a cul-de-sac lot that boasts over a 14,000 square feet. Two bedrooms down-primary & a secondary with private bathroom. Primary bedroom suite includes custom his and her walk-in closets, dual vanity, granite countertops, separate over-sized walk in shower & soaking tub. Open living area has stone wall fireplace w/ floating mantle; crown molding throughout; 5” wood/tile flooring. The huge island kitchen has 42” cabinets, granite counters, double oven, gas stove and upgraded fixtures. Two bedrooms upstairs with private bathrooms plus expansive gameroom. The backyard oasis includes pool, hot tub, extended cedar planked covered patio with stamped concrete, updated lamp fans and gas connection for an outdoor kitchen. Home is equipped with full home security system & cameras surrounding entire exterior.' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 17 Block 3 Enclave at Northpointe Sec 6' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '14151' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1155' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'WILDWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'WILLOW WOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Enclave at Northpointe' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185674' WHERE `Matrix_Unique_ID` = '211728699' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T21:36:16.080' ,`MLSNumber` = '85773955' ,`ListAgentFullName` = 'Rocio Rosales' ,`ListOfficeName` = 'Texas Ally Real Estate Group,' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.032174' ,`Longitude` = '-95.622786' ,`PhotoCount` = '39' ,`PostalCode` = '77377' ,`RoomCount` = '11' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Manleigh' ,`StreetNumber` = '18814' ,`StreetSuffix` = 'Court' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4313' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 11814 Manleigh located in the subdivision of North Pointe Cove in Tomball, TX. You will be welcomed by a Grand entry, Formal Dining and Office. The Foyer leads you to an oversized living room complimented by High Ceilings and plenty of Natual light. The Primary Bedroom is located on the First floor, with additional 4 bedrooms located on the Second floor. You can enjoy a nice Media Room and Office Desk. Large garage with Tandem and spacious back yard perfect for entertainment, located in a cul-de-sac and Zone to Tomball ISD. Easy access to TX-249, 99 and Beltway 8. Schedule your showing today.' ,`Acres` = '0.2493' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 39 BLK 2 VILLAGES OF NORTHPOINTE SEC 3' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10860' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'CANYON POINTE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Villages Northpointe Sec 03' ,`TaxAmount` = '11046' ,`TaxRate` = '2.7964' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185674' WHERE `Matrix_Unique_ID` = '211731685' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T21:08:11.423' ,`MLSNumber` = '84643538' ,`ListAgentFullName` = 'Banessa Tafolla' ,`ListOfficeName` = 'Ambrosi Realty INC.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.932460' ,`Longitude` = '-95.360962' ,`PhotoCount` = '24' ,`PostalCode` = '75862' ,`RoomCount` = '5' ,`ListPrice` = '299999.00' ,`Status` = 'Active' ,`StreetName` = 'Twin Oaks' ,`StreetNumber` = '1045' ,`StreetSuffix` = '' ,`City` = 'Trinity' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3298' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This lovely property is nestled on 1.14 acreage close to downtown Trinity. You will find this haven a great opportunity. Spacious home offers 4 bedrooms, 3 full baths with a homey kitchen & dinning room. It has plenty of space for horses & other farming animals. It has scattered mature trees. This property is close to town nearby in Trinity ISD. It is surrounded by nature and it is a true oasis. The home itself is a must see!!' ,`Acres` = '' ,`Area` = '42' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Trinity Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TWIN OAKS, LOT 08 IMP ONLY ON PID 41393' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Twin Oaks' ,`TaxAmount` = '2940' ,`TaxRate` = '1.8863' ,`WaterSewer` = 'Other Water/Sewer,Public Sewer,Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1664185674' WHERE `Matrix_Unique_ID` = '211796590' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T21:57:16.470' ,`MLSNumber` = '33987617' ,`ListAgentFullName` = 'Alison Durkee' ,`ListOfficeName` = 'USA I Asset Group Corp' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.774269' ,`Longitude` = '-95.642242' ,`PhotoCount` = '50' ,`PostalCode` = '77079' ,`RoomCount` = '11' ,`ListPrice` = '925000.00' ,`Status` = 'Active' ,`StreetName` = 'Redwood Place' ,`StreetNumber` = '15914' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '4110' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'IMMACULATE RENOVATION. The first floor was almost completely redesigned in 2018 including a primary bedroom custom closet addition. The first floor is open concept with connecting living, dining, breakfast and kitchen. The custom kitchen has HIGH END appliances including WOLF oven/range/warming drawer/drawer microwave, ASKO dishwasher, built in Sub Zero refrigerator, Vinotemp 125 bottle wine fridge and nugget ice maker. The kitchen has an oversized peninsula that seats 9 comfortably. There is a custom office with 3 built in desks and lots of cabinets and drawers for storage. The primary bedroom overlooks the picturesque pool and waterfall. The primary bathroom has a standalone Bain Ultra aromatherapy air jet tub as well as a 2 person shower with rain heads and hand held sprayer. The primary closet features a built in dresser and plenty of shelves. There is a separate irrigation water meter, full house water softener/filtration system, outdoor kitchen, and pool bathroom.' ,`Acres` = '0.3834' ,`Area` = '23' ,`BuilderName` = 'Kickerillo' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 1 FLEETWOOD SEC 7 R/P' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '16700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WOLFE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MEMORIAL PARKWAY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fleetwood 7 & Rp' ,`TaxAmount` = '11630' ,`TaxRate` = '2.4889' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185674' WHERE `Matrix_Unique_ID` = '211874680' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T20:33:59.517' ,`MLSNumber` = '18822249' ,`ListAgentFullName` = 'Olga Kostenko' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.790477' ,`Longitude` = '-95.376865' ,`PhotoCount` = '32' ,`PostalCode` = '77009' ,`RoomCount` = '16' ,`ListPrice` = '1149000.00' ,`Status` = 'Active' ,`StreetName` = 'Pecore' ,`StreetNumber` = '512' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3221' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Absolutely stunning and charming Craftsman/Victorian style home in Woodland Heights. From floor to ceiling, this newly renovated home boasts 5” red oak hardwood floors and 7” classic crown molding. Your chef will feel right at home in this spacious custom-designed kitchen, featuring a commercial-grade Italian gas stove & Viking refrigerator. The incredible master suite on the first floor has a vaulted ceiling and private doorway open to the beautifully landscaped butterfly garden. A hand-made custom octagonal stained-glass window brings beautiful light into the staircase leading to the second floor. 2/3 bedrooms upstairs share a Hollywood bath with three separate marble vanities, and a work/play space with custom built-ins could be used as a third bed for weekend sleepovers. Not to be missed features include commercial-grade automated entry gate, whole house generator, security cameras, alarm system, custom built-ins and so much more.' ,`Acres` = '0.1435' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 1 BURRELL' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Leave Business Card,No Photos/No Videos,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Craftsman,Traditional' ,`Subdivision` = 'Woodland Heights' ,`TaxAmount` = '21731' ,`TaxRate` = '2.5304' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185675' WHERE `Matrix_Unique_ID` = '211893098' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T21:15:18.440' ,`MLSNumber` = '55312444' ,`ListAgentFullName` = 'Vu Le' ,`ListOfficeName` = 'Intercontinental Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.492980' ,`Longitude` = '-94.921691' ,`PhotoCount` = '50' ,`PostalCode` = '77539' ,`RoomCount` = '6' ,`ListPrice` = '339000.00' ,`Status` = 'Active' ,`StreetName` = '11th' ,`StreetNumber` = '321' ,`StreetSuffix` = 'Street' ,`City` = 'San Leon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1932' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'spectacular 3 bedroom 2 full bath. Few block walking distance from Galveston Bay. The kitchen has all brand new stainless steel appliances. Gloss cabinets and outstanding granite. Brand new laminate wood floor in master, Dining and family rooms. Great closet space. Home lot-side is on 1/2 Acre with oversite workshop and plenty of parking for cars, boats or Rv\'s space. (NO HOA or any restriction) You can park you boat and RV\'s on this property. Walking distance to the famous oyster bar Gilhooley\'s, a short golf cart ride to Topwater Grill. Few blocks from boat launch for your boat fishing trip. Mins drive to Kemah boardwalk and restaurants. and park. This home is set up as the perfect vacation, Airbnb or full time residence! ' ,`Acres` = '0.3673' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 10 PAGE 9 LOTS 7 THRU 11 BLK 54 SAN LEON' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '16000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SAN LEON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'San Leon' ,`TaxAmount` = '8146' ,`TaxRate` = '2.521' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185675' WHERE `Matrix_Unique_ID` = '211926884' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T21:08:11.533' ,`MLSNumber` = '64724842' ,`ListAgentFullName` = 'Banessa Tafolla' ,`ListOfficeName` = 'Ambrosi Realty INC.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.857693' ,`Longitude` = '-95.613099' ,`PhotoCount` = '20' ,`PostalCode` = '77041' ,`RoomCount` = '5' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Bridgewalk' ,`StreetNumber` = '13442' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1703' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Living area & Primary bedroom have tile floors. Spacious backyard great for entertainment. Definitely a must see!' ,`Acres` = '0.3172' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 108 BLK 2 CONCORD BRIDGE SEC 3' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '13819' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'LEE ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Concord Bridge Sec 03' ,`TaxAmount` = '4318' ,`TaxRate` = '2.471' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185675' WHERE `Matrix_Unique_ID` = '211949903' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T20:50:39.077' ,`MLSNumber` = '51388208' ,`ListAgentFullName` = 'Honey Tucker' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.173279' ,`Longitude` = '-95.414647' ,`PhotoCount` = '43' ,`PostalCode` = '77385' ,`RoomCount` = '10' ,`ListPrice` = '669000.00' ,`Status` = 'Active' ,`StreetName` = 'Sleepy Hollow' ,`StreetNumber` = '11062' ,`StreetSuffix` = 'Road' ,`City` = 'Conroe' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3497' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your estate awaits you in this custom 2 story home situated on over 1 acre lot in White Oak Estates, minutes from The Woodlands. Home features 2 bedrooms down with a primary bedroom, walk in closet and spacious bath and an additional bedroom with full bath. Formal entry and family room offer soaring ceilings. Large home office conveniently located by front door. Two bedrooms await guests upstairs with a full bath and spacious bonus room/bedroom. Entertain guests in the large game room upstairs. Don\'t miss the workout/flex space with half bath accessible from back porch to right. Property is fenced with a side pasture and an apartment above garage with bedroom, sitting area, kitchen and bath. Property showcases an outdoor fire pit area for Winter evenings and an above ground pool perfect for Summer afternoons along with an expansive covered back porch. With a 4 car garage, there is plenty of room for toys only 10 min from The Woodlands. Property generated $5400/mo when leased.' ,`Acres` = '1.005' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WHITE OAK ESTATES 04, BLOCK 1, LOT 25' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '43778' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '625' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'HOUSER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'White Oak Ests Sec 4' ,`TaxAmount` = '9515' ,`TaxRate` = '2.1802' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185675' WHERE `Matrix_Unique_ID` = '211977932' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T21:04:12.793' ,`MLSNumber` = '1068901' ,`ListAgentFullName` = 'Zaran Engineer' ,`ListOfficeName` = 'Cornerstone Prop Mngt, Inc,' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.703398' ,`Longitude` = '-95.367745' ,`PhotoCount` = '8' ,`PostalCode` = '77021' ,`RoomCount` = '7' ,`ListPrice` = '409000.00' ,`Status` = 'Active' ,`StreetName` = 'Illinois' ,`StreetNumber` = '6311' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1967' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS BRAND NEW CONTEMPORARY 2 STORY HOME CONTAINING 3 BEDROOMS, 2 1/2 BATHROOMS, A STUDY/HOME OFFICE ON THE FIRST FLOOR, AND A 2 CAR ATTACHED GARAGE. IT HAS A GREAT LOCATION RIGHT BY THE MEDICAL CENTER, UNIV OF HOUSTON, TSU, RICE UNIV., HERMAN PARK & MUSEUM DISTRICT! Unlike other such new developments, this one is located very close to shopping centers, multiple grocery stores, pharmacies, restaurants etc. Just minutes for highway 288, this newly constructed home offers an open living area with wood flooring, a living area with double doors leading to backyard. Modern kitchen featuring European cabinets , quartz countertops , stainless steel appliances, large kitchen island, porcelain tiles, seamless shower stall, Free standing tub in primary bathroom, etc. etc. No restrictions and no HOA. A MUST SEE! Home will be completed by 9/15/22, will not last long on the market.' ,`Acres` = '' ,`Area` = '4' ,`BuilderName` = 'BG Building Group' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Riverside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 1 PARK AT ILLINOIS STREET' ,`LotDesciption` = 'Other' ,`LotSize` = '2442' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'THOMPSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'SOUTHLAND PLACE 2ND PAR R/P & OTHERS' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664185675' WHERE `Matrix_Unique_ID` = '212011890' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T20:38:10.907' ,`MLSNumber` = '53028660' ,`ListAgentFullName` = 'Shane Terry' ,`ListOfficeName` = 'RE/MAX Northwest, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.040166' ,`Longitude` = '-95.585137' ,`PhotoCount` = '27' ,`PostalCode` = '77375' ,`RoomCount` = '9' ,`ListPrice` = '314990.00' ,`Status` = 'Active' ,`StreetName` = 'Harston' ,`StreetNumber` = '10914' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2513' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to this Beautiful 2 Story, 4 Bedroom, 2 1/2 Bath, home with Soaring Ceilings, and Spacious Open Concept Living. Featuring a Private First Floor Primary Suite with a Huge Walk-In Closet! Working from Home can also be a Breeze in the Private Office/Flex Space located in the Front of the Home. Stunning Natural Light from the Plentiful Windows Surrounding the Home. Sizeable Bedrooms and a Game Room is located Upstairs! The Backyard features a Covered Patio that\'s Perfect For Entertaining Family and Friends. Within close proximity to Great shopping and dining destinations. The Grand Parkway and Hwy 249. Designated Great Klein ISD Schools! This home has so much to offer! Schedule Your Tour Today!!!!' ,`Acres` = '0.1289' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 5 ASHFORD PLACE SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5616' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (KLEIN)' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'ULRICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ashford Place Sec 04' ,`TaxAmount` = '6948' ,`TaxRate` = '2.7066' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185676' WHERE `Matrix_Unique_ID` = '212021964' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T20:31:06.607' ,`MLSNumber` = '52875658' ,`ListAgentFullName` = 'Ryan St George' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.825112' ,`Longitude` = '-95.802240' ,`PhotoCount` = '37' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Scarlatti Cantata' ,`StreetNumber` = '24718' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2503' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Two Story plan with 4 Bedrooms, 2.5 Baths, Master Bedroom is down, Gameroom up overlooks Entry, Kitchen and Dining area open to Family Room, All Bedrooms upstairs have walk-in closets and High Ceilings, Covered Back Patio, Front and Back Yards has Sod and Sprinkler Systems. The back of home has a lake view. Interior repainted 2022. Elevation stone and brick. All smoke alarms replaced 2022.\r\nYour family will flourish in a new home in the Katy community of Camillo Lakes. Amenity-rich, the community will soon boast an amenity center with a resort-style pool as well as two sparkling lakes open for water sports. Camillo Lakes’ excellent location off the Grand Parkway and Interstate 10 puts you near favored Katy attractions such as Typhoon Lagoon as well as shopping and dining at Katy Mills Mall. Young residents attend highly regarded Katy ISD schools, including Leonard Elementary, Haskett Junior High and Paetow High School.' ,`Acres` = '0.1136' ,`Area` = '25' ,`BuilderName` = 'Legend Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 27 BLK 4 CAMILLO LAKES SEC 1' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '4950' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'LEONARD ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,No Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Camillo Lakes Sec 1' ,`TaxAmount` = '8649' ,`TaxRate` = '3.5333' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664185676' WHERE `Matrix_Unique_ID` = '212082847' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T21:06:38.077' ,`MLSNumber` = '58671152' ,`ListAgentFullName` = 'Colby Hearn' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = 'Dona Angell' ,`SellingOfficeName` = 'Keller Williams Woodlands' ,`Latitude` = '30.174715' ,`Longitude` = '-95.611561' ,`PhotoCount` = '45' ,`PostalCode` = '77354' ,`RoomCount` = '12' ,`ListPrice` = '1050000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Champions Ridge' ,`StreetNumber` = '28515' ,`StreetSuffix` = 'Road' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4525' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Private, country living, yet close to The Woodlands! Spacious, updated home on 5-acre lot. LIGHTLY RESTRICTED/NO HOA, LOW TAX RATE! NOT IN FLOOD ZONE/NEVER FLOODED! POOL/SPA. Open floor plan, great for entertaining, updated kitchen with built-in, extra-large subzero refrigerator, separate built-in ice maker, and brand new energy star appliances. Step into luxury in a completely remodeled primary bathroom with walk-in granite shower, complete with LED Mirror and chandelier! Primary bedroom downstairs. Large, covered patio that wraps around the multi-room, air-conditioned shop/private workspace. Fully fenced-in property and automatic privacy gate. Gorgeous, picture windows give way to backyard view of pool/spa and large open green space. New double paned, energy efficient windows (exception-picture windows). Main house AC units replaced within last 5 years. Brand new 2022 carpet, never lived in, throughout most of home.' ,`Acres` = '5' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'ASCOT FARMS 03, BLOCK 3, LOT 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '217800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ascot Farms 03' ,`TaxAmount` = '11375' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185676' WHERE `Matrix_Unique_ID` = '212093950' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T20:26:29.697' ,`MLSNumber` = '40204274' ,`ListAgentFullName` = 'Amy Greene' ,`ListOfficeName` = 'New Leaf Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.503177' ,`Longitude` = '-95.399048' ,`PhotoCount` = '34' ,`PostalCode` = '77578' ,`RoomCount` = '10' ,`ListPrice` = '349000.00' ,`Status` = 'Active' ,`StreetName` = 'Palomar' ,`StreetNumber` = '4' ,`StreetSuffix` = '' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3174' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Unique opportunity in the fabulous Rodeo Palms subdivision on a great block. 5 bedrooms, 3 and one half bath with a Primary suite down, large game room up and open concept island kitchen and Den/Family room. All four secondary bedrooms are located upstairs. Large, green fenced backyard with covered patio. Minutes to Med Center and Downtown Houston! Seller has never occupied property. Sellers Disclosure to come.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PALM COURT SEC1 A0459&A0299 MANVEL)BLK 4 LOT 40 Rodeo Palms' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6399' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'DON JETER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Rodeo Palms' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185676' WHERE `Matrix_Unique_ID` = '212120071' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T20:14:49.857' ,`MLSNumber` = '62661690' ,`ListAgentFullName` = 'Rebecca Mould' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.378436' ,`Longitude` = '-95.026904' ,`PhotoCount` = '24' ,`PostalCode` = '77568' ,`RoomCount` = '11' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Hazy Shores' ,`StreetNumber` = '713' ,`StreetSuffix` = 'Lane' ,`City` = 'La Marque' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2081' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One year old Clifton Plan, ready to become your new home! Don\'t let this 1 story 4 bedroom, 2 baths, tankless hot water heater, granite countertops, black stainless steel appliances get away. Open concept kitchen, breakfast nook to family room. Great for entertaining. Fantastic neighborhood to raise your family. Nice fully fenced backyard. Don\'t hesitate you might be too late!!! Schedule your appointment today. Home Warranty included!' ,`Acres` = '0.1556' ,`Area` = '33' ,`BuilderName` = 'Greeneco Builders Ll' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Marque' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 14 BLK 1 LANDING AT DELANY COVE SEC 8 (2019) ABST 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6776' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '26 - Hitchcock' ,`SchoolElementary` = 'HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HITCHCOCK HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (HITCHCOCK)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Herons Lndg Sec 2' ,`TaxAmount` = '3281' ,`TaxRate` = '3.1135' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185676' WHERE `Matrix_Unique_ID` = '212149022' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T20:50:57.437' ,`MLSNumber` = '24181528' ,`ListAgentFullName` = 'Ivis Courtney' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.027304' ,`Longitude` = '-95.412680' ,`PhotoCount` = '42' ,`PostalCode` = '77073' ,`RoomCount` = '8' ,`ListPrice` = '385000.00' ,`Status` = 'Active' ,`StreetName` = 'Doral' ,`StreetNumber` = '1111' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3580' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS BEAUTIFUL TOW STORES HOME HAVE SO MANY UPGRADES. NEW PAINT THROUGH THE HOUSE, NEW WINDOWS, NEW ROOF WAS CHENGE IN 2021. THE GUTTERS ARE NEW ALSO. THE DRIVEWAY, THE AC UNIT HAS BEING UPDATED IN AND OUT 2017. THE WATER HEATER WAS CHENGED 2017 AND IS A TANGLASS SYSTEM. IN THE 2ND FLOOR HAVE CARPET AND LAMINATE. CEILING FANS AND ALL THE BEDROOMS. THE REFRIGERATORS STAYING IN THE HOUSE. IT HAVE 2 LAUNDRY ROOMS ONE UPSTAIR AND DOWNSTAIR.\r\nIN THE BACK OF THE HOUSE BY THE LAUNDRY IS A BUILD-UP APARTMENT, IT HAVE LIVING ROOM AREA, KITCHEN WITH STOVE REFRIGERATOR AND MORE BEDROOM, FULL BATH AND AC UNIT NEW ALSO 2018. AND MUCH,MUCH, MORE CALL FOR A SHOWING.' ,`Acres` = '0.2645' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 2 INVERNESS FOREST SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11520' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'DUNN ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'LEWIS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Inverness Forest Sec 01' ,`TaxAmount` = '5727' ,`TaxRate` = '2.5234' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1967' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185676' WHERE `Matrix_Unique_ID` = '212183041' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T20:02:06.540' ,`MLSNumber` = '54116303' ,`ListAgentFullName` = 'Laurie Brown' ,`ListOfficeName` = 'Keller Williams Advtge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.281191' ,`Longitude` = '-95.562768' ,`PhotoCount` = '46' ,`PostalCode` = '77316' ,`RoomCount` = '4' ,`ListPrice` = '385000.00' ,`Status` = 'Active' ,`StreetName` = 'Clearmont' ,`StreetNumber` = '155' ,`StreetSuffix` = 'Place' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2433' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this beautiful and inviting home within the master planned golf course community of Woodforest! Within walking distance to all the shopping and restaurants at the front of the subdivision, this home features an open concept floorpan with a dream custom ensuite off the primary 1st floor bedroom, loft gameroom, hot tub, large covered back patio and landscaped yard with sprinkler system. The entire fourth bedroom was used for the expanded primary bath/closet but could easily be turned back into a bedroom or study if so desired. ** OWNED solar panel system** Hot tub maintained weekly by pool company. Wonderful neighborhood and community!' ,`Acres` = '0.169' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S965200 - WOODFOREST 01, BLOCK 1, LOT 41' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '7363' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas 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` = 'Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest' ,`TaxAmount` = '7108' ,`TaxRate` = '2.6888' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185677' WHERE `Matrix_Unique_ID` = '212191982' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T21:27:42.783' ,`MLSNumber` = '93460252' ,`ListAgentFullName` = 'Donna Rooney' ,`ListOfficeName` = 'CB&A, Realtors-Katy' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.740753' ,`Longitude` = '-95.363584' ,`PhotoCount` = '50' ,`PostalCode` = '77004' ,`RoomCount` = '11' ,`ListPrice` = '500000.00' ,`Status` = 'Active' ,`StreetName` = 'Saint Emanuel' ,`StreetNumber` = '2325' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 4 story free standing \"InTownHomes\" property. The home has been freshly painted with new carpet installed in the upstairs bedrooms. Upon entering, you\'ll instantly be drawn to the livability of this home - suited for entertaining and enjoying the downtown living experience. There are 4 bedrooms, 4.5 baths, home office/study, 4th floor gameroom opening up to a large roof top terrace with an amazing view of the Houston skyline! The 2nd floor features a home office/study, spacious kitchen, dining/living area with a balcony. All 4 bedrooms have en suite bathrooms. This townhome has it all with open living areas, hardwood floors, and upgraded carpet in bedrooms. The primary suite and utility area are located on the 3rd floor. The 4th floor has a spacious gameroom, secondary bedroom plus a full bath along with the walkout roof top terrace. Easy access to Downtown, Medical Center, EaDo District, Midtown, Universities and Montrose. Come check it out!' ,`Acres` = '0.0323' ,`Area` = '4' ,`BuilderName` = 'InTownHomes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Reports Available,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 1 SAINT EMANUEL STREET ENCLAVE' ,`LotDesciption` = 'Cleared' ,`LotSize` = '1409' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2590' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Temporarily No Showings,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '4' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Saint Emanuel Street Enclave' ,`TaxAmount` = '9851' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185677' WHERE `Matrix_Unique_ID` = '212196995' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T21:49:51.283' ,`MLSNumber` = '94940364' ,`ListAgentFullName` = 'Yanling Teng' ,`ListOfficeName` = 'Great Wall Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.575701' ,`Longitude` = '-95.596531' ,`PhotoCount` = '21' ,`PostalCode` = '77479' ,`RoomCount` = '3' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Battle Ridge' ,`StreetNumber` = '3110' ,`StreetSuffix` = 'Lane' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2260' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HIGHLY DEMANDED AND DESIRABLE LOCATION! QUIET NICE NEIGHBORHOOD! POOL! GREAT SCHOOLS! CONVENIENT! Easy to Fwy59 and Hwy6. Fantastic education system, Clement High School! \r\nLOW TAX RATE 2.16! NEVER FLOODED! \r\nThe house has been very TASTEFULLY DESIGNED AND REMODELED with high quality material multiple times. August 2022. NEW laminated floors. With tiles for kitchen and bathrooms, NO carpet. NEW swimming pool filter; NEW lighting fixtures and sink faucet in kitchen; NEW bedroom door and closet door. NEW paint for the walls, ceilings, cabinets, doors, windows trims, baseboard and crown mouldings. AC May 2021; gas stove July 2021; The extra storage cabinet and epoxy surfaced floor 2019 added value to the garage. \r\nLike a pool table in the the game room or watching a movie in the home theater? The home office with built- in shelves and cabinets for you to handle important documents. \r\n\r\nA cozy, nice, sweet home to build up good lives and memories.' ,`Acres` = '0.1647' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SETTLERS GROVE SEC 1, BLOCK 1, LOT 7' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7174' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SETTLERS WAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Settlers Grove' ,`TaxAmount` = '5737' ,`TaxRate` = '2.1584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185677' WHERE `Matrix_Unique_ID` = '212206347' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T20:35:42.193' ,`MLSNumber` = '73631213' ,`ListAgentFullName` = 'Kathleen Montes' ,`ListOfficeName` = 'Target Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.161854' ,`Longitude` = '-95.443427' ,`PhotoCount` = '41' ,`PostalCode` = '77385' ,`RoomCount` = '9' ,`ListPrice` = '429900.00' ,`Status` = 'Active' ,`StreetName` = 'Paula' ,`StreetNumber` = '27254' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2875' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This meticulously maintained home in highly sought-after Oak Ridge North won\'t disappoint. The home features an open floor plan with a formal dining room & wood floors. Enjoy cooking in the updated spacious gourmet kitchen with granite counters, SS appliances, gas cooktop and beautiful 42\" cabinets. Relax in the primary suite, large enough to have sitting area. Primary bath boasts a tile shower, double sinks, and spacious closets. You will find three large bedrooms and the perfect game room for game night upstairs. Entertain on the lovely custom patio with wood pergola in the huge, beautifully landscaped private backyard. Corner lot, Low E windows, sprinkler system & 3 car garage are just a few of the amenities of this home! Roof 2019, A/C/Heating 2020. Schedule your showing today!' ,`Acres` = '0.2697' ,`Area` = '15' ,`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` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'OAK RIDGE NORTH 07, BLOCK 13, LOT 15' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '11748' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'OAK RIDGE ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Ridge North 07' ,`TaxAmount` = '5291' ,`TaxRate` = '2.321' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1967' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185677' WHERE `Matrix_Unique_ID` = '212320882' --> 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','212331041','1664185677','212331041','2022-09-25T21:16:36.530','19000667','Irene Rangel','Fathom Realty','','','29.828960','-95.708654','22','77449','4','325000.00','Active','Meadow Lilly Ln','3926','','Katy','2','0','3','2189','Single-Family','The property is occupied, and the Tenant is on a month-to-month basis. This is a beautiful home in Westfield, it has an open Kitchen, spacious bedrooms, nice backyard and covered patio. Make it your home or your next investment property. Showings will start on October 1st, Please call for details and/or for an appointment. Irene Rangel, Realtor','0.196','25','','','','','Sellers Disclosure,Tenant Occupied','','','','Katy - North','Central Gas','1','LT 21 BLK 2 WESTFIELD SEC 14','Subdivision Lot','8557','Appraisal District','','437','0','','2','','0','','','','','Composition','30 - Katy','RHOADS ELEMENTARY SCHOOL','MAYDE CREEK HIGH SCHOOL','CARDIFF JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Leave Business Card,Supra Keybox,Temporarily No Showings','Appraisal District','1','Traditional','Westfield','','','Public Sewer,Public Water','2003','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T20:47:26.667' ,`MLSNumber` = '59069567' ,`ListAgentFullName` = 'Suzanne Heber' ,`ListOfficeName` = 'Kingdom First Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.012453' ,`Longitude` = '-95.562270' ,`PhotoCount` = '38' ,`PostalCode` = '77379' ,`RoomCount` = '8' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Galston' ,`StreetNumber` = '9703' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '2864' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Incredible 6 bedroom, 3 bath home ready for occupancy. Many recent updates include kitchen cabinets, granite countertops, appliances, and a complete interior paint job. A brand new fence encloses the backyard and give you plenty of privacy. The kids will enjoy the spacious game room upstairs. You don\'t want to miss this opportunity priced to sell. Property owner is related to listing broker.' ,`Acres` = '0.1591' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 22 017*G4555400-002-022-006 GLENLOCH SEC 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6930' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '340' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KRAHN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Glenloch Memorial Chase' ,`TaxAmount` = '6165' ,`TaxRate` = '2.4965' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185677' WHERE `Matrix_Unique_ID` = '212386460' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T20:09:51.133' ,`MLSNumber` = '67815874' ,`ListAgentFullName` = 'John Sanchez' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.821099' ,`Longitude` = '-95.680032' ,`PhotoCount` = '15' ,`PostalCode` = '77084' ,`RoomCount` = '10' ,`ListPrice` = '329999.00' ,`Status` = 'Active' ,`StreetName` = 'Barkers Crossing' ,`StreetNumber` = '3614' ,`StreetSuffix` = 'Avenue' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2574' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 4-bedroom, 2.5-bath house in the coveted Barkers Crossing neighborhood features brick elevation with spacious layout and tile throughout the first floor, luxury laminate upstairs, updated appliances and fixtures throughout. Bonus area upstairs that can be used as a loft or game room, cathedral ceilings in the primary make it the perfect retreat for anyone. Come check out this beautiful home!' ,`Acres` = '0.1085' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 37 BLK 1 BARKERS CROSSING SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4725' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '385' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'SCHMALZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MAYDE CREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Barkers Xing Sec 3' ,`TaxAmount` = '5265' ,`TaxRate` = '2.487' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185677' WHERE `Matrix_Unique_ID` = '212414471' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T21:09:44.570' ,`MLSNumber` = '20054464' ,`ListAgentFullName` = 'Tatiana Micolta' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.676362' ,`Longitude` = '-95.740617' ,`PhotoCount` = '34' ,`PostalCode` = '77407' ,`RoomCount` = '7' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Soledad Pine' ,`StreetNumber` = '6010' ,`StreetSuffix` = 'Circle' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3419' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Do not miss out on this immaculate Ashton Woods home perfectly situated in a Cul-De-Sac with so many custom upgrades! This home features 4 bedrooms, 3.5 bathrooms, 2.5 car garage, in ground heated pool & hot tub, office, game room and a fully installed media room that includes a projector, projector screen, and surround sound throughout the home. Open kitchen concept perfect for entertainment. The living area consists of 26 ft ceilings, 8 foot doors throughout entire home. Conveniently located near Grand Parkway, Westpark Tollway, & 59. DON\'T MISS OUT ON THE CHANCE TO CALL THIS YOUR NEXT HOME! CALL US TODAY TO SCHEDULE YOUR SHOWING!' ,`Acres` = '0.2558' ,`Area` = '37' ,`BuilderName` = 'Ashton woods' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'FIELDSTONE SEC 11, BLOCK 1, LOT 20' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '11144' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'OAKLAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'BOWIE MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Fieldstone Sec 11' ,`TaxAmount` = '10068' ,`TaxRate` = '2.8429' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185678' WHERE `Matrix_Unique_ID` = '212430303' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T20:30:46.297' ,`MLSNumber` = '91843187' ,`ListAgentFullName` = 'Mariana Saldana' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = 'Kelly Rickard' ,`SellingOfficeName` = 'Walzel Properties' ,`Latitude` = '29.723429' ,`Longitude` = '-95.575054' ,`PhotoCount` = '25' ,`PostalCode` = '77082' ,`RoomCount` = '11' ,`ListPrice` = '1250000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Bridgeberry' ,`StreetNumber` = '3234' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4689' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful golf course home, neutral colors, Floor plan-2 bedrooms down including Master, massive kitchen with granite countertops and granite backsplash, stainless appliances and computer alcove, custom window treatments thru out, plantation shutters, etc., tile floors, neutral colors, surround sound thru out, beautiful pool w/beach entry, great views of hole #5, cart path on the opposite side, small yard w/grass, oversized garage-room for golf cart. Ready for move-in' ,`Acres` = '0.2166' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Westchase Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 2 2ND AMEND ROYAL OAKS COUNTRY CLUB 5' ,`LotDesciption` = 'On Golf Course' ,`LotSize` = '9434' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3130' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'OUTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'O\'DONNELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Royal Oaks Country Club' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185678' WHERE `Matrix_Unique_ID` = '212430968' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T21:33:41.207' ,`MLSNumber` = '85452407' ,`ListAgentFullName` = 'Kristi Halphen' ,`ListOfficeName` = 'RE/MAX Cinco Ranch' ,`SellingAgentFullName` = 'Philip Paguio' ,`SellingOfficeName` = 'Mission Real Estate Group' ,`Latitude` = '29.776567' ,`Longitude` = '-95.554290' ,`PhotoCount` = '19' ,`PostalCode` = '77024' ,`RoomCount` = '10' ,`ListPrice` = '725000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Vindon' ,`StreetNumber` = '12610' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2204' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 story with great potential, huge oak trees! Seller has lived in the property for 45+ years. Roof 2020, home has been maintained but not updated. Selling \"AS-IS; WHERE-IS\". Open concept; Family Room was added on. Formal dining/living can be utilized as a flex space/study. Nice size secondary bedrooms and closet space. Conveniently located to I-10, Sam Houston Tollway, CityCentre, schools, shopping, entertainment, restaurants and medical facilities. Easy walk to park/tennis/pool/schools.' ,`Acres` = '0.195' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 9 FONN VILLAS SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8496' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '628' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'BUNKER HILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fonn Villas' ,`TaxAmount` = '14097' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1967' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185678' WHERE `Matrix_Unique_ID` = '212464592' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T20:13:29.780' ,`MLSNumber` = '83589809' ,`ListAgentFullName` = 'Catie Fuller' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.273472' ,`Longitude` = '-95.476187' ,`PhotoCount` = '28' ,`PostalCode` = '77304' ,`RoomCount` = '6' ,`ListPrice` = '479900.00' ,`Status` = 'Active' ,`StreetName` = 'Devlin Shores' ,`StreetNumber` = '441' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2257' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Incredible one-story Perry home in Grand Central Park. The inviting extended entry welcomes you into the open floorplan with 12-foot ceilings! The kitchen boasts a large island with plenty of seating room, a walk-in pantry, an abundant amount of cabinets & engineered stone counters. The primary suite features a double-door entry to the primary bath, a separate shower, dual vanities, a soaking tub, and two walk-in closets. The oversized covered patio extends the length of the house ready with a gas connection for your outdoor kitchen. Come and enjoy all the amenities Grand Central Park has to offer including pool, lakes & fishing, firepit, hiking & biking trails & The Lake House with a gym, covered pavilion, patio with stunning lake views, and event lawn.' ,`Acres` = '0.1514' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S537517 - GRAND CENTRAL PARK 17, BLOCK 2, LOT 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6597' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1072' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Central Park 17' ,`TaxAmount` = '10849' ,`TaxRate` = '3.0863' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185678' WHERE `Matrix_Unique_ID` = '212536262' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T21:05:58.670' ,`MLSNumber` = '81215309' ,`ListAgentFullName` = 'Jamie McMartin' ,`ListOfficeName` = 'Compass RE Texas, LLCKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.996639' ,`Longitude` = '-95.543672' ,`PhotoCount` = '35' ,`PostalCode` = '77379' ,`RoomCount` = '13' ,`ListPrice` = '799990.00' ,`Status` = 'Active' ,`StreetName` = 'Tranquil Park' ,`StreetNumber` = '15915' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5088' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CHECK OUT THE VIRTUAL WALK-THROUGH~ Welcome to 15915 Tranquil Park Court. This beautiful home sits on a quiet cul de sac lot. The timeless floor plan includes a large formal dining room with engineered hardwood floors. The living area features an amazing wood paneled two-story living area w/a breathtaking one of a kind carved floor to ceiling fireplace mantle. The updated kitchen features solid Wood J&K Cabinetry, soft closing hinges on doors & drawers, oversized corner carousel cabinets w/a total of 30 drawers in the kitchen-many deep for pot & pan storage. Quartz countertops, custom made vent hood over Forno 8 burner commercial gas range, double oven, Kitchenaid 3 rack freeflex dishwasher, & built in convection microwave. The primary suite offers 3 closets, an executive bathroom & a wall of windows w/a French door that leads to the garden area & backyard pool.' ,`Acres` = '0.3154' ,`Area` = '13' ,`BuilderName` = 'Don Hand' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 46 & TR 47 BLK 24 017*C2915074-006-024-046 CHAMPION FORES' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '13738' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Freestanding Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BRILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Champion Forest' ,`TaxAmount` = '11157' ,`TaxRate` = '2.3465' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185678' WHERE `Matrix_Unique_ID` = '212538425' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T20:59:36.117' ,`MLSNumber` = '22269773' ,`ListAgentFullName` = 'Carolyn Kelly' ,`ListOfficeName` = 'RE/MAX Northwest, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.699373' ,`Longitude` = '-94.837179' ,`PhotoCount` = '31' ,`PostalCode` = '77351' ,`RoomCount` = '3' ,`ListPrice` = '175000.00' ,`Status` = 'Active' ,`StreetName` = 'Amber Lane' ,`StreetNumber` = '170' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1508' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Pure country living with the tin roof to boot! Come feel the cabin charm with cedar island and cabinets, free standing wood burning fireplace, real wood floors and a tin roof. Property surrounded by bamboo tress. House sits on .5627 acres and there is an additional .561 acres for a garden or chickens or whatever your heart desires. There are 2 additional building on this property could be used for storage, guest room, she shed or man cave. New AC unit installed 8-22.\r\n\r\nMeasurements and information are approximate and should be verified.' ,`Acres` = '1.1' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Menard Creek Estates Lot 17 & 18' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Menard Creek Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185679' WHERE `Matrix_Unique_ID` = '212593657' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T21:12:06.217' ,`MLSNumber` = '87673838' ,`ListAgentFullName` = 'Joseph Rollins' ,`ListOfficeName` = 'The Powers Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.108839' ,`Longitude` = '-95.406339' ,`PhotoCount` = '25' ,`PostalCode` = '77386' ,`RoomCount` = '10' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Iris Bloom' ,`StreetNumber` = '29490' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3220' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home located close to the Woodlands. Easy access to I45 and Grand Parkway. Located on a corner lot of a cul-de-sac provides extra room outside not found in the majority of homes located in Forest Village. Kitchen is open to the downstairs living room providing for a unified area. Ceramic wood plank floors are a significant upgrade for this house. The primary bathroom has been upgraded to provide for a large walk-in shower. Upstairs are 3 additional bedrooms with plenty of closet space. The family room, office/bedroom and extra room upstairs provide ample space for the family to hang out together. There is a water softener system that will remain with the house. The garage door has been insulated to reduce the heat and make the area more usable.' ,`Acres` = '0.1383' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S515905 - FOREST VILLAGE 05, BLOCK 2, LOT 15' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '6026' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '424' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'FORD ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Forest Village 05' ,`TaxAmount` = '4915' ,`TaxRate` = '2.8187' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185679' WHERE `Matrix_Unique_ID` = '212610546' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T20:26:23.313' ,`MLSNumber` = '16916940' ,`ListAgentFullName` = 'Sheila Lewis' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.928101' ,`Longitude` = '-95.185751' ,`PhotoCount` = '30' ,`PostalCode` = '77044' ,`RoomCount` = '10' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Chartley Falls' ,`StreetNumber` = '14434' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3065' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Make this beautiful 4-bedroom, 3.5 bathroom house your new home. Great open floorplan. Elegant entry with winding stair case. Beautiful luxury vinyl tile on first floor. Island kitchen with double ovens and stainless steel appliances. Primary bedroom has en-suite bath with double vanities/sinks, jetted garden tub, separate shower and walk-in closets. Three spacious bedrooms upstairs with two full baths. Beautiful covered back patio with super spacious backyard, possibly one of the largest backyards in the community. First floor is 100% brick exterior. Don\'t hesitate! It won\'t last long.' ,`Acres` = '0.3476' ,`Area` = '1' ,`BuilderName` = 'Partners In Building' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 1 SUMMERWOOD SEC 7 EDGEWATER VLG' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '15141' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'SUMMERWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Summerwood Sec 07 Edgewater 06' ,`TaxAmount` = '7811' ,`TaxRate` = '2.683' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185679' WHERE `Matrix_Unique_ID` = '212653212' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T21:01:44.800' ,`MLSNumber` = '11809422' ,`ListAgentFullName` = 'Amber Young-Gomes' ,`ListOfficeName` = 'Executive Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.683595' ,`Longitude` = '-95.436692' ,`PhotoCount` = '24' ,`PostalCode` = '77340' ,`RoomCount` = '3' ,`ListPrice` = '179000.00' ,`Status` = 'Active' ,`StreetName` = 'Dogwood' ,`StreetNumber` = '45' ,`StreetSuffix` = 'Drive' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1504' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming home is situated on the corner of Dogwood Drive and is within minutes of Sam Houston State University. The property includes ample yard space and is nestled in the Watson Lake subdivision. This three-bedroom, two-bathroom house has been updated and is ready for a new owner. One of the two family areas has a wood-burning fireplace, perfect for cozy fall weather. Enjoy your morning coffee under the large covered back patio. Contact us to book a viewing!' ,`Acres` = '' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Watson Lake- Sec 2, Block 6, Lot 1,2,3,4' ,`LotDesciption` = 'Corner,Subdivision Lot,Wooded' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`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` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Watson Lake' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185679' WHERE `Matrix_Unique_ID` = '212667797' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T21:15:15.600' ,`MLSNumber` = '82428189' ,`ListAgentFullName` = 'Limei Zhang' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = 'Abbas Naqvi' ,`SellingOfficeName` = 'REALM Real Estate Professional' ,`Latitude` = '29.689015' ,`Longitude` = '-95.740731' ,`PhotoCount` = '50' ,`PostalCode` = '77407' ,`RoomCount` = '4' ,`ListPrice` = '385000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Sommerset Branch' ,`StreetNumber` = '20706' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2534' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious and lovely home in Grand Mission! This location is absolutely perfect w/ease of access to 99/Grand Parkway & Westpark Tollway; conveniently located to shopping, restaurants & schools!Fully renovated and move in ready! New carpet, new flooring and fresh new paint, new landscaping and so much more!!!4 Bedrooms and 3 full bath!! An oversized covered patio and specious size yard are enhanced by a sprinkler system. Make your appointment today as this won\'t last long!( Roof original, ac 2019) Multiple offers, seller will make decision Sunday night.' ,`Acres` = '0.151' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND MISSION ESTATES SEC 10, BLOCK 3, LOT 25' ,`LotDesciption` = 'Other' ,`LotSize` = '6577' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '965' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Mission Estates Sec 10' ,`TaxAmount` = '7656' ,`TaxRate` = '2.8397' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185679' WHERE `Matrix_Unique_ID` = '212668021' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T20:25:53.580' ,`MLSNumber` = '69251170' ,`ListAgentFullName` = 'Ellen Camp' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.787788' ,`Longitude` = '-95.462751' ,`PhotoCount` = '24' ,`PostalCode` = '77055' ,`RoomCount` = '16' ,`ListPrice` = '1499000.00' ,`Status` = 'Active' ,`StreetName` = 'Ciano' ,`StreetNumber` = '7515' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5719' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Luxurious living in this sophisticated 2 stry home w/ 5 BR, 5 1/2 baths featuring 2 PRIMARY BEDROOMS/BATHS & 2 LAUNDRY ROOMS! Stunning spiral staircase w/ custom paneling. French doors and an abundance of windows allow for plenty of natural light throughout. 3 car garage & fenced grassy area in back. 2 upstairs balconies & 2 courtyards w/ pavers reminiscent of a European village home. Entertaining & everyday living is a breeze in this gourmet kitchen featuring stainless Miele appliances, gas stove, giant custom built-in fridge & sprawling center island. Snuggle up w/ a good book near fireplace in the family room under gorgeous crystal chandelier. Each secondary bedroom is incredibly spacious w/ private en-suite bathroom. Vacation at home at resort style, community pool. Wide streets for ample guest parking. Gated community, Lock & Leave. One block from AWTY, conveniently located near I10 for downtown access. Zoned to Memorial High School. Sellers are motivated, priced to sell quickly!' ,`Acres` = '0.1684' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Pre-Foreclosure,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 83 BLK 1 RAVENNA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7336' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '4427' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HOUSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'English,French,Mediterranean,Spanish,Traditional' ,`Subdivision` = 'Ravenna Sub' ,`TaxAmount` = '39335' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185679' WHERE `Matrix_Unique_ID` = '212706425' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T21:56:10.030' ,`MLSNumber` = '19326438' ,`ListAgentFullName` = 'Christina DeLaTorre' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.770860' ,`Longitude` = '-95.303061' ,`PhotoCount` = '26' ,`PostalCode` = '77020' ,`RoomCount` = '3' ,`ListPrice` = '344900.00' ,`Status` = 'Active' ,`StreetName` = 'Arapahoe' ,`StreetNumber` = '6704' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1687' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION located minutes away from downtown & the much-anticipated East River Project along Buffalo Bayou. As you pull up, this home stands out w/ its sleek modern facade. Corner lot w/ low maintenance yard. Plenty of outdoor green space for the little ones or pets. You have plenty of space to add a deck right outside your backdoor. Bright, Airy & Large open-concept floorplan. The first thing you will notice as you enter are the high ceilings and recessed lighting. The 1st floor features an open living, dining & kitchen area. The large island in the kitchen has outlets, drawers and cabinet space. Soft closing drawers and cabinets. An abundance of windows, allows just the right amount of natural light to come thru. The 2nd floor features all bedrooms, which allows more space for the common areas on the first floor but also gives you a relaxing refuge. Quality workmanship throughout. Convenient location w/ easy access I-10. *$3k to buyer to use as you want, offer expires 9/26.' ,`Acres` = '0.0717' ,`Area` = '2' ,`BuilderName` = 'Uptown Houston Dev.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 23 DENVER AMEND' ,`LotDesciption` = 'Corner' ,`LotSize` = '3125' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PUGH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Denver Amend' ,`TaxAmount` = '874' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664185680' WHERE `Matrix_Unique_ID` = '212709298' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T21:28:31.673' ,`MLSNumber` = '96673726' ,`ListAgentFullName` = 'Raquel Johnson' ,`ListOfficeName` = 'Sapphire Homes Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.818776' ,`Longitude` = '-94.987440' ,`PhotoCount` = '40' ,`PostalCode` = '77521' ,`RoomCount` = '3' ,`ListPrice` = '229000.00' ,`Status` = 'Active' ,`StreetName` = 'Black Rock' ,`StreetNumber` = '4822' ,`StreetSuffix` = 'Street' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1463' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Very well maintained 3 Bed 2 Bath house in the heat of Eastpoint subdivision, this property features a very large covered back patio perfect to entertain your guests, Tile floors throughout the house, granite counter tops in the kitchen. Also a 2 yrs old roof, 1 year old AC unit and ducts. This is a must see!' ,`Acres` = '0.1567' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 226 EASTPOINT R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6825' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '280' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'VICTORIA WALKER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Eastpoint R/P' ,`TaxAmount` = '4931' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185680' WHERE `Matrix_Unique_ID` = '212719102' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T21:18:18.290' ,`MLSNumber` = '66754138' ,`ListAgentFullName` = 'Christa Hoogeboom' ,`ListOfficeName` = 'Sparrow Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.409580' ,`Longitude` = '-94.908590' ,`PhotoCount` = '47' ,`PostalCode` = '77590' ,`RoomCount` = '12' ,`ListPrice` = '400000.00' ,`Status` = 'Active' ,`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`='1664185680' WHERE `Matrix_Unique_ID` = '212724147' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T21:43:20.303' ,`MLSNumber` = '42427916' ,`ListAgentFullName` = 'Kathy Arnold' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '30.150323' ,`Longitude` = '-95.502367' ,`PhotoCount` = '14' ,`PostalCode` = '77381' ,`RoomCount` = '3' ,`ListPrice` = '270000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Wavy Oak' ,`StreetNumber` = '5' ,`StreetSuffix` = 'Circle' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1335' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Surrounded by trees, this 3 bedroom all brick home is nestled in Panther Creek in The Woodlands. High ceiling, a woodburning fireplace and engineered wood flooring compliment the family room. Plenty of space for a large dining table too. New cabinets (\'19), quartz countertops (\'19) and stainless energy appliances (\'17) add to this updated kitchen. Laundry room is in the home. Bonus: Roof (\'19), A/C (\'16), back fence (\'15) and bathroom vanities (\'17). Energy efficient windows (\'19) have been added throughout the home plus ceiling fans. Spacious front yard with long and wide driveway. Backyard has a large tile block patio with an awning that extends for those sunny days.\r\nThe Woodlands has it all, the best in entertainment, restaurants, lakes/ponds, hike and bike trails and medical facilities. Come check it out!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL PANTHER CK 07, BLOCK 9, LOT 24' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot,Wooded' ,`LotSize` = '5600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GLEN LOCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Woodlands Village Panther Creek' ,`TaxAmount` = '4340' ,`TaxRate` = '2.0869' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1664185680' WHERE `Matrix_Unique_ID` = '212735817' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T20:01:08.040' ,`MLSNumber` = '73081981' ,`ListAgentFullName` = 'Francois Jones' ,`ListOfficeName` = 'Masters Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.142438' ,`Longitude` = '-95.410097' ,`PhotoCount` = '37' ,`PostalCode` = '77386' ,`RoomCount` = '7' ,`ListPrice` = '348500.00' ,`Status` = 'Active' ,`StreetName` = 'Copperwood Park' ,`StreetNumber` = '2043' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2653' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'IT WONT LAST!!! Incredible Remodeled Kitchen: Granite Counters + Stainless Appliances! 42\" Cabinetry with Under Cabinet Lighting + Recessed Lighting! Private First Floor Primary Suite with Tray Ceiling! Lovely Whirlpool Garden Bath with Dual Sinks and a Big Walk-In Closet! Large Secondary Bedrooms. Large Gameroom/Media Room with Great 16 x 4 Walk-In Storage Closet! Windows, roof and 1st floor HVAC replaced in the last several years! Quite Backyard Setting with No Neighbors Behind and access to greenbelt. Master-Planned Community with Easy Access to I-45, GP 99, & The Woodlands Amenities! WON\'T LAST - HURRY!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'IMPERIAL OAKS PARK 01, BLOCK 1, LOT 37' ,`LotDesciption` = 'Greenbelt' ,`LotSize` = '8164' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'KAUFMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Oaks' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185680' WHERE `Matrix_Unique_ID` = '212762465' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T21:58:14.063' ,`MLSNumber` = '2228588' ,`ListAgentFullName` = 'Shan Qiu' ,`ListOfficeName` = 'S & J Company' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.707593' ,`Longitude` = '-95.605294' ,`PhotoCount` = '24' ,`PostalCode` = '77072' ,`RoomCount` = '8' ,`ListPrice` = '289000.00' ,`Status` = 'Active' ,`StreetName` = 'Bayberry Bend Circle' ,`StreetNumber` = '12710' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2129' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New improved listing price.\r\nBeautifully Remodeled Perry Homes on a corner lot near Bellaire in Dairy Ashford. The whole house is recently upgraded by waterproof vinyl plank flooring. Kitchen is totally renovated: new granite countertop, new stainless-steel sink and new kitchen faucet, new stove, new microwave, new light fixtures, new fans. New paint everywhere, new toilets. Crown molding is through the house, even the two-car garage is nicely done, supplying a lot space for entertainment and comfort living. Good Location: low tax region, easy access to Bellaire, Dairy Ashford, Bellway 8, Hwy 6 and Westpark tollway. Closed to school. You will like it. Hurry, it wouldn’t last long!\r\nPlease wear shoe covers provided by the owner besides the door to enter the house.' ,`Acres` = '0.0852' ,`Area` = '28' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 1 HIGH STAR SEC 3' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '3713' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'MAHANAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'O\'DONNELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'High Stare' ,`TaxAmount` = '4075' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185680' WHERE `Matrix_Unique_ID` = '212798095' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T20:20:06.440' ,`MLSNumber` = '53745935' ,`ListAgentFullName` = 'Bonnie Schinnerer' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.846580' ,`Longitude` = '-94.847636' ,`PhotoCount` = '37' ,`PostalCode` = '77523' ,`RoomCount` = '9' ,`ListPrice` = '469900.00' ,`Status` = 'Active' ,`StreetName` = 'Broadmoor' ,`StreetNumber` = '4010' ,`StreetSuffix` = 'Drive' ,`City` = 'Mont Belvieu' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3070' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to Wilburn Ranch Subdivision. One of the most sought out subdivisions in Mont Belvieu, TX. Over 3000 sq ft 1 story beautiful home has 4 large bedrooms, 3 1/2 bathrooms, dining room, office/study and sits on a little over 1/4-acre lot, large enough for a swimming pool. As you walk through the front door you will notice the 12ft ceilings, hard wood floors and crown molding throughout the home. Open concept gourmet kitchen extends into the living room perfect for entertaining family and friends. Kitchen features dark expresso cabinets, granite counter tops, breakfast nook and a white stone wrap around island with granite countertop. The master bedroom has a huge master bath with a jetted jacuzzi tub and an oversized master closet. One of the bedrooms includes an ensuite bathroom. Large backyard patio and a 10x20 shed. Enjoy morning or nightly walks on the walking trail. Prime location for dining, shopping and only 30 minutes to Houston. Low Taxes, A+ Rating BHISD' ,`Acres` = '0.378' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BK 5 LT 35 WILBURN RANCH S/D' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '16466' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`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` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wilburn Ranch Sub' ,`TaxAmount` = '8304' ,`TaxRate` = '2.1606' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664185681' WHERE `Matrix_Unique_ID` = '212816595' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T21:07:34.797' ,`MLSNumber` = '41731121' ,`ListAgentFullName` = 'Firely Vincent' ,`ListOfficeName` = '1st Class RE Luxury Living,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.843109' ,`Longitude` = '-95.723939' ,`PhotoCount` = '48' ,`PostalCode` = '77449' ,`RoomCount` = '11' ,`ListPrice` = '349990.00' ,`Status` = 'Active' ,`StreetName` = 'Lamppost Hill' ,`StreetNumber` = '5030' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3220' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 5030 Lamppost Hill Ct! This stunning 3,220 sq ft 2-story home boasts with 4 bedrooms, 2 1/2 bathrooms, and features a ton of beautiful upgrades, not to mention the HUGE upstairs GAMEROOM, an incredible MEDIA ROOM, and an amazing BONUS ROOM that would be perfect for a study! Featuring beautiful stainless steel appliances, wine cooler fridge under countertop, modern fixtures, a spacious covered back patio, above ground pool and so much more. New roof & heater both installed less then a year ago! With an amazing location featuring easy access to 99 and I-10, this stunning home has everything you could ever want or need! This gorgeous home won\'t last long, schedule your private showing today!' ,`Acres` = '0.1102' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 1 RICEWOOD VILLAGE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4800' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '430' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'M ROBINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (CY-FAIR)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ricewood Village Sec 2' ,`TaxAmount` = '7481' ,`TaxRate` = '3.011' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1664185681' WHERE `Matrix_Unique_ID` = '212826798' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T20:38:02.843' ,`MLSNumber` = '2693688' ,`ListAgentFullName` = 'Yan Liu' ,`ListOfficeName` = 'KingFay Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.702844' ,`Longitude` = '-95.802890' ,`PhotoCount` = '18' ,`PostalCode` = '77494' ,`RoomCount` = '8' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Summerfield Glade' ,`StreetNumber` = '6215' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2492' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1441' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CINCO RANCH SOUTHWEST SEC 23, BLOCK 1, LOT 38' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6278' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WILSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'SEVEN LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'SEVEN LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cinco Ranch Southwest Sec 23' ,`TaxAmount` = '7572' ,`TaxRate` = '2.7045' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1664185681' WHERE `Matrix_Unique_ID` = '212828803' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T21:07:54.310' ,`MLSNumber` = '55424913' ,`ListAgentFullName` = 'Christina DeLaTorre' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.958574' ,`Longitude` = '-95.592535' ,`PhotoCount` = '27' ,`PostalCode` = '77429' ,`RoomCount` = '4' ,`ListPrice` = '269900.00' ,`Status` = 'Active' ,`StreetName` = 'Bent Way' ,`StreetNumber` = '11402' ,`StreetSuffix` = '' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1836' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MUST SEE! Great floorplan with recent updating throughout. Spacious Corner Lot on a Cul-De-Sac Street. Family friendly community. Zoned to A rated Hamilton Middle School. Recently painted a nice neutral color throughout. Inviting living and formal dining area. Spacious kitchen with gas range, dishwasher, microwave and granite counter tops. Large kitchen window looks out into your backyard so you can keep an eye out on the little ones or pets while they enjoy all the green open space. There is a spacious den with fireplace as well that could also be used as a gameroom. The space is so versatile. Recently installed vinyl plank flooring is easy to maintain. Extra storage space in garage. Community Park and Pool. You won\'t want to miss this one. Set up your appt today. SELLER OFFERING $3K TO BUYER.' ,`Acres` = '' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 50 Block 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '7475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '520' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MILLSAP ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mill Ridge North' ,`TaxAmount` = '4391' ,`TaxRate` = '2.53' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185681' WHERE `Matrix_Unique_ID` = '212838524' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T20:02:23.060' ,`MLSNumber` = '39836851' ,`ListAgentFullName` = 'Heather Murley' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '30.345411' ,`Longitude` = '-95.376547' ,`PhotoCount` = '26' ,`PostalCode` = '77303' ,`RoomCount` = '7' ,`ListPrice` = '235000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Pinebark' ,`StreetNumber` = '3046' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1250' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'All the country charm nestled among mature trees sitting on just a little over an acre, this home has it all! LVP completely throughout this 3 Bedroom 2 Bath home. Large spacious kitchen with eat up bar along with plenty of soft close cabinets and drawers and all new dishwasher, range and microwave. Almost everything is new in this home, exterior siding, roof, HVAC, plumbing, electrical, flooring, fixtures, deck\'s front and back, granite, toilets, tub, bath vanities, interior and exterior doors. Home is a complete remodel taken down to the studs. This is a MUST see! To be completed in next week are - hang mirrors in both bathrooms - knobs on all doors - touch ups throughout on paint and trim.' ,`Acres` = '1.0101' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CRYSTAL CREEK 01, BLOCK 1, LOT 54' ,`LotDesciption` = 'Wooded' ,`LotSize` = '44000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '20' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Crystal Creek 01' ,`TaxAmount` = '921' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1664185681' WHERE `Matrix_Unique_ID` = '212842681' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T20:15:57.467' ,`MLSNumber` = '91485578' ,`ListAgentFullName` = 'Lauren Akery' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.531186' ,`Longitude` = '-95.161567' ,`PhotoCount` = '32' ,`PostalCode` = '77598' ,`RoomCount` = '7' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Heritage Bend' ,`StreetNumber` = '2303' ,`StreetSuffix` = 'Court' ,`City` = 'Webster' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1508' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home in Heritage Park! This four bedroom two bath home is completely updated throughout. No carpet anywhere (tile throughout), double hung windows, updated cabinets and subway tile backsplash, updated showers, and stainless appliances. Backyard features an extended patio on an oversized lot perfect for relaxation. It also has a firepit, as well as a tuff shed which will remain with the home. Quick and easy access to 528 and I-45, grocery stores, shopping and more. Zoned to the award winning CCISD school district.' ,`Acres` = '0.2969' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 60 BLK 16 HERITAGE PARK SEC 5' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '12932' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '165' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'GREENE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'BROOKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Heritage Park' ,`TaxAmount` = '4217' ,`TaxRate` = '2.166' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185682' WHERE `Matrix_Unique_ID` = '212847169' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T21:28:45.793' ,`MLSNumber` = '78818715' ,`ListAgentFullName` = 'Dean Melton' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.253306' ,`Longitude` = '-95.519842' ,`PhotoCount` = '47' ,`PostalCode` = '77384' ,`RoomCount` = '9' ,`ListPrice` = '499990.00' ,`Status` = 'Active' ,`StreetName` = 'Routt Forest' ,`StreetNumber` = '14027' ,`StreetSuffix` = 'Trail' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2829' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Delightful home with relaxing backyard oasis, sparkling gunite pool/spa, large end lot in the peaceful community of Fosters Ridge. Home has 4 bedrooms, 3 full baths, open floorplan with 3 bedrooms down, including primary suite. The 4th bdrm, 3rd bath & spacious gameroom are upstairs. Beautiful island kitchen, granite countertops, stainless steel appliances, butlers pantry, & walk-in pantry. The open kitchen, family room, breakfast area & patio overlook the pool. Great flow for entertaining. Home boasts tons of windows providing natural light. Custom chandelier & designer pressed tin ceiling in the formal dining room, custom valances in family & breakfast, electric FP, walk-in closets in most rooms, plenty of storage, easily accessible floored attic, 8\'x8\' storage shed on concrete pad & professional landscape lighting in backyard. Beautifully designed gunite pool has 3 waterfalls, raised hot tub, LED lights, removable table top, & tanning deck. Walking distance to park and rec center.' ,`Acres` = '0.2115' ,`Area` = '15' ,`BuilderName` = 'D R Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S516400 - FOSTERS RIDGE 01, BLOCK 2, LOT 17' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9212' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Fosters Ridge' ,`TaxAmount` = '9074' ,`TaxRate` = '3.1488' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185682' WHERE `Matrix_Unique_ID` = '212854255' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T20:09:17.190' ,`MLSNumber` = '39894389' ,`ListAgentFullName` = 'Monica Humphrey' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.943726' ,`Longitude` = '-95.268925' ,`PhotoCount` = '20' ,`PostalCode` = '77396' ,`RoomCount` = '6' ,`ListPrice` = '195000.00' ,`Status` = 'Active' ,`StreetName` = 'Flamingo' ,`StreetNumber` = '15306' ,`StreetSuffix` = 'Park' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1390' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this quaint home in the well established Audubon Park in northeast Houston! Situated with easy access to Beltway 8, this three bedroom, 2 bath home features a brick fireplace, laminate and tile flooring throughout, and a primary bedroom with en suite bath. Garage has extra storage, and backyard is large and fully fenced. Living room features beams and built in bookcase. All appliances stay!' ,`Acres` = '0.154' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Humble Area East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 6 AUDUBON PARK SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6710' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '343' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'NORTH BELT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'HUMBLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Audubon Park Sec 01' ,`TaxAmount` = '3128' ,`TaxRate` = '2.7373' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185682' WHERE `Matrix_Unique_ID` = '212868012' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T20:53:52.903' ,`MLSNumber` = '57064715' ,`ListAgentFullName` = 'Kimberly Orbison' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.813643' ,`Longitude` = '-94.996817' ,`PhotoCount` = '43' ,`PostalCode` = '77521' ,`RoomCount` = '11' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Bearberry' ,`StreetNumber` = '4223' ,`StreetSuffix` = 'Avenue' ,`City` = 'Baytown' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEVER FLOODED! LOW TAX RATE! ONE YEAR HOME WARRANTY! OVER QUARTER ACRE LOT! This 2 Story 4 Bedroom 3.5 Bath home sits on over a quarter acre lot, no back neighbors, perfect for a pool, already has She Shed or Workshop what ever you choose equipped with electric, and the home is located in a cul-de-sac. Some of its features are granite countertops in the kitchen and primary bathroom, soaking tub, with separate shower, walk in closet, designer cabinets, gas fireplace, crown molding, private utility room, 2nd floor bonus room with a private balcony, and a private covered 18x7 patio in the oversized backyard. This is a must see!! The kitchen is an open concept with a breakfast bar/eat in kitchen with pantry, and a Formal Dining Room for entertainment or the holidays. Refrigerator is included!' ,`Acres` = '0.2722' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 BAY RIVER COLONY SEC 10' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '11858' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'BANUELOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay River Colony Sec 10' ,`TaxAmount` = '7382' ,`TaxRate` = '2.705' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185682' WHERE `Matrix_Unique_ID` = '212872098' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T20:43:30.360' ,`MLSNumber` = '42343049' ,`ListAgentFullName` = 'Thomas Heilbrun' ,`ListOfficeName` = 'Cornerstone Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.917703' ,`Longitude` = '-95.684312' ,`PhotoCount` = '23' ,`PostalCode` = '77095' ,`RoomCount` = '9' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Oxford Grove Drive' ,`StreetNumber` = '9619' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1988' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely 1 story. Large bedrooms, high ceilings. well maintained. Primary bedroom separate from the other 3. Includes a covered patio. This house was loved and taken care of. Great neighborhood. Wonderful schools. Well secluded.' ,`Acres` = '0.1263' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 3 CANYON LAKES AT STONEGATE SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'POSTMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'ARAGON MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Lks/Stonegate Sec 7' ,`TaxAmount` = '5743' ,`TaxRate` = '2.561' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185682' WHERE `Matrix_Unique_ID` = '212873635' --> 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','212875841','1664185682','212875841','2022-09-25T20:48:03.343','11195966','Kris Cain','Cain & Company','','','29.701230','-95.369823','26','77021','4','398900.00','Active','Del Rio','6617','Street','Houston','2','1','3','1854','Single-Family','Welcome to a conceptual 20th century dream home come true! Just minutes from downtown, the Museum District, NRG and the Medical Center, this gated beauty features a finished epoxy garage with Nema car charger. Each bedroom is professionally designed with en-suite bathrooms & walk-in closets. The 2nd floor has open living space with upgraded lighting, a balcony & wall-mounted multi-facet fireplace, breakfast bar, with granite countertops and a butler pantry. This smart home can be sold fully furnished and can be an great short-term rental with no HOA restrictions.','0.0403','4','','','Electric Dryer Connections','','Sellers Disclosure','1','Mock Fireplace','1','University Area','Central Electric,Central Gas','0','LT 1 BLK 1 SOUTHLAND PLACE 2ND PAR R/P','Corner','1755','Appraisal District','','50','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','27 - Houston','THOMPSON ELEMENTARY SCHOOL (HOUSTON)','YATES HIGH SCHOOL','CULLEN MIDDLE SCHOOL (HOUSTON)','Appointment Required,Controlled Access,Request Online Appointment','Appraisal','3','French','Southland Place','7050','2.3307','Public Sewer,Public Water','2015','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','212887449','1664185682','212887449','2022-09-25T21:45:15.727','2494216','Karen Vizena','Evans and Associates','','','31.056041','-95.123152','17','75845','3','69900.00','Active','4th','252','Street','Groveton','1','0','1','504','Single-Family','This cozy cabin is like new with a kitchen, open living area, restroom/utility room, and a loft for sleeping or storage on 1/3 of an acre. The property is fenced with a double gate, extra parking, and a 12x14 storage building that could also serve as a workshop. This small home is in move in condition with a metal roof and hardi-board skirting. It is serviced with public water and sewer. Much of the front and backyard is shaded with plenty of space to sit and enjoy the outdoors or a bon fire on cool evenings. Affordable home to live in or a relaxing retreat, depending on your need. Located in the city limits with easy access to schools, shopping, & restaurants. Bring your boat or other recreational toys for nearby fishing and hunting. Approximately 20 minutes to the Trinity River & Lake Livingston public boat ramp! 45 min from Sam Houston Univ/Huntsville. Centrally located between Houston, Dallas, & Tyler.','0.32','42','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','','','','Groveton Area','Other Heating','0','GROVETON, CITY OF, BLOCK 6 LOT 25','Cleared','13939','Appraisal District','','','0','','0','Freestanding Oven','0','','','Electric Range','','Aluminum','59 - Groveton','GROVETON ELEMENTARY SCHOOL','GROVETON J H-H S','GROVETON J H-H S','Leave Business Card,Lockbox Front','Seller','1','Traditional','Groveton City Of','548','2.4366','Public Sewer,Public Water','2018','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','212891327','1664185682','212891327','2022-09-25T21:50:41.920','69900074','Holly Sewell','Lucky Money Real Estate','','','30.013346','-95.311318','24','77338','4','299000.00','Active','Stallion Trail','7427','Drive','Humble','2','1','4','2788','Single-Family','Schedule today to see this beautiful 4 bedroom home. Downstairs has a large open concept kitchen and living room, a private office, and formal dining room. The primary bedroom is also downstairs. The primary bathroom has a newly remodeled shower and a large walk in closet. There are tile floors throughout the downstairs. Three spacious bedrooms upstairs with a full bathroom. The upstairs game room is perfect for entertaining. Plenty of additional storage space upstairs.','0.1136','12','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','0','Humble Area West','Central Electric','1','LT 47 BLK 2 SADDLE RIDGE SEC 2','Other','4950','Appraisal District','','350','0','','2','','0','','','','','Composition','1 - Aldine','CYPRESSWOOD ELEMENTARY SCHOOL (ALDINE)','NIMITZ HIGH SCHOOL (ALDINE)','JONES MIDDLE SCHOOL (ALDINE)','Accompany,Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','2','Traditional','Saddle Rdg Sec 02','6084','2.7734','Water District','2007','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','212919730','1664185683','212919730','2022-09-25T21:55:27.943','63637855','Angeline Clark','Monarch Real Estate & Ranch','','','29.500270','-95.395980','6','77578','12','585400.00','Active','Palmero','9','Way','Manvel','3','1','5','3151','Single-Family','SARATOGA HOMES NEW CONSTRUCTION!! Two story, new construction home for sale in Manvel, TX with elongated foyer entryway. Our gourmet kitchen is a chef\'s dream kitchen with a large granite kitchen island, double ovens, and walk-in pantry. Formal dining room and separate breakfast area. Open-concept family room features a grandiose wall of windows and stone fireplace faces the kitchen where lasting memories will be made. Spacious primary retreat located on the first level boasts an enormous walk-in closet. Primary bath is the perfect oasis with his and hers vanities, separate soaking tub, and walk-in shower. Open to below catwalk makes it easy to keep an eye on the kids from the first level. Three secondary bedrooms. Reading loft, huge game room, and separate media room lie upstairs. Covered back patio. Our Hudson floor plan is the ULTIMATE floor plan for entertainer\'s!','','5','Saratoga Homes','','Electric Dryer Connections,Gas Dryer Connections','','Other Disclosures','1','','','Alvin North','Central Electric,Central Gas','1','SEC 4 BLK 1 LOT 4','Subdivision Lot','11299','Appraisal District','','1500','1','To Be Built/Under Construction','3','Convection Oven,Double Oven','0','','','Gas Cooktop','','Composition,Other','3 - Alvin','DON JETER ELEMENTARY SCHOOL','MANVEL HIGH SCHOOL','RODEO PALMS JUNIOR HIGH SCHOOL','Appointment Required,Call Occupant,Leave Business Card','Seller','2','Traditional','Rodeo Palms','','3.66','Public Sewer,Public Water','2022','Builder'); --> 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','212919740','1664185683','212919740','2022-09-25T21:21:11.853','71561971','Angeline Clark','Monarch Real Estate & Ranch','','','29.465709','-95.247364','2','77511','11','395400.00','Active','Latigo','5296','Court','Alvin','3','1','5','2589','Single-Family','SARATOGA HOMES NEW CONSTRUCTION - LENNOX FLOORPLAN! Welcome home to 5296 Latigo Court! Two story new construction home for sale in Alvin, TX. Open-concept layout features an elongated foyer entryway. The gourmet kitchen is a chef\'s dream kitchen with a large kitchen island, and walk-in pantry. Formal dining room and separate breakfast area. Over-sized family room with a separate sitting room offers plenty of space for quality family time. Grand primary suite tucked away in the corner for the utmost privacy. Spacious primary bath features separate sinks, freestanding tub, and large walk-in shower. 4 spacious secondary bedrooms. Back patio fit for entertainers! CALL TODAY FOR YOUR TOUR & TO FIND OUT MORE ABOUT CURRENT INCENTIVES!','0.132','5','Saratoga Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','','','Alvin North','Central Gas','1','KENDALL LAKES SEC 10 (A0482 & A0693) (ALVIN) BLK 1 LOT 69','Subdivision Lot','5750','Appraisal District','','600','1','To Be Built/Under Construction','2','','0','','','','','Composition','3 - Alvin','MARK TWAIN ELEMENTARY SCHOOL (ALVIN)','ALVIN HIGH SCHOOL','G W HARBY J H','Appointment Required,Call Occupant','Builder','2','Traditional','KENDALL LAKES','3666','3.5854','Water District','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T20:48:01.783' ,`MLSNumber` = '5331759' ,`ListAgentFullName` = 'Vanessa Sanchez' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.839440' ,`Longitude` = '-95.277392' ,`PhotoCount` = '12' ,`PostalCode` = '77028' ,`RoomCount` = '3' ,`ListPrice` = '195000.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Knoll' ,`StreetNumber` = '8166' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1068' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this charming cottage style home. This beauty features 3 spacious bedrooms with 1.5 baths. House has been completely renovated. New AC system, roof, double pane windows and more. Tile flooring throughout the house with neutral paint. Huge backyard is perfect for relaxing or entertaining. Great location with multiple access to freeways. Close to downtown entertainment and activities. Washer, dryer and refrigerator included. Welcome home!' ,`Acres` = '0.1612' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 240 BLK 11 CLAIRMONT PLACE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7020' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HILLIARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Clairmont Place Sec 01' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1946' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664185683' WHERE `Matrix_Unique_ID` = '212920029' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T21:35:25.117' ,`MLSNumber` = '2953436' ,`ListAgentFullName` = 'Joel Cirilo III' ,`ListOfficeName` = 'Liv Texas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.667387' ,`Longitude` = '-95.440280' ,`PhotoCount` = '32' ,`PostalCode` = '77025' ,`RoomCount` = '8' ,`ListPrice` = '864995.00' ,`Status` = 'Active' ,`StreetName` = 'Woodshire' ,`StreetNumber` = '4006' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3846' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You will immediately feel at home when you tour 4006 Woodshire! Wonderfully bright, this home incorporates large entertainment spaces, home office, bonus room, formal dining room, and an open living/ kitchen area. Entertain in style in this beautifully appointed kitchen featuring new stainless steel appliances, quartz countertops, tile backsplash, oversized kitchen island, large walk-in pantry, built-in microwave and cooktop. The generous owner\'s suite is made for relaxation and enhances a his-and-hers bathroom and a large walk-in closet. This home comes with all brand-new mechanical systems; Electrical panel, HVAC system, PEX lines w/ Tankless water heater, and smart garage-door openers. Enjoy the outdoor lifestyle in your shaded backyard which includes a wide porch and a large grassy area for yard games. The perfect space to consider building an underground pool. Near to parks, restaurants, grocery stores, cafes, and department stores. Schedule your private tour today. No Flood Zone!' ,`Acres` = '0.1653' ,`Area` = '20' ,`BuilderName` = 'Cozy Nest/ Lineage' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Willow Meadows Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 143 BLK 5 WESTWOOD SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHEARN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Left Side,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Westwood Sec 01' ,`TaxAmount` = '3882' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1664185683' WHERE `Matrix_Unique_ID` = '212920176' --> 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','212949844','1664185683','212949844','2022-09-25T20:51:05.110','10953539','Ashley Ruby','Walzel Properties','','','29.604622','-95.216932','32','77089','7','260000.00','Active','Sagecliff','12015','Drive','Houston','2','0','4','2188','Single-Family','This beautiful home has been remodeled inside and out! All Exterior has been made brand new within the last 3 years from new hardy siding to paint and a NEW ROOF! The interior is the most recent remodel with all new Granite throughout, New Flooring throughout. The Primary bath has a new beautifully tiled shower with a glass door! Stainless Steel Appliances in the kitchen and even has a tankless water heater and a generator for the home! This home is a MUST SEE!','0.2089','3','','','','','Sellers Disclosure','','','1','Southbelt/Ellington','Central Electric,Central Gas','1','LT 13 BLK 2 SAGEMONT PARK SEC 1','Subdivision Lot','9100','Appraisal District','','125','0','','2','','0','','','','','Composition','41 - Pasadena','STUCHBERY ELEMENTARY SCHOOL','DOBIE HIGH SCHOOL','BEVERLYHILLS INTERMEDIATE SCHOOL','Appointment Required,Request Online Appointment,Vacant/Unoccupied','Appraisal District','1','Ranch','Sagemont Park Sec 01','5114','2.6863','Water District','1973','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','212952913','1664185683','212952913','2022-09-25T20:20:21.850','76773372','Chau Nguyen','Chau Realty','','','29.689534','-95.289917','5','77087','5','229900.00','Active','Greenstone','7610','Street','Houston','1','0','4','1224','Single-Family','EXCELLENT LOCATION to downtown, to UH Central, to Hobby airport, to medical center, to Pasadena, to Galveston, and many more. It is located at the junction of 45 South and loop 610 South, minutes to Gulfgate Center Mall. Private gated property, never been flooded, quiet neighborhood, lovely interior, super cute loft upstairs, .','0.1377','3','','','Washer Connections','','Owner/Agent','0','','','Hobby Area','Central Electric','0','TRS 2 & 3A BLK 1 GREENWAY SEC 1','Subdivision Lot','6000','Appraisal District','','','0','','0','','0','','','Gas Range','','Composition','27 - Houston','GOLFCREST ELEMENTARY SCHOOL','STERLING HIGH SCHOOL (HOUSTON)','HARTMAN MIDDLE SCHOOL','Accompany,Appointment Required,Call Occupant,Leave Business Card,No Supra Keybox','Appraisal District','1','Contemporary/Modern','Greenway 1','2933','2.3307','Public Sewer,Public Water','1951','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','212952946','1664185683','212952946','2022-09-25T20:55:17.393','64998119','Ernest Mooney','Berkshire Hathaway HomeServices Premier Properties','','','29.562596','-95.290675','8','77581','4','140000.00','Active','San Antonio','2416','Street','Pearland','1','0','2','775','Single-Family','House has not been lived in for sometime, needs work, Located in Pearland Town Site, no HOA .','0.1435','5','','','','','No Disclosures','','','','Pearland','Window Unit','0','PEARLAND BLK 34 LOT 17-18','Subdivision Lot','6251','Appraisal District','','','0','','0','','0','','','','','Composition','42 - Pearland','C J HARRIS ELEMENTARY SCHOOL','PEARLAND HIGH SCHOOL','PEARLAND JUNIOR HIGH EAST','Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Other Style','Pearland','2833','2.5552','Public Sewer,Public Water','1942','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','212955479','1664185683','212955479','2022-09-25T20:51:43.520','43392663','Lyssa Lechuga','New Home Star Texas, LLC','','','28.976262','-95.970859','14','77414','3','169999.00','Active','Avenue B','2721','','Bay City','2','0','3','1278','Single-Family','***Call soon and ask about Builder contributions to buyer\'s closing cost***\r\n This single-story plan with 3 bedrooms, 2 baths, one story home is energy efficient, with an open Concept Kitchen overlooking the large living-dining combo, making this home perfect for entertaining. This home includes LED Lighting, and vinyl plank flooring in the living room, dining, kitchen, and baths. Moen fixtures in a timeless chrome finish are placed throughout the home. Lush carpeting in the bedrooms. Beautiful black appliance package included, home is engineered and inspected by a third-party engineer, has a seer HVAC system, double pane insulated Low-E windows, ENERGY EFFICIENT! \r\nWarranty: 1 yr workmanship & materials, 2 yr on all systems- plumbing, electrical, HVAC & other Mechanical Systems, 10 yr Major Structural components','','54','Censeo','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','','','Central Electric','0','BAY CITY ORIGINAL TOWNSITE, BLOCK 84, LOT 1-2 (W-50\')','Other','','Appraisal District','','','1','Never Lived In','1','Electric Oven','0','','','Electric Cooktop','','Composition','132 - Bay City','TENIE HOLMES ELEMENTARY SCHOOL','BAY CITY HIGH SCHOOL','BAY CITY JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,No Supra Keybox,Vacant/Unoccupied','Builder','1','Traditional','Bay City Original Townsite','1347','2.8238','Public Sewer,Public Water','2022','Builder'); --> 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','212955522','1664185683','212955522','2022-09-25T20:40:08.373','78196599','Roseann Johnson','Coldwell Banker Realty','','','29.501111','-95.533820','50','77459','11','575000.00','Active','Dewalt Way','3806','','Missouri City','4','0','4','4432','Single-Family','Meticulously cared for home with 2 primary bedrooms, one down & and one up. 2 bedrooms downstairs, both with full baths. Barn doors separate the downstairs guest bedroom for complete privacy & upstairs primary bedroom suite as well. Fresh interior paint. 3 year old roof. Hot water heaters & AC units 2021. Carpet up only. Oversized kitchen & eating area with tile floors, SS appliances, granite counters, double ovens, custom pantry. Formal dining room & designated study with wood floors & plantation shutters. Primary bedroom down has closet with built-in storage. Primary bath with double sinks, separate tub & shower. Primary bedroom up has added huge closet with built ins, vinyl plank floors. Recently Updated primary bath features huge walk- in shower. Secondary bedroom up with full bath & flex room can be used as 5th bedroom. Large stone patio & pergola cover. 3 car garage. Tree shaded lot.','','38','Newmark','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Levee District,Mud,Sellers Disclosure','1','','1','Sienna Area','Central Gas','1','Sienna Steep Bank Village blk 2 lot 7','In Golf Course Community,Subdivision Lot','13924','Appraisal District','','','0','','3','Double Oven,Electric Oven','0','','','Gas Cooktop','','Composition','19 - Fort Bend','SIENNA CROSSING ELEMENTARY SCHOOL','RIDGE POINT HIGH SCHOOL','BAINES MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied','Appraisal District','2','Traditional','Sienna','11124','2.57','Public Sewer,Public Water','2001','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212955587','1664185683','212955587','2022-09-25T21:38:19.243','70463090','Mohammad Khatri','G+A Real Estate','','','30.056524','-95.503110','49','77379','10','599990.00','Active','Brookway Willow','5419','Drive','Spring','3','1','4','4162','Single-Family','Immaculate 4 Bedroom house with Mediterranean interior style located minutes away from The Woodlands, IAH Aiport, and BHA Private School. Zoned to highly acclaimed Klein School District. Waterview lot with a large backyard. Separate Formal Living & dining as well as an office/Study upon entering the house. Powder room for guests. Tiles and Wood flooring throughout. Family room with high ceiling & lots of natural light. Kitchen with granite & new SS appliances. A Primary bedroom downstairs with double sinks/shower/tub. Roof 2017, Furnace & AC Coil also recently replaced. Upstairs has a second Primary bedroom/suite with an attached bath. Two additional large bedrooms upstairs and a full bathroom along with a huge game room for entertainment. Separate media room that can also be used as a 5th bedroom. Storage in the back stays. Call today to schedule a private tour.','0.1515','14','Meritage Homes','','','','Sellers Disclosure','1','Freestanding','1','Spring/Klein/Tomball','Central Gas','1','LT 24 BLK 4 SENTERRA LAKES SEC 1','Subdivision Lot,Water View,Waterfront','6600','Appraisal District','','875','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','32 - Klein','KUEHNLE ELEMENTARY SCHOOL','KLEIN HIGH SCHOOL','KRIMMEL INTERMEDIATE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Mediterranean','Senterra Lakes Sec 01','9222','2.5965','Water District','2007','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','212956401','1664185683','212956401','2022-09-25T21:31:00.373','19294650','Kelechi Okeadu','A List Real Estate Group, LLC','','','29.819092','-95.273860','10','77028','3','115000.00','Active','Wedgefield','6114','Street','Houston','1','0','3','1472','Single-Family','Three bedroom one bathroom with nice wood frame home with additional space in the backyard. Great investment property or fixer upper. Please verify room measurements FYI. Property being sold As-Is.','','2','','','','','No Disclosures,Other Disclosures','','','','Northeast Houston','Central Gas','0','Liberty Road Manor','Other','5400','Appraisal District','','','0','','2','','0','','','','','Composition,Other','27 - Houston','ELMORE ELEMENTARY SCHOOL','KASHMERE HIGH SCHOOL','KEY MIDDLE SCHOOL','Accompany,Appointment Required,Controlled Access','Appraisal District','1','Other Style','Liberty Road Manor','','','Public Sewer,Public Water','1940','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','212956417','1664185683','212956417','2022-09-25T21:37:30.260','98039262','Lyssa Lechuga','New Home Star Texas, LLC','','','29.188392','-96.274981','14','77437','4','169999.00','Active','Greely','316','Street','El Campo','2','1','4','1549','Single-Family','***Call soon and ask about Builder contributions to buyer\'s closing cost***\r\n This 2 story plan with 4 bedrooms, 2 and a half baths, is energy efficient, with an open Concept Kitchen overlooking the large living-dining combo, making this home perfect for entertaining. This home includes LED Lighting, and vinyl plank flooring in the living room, dining, kitchen, and baths. Moen fixtures in a timeless chrome finish are placed throughout the home. All bedrooms are upstairs with lush carpeting in the bedrooms. 3 of the rooms have walk-in closets. Beautiful loft area at the top of the stairs. Perfect for reading or homework. Black appliance package included, home is engineered and inspected by a third-party engineer, has a seer HVAC system, double pane insulated Low-E windows, ENERGY EFFICIENT! \r\n—Follow link to the builder website to see floorplan—\r\nWarranty: 1yr workmanship & materials, 2yr on plumbing, electrical, HVAC & other Mechanical Systems,10yr Major Structural components','0.1579','55','Censeo','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','','','Central Electric','0','HARLEM LOT 35,36','Other','6878','Appraisal District','','','1','Never Lived In','1','Electric Oven','0','','','Electric Cooktop','','Composition','198 - El Campo','','EL CAMPO HIGH SCHOOL','EL CAMPO MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Vacant/Unoccupied','Builder','2','Traditional','Harlem','2394','2.4815','Public Sewer,Public Water','2021','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','212956563','1664185683','212956563','2022-09-25T21:58:01.117','63907367','Lloyd Lee','Coldwell Banker Realty','','','29.861769','-95.626399','0','77084','7','189900.00','Active','Cinnamon Creek','5935','Circle','Houston','2','1','2','1372','Single-Family','Immaculate home located in Jamestown Colony with close acces to major thoroughfares such as West Little York, Eldridge and Hwy 6. New paint throughout the home and new flooring in the bedrooms! Wash, dryer and refrigerator stays in the quaint home right next to the community playground. The first floor boasts and open design with a half bath, a fireplace and direct access to the kitchen. The wrap around gated backyard has plenty of space to set up dining al fresco or a private playground. This home has never flooded. The home\'s windows make for a light and bright atmosphere throughout the day. The home also offers: a formal dining and breakfast area, quartz kitchen countertops, indoor utility closet and much more! Take a look today before this home gets sold!','0.0643','8','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Other Disclosures,Sellers Disclosure','1','Gas Connections','1','Eldridge North','Central Gas','1','LT 23 BLK 1 CHARLESTOWN COLONY SEC 1','Patio Lot','2800','Appraisal District','','336','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','13 - Cypress-Fairbanks','HORNE ELEMENTARY SCHOOL','CYPRESS FALLS HIGH SCHOOL','TRUITT MIDDLE SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','2','Traditional','Charlestown Colony Sec 01','3451','2.591','Water District','1984','Appraisal District'); --> New record created successfully