Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T08:24:12.933' ,`MLSNumber` = '63684924' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Jaime Pringle' ,`SellingOfficeName` = 'Texas Premier Realty' ,`Latitude` = '29.950349' ,`Longitude` = '-95.197892' ,`PhotoCount` = '30' ,`PostalCode` = '77346' ,`RoomCount` = '16' ,`ListPrice` = '563872.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Roscobie Park' ,`StreetNumber` = '15639' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Fairfax, Elevation A). CURRENTLY BEING BUILT. Two story. 5 bedrooms. 3.5 baths. Spacious island kitchen open to family room and informal dining. Primary suite with large walk-in closet. Additional first floor bedroom with private bath. First floor study. 3 additional bedrooms, game room and media room on second floor. Covered patio and 2-car garage. Forget the world outside and come home to Balmoral, a community surrounded by beauty and peace in the West Lake Houston area of northeast Beltway 8 in Humble, TX. Balmoral offers residents connected living with luxurious homes and many amenities to choose from, including the Houston area\'s Crystal Clear Lagoon surrounded by glistening white sand beaches. Stop by the Westin Homes model home today to find out more about Balmoral!' ,`Acres` = '0.159' ,`Area` = '1' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6924' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1430' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GROVES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Balmoral' ,`TaxAmount` = '1757' ,`TaxRate` = '3.5573' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667834875' WHERE `Matrix_Unique_ID` = '207785749' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T08:29:23.193' ,`MLSNumber` = '34622026' ,`ListAgentFullName` = 'Carlos Olimon' ,`ListOfficeName` = 'Realty Executives' ,`SellingAgentFullName` = 'Carolina Perez' ,`SellingOfficeName` = 'HomeSmart' ,`Latitude` = '29.912337' ,`Longitude` = '-95.105117' ,`PhotoCount` = '21' ,`PostalCode` = '77532' ,`RoomCount` = '9' ,`ListPrice` = '235000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Challenger' ,`StreetNumber` = '15915' ,`StreetSuffix` = 'Drive' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1610' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Be sure not to miss out on this charming 3 bedroom 2 bath new home in this resort like community of Newport. Enjoy great functionality in this single story home with tile floors and a utility room inside.' ,`Acres` = '0.3508' ,`Area` = '1' ,`BuilderName` = 'Geronimo' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 14 NEWPORT SEC 2' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '15280' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '55' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'CROSBY ELEMENTARY SCHOOL (CROSBY)' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Newport Sec 02' ,`TaxAmount` = '1015' ,`TaxRate` = '2.7105' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667834875' WHERE `Matrix_Unique_ID` = '208604843' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T08:23:38.630' ,`MLSNumber` = '72352971' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Sandra Billings' ,`SellingOfficeName` = 'Billings Real Estate Group' ,`Latitude` = '29.877451' ,`Longitude` = '-95.793282' ,`PhotoCount` = '32' ,`PostalCode` = '77493' ,`RoomCount` = '12' ,`ListPrice` = '449953.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Winterberry Glen' ,`StreetNumber` = '7203' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2420' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Haven, Elevation C) CURRENTLY BEING BUILT. Two story. 4 bedrooms. 3 baths. Spacious island kitchen open to informal dining room and family room. Primary suite with large walk-in closet as well as secondary bedroom on first floor. Spacious game room upstairs. Covered patio and attached 2 car garage. Just minutes from the Grand Parkway, Elyson is located in the Heart of Katy! The Elyson Café is the center of this community and offers a full food and drinks menu plus a coffee bar. Community amenities also include a pool, fitness center, game room, event lawn, tennis courts, parks and trails, and so much more. Stop by the Westin Homes model to learn more about Elyson!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 8 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6016' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1242' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Elyson' ,`TaxAmount` = '' ,`TaxRate` = '3.4' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667834875' WHERE `Matrix_Unique_ID` = '208690788' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T08:41:14.503' ,`MLSNumber` = '83068241' ,`ListAgentFullName` = 'Jose Hidalgo' ,`ListOfficeName` = 'Texas Ally Real Estate Group,' ,`SellingAgentFullName` = 'Vanessa Lopez' ,`SellingOfficeName` = 'Texas Ally Real Estate Group,' ,`Latitude` = '29.680500' ,`Longitude` = '-98.128266' ,`PhotoCount` = '8' ,`PostalCode` = '78130' ,`RoomCount` = '7' ,`ListPrice` = '318000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Marigold' ,`StreetNumber` = '1415' ,`StreetSuffix` = 'Drive' ,`City` = 'New Braunfels' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1561' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Move In Ready: 3 bedroom (master recently remodeled), 2 bath (both recently remodeled), Spacious 2 car garage with bonus storage room, 2 living areas, Walk in pantry, Corner lot. Within walking/biking distance to Walmart, H-E-B, Lowes and much more. Only 20 minutes from San Antonio and San Marcos, 40 minutes from Austin \r\nNew paint and flooring just completed.' ,`Acres` = '0.4002' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'GREEN MEADOWS 1, BLOCK 1, LOT 1 & 2' ,`LotDesciption` = 'Other' ,`LotSize` = '17435' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '142 - New Braunfels' ,`SchoolElementary` = 'WALNUT SPRINGS ELEMENTARY SCHOOL (NEW BRAUNFELS)' ,`SchoolHigh` = 'NEW BRAUNFELS HIGH SCHOOL' ,`SchoolMiddle` = 'NEW BRAUNFELS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Green Meadows 1' ,`TaxAmount` = '4298' ,`TaxRate` = '2.0267' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1667834875' WHERE `Matrix_Unique_ID` = '208826918' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T07:28:59.607' ,`MLSNumber` = '18239130' ,`ListAgentFullName` = 'Stafford Steimel' ,`ListOfficeName` = 'David Brown Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.161025' ,`Longitude` = '-95.626833' ,`PhotoCount` = '50' ,`PostalCode` = '77354' ,`RoomCount` = '16' ,`ListPrice` = '1225000.00' ,`Status` = 'Active' ,`StreetName` = 'Trailwood Estates' ,`StreetNumber` = '1045' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '5307' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custom 5bd/3bth natural Texas Limestone home on 1.77 acres in Autumnwood Reserve. Tranquility awaits w/just the right amount of irrigated foliage buffer/trees & electric gate access to your private drive. Conveniently located between The Woodlands & Tomball, easy commute to Houston Metro area via SH249 &99. Stunning open concept, high ceilings, built in cabinets accommodating 75/80” TV. High elevation, never flooded & equipped with Generac generator. New roof installed in 2022! First floor and second floor master suites. Energy efficient windows combined with 2x6 framed construction. The attached oversized 3 car garage is fully insulated w/epoxy coated floors and massive storage spaces. A second detached oversize 2 car shop with portico boasts 2100 sq ft of HVAC comfortability both in the vehicle bays & upstairs (living area). A third separate 1.5 car shop leaves you with additional endless storage. 65’ front porch and large back porch with private backyard for entertaining.' ,`Acres` = '1.771' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S827800 - THE RESERVE AT AUTUMNWOOD 01, BLOCK 2, LOT 15, ACR' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot,Wooded' ,`LotSize` = '77145' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,No Photos/No Videos,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Craftsman' ,`Subdivision` = 'The Reserve At Autumnwood 01' ,`TaxAmount` = '9507' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834875' WHERE `Matrix_Unique_ID` = '209744182' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T08:37:22.957' ,`MLSNumber` = '97728388' ,`ListAgentFullName` = 'Kelli Semar' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.590828' ,`Longitude` = '-95.136686' ,`PhotoCount` = '28' ,`PostalCode` = '77331' ,`RoomCount` = '3' ,`ListPrice` = '187000.00' ,`Status` = 'Active' ,`StreetName` = 'Berry' ,`StreetNumber` = '51' ,`StreetSuffix` = 'Street' ,`City` = 'Coldspring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1894' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a darling craftsman close to the center of town. This home embraces the small-town feel of Coldspring. One mile from the center of town where all the festivals are held. It\'s 3 bed 2 bath floor plan is large and traditional to the style of a home of its era. It has hardwood floors and high ceilings in the majority of the rooms. The wide hall is adorned with large traditional door casings. Outside on the edge of the large backyard, you will find a detached one-car garage with a workshop area. Some areas of the house have been updated like the new roof. Other areas of the house still have the original charm of a 1950\'s Craftsman. To appreciate it, you must see it.' ,`Acres` = '0.425' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Coldspring/South San Jacinto County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'A042 ROBERT RANKIN, TRACT 349.1, ACRES .425' ,`LotDesciption` = 'Cleared' ,`LotSize` = '18513' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'ROBERT RANKIN' ,`TaxAmount` = '1632' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1667834876' WHERE `Matrix_Unique_ID` = '210152930' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T08:24:38.737' ,`MLSNumber` = '68828417' ,`ListAgentFullName` = 'Randall Doe' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.709567' ,`Longitude` = '-95.372167' ,`PhotoCount` = '42' ,`PostalCode` = '77021' ,`RoomCount` = '11' ,`ListPrice` = '690000.00' ,`Status` = 'Active' ,`StreetName` = 'Parkwood' ,`StreetNumber` = '3217' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2461' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HUGE PRICE IMPROVEMENT! Beautifully re-imagined traditional beauty in historic Riverside Terrace in the shadow of the Texas Medical Center, a short distance to Downtown, TSU, Montrose/Museum District, NRG, & U of H. On a preferred street, recent 3-car garage/workshop & alley access & 9’ high door great for RV. Taken to the studs (2019), the remodel included new HVAC, electrical, roof, plumbing supplies/drains that beautifully blends the best of the 1940s, w/ detailed millwork, hardwood floors, and unique floor plan w/ 3 bedrooms w/ en-suite baths. Chefs capable kitchen w/ two pantries, commercial island & free flowing floorplan to both family room & formal dining/living. Exterior compels you w/ oversized deck & fully irrigated landscape. Terrific location near 610,59,288, plus H-E-B built ‘20. No history of flooding per seller!. Note the Historic brass plaque by the front door.' ,`Acres` = '0.2181' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Riverside' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 17 & 18A BLK 45 RIVERSIDE TERRACE SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range,Grill' ,`Refrigerator` = '' ,`Roof` = 'Built Up,Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'THOMPSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverside Terrace' ,`TaxAmount` = '5966' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834876' WHERE `Matrix_Unique_ID` = '210249552' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T07:55:40.977' ,`MLSNumber` = '51271994' ,`ListAgentFullName` = 'Brenda Venable' ,`ListOfficeName` = 'Brenda Venable' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.790230' ,`Longitude` = '-95.464204' ,`PhotoCount` = '42' ,`PostalCode` = '77055' ,`RoomCount` = '6' ,`ListPrice` = '795000.00' ,`Status` = 'Active' ,`StreetName` = 'Little Caprese' ,`StreetNumber` = '7562' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2682' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a must see home! Corner end unit w/ lots of privacy! Walk through a wrought iron gate entrance to lush landscaping and a brick paved walkway! Fig ivy walls, Brick paved patio with overhang. Perfect for outdoor dining! Enter into beautiful wood flooring, downstairs bedroom w/ full bath and ELEVATOR! Walk in closet as well. Wide open living area with super high ceilings, chef\'s kitchen with the most beautiful colored cabinets (some glass front), gas cooking, Miele high end ss appliances, Liebherr refrigerator, motorized window coverings in living area, walk in pantry, walls of windows, center island with Quartz counters too! Wine refrigerator! Primary bedroom features coffered ceilings, resort style bathroom with soaking tub, large seamless glass shower, double sinks, walk in closets! Wood flooring throughout! Gated community! Lovely community pool, fabulous parks, walkways! Zoned to Memorial High School! Walking distance to Awty Int\'l School! Minutes from the Galleria/Downtown!' ,`Acres` = '0.0756' ,`Area` = '24' ,`BuilderName` = 'Lovett' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 37 BLK 1 RAVENNA AMEND' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '3291' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3447' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric 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` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Ravenna Sub' ,`TaxAmount` = '17603' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834876' WHERE `Matrix_Unique_ID` = '210400789' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T08:41:22.177' ,`MLSNumber` = '53241488' ,`ListAgentFullName` = 'Leo Radford' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Leo Radford' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.993337' ,`Longitude` = '-95.701153' ,`PhotoCount` = '26' ,`PostalCode` = '77429' ,`RoomCount` = '7' ,`ListPrice` = '330000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Grove Brook' ,`StreetNumber` = '18243' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2385' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Motivated Seller offering up to $10,000 dollars in concessions!! This is a lovely home meticulously designed freshly painted with hardwood flooring, Granite kitchen countertops, and stainless still appliances with a refrigerator. It also includes a game and family room with plenty of space for your family to grow and entertain.' ,`Acres` = '0.1118' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 6 VILLAGES OF CYPRESS LAKES SEC 1 AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4872' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '60' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'FARNEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'GOODSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Villages Cypress Lakes' ,`TaxAmount` = '6279' ,`TaxRate` = '3.061' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834876' WHERE `Matrix_Unique_ID` = '210786655' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T07:30:04.390' ,`MLSNumber` = '97798969' ,`ListAgentFullName` = 'Kristina Martinez' ,`ListOfficeName` = 'Luxe Living Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.789690' ,`Longitude` = '-95.822322' ,`PhotoCount` = '32' ,`PostalCode` = '77493' ,`RoomCount` = '9' ,`ListPrice` = '749000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue B' ,`StreetNumber` = '1113' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4293' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Historic Peck Home is for sale! This beautiful commercial and/or residential property is ready for a new owner! Conveniently located in the heart of Downtown Katy! This property is 2 stories with 9 rooms! Featuring a conference room, an executive suite, multiple office spaces, and a show room. ENDLESS opportunities to utilize this commercial property, it can be converted to an event hall, wedding chapel, doctor office, law office, hair salon, retail space, real estate office or it can be converted back to a residential home! There is plenty of parking space, 10 parking spots! Look no further! Low tax rate! A virtual tour is available for your convenience.' ,`Acres` = '0.287' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 7 & 8 BLK 18 KATY .TOWN.' ,`LotDesciption` = 'Corner' ,`LotSize` = '12500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'KATY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial,Victorian' ,`Subdivision` = 'Katy Town' ,`TaxAmount` = '11253' ,`TaxRate` = '2.3852' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1915' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834876' WHERE `Matrix_Unique_ID` = '210797934' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T08:33:12.790' ,`MLSNumber` = '60858969' ,`ListAgentFullName` = 'James Hickok' ,`ListOfficeName` = 'The Local Agents Real Estate LLC' ,`SellingAgentFullName` = 'James Hickok' ,`SellingOfficeName` = 'The Local Agents Real Estate LLC' ,`Latitude` = '28.955486' ,`Longitude` = '-95.283083' ,`PhotoCount` = '39' ,`PostalCode` = '77541' ,`RoomCount` = '3' ,`ListPrice` = '339000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Driftwood' ,`StreetNumber` = '319' ,`StreetSuffix` = 'Court' ,`City` = 'Surfside Beach' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1312' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 319 Driftwood Ct, which is a short walk to the beach where memories are made! This cute 3 bedroom 2 bath home has a split floorplan with bedrooms on either side with living, dining and kitchen within the center. Two rooms use a Jack and Jill bathroom, while the 3rd bedroom has access to the hallway bathroom. Multiple seating areas throughout the dining and living areas to enjoy water views, you can also separate the dining seating area with the living area with pocket doors for privacy. A large deck wraps around 2 sides with access only from within house, there is a separate deck with stairs to access the front door. Stackable washer and dryer inside the house in one of the bedroom closets. Two central AC units. Under the home has a full concrete pad with 3 storage rooms, one with a shower and toilet which is not counted in the listing. Walking distance to local restaurants and shopping. All furnishings included!' ,`Acres` = '0.14' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'KRAMIG LTS 46-46A (A0051 FJ CALVIT DIV 2 (B C I C)(SURFSIDE)' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '6098' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kramig Lts 46-46a' ,`TaxAmount` = '5158' ,`TaxRate` = '2.333' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834877' WHERE `Matrix_Unique_ID` = '211052569' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T08:05:45.587' ,`MLSNumber` = '65278000' ,`ListAgentFullName` = 'Savannah Gutierrez' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.173878' ,`Longitude` = '-96.388626' ,`PhotoCount` = '22' ,`PostalCode` = '77833' ,`RoomCount` = '4' ,`ListPrice` = '219000.00' ,`Status` = 'Active' ,`StreetName` = 'Sheeley' ,`StreetNumber` = '604' ,`StreetSuffix` = 'Street' ,`City` = 'Brenham' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1086' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'As you walk into this adorable home you are welcomed by an open living/kitchen area with tons of light. This 3 bedroom, 2 bath and a bonus room that could be an office/playroom/nursery/4th bedroom located on a large lot with matured trees. This home has been completely remodeled including new plumbing, electrical, HVAC, insulation, roof, refinished wood floors, granite countertops, stainless steel appliances, windows, blinds and driveway. Close to Downtown Brenham this property would also be a great Airbnb or rental property.' ,`Acres` = '0.24' ,`Area` = '58' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 2 & 4, J.K. Sheeley' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '10528' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '137 - Brenham' ,`SchoolElementary` = 'BISD DRAW' ,`SchoolHigh` = 'BRENHAM HIGH SCHOOL' ,`SchoolMiddle` = 'BRENHAM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'J.K. Sheeley' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834877' WHERE `Matrix_Unique_ID` = '211250116' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T08:35:46.257' ,`MLSNumber` = '47237319' ,`ListAgentFullName` = 'Sonya Renteria' ,`ListOfficeName` = 'City Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.576254' ,`Longitude` = '-95.126842' ,`PhotoCount` = '23' ,`PostalCode` = '77062' ,`RoomCount` = '5' ,`ListPrice` = '368000.00' ,`Status` = 'Active' ,`StreetName` = 'Saint Cloud' ,`StreetNumber` = '15323' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3337' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BACK ON THE MARKET, LOOK AT THE PRICE!! WOW 4 bedroom home, approximately 3334 sq. ft. Owners suite downstairs w/ additional room off of the primary bedroom. 3 rooms up. New paint (inside and outside), all new flooring, new granite counter tops, new glass backsplash in kitchen, ceiling fans and new fixtures throughout, New Hvac air ducts, electrical and plumbing. Double ovens, stove top and dishwasher. It has both living and dining formals, new oversized walk-in shower in owners suite, bathroom off of utility and back (great for pool bath) new 2 inch faux blinds throughout. Fireplace is gas or wood burning. Detached 2 car garage with door opener and a breezeway. Huge backyard w/ mature trees and lush landscaping. The home also offers a nice large covered porch to relax in your rocker for those lazy days.\r\n\r\n***TOTALLY REMODELED BEAUTY, COME BY AND TAKE A LOOK!!!***' ,`Acres` = '0.195' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 9 OAKBROOK WEST SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8494' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '69' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'CLEAR LAKE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'CLEARLAKE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Oakbrook West Sec 03' ,`TaxAmount` = '7045' ,`TaxRate` = '2.5769' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834877' WHERE `Matrix_Unique_ID` = '211355689' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T07:34:56.120' ,`MLSNumber` = '75391583' ,`ListAgentFullName` = 'Suzan Zachariah' ,`ListOfficeName` = 'The Local Agents Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.956292' ,`Longitude` = '-95.279823' ,`PhotoCount` = '30' ,`PostalCode` = '77541' ,`RoomCount` = '4' ,`ListPrice` = '490000.00' ,`Status` = 'Active' ,`StreetName` = 'Point Lookout' ,`StreetNumber` = '507' ,`StreetSuffix` = '' ,`City` = 'Surfside Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1056' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'VOTE TODAY FOR THIS HOME TO HOLD AN OPEN HOUSE. MAKE YOUR CHOICE KNOWN. Ready for a super neighborhood (neighbors will greet you & share how much they love Point Lookout) & great location in beachside subdivision with newer homes? This is Point Lookout. This is a cute home with lots of extras that include a outside shower, storage area, a fenced area for the dogs, expanded deck with views and promises of fun. The home is super cute with three bedrooms & two baths. Youo will walk in off the deck to the open living/kitchen/dining area with the utility nook and a hall bath with shower. To the left side is the master with a private bath with a shower, on the other side of the dining/living area, are two more bedrooms. I love the bathroom updates. It has been a primary residence for a rental but it would be great for a rental. It is so cute & the area is great for enjoying the beach with easy access to the beach over a city walkover.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'POINT LOOKOUT SD (B C I C DIV 2)(SURFSIDE), BLOCK 3, LOT 2' ,`LotDesciption` = 'Water View' ,`LotSize` = '6695' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Point Lookout SD B C I C Div' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834877' WHERE `Matrix_Unique_ID` = '211526292' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T08:16:20.877' ,`MLSNumber` = '54504803' ,`ListAgentFullName` = 'Sonya Renteria' ,`ListOfficeName` = 'City Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.159849' ,`Longitude` = '-96.416623' ,`PhotoCount` = '28' ,`PostalCode` = '77833' ,`RoomCount` = '4' ,`ListPrice` = '364000.00' ,`Status` = 'Active' ,`StreetName` = 'Timber Oaks' ,`StreetNumber` = '1401' ,`StreetSuffix` = '' ,`City` = 'Brenham' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1869' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 1-story home in Timber Oaks Subdivision. Will be completed before the end of September! Timber Oaks is close to town and Blinn College, and has easy access to HWY 290. With High ceilings, this 3 bedroom, 2 bath, 2 car garage, comes with a study/office/dining room/optional 4th bedroom. Kitchen is open to Living room, GREAT for ENTERTAINMENT! Laminate flooring thu-out, carpet in Bedrooms. This home is highly energy efficient with a High-SEER HVAC system.. Please call for more information on the MANY, MANY OPTIONS INCLUDED on YOUR HOME!' ,`Acres` = '' ,`Area` = '58' ,`BuilderName` = 'MC Building Services' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S5873 Timber Oaks Sec 3, Block 1 Lot 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '137 - Brenham' ,`SchoolElementary` = 'BISD DRAW' ,`SchoolHigh` = 'BRENHAM HIGH SCHOOL' ,`SchoolMiddle` = 'BRENHAM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Timber Oaks' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667834878' WHERE `Matrix_Unique_ID` = '211640947' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T08:15:52.890' ,`MLSNumber` = '28832988' ,`ListAgentFullName` = 'Sonya Renteria' ,`ListOfficeName` = 'City Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.159783' ,`Longitude` = '-96.416880' ,`PhotoCount` = '29' ,`PostalCode` = '77833' ,`RoomCount` = '5' ,`ListPrice` = '384000.00' ,`Status` = 'Active' ,`StreetName` = 'Timber Oaks' ,`StreetNumber` = '1403' ,`StreetSuffix` = '' ,`City` = 'Brenham' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1989' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 1-story home in Timber Oaks Subdivision. Will be completed Before the end of September! Timber Oaks is close to town and Blinn College, and has easy access to HWY 290. With High ceilings, this 4 bedroom, 3 bath, 2 car garage. Kitchen with Island is open to Living room, GREAT for ENTERTAINMENT! Laminate flooring thu-out, carpet in Bedrooms. This home is highly energy efficient with a High-SEER HVAC system.. Please call for more information on the MANY, MANY OPTIONS INCLUDED on YOUR HOME!' ,`Acres` = '' ,`Area` = '58' ,`BuilderName` = 'MC Building Services' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S5873 Timber Oaks Sec 3, Block 1 Lot 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '137 - Brenham' ,`SchoolElementary` = 'BISD DRAW' ,`SchoolHigh` = 'BRENHAM HIGH SCHOOL' ,`SchoolMiddle` = 'BRENHAM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Timber Oaks' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667834878' WHERE `Matrix_Unique_ID` = '211641058' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T08:54:15.400' ,`MLSNumber` = '41227643' ,`ListAgentFullName` = 'Terry Jeanes' ,`ListOfficeName` = 'Led Well Realty' ,`SellingAgentFullName` = 'Michelle Reyna' ,`SellingOfficeName` = 'The Reyna Realty Group' ,`Latitude` = '29.813713' ,`Longitude` = '-95.404780' ,`PhotoCount` = '38' ,`PostalCode` = '77018' ,`RoomCount` = '9' ,`ListPrice` = '519854.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = '30th' ,`StreetNumber` = '415' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1839' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely quintessential classical Garden Oaks Cottage with designer updates and many upgrades. Featured as a Garden Oaks home tour home. Welcome to the lovely bright and cheery living space. Nice Formals and fabulous kitchen. Beautiful wood floors. Wonderful shutters on the timeless multi-paned windows. Owners suite features nook , perfect for desk space or even infant care area. Large vanity dressing area and private bath with soaker tub. Walk in closet with built-ins not usually found in Garden Oaks Cottages. Large indoor utility with great built-ins as well. Lovely front bedroom with nice storage. Fabulous kitchen with high ceilings and breakfast area. You will love it.' ,`Acres` = '0.2445' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Garden Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 11 GARDEN OAKS SEC 1' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '10650' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GARDEN OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Garden Oaks' ,`TaxAmount` = '9307' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1942' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834878' WHERE `Matrix_Unique_ID` = '211843592' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T08:17:03.930' ,`MLSNumber` = '82866409' ,`ListAgentFullName` = 'Janna Arredondo' ,`ListOfficeName` = 'C.R.Realty' ,`SellingAgentFullName` = 'Kay Soumir' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.571297' ,`Longitude` = '-95.781525' ,`PhotoCount` = '21' ,`PostalCode` = '77469' ,`RoomCount` = '7' ,`ListPrice` = '175000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Riverwood' ,`StreetNumber` = '5011' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1468' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your beautiful 1 Story Home. You will fall in love with this 4 bedroom 2 bath home. The open floor plan makes this an ideal setting for gathering with family and friends. The charming kitchen has a window sink over looking the living room, pantry, and plenty of counter space. The living room has a beautiful fireplace, a bonus to the breakfast room is the patio door which can extend your entertaining space even further as you step out unto the patio and spacious backyard. 3 bedrooms and a full bathroom are found in their own wing of the home. The secluded primary suite is well kept off of the living space with plenty of natural light. Large backyard for all your entertaining and family gatherings. NEW kitchen appliances, NEW kitchen countertops, NEW laminate, NEW carpet no, Fresh paint, and so much more. 32k PRICE Reduction' ,`Acres` = '0.1366' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RIVERWOOD VILLAGE SEC 1, BLOCK 3, LOT 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5948' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '351' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LONG ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverwood Village Sec 1' ,`TaxAmount` = '3078' ,`TaxRate` = '2.4948' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834878' WHERE `Matrix_Unique_ID` = '211898521' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T07:45:20.023' ,`MLSNumber` = '75279912' ,`ListAgentFullName` = 'Erika Jones' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.260651' ,`Longitude` = '-95.705115' ,`PhotoCount` = '50' ,`PostalCode` = '77354' ,`RoomCount` = '10' ,`ListPrice` = '638500.00' ,`Status` = 'Active' ,`StreetName` = 'Magnolia Reserve' ,`StreetNumber` = '121' ,`StreetSuffix` = 'Loop' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3368' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Pristine brick and stone home is like new and improved! Nestled among the trees on a .62 acre property, it has all of comfort and luxury you deserve. A Must See Supreme Summer Kitchen w/1,158 sq\' of covered outdoor living. Too many upgrades to list. Cedar fenced backyard w/ spectacular sunset & wooded views. 8ft Mahogany glass front door greets you to a Foyer and Formal Dining Room graced with rich wood flooring. The open concept is designed to impress! Soaring ceiling, walls of windows, and elegant fireplace welcomes you to spacious Family Room. Bright white Chef\'s kitchen has loads of storage, large island, SS appliances, and Breakfast Area. Butler\'s Pantry & huge walk in pantry takes the kitchen over the top! The Media Room includes Sonos surround sound speakers, wall sconce lighting, ceiling fan and a closet. Spacious Primary Suite has a luxurious Ensuite Bathroom. Bedroom #2 has Ensuite Bath while 2 other bedrooms share the hallway Bath. This home is a Staycation!' ,`Acres` = '0.6206' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S712300 - MAGNOLIA RESERVE 01, BLOCK 4, LOT 6' ,`LotDesciption` = 'Greenbelt,Subdivision Lot,Wooded' ,`LotSize` = '27032' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '726' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Magnolia Reserve' ,`TaxAmount` = '8119' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834878' WHERE `Matrix_Unique_ID` = '212074475' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T08:56:31.180' ,`MLSNumber` = '36001196' ,`ListAgentFullName` = 'Devin Hooper' ,`ListOfficeName` = 'Virginia Malone Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.473424' ,`Longitude` = '-94.924728' ,`PhotoCount` = '50' ,`PostalCode` = '77539' ,`RoomCount` = '19' ,`ListPrice` = '499900.00' ,`Status` = 'Active' ,`StreetName` = '8th' ,`StreetNumber` = '1422' ,`StreetSuffix` = 'Street' ,`City` = 'San Leon' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2471' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Imagine sitting on your covered porch watching the sunrise or sunset, Maybe watch a thunderstorm gather in the distance as it crosses the Galveston Bay. All of that is possible in this Amazing Water View Home. The house sits on a peninsula with water views on 3 sides and there is great restaurant’s, marinas and fishing just minutes away. This home has so many features it’s hard to list them all. Gas Generator built into home in case you lose power. Main living area upstairs features 2100 sqft of living space, downstairs could be an apartment with kitchen/living/dining combo, bedroom & bathroom or could be a bar or entertainment area. There is a spiral staircase that could be converted into an elevator. There is also a workout/craft room. Pull through garage, plenty of parking and Storage. This could be used as weekend rental, and it is move-in ready.\r\nCheck out Video Walk Through. Home is Occupied. Motivated Seller, Submit all Offers.' ,`Acres` = '0.2307' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Central Gas,Wall Heater,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 10 A EDWARDS LOTS 35 TO 37 BLK 211 SAN LEON' ,`LotDesciption` = 'Water View' ,`LotSize` = '10050' ,`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` = '17 - Dickinson' ,`SchoolElementary` = 'SAN LEON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'San Leon WV Southeast' ,`TaxAmount` = '9703' ,`TaxRate` = '2.521' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834879' WHERE `Matrix_Unique_ID` = '212223280' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T08:46:27.833' ,`MLSNumber` = '14365173' ,`ListAgentFullName` = 'Dallas Nield' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.812717' ,`Longitude` = '-95.383566' ,`PhotoCount` = '36' ,`PostalCode` = '77009' ,`RoomCount` = '6' ,`ListPrice` = '485000.00' ,`Status` = 'Active' ,`StreetName` = '28th' ,`StreetNumber` = '1203' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2696' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME WELCOME to this recently built home in the Sunset Heights. This home has beautiful details throughout. With 12 foot ceilings on the main floor and 10 foot ceilings on the third floor you will definitely enjoy the open concept floorplan. Custom black out curtains for almost every window and custom window fixtures makes this home an absolute joy. With Bosch dishwasher and stove or you will love cooking in this open kitchen. Custom pot/pan holders with drawer separate for pans. Heavy duty slat walls above kitchen cabinets and in the garage make for ample storage space. Recently painted and new floors are awaiting you! Washer/Dryer and Refrigerator available with purchase.' ,`Acres` = '0.0458' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 BLK 1 SUNSET HEIGHTS PLACE SEC 2 R/P PAR R/P' ,`LotDesciption` = 'Corner' ,`LotSize` = '1997' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'FIELD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunset Heights Place' ,`TaxAmount` = '11251' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834879' WHERE `Matrix_Unique_ID` = '212476992' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T07:39:53.600' ,`MLSNumber` = '42343049' ,`ListAgentFullName` = 'Thomas Heilbrun' ,`ListOfficeName` = 'Cornerstone Realty' ,`SellingAgentFullName` = 'Sean Gambini' ,`SellingOfficeName` = 'GoUpRE' ,`Latitude` = '29.917703' ,`Longitude` = '-95.684312' ,`PhotoCount` = '23' ,`PostalCode` = '77095' ,`RoomCount` = '9' ,`ListPrice` = '315000.00' ,`Status` = 'Option Pending' ,`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`='1667834879' WHERE `Matrix_Unique_ID` = '212873635' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T07:00:44.997' ,`MLSNumber` = '23453469' ,`ListAgentFullName` = 'Christopher Carlson' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = 'Rhonda Walker' ,`SellingOfficeName` = 'DOSS Pros, LLC' ,`Latitude` = '29.759038' ,`Longitude` = '-95.898322' ,`PhotoCount` = '38' ,`PostalCode` = '77423' ,`RoomCount` = '11' ,`ListPrice` = '550000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Acadian' ,`StreetNumber` = '2211' ,`StreetSuffix` = 'Way' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3259' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Never leave home again! Located in the Master Planned Community, Jordan Ranch, this corner-lot home has it all! The incredible covered patio and outdoor kitchen gives you a place to escape to, with plenty of yard to add to your backyard oasis. Garage extension provides an opportunity for extra storage or a workshop without taking away from parking space for your car. Living room is wired with premium sound and has custom built-in cabinetry and shelving. The finishes throughout the home will leave you in awe and you are sure to fall in love! Water filtration system recently added to give you the purest drinking water and help extend the lifespan of your plumbing. Come take a look today before it\'s gone!' ,`Acres` = '0.2245' ,`Area` = '30' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'JORDAN RANCH SEC 2, BLOCK 1, LOT 4' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '9781' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Jordan Ranch' ,`TaxAmount` = '12467' ,`TaxRate` = '3.1948' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834879' WHERE `Matrix_Unique_ID` = '212966013' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T07:37:00.680' ,`MLSNumber` = '15145036' ,`ListAgentFullName` = 'Beth Lefkowitz' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.764779' ,`Longitude` = '-95.471709' ,`PhotoCount` = '35' ,`PostalCode` = '77056' ,`RoomCount` = '13' ,`ListPrice` = '899000.00' ,`Status` = 'Active' ,`StreetName` = 'Woodway Oaks' ,`StreetNumber` = '10' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4734' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located on a private lane with only 4 homes, you discover this refined 4 BR + study and 5.5 bath residence with generous room proportions.The formal living room and dining room are perfect for entertaining in style. The gourmet island kitchen with granite counters opens up to the breakfast room with one of three fireplaces. The first floor also features a paneled study, family room and bar. Most rooms downstairs have French glass doors leading to a private patio. The secluded upstairs primary bedroom suite offers a generous sitting area, fireplace and enjoys two full sized baths as well as his and her walk-in closets. Her primary bath sanctuary offers a deep soaking tub and ample cabinets. All secondary bedrooms have en suite baths. Other amenities include a 2d staircase, high ceilings, elevator capable. One bedroom can be quarters. Desirable location w/ close proximity to the Galleria, downtown, dining and shopping makes this the perfect home. No HOA. Motivated seller, bring an offer!' ,`Acres` = '0.079' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Tanglewood Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 WOODWAY OAKS 2ND PAR R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7623' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodway Oaks Prcl R/P' ,`TaxAmount` = '17666' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834879' WHERE `Matrix_Unique_ID` = '213260226' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T08:59:55.000' ,`MLSNumber` = '68001830' ,`ListAgentFullName` = 'Michael Seder' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = 'Melissa Franklin' ,`SellingOfficeName` = 'RE/MAX Integrity' ,`Latitude` = '30.095458' ,`Longitude` = '-95.377536' ,`PhotoCount` = '27' ,`PostalCode` = '77386' ,`RoomCount` = '9' ,`ListPrice` = '497500.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Vivace' ,`StreetNumber` = '27680' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2535' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One story home that backs to a lush greenbelt in Vivace at Harmony! Stunning curb appeal with a brick and stone exterior, covered front porch, plantation shutters, extensive tile and wood floors, crown moulding, and a neutral paint palette. Study with French doors; formal living/flex space; open concept island kitchen with vaulted ceiling, breakfast bar, upgraded cabinetry with undermount lighting, Omega stone counters, spacious pantry and gas cooktop overlooks the dining and den with gas log fireplace; owner\'s retreat and two secondary bedrooms; two car attached garage with epoxy flooring and storage; fenced yard has covered patio and no rear neighbors, ensuring privacy.' ,`Acres` = '0.1837' ,`Area` = '40' ,`BuilderName` = 'SHEA HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S944700 - VIVACE AT HARMONY 01, BLOCK 3, LOT 9' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '8001' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BROADWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Vivace At Harmony 01' ,`TaxAmount` = '10456' ,`TaxRate` = '2.9587' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834880' WHERE `Matrix_Unique_ID` = '213320364' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T08:55:42.523' ,`MLSNumber` = '23011498' ,`ListAgentFullName` = 'Jody Ricco' ,`ListOfficeName` = 'Ricco Realty' ,`SellingAgentFullName` = 'Robert Gracia' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.494138' ,`Longitude` = '-95.713578' ,`PhotoCount` = '32' ,`PostalCode` = '77469' ,`RoomCount` = '7' ,`ListPrice` = '325000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Dry Creek' ,`StreetNumber` = '9722' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2310' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home has a lot of upgrades and a fantastic location. On a cul-de-sac and backing to Dry Creek it has a wrought iron fence along the back with a gate to access the greenspace and enjoy the view. Hardwood floors throughout except the bedrooms. Dramatic entry features tray ceilings. The study off of the extended foyer has double doors. Formal dining room with butlers pantry. The island kitchen is huge and has an extended serving bar, complete with granite countertops, undermount sink and glass tile backsplash. Perfect for entertaining, the kitchen is open to the living. A wood burning fireplace with gas connections is featured in the family room. The plan is open and features lots of windows. The primary bedroom has an executive bath with separate shower, large soaking tub and double sinks. The exterior is fully bricked and has a covered patio in back to enjoy the views of the creek. Privacy fence along side yard. Mature landscaping and inviting entry. Great Neighborhood Amenities!!' ,`Acres` = '0.1611' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BONBROOK PLANTATION SOUTH SEC 5, BLOCK 1, LOT 53' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt' ,`LotSize` = '7017' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CARTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bonbrook Plantation' ,`TaxAmount` = '7381' ,`TaxRate` = '2.6948' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834880' WHERE `Matrix_Unique_ID` = '213413143' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T08:46:18.757' ,`MLSNumber` = '92550319' ,`ListAgentFullName` = 'Dorian Wintill' ,`ListOfficeName` = 'Dorian Wintill' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.936608' ,`Longitude` = '-95.674721' ,`PhotoCount` = '18' ,`PostalCode` = '77095' ,`RoomCount` = '10' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Falls' ,`StreetNumber` = '10943' ,`StreetSuffix` = 'Terrace' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2560' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Move in ready! Remodeled kitchen with custom maple cabinets and quartzite countertops; remodeled primary bath with frameless glass shower and two sinks with marble countertops; luxury vinyl plank flooring in the living areas downstairs; recent carpet upstairs in all bedrooms and game room; remodeled secondary bath upstairs; two car garage; lawn irrigation system; extended back patio. Come see today!' ,`Acres` = '0.1523' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 43 BLK 2 RIATA RANCH SEC 8 AMEND' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6636' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '840' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WOODARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'SPILLANE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Riata Ranch Sec 08 Amd' ,`TaxAmount` = '6662' ,`TaxRate` = '2.711' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834880' WHERE `Matrix_Unique_ID` = '213425815' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T07:53:41.127' ,`MLSNumber` = '25429570' ,`ListAgentFullName` = 'Kristin Kubala' ,`ListOfficeName` = 'Texas Local Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.930262' ,`Longitude` = '-95.691450' ,`PhotoCount` = '50' ,`PostalCode` = '77433' ,`RoomCount` = '16' ,`ListPrice` = '2100000.00' ,`Status` = 'Active' ,`StreetName` = 'Crestwood Cove' ,`StreetNumber` = '10414' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '6' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '6302' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Breathtaking WATERFRONT estate located on a quiet cul-de-sac & in a gated section of Towne Lake. Mediterranean style elevation that is adorned with lush landscaping, a covered front porch & full sized balcony, 10 ft double doors,eave lighting surrounding the home and a circular drive in addition to a 4 car garage. You are welcomed by grand ceiling height & a direct view to the lake. Downstairs you will find your primary bedroom & ensuite and a large private guest suite & 3 additional bedrooms with private baths, gameroom & media room on the second floor. The open concept living room is perfect for your entertaining & family gatherings. The backyard is absolutely spectacular as you have an infinity style pool, hot tub, extended covered patio, outdoor kitchen, separate grotto and seating area, designated firepit seating area, built in trampoline and last, but not least a luxurious covered boat dock and pontoon. Generator, mosquito system, elevator to attic- too many features to list!' ,`Acres` = '0.3579' ,`Area` = '25' ,`BuilderName` = 'David Weekley' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 2 TOWNE LAKE SEC 38' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '15590' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2235' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'RENNELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Towne Lake' ,`TaxAmount` = '41139' ,`TaxRate` = '3.471' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834880' WHERE `Matrix_Unique_ID` = '213490767' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T07:46:53.353' ,`MLSNumber` = '91795902' ,`ListAgentFullName` = 'Sarah Lernor' ,`ListOfficeName` = 'Realvest Services, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.536878' ,`Longitude` = '-95.298739' ,`PhotoCount` = '30' ,`PostalCode` = '77584' ,`RoomCount` = '8' ,`ListPrice` = '294900.00' ,`Status` = 'Active' ,`StreetName` = 'Spring Garden' ,`StreetNumber` = '3907' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2304' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well-maintained two-story home right in the heart of Pearland zoned to beloved Magnolia Elementary! This family friendly neighborhood, currently decked out for Halloween, is walking distance to Centennial Park and a short bike ride from the Pearland Rec Center, Natatorium, Turner High School and more. The large secondary room has its own half bathroom and plenty of closet/storage space and even a secret reading nook for kids to enjoy! Kitchen updates include granite countertops and glass backsplash, and let\'s not forget about the office tucked away off of the kitchen. Large backyard with mature trees provides plenty of room to play and entertain! Don\'t miss out on this must-see! **Temporarily no showings as sellers are sick.**' ,`Acres` = '0.1623' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SPRINGFIELD (PEARLAND) (A0509 H T & B) BLK 5 LOT 3 (REPLAT)' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7070' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '135' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'MAGNOLIA ELEMENTARY SCHOOL (PEARLAND)' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH SOUTH' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Springfield Pearland' ,`TaxAmount` = '5773' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834881' WHERE `Matrix_Unique_ID` = '213584686' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T08:56:33.487' ,`MLSNumber` = '35616918' ,`ListAgentFullName` = 'Ana Peternell' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.434945' ,`Longitude` = '-95.637108' ,`PhotoCount` = '50' ,`PostalCode` = '77356' ,`RoomCount` = '11' ,`ListPrice` = '524000.00' ,`Status` = 'Active' ,`StreetName` = 'Camden Hills' ,`StreetNumber` = '89' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2543' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'State of the art new construction in desirable Bentwater Golf/Gated Community! VALENCIA is a one story home with an open floor plan designed for comfort and efficiency. The elevation consists of brick, stone & stucco to provide an elegant welcome to your home. Beautiful Floors were hand selected, beautiful QUARTZ countertops, Gas connection for an outdoor grill. The house is equipped with 5” aluminum gutters & sprinkler system in the house. Do you want more? There is a 220V ADAPTOR in the garage for electrical car equipment! Gas, water and sewer set up for an outdoor kitchen too. SAMSUNG Washer, dryer & fridge included in the sale. Bentwater renowned Country & Yacht club includes tennis courts, restaurant, golf course, Day Spa, Hair Salon, Fitness Center & More. This home holds the Social Membership level. Home builder & structural warranty included too.' ,`Acres` = '0.1686' ,`Area` = '39' ,`BuilderName` = 'Prisco Homes/HQC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BENTWATER 29, BLOCK 2, LOT 1 9' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bentwater 29' ,`TaxAmount` = '402' ,`TaxRate` = '2.1898' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667834881' WHERE `Matrix_Unique_ID` = '213614025' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T08:43:54.320' ,`MLSNumber` = '72385141' ,`ListAgentFullName` = 'Heather Chavez' ,`ListOfficeName` = 'Realty ONE Group Iconic' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.263279' ,`Longitude` = '-95.546491' ,`PhotoCount` = '48' ,`PostalCode` = '77316' ,`RoomCount` = '7' ,`ListPrice` = '465000.00' ,`Status` = 'Active' ,`StreetName` = 'Capriccio' ,`StreetNumber` = '223' ,`StreetSuffix` = 'Lane' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2833' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful, well-maintained home (W/ tons of upgrades) in the highly acclaimed Woodforest Country Club community! 2 story home features an open-concept floor plan w/many windows allowing lots of natural light enhancing interior living space. Home features beautiful wood floors, large living area w/gorgeous fireplace. Large kitchen w/ walk-in pantry, stainless steel appliances, granite counters & large kitchen island for gatherings. 1st floor spacious primary suite features a large walk-in closet, his & her sinks & a soaking tub. First floor also w/secondary bedroom & an additional full bath. Upstairs, you will find a large gameroom/flex-room, 3rd & 4th bedrooms w/ large closets & 3rd full bath. Home backs up to GREENBELT. Enjoy peaceful moments out back on your covered patio. The Woodforest community offers resort style pools, splash pad, walking/biking trails, tennis & basketball courts, retail shopping, restaurants & Harvest Market for your daily grocery needs. This is a must see!' ,`Acres` = '0.1822' ,`Area` = '39' ,`BuilderName` = 'Chesmar' ,`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` = 'S965255 - WOODFOREST 55, BLOCK 2, LOT 18' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '7935' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1265' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LONE STAR ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest 55' ,`TaxAmount` = '8435' ,`TaxRate` = '2.665' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834881' WHERE `Matrix_Unique_ID` = '213623148' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T08:32:49.747' ,`MLSNumber` = '95768807' ,`ListAgentFullName` = 'Evan Basham' ,`ListOfficeName` = 'Anne Vickery & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.001924' ,`Longitude` = '-95.178266' ,`PhotoCount` = '14' ,`PostalCode` = '77346' ,`RoomCount` = '3' ,`ListPrice` = '287000.00' ,`Status` = 'Active' ,`StreetName` = 'Timber Oaks Ridge' ,`StreetNumber` = '6032' ,`StreetSuffix` = 'Ridge' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1867' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3/2 home located at the end of a cul-de-sac. The neighborhood pool, elementary school, HEB, Walmart, Target, and many restaurants are all within walking distance! (all within a mile from this home). Open floor plan, new paint and carpet, big yard, deck, shed with electric and a/c, backs up to easement.' ,`Acres` = '0.2351' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 4 KINGWOOD GLEN SEC 3' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '10241' ,`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` = '29 - Humble' ,`SchoolElementary` = 'OAK FOREST ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'TIMBERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kingwood Glen Sec 03' ,`TaxAmount` = '5997' ,`TaxRate` = '2.933' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834881' WHERE `Matrix_Unique_ID` = '213842312' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T08:25:52.850' ,`MLSNumber` = '20173035' ,`ListAgentFullName` = 'Aaron Jistel' ,`ListOfficeName` = 'Listing Spark' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.514322' ,`Longitude` = '-95.550580' ,`PhotoCount` = '25' ,`PostalCode` = '77459' ,`RoomCount` = '8' ,`ListPrice` = '624900.00' ,`Status` = 'Active' ,`StreetName` = 'Via San Carlo' ,`StreetNumber` = '15' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3340' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is the home of your dreams... 4 bedroom and 3 1/2 bath - Dedicated Office with floating furniture that stays and Theater Room with projector and screen that stay. Great lot with large backyard, covered patio and gorgeous pool, spa, and waterfall. Large, covered patio ready for surround sound and has a TV mount. There has been an added flagstone sitting area in the backyard perfect for fire pit. A vacation in your back yard every day. Gorgeous on the inside and a huge 3 car garage. Great master bedroom on the first floor with huge and gorgeous bathroom and two walk-in closets, jetted tub, and separate shower. Another 3 bedrooms, 2 baths, a theater room, and a game room all upstairs. This is a beautiful home in a prestigious neighborhood (Sienna) with WONDERFUL A+ FBISD schools. It will make the buyer extremely happy. WILL WORK WITH A BUYER\'S AGENT - BRING ME YOUR BUYERS!' ,`Acres` = '0.2798' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SIENNA VILLAGE OF BEES CREEK SEC 25, BLOCK 3, LOT 1' ,`LotDesciption` = 'In Golf Course Community' ,`LotSize` = '12187' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1290' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SIENNA CROSSING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Sienna Village Of Bees Creek Sec 25' ,`TaxAmount` = '12777' ,`TaxRate` = '2.8129' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834881' WHERE `Matrix_Unique_ID` = '213879211' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T08:22:00.340' ,`MLSNumber` = '94777942' ,`ListAgentFullName` = 'Cynthia Corder' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.425521' ,`Longitude` = '-95.080998' ,`PhotoCount` = '46' ,`PostalCode` = '77539' ,`RoomCount` = '6' ,`ListPrice` = '699000.00' ,`Status` = 'Active' ,`StreetName` = '2nd' ,`StreetNumber` = '12104' ,`StreetSuffix` = 'Street' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2665' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This modern farmhouse is pretty as a picture! Country living at its finest in this 4 Bdrm 2 Bath home that sits on a 2.66-acre lot. You will be welcomed by a beautiful front porch and a main door that leads to a charming entryway! It\'s an open-concept floor plan w/ an incredible vaulted ceiling in the living area, and windows that give lots of natural light to the house. The chef\'s kitchen has an oversized island, white quartz countertops, a herringbone backsplash, an industrial vent hood, stainless steel appliances, and lots of storage on custom cabinets. It has a large pantry, and utility room for laundry. The primary bedroom has a color-changing remote fireplace, and bath w/a designer soaking tub, huge shower, and makeup vanity with his&hers sink. The outdoor living area is perfect for backyard parties, with a grilling station, and has a view of the large lot. There is a perfect small barn to home your animals! The lot has plenty of room for pool, horses, a garden, and many more!' ,`Acres` = '2.6605' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 2 FULLEN SUB (2019) ABST 1' ,`LotDesciption` = 'Other' ,`LotSize` = '115893' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'WILLIAM F BARNETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Fullen' ,`TaxAmount` = '14570' ,`TaxRate` = '2.4081' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667834882' WHERE `Matrix_Unique_ID` = '213892522' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T08:13:44.210' ,`MLSNumber` = '89682936' ,`ListAgentFullName` = 'Paula Miller' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.620800' ,`Longitude` = '-95.587502' ,`PhotoCount` = '35' ,`PostalCode` = '77478' ,`RoomCount` = '9' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Briar' ,`StreetNumber` = '3107' ,`StreetSuffix` = 'Court' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2871' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in the Sugar Creek Country Club community you must come see the designer picked accents that turn this home into an elegant dream! As you enter you are instantly greeted by the warm wood-like tile flooring that flows effortlessly throughout the first level. Let your feet sink into the fresh, luxurious carpet in the bedrooms and upstairs. Directly to your left is a room that can be anything you need, a home office, formal living room, study. In the kitchen you will find white shaker cabinets accented by brilliant white quartz countertops and to finish it off all new stainless-steel appliances. Your beautiful primary bedroom and bathroom is perfect for relaxing at the end of a long day. The large cedar lined closet is an added bonus too! Make your appointment today and see what this elegant dream can offer you!' ,`Acres` = '0.1928' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sugar Land East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SUGAR CREEK SEC 10, BLOCK 2, LOT 46' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'DULLES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sugar Creek Sec 10' ,`TaxAmount` = '6553' ,`TaxRate` = '2.0094' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834882' WHERE `Matrix_Unique_ID` = '213903957' --> 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','214023113','1667834882','214023113','2022-11-06T07:22:43.190','7281779','Geralyn Varney','Accustar Realty','','','30.009304','-95.490995','50','77068','9','248500.00','Active','Stoney Oak','3406','Drive','Houston','2','0','4','2364','Single-Family','Location makes this 4-bedroom home with flex room a must see. The flex room upstairs makes for a great office, 5th bedroom or game room for your enjoyment allowing you extra space to make it your own. You will love the high ceilings in the living area and the custom built-ins, wet bar and the wall of windows that open to the large backyard from the dining room and primary bedroom. All this is within walking distance to the middle and elementary schools and is only 10 minutes away from Willowbrook Mall, shopping, restaurants, and medical facilities. There is also a STEM school at the front of the subdivision. Priced to sell – Don’t miss out on this one!','0.2388','13','','','Electric Dryer Connections','','Exclusions,Sellers Disclosure','1','Gaslog Fireplace','1','1960/Cypress Creek North','Central Gas','1','LT 21 BLK 19 OLDE OAKS SEC 1','Subdivision Lot','10400','Appraisal District','','455','0','','2','Double Oven','0','','','Electric Cooktop','','Composition','48 - Spring','PAT REYNOLDS ELEMENTARY SCHOOL','WESTFIELD HIGH SCHOOL','EDWIN M WELLS MIDDLE SCHOOL','Appointment Required,Call Occupant,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','2','Contemporary/Modern','OLDE OAKS','4329','2.3342','Water District','1979','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T08:52:40.587' ,`MLSNumber` = '44676575' ,`ListAgentFullName` = 'Michael Seder' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = 'Haley Maida' ,`SellingOfficeName` = 'Keller Williams Woodlands' ,`Latitude` = '30.206740' ,`Longitude` = '-95.541639' ,`PhotoCount` = '31' ,`PostalCode` = '77382' ,`RoomCount` = '11' ,`ListPrice` = '707445.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Webb Creek' ,`StreetNumber` = '35' ,`StreetSuffix` = 'Place' ,`City` = 'The Woodlands' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3555' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Original owners! This custom 1.5 story home is located on a quiet cul-de-sac in Alden Bridge - zoned to top rated schools and just minutes from shopping, restaurants, parks with playgrounds and miles of walking and bike trails. This light and airy home offers incredible curb appeal with an all brick exterior, double crown moulding, hardwood floors, transom windows, plantation shutters, built-ins and detailed trim work throughout. The study can be closed off for privacy with French doors and has a built-in desk with shelving. An elegant formal dining with chair rail and adjacent butler\'s pantry opens to the formal living room with gas log fireplace and wall of windows framing your backyard pool views. This island kitchen is the heart of the home, and opens to the breakfast and family rooms with more windows that allow natural light inside. Rare owner\'s retreat and two bedrooms downstairs, with a game room and 4th bedroom up; backyard oasis has lush landscaping, a timeless pool and spa.' ,`Acres` = '0.2846' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL ALDEN BR 46, BLOCK 1, LOT 9' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '12395' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUCKALEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Alden Br 46' ,`TaxAmount` = '13036' ,`TaxRate` = '2.1811' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834882' WHERE `Matrix_Unique_ID` = '214049791' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T08:56:24.190' ,`MLSNumber` = '66865663' ,`ListAgentFullName` = 'Georgian Landau' ,`ListOfficeName` = 'Texas Ally Real Estate Group,' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.013746' ,`Longitude` = '-95.617122' ,`PhotoCount` = '50' ,`PostalCode` = '77377' ,`RoomCount` = '10' ,`ListPrice` = '569900.00' ,`Status` = 'Active' ,`StreetName` = 'Village Crest' ,`StreetNumber` = '12507' ,`StreetSuffix` = 'Court' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3280' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous, model-perfect, home has been recently renovated and is amazing! The huge back yard is serene with a gorgeous pool/water fall, and no neighbors in back! The moment you enter; you are pleasantly pleased with beautiful updates & touches throughout. The floor plan boasts high ceilings, plenty of natural light, large game room, 5 bedrooms, and 3-1/2 baths! Recent updates include new roof, all new flooring, new granite in kitchen & all baths, stainless steel appliances, new modern backsplash in kitchen and around the jetted tub, new ledger stone around fireplace, new iron baluster railings, new faucets, undermount sinks, light fixtures, hardware, and a freshly painted interior & exterior! Home is walking distance to the community clubhouse, pools, tennis courts, basketball courts, and gorgeous lake-view walking trails! The location is amazing, just minutes from SH249 and the Vintage area, and located in the esteemed Tomball school district! NEVER FLOODED! Will not last long!' ,`Acres` = '0.281' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 1 VILLAGE CREEK SEC 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '12240' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '759' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'WILLOW CREEK ELEMENTARY SCHOOL (TOMBALL)' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'WILLOW WOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Village Creek' ,`TaxAmount` = '8756' ,`TaxRate` = '2.7564' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834882' WHERE `Matrix_Unique_ID` = '214067029' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T08:12:13.670' ,`MLSNumber` = '61544214' ,`ListAgentFullName` = 'Eugene Chua' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.216644' ,`Longitude` = '-95.429120' ,`PhotoCount` = '46' ,`PostalCode` = '77385' ,`RoomCount` = '11' ,`ListPrice` = '337000.00' ,`Status` = 'Active' ,`StreetName` = 'Greenhouse' ,`StreetNumber` = '16789' ,`StreetSuffix` = 'Street' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2640' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A grand opportunity awaits in Montgomery Creek Ranch! Enjoy this 5-bed/ 3-bath home just 30 minutes from Lake Conroe! Move-in-ready, you\'ll love the abundance of natural light that illuminates this clever floor plan. Highlights include a bedroom ensuite on the 1st floor and tons of updates throughout! Delight in new floors, new granite countertops, and new stainless steel kitchen appliances including a refrigerator! You\'ll also find new light fixtures, new blinds, new toilets, and even a new garage door! Relax by the fireplace in your spacious family room. Adjacent to the dining room and kitchen, the beautiful tile floors connect the rooms seamlessly. All bedrooms offer wood-like vinyl flooring including the 1st-floor ensuite, perfect for a guest room or study. The 2nd floor reveals a study area and 4 bedrooms including the primary suite. Enjoy a huge backyard with a new concrete patio. Only minutes from restaurants, stores, and the hospital, you can\'t go wrong. Come see for yourself!' ,`Acres` = '0.1211' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S720808 - MONTGOMERY CREEK RANCH 08, BLOCK 7, LOT 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5275' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Montgomery Creek Ranch 08' ,`TaxAmount` = '6203' ,`TaxRate` = '2.6088' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834883' WHERE `Matrix_Unique_ID` = '214081546' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T07:15:13.953' ,`MLSNumber` = '26921007' ,`ListAgentFullName` = 'Antonio Gonzalez' ,`ListOfficeName` = 'Greatland Living' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.088515' ,`Longitude` = '-95.472504' ,`PhotoCount` = '30' ,`PostalCode` = '77389' ,`RoomCount` = '5' ,`ListPrice` = '234900.00' ,`Status` = 'Active' ,`StreetName` = 'Acorn Grove' ,`StreetNumber` = '22319' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1406' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Absolutely Stunning 1 story home in Forest North Subdivision. This beautiful home is move-in ready and offers: Fresh paint, new carpet, new laminate floors, recent roof, 3 bedrooms, 2 full bathrooms and 2 car garage. Spacious family room has vaulted ceilings, stone fireplace and opens to kitchen and formal dining room. Kitchen is light and bright with a nice breakfast nook. Bathrooms have been updated and bedrooms have new carpet. Backyard has a covered patio w/an extended wood deck. This home is a must see! Has easy access to 99, 45, 2920 and Hardy Toll Rd. Schedule your private showing today!' ,`Acres` = '0.1641' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 15 017*F5951900-002-015-017 FOREST NORTH SEC 2 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '380' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'ZWINK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'HILDEBRANDT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Forest North Sec 02 R/P' ,`TaxAmount` = '4346' ,`TaxRate` = '3.024' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834883' WHERE `Matrix_Unique_ID` = '214254442' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T08:45:02.910' ,`MLSNumber` = '51778379' ,`ListAgentFullName` = 'Debra Osborn-Camino' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.098991' ,`Longitude` = '-95.186246' ,`PhotoCount` = '40' ,`PostalCode` = '77365' ,`RoomCount` = '9' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Whitehaven Ridge' ,`StreetNumber` = '4503' ,`StreetSuffix` = 'Way' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2182' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Premium Corner Lot, only two neighbors! Wildflower Series \'\'Sunflower\" is a gorgeous Brick home in Country Colony. This 2-Story - 3 Bedroom, 2.5 Bath home with an upstairs game room! Designer paint with high ceilings. Features kitchen and Breakfast room open to the large and spacious den! Granite Island with breakfast bar, designer cabinets, and Stainless Steel appliances. Dining room off the entry. Open concept. Master Suite with Garden Tub, Separate Shower, Dual Sinks, and a walk-in Closet! Lovely Upgrade Carpet and Tile Floors; 2\'\'Faux Wood Blinds; Sprinkler System; Covered Back Patio and Gas Stub! Fully Sodded Yards; Energy Efficient 16 SEER HVAC. This home is a Wi-Fi CERTIFIED smart home featuring integrated automation and voice control with Amazon Alexa! Front covered porch to enjoy your morning coffee! Ask about special INTEREST rate buy-down opportunity seller offering.' ,`Acres` = '0.1589' ,`Area` = '40' ,`BuilderName` = 'Village' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S349205 - COUNTRY COLONY 05, BLOCK 1, LOT 27' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6922' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'PORTER ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'NEW CANEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Country Colony' ,`TaxAmount` = '8156' ,`TaxRate` = '3.2531' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834883' WHERE `Matrix_Unique_ID` = '214260802' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T08:51:36.567' ,`MLSNumber` = '48070445' ,`ListAgentFullName` = 'Gail Cain' ,`ListOfficeName` = 'Keller Williams Advtge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.269071' ,`Longitude` = '-95.600347' ,`PhotoCount` = '46' ,`PostalCode` = '77316' ,`RoomCount` = '10' ,`ListPrice` = '849000.00' ,`Status` = 'Active' ,`StreetName` = 'Sebastians Run' ,`StreetNumber` = '11550' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3973' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning 4 bedroom 3.5 bath home sits surrounded by pine trees on one acre of beauty in Grand Lake Estates. Gorgeous High Ceilings and Grand 8 foot Doorways welcome you inside. Custom Cabinetry throughout kitchen and breakfast areas with extensive granite countertops. Take in the spectacular views of nature from the grand windows that align the back of the home OR from the balcony upstairs. Huge media room with kitchenette and MORE built-in\'s upstairs. Large secondary bedrooms with unbelievable closet sizes! One entire enclosed space upstairs dedicated to storage or ready for conversion to additional living space. The massive covered back porch awaits a peaceful retreat anytime of day. Grill your favorite meals and entertain guests around the outdoor kitchen. Invisible fence surrounds the entire property for your pets to enjoy their playtime outdoors! Highly Acclaimed Montgomery ISD. LOW Tax Rate. THIS is the Oasis you have been searching for -- A MUST-SEE TODAY!' ,`Acres` = '1' ,`Area` = '39' ,`BuilderName` = 'Laray Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S539009 - GRAND LAKE ESTATES 09, BLOCK 2, LOT 50, ACRES 1' ,`LotDesciption` = 'Cleared,In Golf Course Community,Subdivision Lot,Water View,Wooded' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '845' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'KEENAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Lake Estates 09' ,`TaxAmount` = '11919' ,`TaxRate` = '1.825' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834883' WHERE `Matrix_Unique_ID` = '214278521' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T07:02:01.030' ,`MLSNumber` = '10060245' ,`ListAgentFullName` = 'Christine Beaulac' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.398955' ,`Longitude` = '-95.499617' ,`PhotoCount` = '50' ,`PostalCode` = '77318' ,`RoomCount` = '7' ,`ListPrice` = '699990.00' ,`Status` = 'Active' ,`StreetName` = 'Calm Savanna' ,`StreetNumber` = '223' ,`StreetSuffix` = 'Court' ,`City` = 'Willis' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3073' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for a place to call home that feels like a vacation resort? The Woodlands Hills community has it all! A lazy river, resort style pool, rock wall, splash pad, tennis courts, dog park, gym and so much more! From the moment you drive up, you\'ll appreciate the 4-car epoxied garage, manicured lawn, and visual masterpiece of this beautiful home. You will be greeted by the double glass front doors, wood flooring throughout the home, tall ceilings, and modern stainless-steel appliances that showcase this home\'s stunning features. The open-concept floor plan is perfect for gatherings large and small and the extended back patio and fire pit provide an idyllic setting to enjoy your morning coffee or winding down after a long day. Grab some popcorn and enjoy watching movies in the oversized theater room! This home sits on a 75\' lot in the most desired section of The Woodlands Hills, Rivus Woods. Come see this stunning home and discover one of Houston\'s newest sought-after neighborhoods.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 22, Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12537' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Hills' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834883' WHERE `Matrix_Unique_ID` = '214297492' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T08:35:32.980' ,`MLSNumber` = '93032397' ,`ListAgentFullName` = 'Christopher Phan' ,`ListOfficeName` = 'Truss Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.847938' ,`Longitude` = '-95.447964' ,`PhotoCount` = '34' ,`PostalCode` = '77091' ,`RoomCount` = '6' ,`ListPrice` = '355000.00' ,`Status` = 'Active' ,`StreetName` = 'West Tidwell' ,`StreetNumber` = '2628' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1751' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ONLY 3 UNITS LEFT of the 3-story modern farmhouse homes built by Oracle City Homes of Phase 2 in Northwest Landing\'s 24-unit privately gated community located in one of the hottest and most affordable areas in Houston, Acres Homes. These units will be complete before the end of this year and are up for grabs with new upgrades such as a top-mounted stainless steel sink, lighter luxury vinyl floors, and cozy backyard space. Buyers have the ability to upgrade features to the home. These 3 story modern farmhouse homes feature a breathtaking exterior with a flex/office space on the first floor. The second floor is packed with standard upgrades from a large quartz island and plenty of back counter space including soft close cabinets and drawers, under-mount lighting with an open floor plan, high ceilings, and a private balcony and variations of oversized windows throughout the home. The primary bedroom comes with his/her closets and the primary ensuite is dressed to impress. Welcome home!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Oracle City Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 11, Blk 1, Northwest Landing' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1432' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '125' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SMITH ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Northwest Landing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667834884' WHERE `Matrix_Unique_ID` = '214360680' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T08:35:08.943' ,`MLSNumber` = '49049275' ,`ListAgentFullName` = 'Christopher Phan' ,`ListOfficeName` = 'Truss Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.847938' ,`Longitude` = '-95.447964' ,`PhotoCount` = '34' ,`PostalCode` = '77091' ,`RoomCount` = '6' ,`ListPrice` = '349000.00' ,`Status` = 'Active' ,`StreetName` = 'West Tidwell' ,`StreetNumber` = '2628' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1751' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ONLY 3 UNITS LEFT of the 3-story modern farmhouse homes built by Oracle City Homes of Phase 2 in Northwest Landing\'s 24-unit privately gated community located in one of the hottest and most affordable areas in Houston, Acres Homes. These units will be complete before the end of this year and are up for grabs with new upgrades such as a top-mounted stainless steel sink, lighter luxury vinyl floors, and cozy backyard space. Buyers have the ability to upgrade features to the home. These 3 story modern farmhouse homes feature a breathtaking exterior with a flex/office space on the first floor. The second floor is packed with standard upgrades from a large quartz island and plenty of back counter space including soft close cabinets and drawers, under-mount lighting with an open floor plan, high ceilings, and a private balcony and variations of oversized windows throughout the home. The primary bedroom comes with his/her closets and the primary ensuite is dressed to impress. Welcome home!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Oracle City Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 12, Blk 1, Northwest Landing' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1432' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '125' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SMITH ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Northwest Landing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667834884' WHERE `Matrix_Unique_ID` = '214361123' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T08:34:41.097' ,`MLSNumber` = '82729772' ,`ListAgentFullName` = 'Christopher Phan' ,`ListOfficeName` = 'Truss Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.847938' ,`Longitude` = '-95.447964' ,`PhotoCount` = '34' ,`PostalCode` = '77091' ,`RoomCount` = '6' ,`ListPrice` = '355000.00' ,`Status` = 'Active' ,`StreetName` = 'West Tidwell' ,`StreetNumber` = '2628' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1751' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LAST CORNER UNIT of the 3-story modern farmhouse homes built by Oracle City Homes of Phase 2 in Northwest Landing\'s 24-unit privately gated community located in one of the hottest and most affordable areas in Houston, Acres Homes. These units will be complete before the end of this year and are up for grabs with new upgrades such as a top-mounted stainless steel sink, lighter luxury vinyl floors, and cozy backyard space. Buyers have the ability to upgrade features to the home. These 3 story modern farmhouse homes feature a breathtaking exterior with a flex/office space on the first floor. The second floor is packed with standard upgrades from a large quartz island and plenty of back counter space including soft close cabinets and drawers, under-mount lighting with an open floor plan, high ceilings, and a private balcony and variations of oversized windows throughout the home. The primary bedroom comes with his/her closets and the primary ensuite is dressed to impress. Welcome home!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Oracle City Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 13, Blk 1, Northwest Landing' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1432' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '125' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SMITH ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Northwest Landing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667834884' WHERE `Matrix_Unique_ID` = '214361560' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T07:39:48.703' ,`MLSNumber` = '79923120' ,`ListAgentFullName` = 'Mitchell Haynes' ,`ListOfficeName` = 'BuyBroker' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.198733' ,`Longitude` = '-94.947456' ,`PhotoCount` = '10' ,`PostalCode` = '77554' ,`RoomCount` = '8' ,`ListPrice` = '1649500.00' ,`Status` = 'Active' ,`StreetName` = 'Rum Bay' ,`StreetNumber` = '4110' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2922' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Highly desirable community of Pirates Beach West. Located on a quiet cul de sac street minutes from the beautiful Galveston beaches. Walk to the neighborhood beach access from your fabulous New Beach Home. NEW CONSTRUCTION with an estimated completion of Spring 2023. Buyers may still make some selections. Amazing 2,922 sq ft of luxury, perfect for a vacation home, weekend getaway, second home or investment. Sit on the upper or lower decks and enjoy the ocean breezes, listen to the waves crashing as you enjoy the ocean views. Home includes 4 bedrooms and 4 full baths plus powder room. primary bedroom includes ensuite bath with dual sinks, large walk in closet and direct access to covered porch. One bedroom downstairs. Main floor features open concept with kitchen open to the living area perfect for entertaining. Features include SS appliances, gas range, quartz countertops, custom wood cabinets, large island and walk-in pantry. Quality construction and finishes including impact glass.' ,`Acres` = '0.1894' ,`Area` = '33' ,`BuilderName` = 'Texas Furst Builders' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'HOA First Right of Refusal' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 41 LOT 10 BLK 3 PIRATES BEACH SEC 10' ,`LotDesciption` = 'Water View' ,`LotSize` = '8250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '395' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Pirates Beach Sec 10 91' ,`TaxAmount` = '1626' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667834884' WHERE `Matrix_Unique_ID` = '214366403' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T07:30:31.800' ,`MLSNumber` = '3543485' ,`ListAgentFullName` = 'Jessica Montes' ,`ListOfficeName` = 'Century 21 Top Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.837706' ,`Longitude` = '-95.187302' ,`PhotoCount` = '30' ,`PostalCode` = '77049' ,`RoomCount` = '7' ,`ListPrice` = '170000.00' ,`Status` = 'Active' ,`StreetName` = 'Royalwood' ,`StreetNumber` = '7834' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1656' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One story 3 Bedroom with a study currently being used as a 4th bedroom! Garage has been converted into a large livingroom with a corner brick fireplace. This home has a spacious backyard with no back neighbors and a wood shed with electricity and AC window unit. Come take a look, the possibilities are endless!' ,`Acres` = '0.2204' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 12 ROYALWOOD SEC 2 R/P' ,`LotDesciption` = 'Other' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '85' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'ROYALWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'C.E. KING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Royalwood Sec 02 Rep' ,`TaxAmount` = '3181' ,`TaxRate` = '2.7361' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834885' WHERE `Matrix_Unique_ID` = '214441104' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T07:28:43.210' ,`MLSNumber` = '83119594' ,`ListAgentFullName` = 'Richard Fenyes' ,`ListOfficeName` = 'Rocket, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.618939' ,`Longitude` = '-95.408692' ,`PhotoCount` = '20' ,`PostalCode` = '77047' ,`RoomCount` = '6' ,`ListPrice` = '259000.00' ,`Status` = 'Active' ,`StreetName` = 'Belmont Legend' ,`StreetNumber` = '12931' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2038' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Clean spacious home ready for move in; NOT in a flood zone. Close to major thoroughfares of 288 & Beltway 8 . Home features ample living space with great family functionality including a large family room, dining area and a kitchen with really good counter space and a bar-top area. The downstairs upgraded guest powder/half-bath room is great for guests and just awesome to have. The GAME ROOM is perfect for lounging and can also be used as a flexible area. The well sized Primary bedroom includes an additional sitting area while the Primary Bath has a very nice XTRA wide soaking tub and the walk-in closet gives a good amount of space. All of the bedrooms are large and accommodating. The front driveway is elongated which is perfect for additional parking. Good to know the hot-water heater is located within the 2 car garage while the in-home laundry can fit full size washer and dryer. The community offers walking trails, a splash pad area for the kids and a park with playground. Nice home.' ,`Acres` = '0.1063' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 2 REGAL OAKS SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4630' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '436' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ALMEDA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Regal Oaks Sec 03' ,`TaxAmount` = '5850' ,`TaxRate` = '2.9007' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834885' WHERE `Matrix_Unique_ID` = '214441232' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T07:40:12.010' ,`MLSNumber` = '51594222' ,`ListAgentFullName` = 'Stephanie Bateman' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.546780' ,`Longitude` = '-95.220042' ,`PhotoCount` = '23' ,`PostalCode` = '77581' ,`RoomCount` = '9' ,`ListPrice` = '359000.00' ,`Status` = 'Active' ,`StreetName` = 'Danielle' ,`StreetNumber` = '1315' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2188' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Showings Begin Friday, 11/11 9a**. Single story Pearland home with 4 bedrooms, detached garage & custom upgrades throughout. This lovely home features engineered wood floors, plantation shutters, crown molding plus 6\" baseboards, custom bathrooms, custom landscaping, sprinklers, recent roof, foundation with warranty. At the center of the home is the custom kitchen with stone counters, stainless appliances, extesive cabinetry, wine fridge, island plus skylight (see photos). The floorplan is open & functional with formal dining, formal living or play room, study/4th bedroom with closet, kitchen open to the living room plus breakfast bar. The primary is set privately in this split plan and includes a sitting area overlooking the patio, two walk-in closets & a custom bathroom with dual sinks, custom storage, jetted tub & frameless tiled shower. Quiet culdesac street, neighborhood zoned to Pearland schools & near shopping + dining options. See photos for more. **OPEN SAT 11/12 1-3p**' ,`Acres` = '0.202' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BRIARWOOD ESTATES (A0111 PERRY & AUSTIN)(PEARLAND), BLOCK 1,' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8799' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'RUSTIC OAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH EAST' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Briarwood Estates' ,`TaxAmount` = '6794' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834885' WHERE `Matrix_Unique_ID` = '214451336' --> 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','214463838','1667834885','214463838','2022-11-06T08:45:11.787','49883057','Alyssa Hashem','Realty Associates','','','29.720883','-95.465390','24','77081','3','495000.00','Active','Woodbrook','5622','Way','Houston','3','1','3','2509','Single-Family','Welcome home to 5622 Woodbrook Way','0.043','17','','','','','Other Disclosures,Sellers Disclosure','','','','Bellaire Area','Central Electric','1','LT 13 BLK 2 EDISON PARK','Subdivision Lot','1875','Appraisal District','','0','0','','2','','0','','','','','Composition','27 - Houston','CUNNINGHAM ELEMENTARY SCHOOL (HOUSTON)','BELLAIRE HIGH SCHOOL','LONG MIDDLE SCHOOL (HOUSTON)','Lockbox Front','Appraisal District','3','Traditional','Edison Park','8291','2.3307','Public Sewer,Public Water','2016','Appraisal District'); --> New record created successfully