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-08-21T01:22:00.573' ,`MLSNumber` = '17733714' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.834271' ,`Longitude` = '-95.797895' ,`PhotoCount` = '40' ,`PostalCode` = '77493' ,`RoomCount` = '3' ,`ListPrice` = '346240.00' ,`Status` = 'Active' ,`StreetName` = 'Pale Fox' ,`StreetNumber` = '4431' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1688' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready NOW! Beautiful one story home on a Cul De Sac. Stock up on everyone’s favorites with plenty of room in the walk-in pantry. The open-concept layout and covered outdoor living space are great for entertaining. A fourth bedroom is perfect for guests or larger families. Katy Pointe is located in a prime location in one of greater Houston’s hottest markets with easy access to the Grand Parkway, Katy Freeway, and a convenient commute to major employers. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Heat Pump,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0137 Plan 830B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '590' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BETHKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Katy Pointe' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701156' WHERE `Matrix_Unique_ID` = '203393280' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T01:22:00.573' ,`MLSNumber` = '5586529' ,`ListAgentFullName` = 'Manuel Martinez' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.810351' ,`Longitude` = '-95.524320' ,`PhotoCount` = '35' ,`PostalCode` = '77080' ,`RoomCount` = '7' ,`ListPrice` = '569000.00' ,`Status` = 'Active' ,`StreetName` = 'Blalock' ,`StreetNumber` = '2122' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2633' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Elegantly designed homes with stucco & brick. The main floor of your home will feature sleek finishes, stainless steel appliances. The 12 ft ceilings provide an essence of space and natural light, modern fixtures, wood flooring. This home is perfect for entertaining or a quiet date night at home as the home is pre-wired for exterior cameras, Surround Sound, Smart Alarm capabilities and has a balcony off your main floor. Your first floor will have your entry from the attached garage, a bedroom or ideal space for an office. Your primary suite is breathtaking. As soon as you enter you\'ll appreciate the vaulted ceilings, natural lighting and the most ideal primary bath oasis. Your bath features oversized modern standalone tub, oversized shower and a walk-in closet with plentiful space. These homes feature generous parking with a 2 car garage. This property is centrally located minutes away from Heights, Galleria, Bellaire, and Downtown.' ,`Acres` = '0.0613' ,`Area` = '24' ,`BuilderName` = 'JNP HOME BUILDERS LL' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 NEUEN MANOR 3RD PAR R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2672' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'BUFFALO CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING WOODS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Sauers Sub' ,`TaxAmount` = '9133' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701156' WHERE `Matrix_Unique_ID` = '206759253' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T01:22:00.573' ,`MLSNumber` = '54136829' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.406697' ,`Longitude` = '-95.051373' ,`PhotoCount` = '49' ,`PostalCode` = '77568' ,`RoomCount` = '9' ,`ListPrice` = '425639.00' ,`Status` = 'Active' ,`StreetName` = 'Bayrose' ,`StreetNumber` = '2601' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2572' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Move-in ready.** Fall in love with this gorgeous property located in the tranquil community of Lago Mar. This lovely 4 bedroom, 3.5 Bath home features high ceilings, a game room, a breakfast bar, oversized island, and an extended covered patio. Stainless steel appliances included with gas stove, microwave and dishwasher. Seek comfort in the serene primary suite, complete with a bay window in the master bedroom, a walk-in closet, dual vanities, a tub, and a separate shower. Lago Mar is home to the largest crystal lagoon, a 12-acre Caribbean blue lagoon surrounded by white sand beaches. “Move-in-Ready”. Full yard sod, full yard sprinkler system, front gutters. Other community amenities include a clubhouse, fitness center, and playground. Located off I-45, residents enjoy easy access to major business centers and popular shopping malls. Schools are zoned to Dickinson ISD. Don’t miss out – call now!' ,`Acres` = '0.1486' ,`Area` = '33' ,`BuilderName` = 'Liberty Home Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 8 BLK 1 LAGO MAR POD 6 SEC 2 (2020) ABST 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6471' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar Pod 6 Sec 2' ,`TaxAmount` = '1627' ,`TaxRate` = '3.5512' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701157' WHERE `Matrix_Unique_ID` = '207224021' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T01:22:00.573' ,`MLSNumber` = '28326049' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.405627' ,`Longitude` = '-95.052015' ,`PhotoCount` = '39' ,`PostalCode` = '77568' ,`RoomCount` = '7' ,`ListPrice` = '393594.00' ,`Status` = 'Active' ,`StreetName` = 'Bayrose' ,`StreetNumber` = '2502' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2001' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Move in ready!! Fall in love with this gorgeous property in the incredible community of Lago Mar. Custom home, with a fireplace no rear neighbors, next to a greenspace. Resting on a spacious lot, this 4-sided brick home has it all, high ceilings, luxury vinyl plank flooring, faux wood blinds, and a covered patio. Try a new recipe in the island kitchen which features granite countertops, a tile backsplash, gas stove, microwave dishwasher, and stainless steel appliances. Enjoy the comforts of this spa-like primary suite, complete with a spacious Walk-in Master Spa Shower, dual vanities and a walk-in closet. Lago Mar is home to Texas’ largest crystal lagoon, a 12-acre Caribbean blue lagoon surrounded by white sand beaches. Other community amenities include a clubhouse, fitness center, and playground. Located off I-45, residents take advantage of easy access to major business centers and popular shopping malls. Schools are zoned to Dickinson ISD. Call today!' ,`Acres` = '0.1554' ,`Area` = '33' ,`BuilderName` = 'Liberty Home Builder' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 14 BLK 2 LAGO MAR POD 6 SEC 2 (2020) ABST 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6770' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar Sec 2 Pod 6' ,`TaxAmount` = '1632' ,`TaxRate` = '3.5512' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701157' WHERE `Matrix_Unique_ID` = '207225046' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T01:22:00.573' ,`MLSNumber` = '471382' ,`ListAgentFullName` = 'Douglas Culver' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.714270' ,`Longitude` = '-95.367202' ,`PhotoCount` = '14' ,`PostalCode` = '77004' ,`RoomCount` = '9' ,`ListPrice` = '369000.00' ,`Status` = 'Active' ,`StreetName` = 'Prospect' ,`StreetNumber` = '3218' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1974' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Traditional 2 story brick in close in Southwood Oaks. 3 bedroom, 2.5 baths, hardwood floors throughout, just refinished (March 2022). Granite kitchen countertops. Recent (March 2022) interior paint and foundation work. Double paned windows throughout. New gutters (April 2022). Large fenced backyard. This is a great home in a revitalizing neighborhood. Close to The Medical Center & Hermann Park, Downtown, Midtown, and TSU & U of H. All per Seller' ,`Acres` = '0.1452' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Riverside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 BLK 3 SOUTHWOOD OAKS' ,`LotDesciption` = 'Other' ,`LotSize` = '6327' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOCKHART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Southwood Oaks' ,`TaxAmount` = '8248' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1942' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701157' WHERE `Matrix_Unique_ID` = '207271605' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T01:22:00.573' ,`MLSNumber` = '77514794' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.407616' ,`Longitude` = '-95.051093' ,`PhotoCount` = '47' ,`PostalCode` = '77568' ,`RoomCount` = '7' ,`ListPrice` = '386567.00' ,`Status` = 'Active' ,`StreetName` = 'Bayrose' ,`StreetNumber` = '2622' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2171' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy the comforts of this lovely property in the Lago Mar community. Corner lot with 4 bedrooms, 2 bath with study, no rear neighbors! Resting on a spacious lot, this 4-sided brick home has it all, high ceilings, luxury vinyl plank flooring, a study, faux wood blinds, and an extended covered patio. The island kitchen features Omega stone countertops, a tile backsplash, and stainless steel appliances. With a bay window, a walk-in closet, dual vanities, and a jetted tub, the primary suite is the perfect place to relax after a long day. “Move-in-Ready”. Full yard sod, full yard sprinkler system, front gutters. Lago Mar is home to Texas’ largest crystal lagoon, a 12-acre Caribbean blue lagoon surrounded by white sand beaches. Other community amenities include a clubhouse, fitness center, and playground. Located off I-45, residents enjoy easy access to major business centers and popular shopping malls. Schools are zoned to Dickinson ISD. Call today for more information!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Liberty Home Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1, Block 2, Section 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.5521' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701157' WHERE `Matrix_Unique_ID` = '207425866' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T01:22:00.573' ,`MLSNumber` = '14026678' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.406748' ,`Longitude` = '-95.050569' ,`PhotoCount` = '42' ,`PostalCode` = '77568' ,`RoomCount` = '4' ,`ListPrice` = '352893.00' ,`Status` = 'Active' ,`StreetName` = 'Bayrose' ,`StreetNumber` = '2618' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1796' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Manager\'s Special, 3 bedrooms, 2 baths with a study, no rear neighbors! Fall in love with this gorgeous property in the incredible community of Lago Mar. The 3-side brick home boasts a stone elevation, high ceilings, luxury vinyl plank flooring, faux wood blinds, and an extended covered patio. Try a new recipe in the island kitchen, which features Omega stone countertops, a mosaic backsplash, and stainless-steel appliances. Enjoy the comforts of this spa-like primary suite, complete with a bay window, a walk-in closet, dual vanities, a tub, and a separate shower. “Move-in-Ready”. Full yard sod, full yard sprinkler system, front gutters. Lago Mar is home to Texas’ largest crystal lagoon, a 12-acre Caribbean blue lagoon surrounded by white sand beaches. Other community amenities include a clubhouse, fitness center, and playground. Located off I-45, residents take advantage of easy access to major business centers and popular shopping malls. Schools are zoned to Dickinson ISD. Call today!' ,`Acres` = '0.1475' ,`Area` = '33' ,`BuilderName` = 'Liberty Home Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 2 BLK 2 LAGO MAR POD 6 SEC 2 (2020) ABST 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6423' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar Pod 6 Sec 2' ,`TaxAmount` = '1624' ,`TaxRate` = '3.5512' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701157' WHERE `Matrix_Unique_ID` = '207429185' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T01:22:00.573' ,`MLSNumber` = '69081537' ,`ListAgentFullName` = 'Sherry Barker' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.749169' ,`Longitude` = '-95.593909' ,`PhotoCount` = '23' ,`PostalCode` = '77077' ,`RoomCount` = '8' ,`ListPrice` = '409000.00' ,`Status` = 'Active' ,`StreetName` = 'Nova' ,`StreetNumber` = '12035' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2114' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 4 bedroom home with open floor plan. Fabulous updated gourmet kitchen features custom Woodmode/Brookhaven cabinetry, granite countertops, stainless oven, microwave, warming drawer and dishwasher, gas cooktop with pot filler, built-in refrigerator and large pantry. Enjoy your own relaxing, tropical paradise year-round! Home opens to enclosed patio with lovely koi pond (three fish included), a wonderful venue for entertaining (not included in sq. ft. calculation). Great backyard and patio, covered outdoor kitchen with Fire Magic grill, burner, sink, fridge and storage. Spacious living room features gas-log or wood fireplace, flanked by built-ins, French doors to enclosed patio, oversized garage with workbench and abundant storage. Neighborhood pool, park, tennis courts and clubhouse. Short distance to Robin Loop of Terry Hershey Park trails. All info per Seller.' ,`Acres` = '0.2031' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 8 BRIAR LAKE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8849' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '673' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Grill' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ASHFORD/SHADOWBRIAR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Briar Lake' ,`TaxAmount` = '7359' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701157' WHERE `Matrix_Unique_ID` = '207672989' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T01:22:00.573' ,`MLSNumber` = '20728373' ,`ListAgentFullName` = 'Juan Nunez' ,`ListOfficeName` = 'Jane Byrd Properties INTL.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.159257' ,`Longitude` = '-95.674770' ,`PhotoCount` = '31' ,`PostalCode` = '77362' ,`RoomCount` = '4' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Spring Creek' ,`StreetNumber` = '34427' ,`StreetSuffix` = 'Circle' ,`City` = 'Pinehurst' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3188' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful home built by Ashton Woods Co. It features an open floor plan with 4 bedrooms and 3 1/2\r\nbathrooms, prewire home theater that can be used also as a 5th bedroom if needed. Gorgeous entry foyer with an adjoining study, an elegant dining room and a spacious dining room. Just a 4-year-old home very well maintained.' ,`Acres` = '0.2062' ,`Area` = '15' ,`BuilderName` = 'Ashton Woods' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WOODTRACE 02, BLOCK 3, LOT 7' ,`LotDesciption` = 'Other' ,`LotSize` = '8983' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Woodtrace 02' ,`TaxAmount` = '11673' ,`TaxRate` = '3.3178' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663701157' WHERE `Matrix_Unique_ID` = '208124386' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T01:22:00.573' ,`MLSNumber` = '58490691' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = 'Devyn Winkler' ,`SellingOfficeName` = 'CB&A, Realtors' ,`Latitude` = '29.870394' ,`Longitude` = '-95.786527' ,`PhotoCount` = '50' ,`PostalCode` = '77493' ,`RoomCount` = '18' ,`ListPrice` = '899990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Covington Lake' ,`StreetNumber` = '23707' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4793' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Elyson 5/6 bedroom 5.5 bath next generation home on a quiet cul-de-sac with water views! Massive study/office just off the french door entry. Stunning family room complete with a soaring 2 story ceiling, cozy stone-front fireplace, an abundance of natural sunlight and beautiful wood flooring. Family room opens to the gorgeous gourmet kitchen equipped with granite countertops, tile backsplash, stainless steel appliances and a huge island with built-in breakfast bar. Just off the kitchen is a private in-law suite featuring 1 bedroom, 2 full baths, living room area, kitchen & breakfast area! Whole home water purifier. Spacious primary suite w/picturesque bath and walk-in closet. 2nd floor includes a game room, media room, flex room and additional 3 bedrooms. Backyard with covered patio, green space, peaceful water views and direct access to neighborhood walking trails. Masterplanned community boasts SO MANY amenities! Ready for move-in with fresh carpet & paint! Don\'t delay, call today!' ,`Acres` = '0.2882' ,`Area` = '25' ,`BuilderName` = 'Darling Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '12552' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,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,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Elyson' ,`TaxAmount` = '18795' ,`TaxRate` = '3.5368' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701158' WHERE `Matrix_Unique_ID` = '208450915' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T01:22:00.573' ,`MLSNumber` = '84602583' ,`ListAgentFullName` = 'Colleen Sherlock' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.845736' ,`Longitude` = '-95.476333' ,`PhotoCount` = '23' ,`PostalCode` = '77092' ,`RoomCount` = '10' ,`ListPrice` = '309000.00' ,`Status` = 'Active' ,`StreetName` = 'Silver Forest' ,`StreetNumber` = '5838' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2067' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 bedroom 2 bath home situated on an 8,030 sq ft lot (HCAD) in the desirable subdivision of Forest West. Home features an open floor plan with living, dining, and kitchen with serving bar. Kitchen is equipped with stainless appliances and great storage. Sunroom or game room located off living area with sliding doors to covered patio and fully-fenced backyard. Two spacious bedrooms down the hall with shared bath plus primary suite with full bath and large walk-in closet with organization system. Study space at the front of the home. Updates include PEX Plumbing, high-efficiency windows and doors, NEW HVAC JULY 2022, no carpet. Two-car garage. Community park and pool managed by the HOA. All per seller.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 1 FOREST WEST SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8030' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '196' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WAINWRIGHT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Forest West' ,`TaxAmount` = '6968' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701158' WHERE `Matrix_Unique_ID` = '208727292' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T01:22:00.573' ,`MLSNumber` = '47314443' ,`ListAgentFullName` = 'Alexandra Heins' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.768400' ,`Longitude` = '-95.416708' ,`PhotoCount` = '33' ,`PostalCode` = '77007' ,`RoomCount` = '11' ,`ListPrice` = '969000.00' ,`Status` = 'Active' ,`StreetName` = 'Floyd' ,`StreetNumber` = '5410' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3526' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This freestanding luxe modern home was built by BK Builders with a private drive and spacious backyard. The home boasts 3 bedrooms, 3.5 bathrooms, a study and open floor plan with wide plank hardwoods, custom stair railings and two covered outdoor terraces. The open floor plan lends itself to both entertaining and relaxing. The kitchen hosts Thermador and Gaggenau appliances. Past the dining room is a wine room complete with 2 beverage refrigerators and bottle storage. All bedrooms are large and have en-suite baths. The Expansive Primary Retreat has a private covered terrace, luxurious bathroom and “dreamy” closet. The home is located in the Rice Military - Memorial Park area. Near many of Houston’s best restaurants, shopping, outdoor parks, golf, bike-walking paths and so much more! Close proximity to downtown, the Med center and River Oaks District. All per Seller' ,`Acres` = '0.064' ,`Area` = '16' ,`BuilderName` = 'BK Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rice Military/Washington Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 FLOYD STREET TERRACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2787' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Floyd Street Terrace' ,`TaxAmount` = '15965' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701158' WHERE `Matrix_Unique_ID` = '208852144' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T01:22:00.573' ,`MLSNumber` = '10338063' ,`ListAgentFullName` = 'Jenna Finklea-Frederick' ,`ListOfficeName` = 'Barr and Assoc Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.400466' ,`Longitude` = '-95.275041' ,`PhotoCount` = '29' ,`PostalCode` = '77511' ,`RoomCount` = '7' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Mockingbird' ,`StreetNumber` = '2701' ,`StreetSuffix` = 'Drive' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2552' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss this lovely 5 bedroom, 2 1/2 bath located on a corner lot with breakfast nook, formal dining and huge living room. Great outdoor space for entertaining. All bedrooms are upstairs. Master closet is 11 x 16.5\' - can be used as an extra room or closet. This Unique floor plan is waiting for you to make this your dream home. Well established and much sought after subdivision of Deer Trail. This house is a must see!' ,`Acres` = '0.2014' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'DEER TRAIL SUBDIVISION (A0487 HOOPER & WADE)(ALVIN) BLK 6 LO' ,`LotDesciption` = 'Corner' ,`LotSize` = '8773' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'NELSON ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'ALVIN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Deer Trail Sub' ,`TaxAmount` = '6751' ,`TaxRate` = '2.8854' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701158' WHERE `Matrix_Unique_ID` = '208953841' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T01:22:00.573' ,`MLSNumber` = '47842084' ,`ListAgentFullName` = 'Ruth Lopez Hernandez' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = 'Jill Henderson' ,`SellingOfficeName` = 'Red Door Realty & Associates' ,`Latitude` = '29.996619' ,`Longitude` = '-95.146363' ,`PhotoCount` = '45' ,`PostalCode` = '77346' ,`RoomCount` = '9' ,`ListPrice` = '415000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Relay' ,`StreetNumber` = '19206' ,`StreetSuffix` = 'Road' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3368' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful 4bedrooms 3 full baths and guest restroom. Grand entry staircase hardwood treads & iron spindles. Granite countertops in Kitchen and all baths. High ceilings is a Study/Office suite, Formal dinning room area as you walk into the butler\'s kitchen and large walk in pantry. Open kitchen area with 10 ft ceilings on first and second floor. Newly installed Porcelain title in the living room area. Freshly painting throughout. Energy efficient with double pane vinyl windows and trane. You will have overhead storage shelves in garage. Two - ac/units as well as (2) 40 gallon water heaters. You will never run out of hot water.\r\n**WE ARE RECEIVING BACK UP OFFERS IN CASE IF BUYERS ARE NOT ABLE TO PERFORM. SHOWINGS ARE STILL BEING ALLOWED**' ,`Acres` = '0.2975' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 58 BLK 13 OLYMPIC VILLAGE WALDEN ON LAKE HOUSTON PH 2' ,`LotDesciption` = 'In Golf Course Community' ,`LotSize` = '12960' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '365' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'MAPLEBROOK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Walden On Lake Houston Ph 02' ,`TaxAmount` = '7437' ,`TaxRate` = '2.5885' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701158' WHERE `Matrix_Unique_ID` = '209036934' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T01:22:00.573' ,`MLSNumber` = '78329046' ,`ListAgentFullName` = 'Esanet Benedict' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.058043' ,`Longitude` = '-95.501503' ,`PhotoCount` = '37' ,`PostalCode` = '77379' ,`RoomCount` = '10' ,`ListPrice` = '389900.00' ,`Status` = 'Active' ,`StreetName` = 'Ransten' ,`StreetNumber` = '19915' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2987' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing $10K Price Reduction -Priced to SELL! This beautiful property offers the space & lifestyle you\'ve been looking for! 4 generous sized bedrooms, 3 1/2 bath & 3-car garage. Ideal open-concept floor plan with large living room, corner cast stone gas fireplace, open to oversized Kitchen with 42\" maple cabinetry, elegant granite countertops, stone backsplash, stainless-steel appliances, 7\' island, breakfast bar, breakfast room & spacious utility room w/ shelving for additional storage (Refrigerator, Washer/Dryer stay), plus Formal dining or study/bonus room. Primary bedroom is privately situated on main floor with ensuite & walk-in closet. Upstairs is a massive game room/loft, with 3 additional bedrooms & 2 full baths. Backyard is serene & spacious with covered patio & irrigation system at back & front. Wonderful neighborhood amenities include pool, clubhouse, tennis, park & lakes. Zoned to popular Klein ISD. Great location close to Hwy 99, I-45, 249, Exxon Campus, Dining & Shopping!' ,`Acres` = '0.1525' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 4 SENTERRA LAKES SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6641' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KUEHNLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KRIMMEL INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Senterra Lakes Sec 01' ,`TaxAmount` = '7843' ,`TaxRate` = '2.5965' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701158' WHERE `Matrix_Unique_ID` = '209120444' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T01:22:00.573' ,`MLSNumber` = '5562222' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.541280' ,`Longitude` = '-95.315341' ,`PhotoCount` = '23' ,`PostalCode` = '77584' ,`RoomCount` = '10' ,`ListPrice` = '394702.00' ,`Status` = 'Active' ,`StreetName` = 'Patton' ,`StreetNumber` = '6111' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2140' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'See 3D Virtual Tour! Beautiful Kempton Floor Plan with 4 Bedrooms, 2 1/2 Baths, with 2 car garage. UPGRADES GALORE! Wrought Iron Spindles to Stainless Steel Appliances! You will love this floor plan with a formal dining room, a kitchen that looks out to the spacious family room and is central to both the dining room and breakfast nook, a secluded master suite with a large walk-in closet in the owner’s retreat, a convenient walk-in utility room with easy access to the garage and family room, and upstairs game room with 3 bedrooms. 10X20 Patio with fenced backyard. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Thermostat, Pex Hot & Cold Water Lines, Radiant Barrier, Rheem Gas Tankless Water Heater, and Vinyl Double Pane Low E Windows that open to the inside of the home for Cleaning. Community amenities include park and Mary’s Creek Trail which is part of the Pearland\'s Connectivity Trail. Convenient to TX-288, Beltway 8, and I-610. Pearland ISD.' ,`Acres` = '0.1571' ,`Area` = '5' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CYPRESS VILLAGE SEC 3 (A0546 HT&B) (PEARLAND) BLK 1 LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6843' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '275' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'MASSEY RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Village' ,`TaxAmount` = '988' ,`TaxRate` = '3.518' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701158' WHERE `Matrix_Unique_ID` = '209170834' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T01:22:00.573' ,`MLSNumber` = '91466926' ,`ListAgentFullName` = 'Wade Knight' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.751050' ,`Longitude` = '-95.399886' ,`PhotoCount` = '30' ,`PostalCode` = '77006' ,`RoomCount` = '7' ,`ListPrice` = '555000.00' ,`Status` = 'Active' ,`StreetName` = 'Haddon' ,`StreetNumber` = '1521' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2841' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Co-Listed with Nadia Carron! Enjoy sophisticated living in the heart of everything. This stunning townhome distinguishes itself with lovely, attractive finishes throughout. Beautifully appointed 3-bedroom, 3-1/2 bath, free-standing home in gated community with views of tree lined park. This gem is located minutes from Memorial Park, downtown and the Texas Medical Center. Fabulous open living with abundant light. Built by Lovett with marble flooring in entry and master bath and hardwoods throughout. Wonderful built-ins, crown molding and custom shutters. Granite counters in kitchen and bathrooms. All bedrooms have en-suite bath. Terrific closet space including two spacious master closets. Tile roof. Washer/dryer, refrigerator and 50\" TV included. High-efficiency HVAC, recent 3-ton A/C unit, recent tankless water heater and recent epoxy garage floor. Custom iron entry door. Walk to River Oaks Shopping Center and Whole Foods.' ,`Acres` = '0.0396' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Montrose' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 1 HADDON COURT T/H' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1727' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2575' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WOODROW WILSON MONTESSORI' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Haddon Court Twnhms' ,`TaxAmount` = '11452' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701158' WHERE `Matrix_Unique_ID` = '209258510' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T01:22:00.573' ,`MLSNumber` = '3453903' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.232508' ,`Longitude` = '-95.705321' ,`PhotoCount` = '7' ,`PostalCode` = '77354' ,`RoomCount` = '3' ,`ListPrice` = '288490.00' ,`Status` = 'Active' ,`StreetName` = 'WINTER GRASS BEND' ,`StreetNumber` = '40545' ,`StreetSuffix` = '' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1501' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful NEW Express Home in the best location! Lovely property with great curb appeal with landscape package! Open floor plan with designer details and modern finishes! Great island kitchen with granite countertops! Perfect bedroom one suite with spa like bath and spacious closet! Also features a useful covered back patio! Mill Creek is in a great area and is zoned to Magnolia ISD! Hurry and call today!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Mill Creek Estates 02, BLOCK 2, Lot 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6250' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mill Creek' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701159' WHERE `Matrix_Unique_ID` = '209457017' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T01:22:00.573' ,`MLSNumber` = '32204387' ,`ListAgentFullName` = 'Hong Huynh' ,`ListOfficeName` = 'Home Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.567050' ,`Longitude` = '-95.745184' ,`PhotoCount` = '38' ,`PostalCode` = '77469' ,`RoomCount` = '10' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Lively Ferry' ,`StreetNumber` = '23714' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3103' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to our beautiful home in Veranda community, built by Highland Homes builder in 2020. This home is a 1.5 stories that comes with game room area, study office and other attractive features. A 3-garage for additional parking or ample storage. High ceiling with 8 ft windows throughout the house, tank less water heater and sprinkle water system installed. Home has been diligently maintained and ready to be enjoyed by its new owner.\r\n\r\nOPEN HOUSE SUNDAY from 2PM-5PM' ,`Acres` = '0.1922' ,`Area` = '30' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'VERANDA SEC 30, BLOCK 3, LOT 20' ,`LotDesciption` = 'Cleared' ,`LotSize` = '8372' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '990' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = 'Fiberglass' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'PHELAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Veranda' ,`TaxAmount` = '9289' ,`TaxRate` = '3.1798' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701159' WHERE `Matrix_Unique_ID` = '209703017' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T01:22:00.573' ,`MLSNumber` = '55642657' ,`ListAgentFullName` = 'Jin Jin' ,`ListOfficeName` = 'Daytown International LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.706409' ,`Longitude` = '-95.878401' ,`PhotoCount` = '50' ,`PostalCode` = '77441' ,`RoomCount` = '11' ,`ListPrice` = '385000.00' ,`Status` = 'Active' ,`StreetName` = 'Crystal Rose Lane' ,`StreetNumber` = '29135' ,`StreetSuffix` = '' ,`City` = 'Fulshear' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2407' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Must See! Pretty 2-story home with 4 beds, 2.5 baths& 2 car attached garage, and 1 game room upstairs located in master community Cross Creek Ranch; the fresh paint. This master planned community has parks, hike & bike trails, pools w/resort style waterpark, dog park, tennis courts and more! Easy access to FM 1093 Rd. call for today.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'THE BROOKS AT CROSS CREEK RANCH SEC 1, BLOCK 2, LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6376' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cross Creek Ranch' ,`TaxAmount` = '9546' ,`TaxRate` = '3.33' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701159' WHERE `Matrix_Unique_ID` = '209734165' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T01:22:00.573' ,`MLSNumber` = '39808877' ,`ListAgentFullName` = 'Peter Van Borssum' ,`ListOfficeName` = 'Sand N Sea Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.148307' ,`Longitude` = '-95.045267' ,`PhotoCount` = '40' ,`PostalCode` = '77554' ,`RoomCount` = '12' ,`ListPrice` = '749500.00' ,`Status` = 'Active' ,`StreetName` = 'Concho' ,`StreetNumber` = '3754' ,`StreetSuffix` = 'Key' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1520' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 3754 Concho Key. This canal home is ideally situated to take in the bay/wetlands view of the bird sanctuary just to the east of the home and glorious sunrises from the expansive covered east facing deck. The property is walking distance from the Sea Isle fishing pier, across the street from a vast area to kayak & wade fish as well as a short boat ride to the marina for fuel/bait/supplies and then out to the bay. The home features a large living/dining area and kitchen that are all open to one another in addition to 4 bedrooms, 2 bathrooms and a spacious utility room all on a single level. 3 of the bedrooms have direct access to the outdoor decks. Each room of the home offers wonderful water views, you will also find over 850 sq ft of deck space for additional entertaining and enjoying the outdoors, on the south or east facing decks. The home is being offered furnished, and was used in previous years as a resort rental and should do well in the future as an STR.' ,`Acres` = '0.1536' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric,Window Unit' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 18 LOT 1464 SEA ISLE 2ND EXTENSION' ,`LotDesciption` = 'Corner,Subdivision Lot,Waterfront' ,`LotSize` = '6690' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '231' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sea Isle Ext 2' ,`TaxAmount` = '9013' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663701159' WHERE `Matrix_Unique_ID` = '209826394' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T01:22:00.573' ,`MLSNumber` = '15612583' ,`ListAgentFullName` = 'Nicole Shields' ,`ListOfficeName` = 'CRI Real Estate Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.287612' ,`Longitude` = '-95.408088' ,`PhotoCount` = '36' ,`PostalCode` = '77301' ,`RoomCount` = '6' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Strong Horse' ,`StreetNumber` = '2302' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3065' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Highly desirable 2 story home in Barton Woods. One of the largest floor plans available. 4 bedrooms with primary down, game room and secondary rooms upstairs.Home office or flex room with large walk in storage closet, half bath and spacious laundry downstairs. Wood vinyl plank floors in main living spaces, granite counters in kitchen with double ovens and gas range. Tankless water heater, sprinkler system and water softener. Primary suite has 2 closets, separate shower/tub double vanities. This property backs to a walking trail in the neighborhood and has back gate to access. , no back neighbors! Back covered patio for outdoor enjoyment. Easy access to I-45, shopping and dining. Barton Woods is equipped with community pool, trails and park. Backyard has rear gate leading to neighboring park and pathway.' ,`Acres` = '0.1398' ,`Area` = '19' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S249503 - BARTON WOODS 03, BLOCK 1, LOT 14' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6090' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Barton Woods 03' ,`TaxAmount` = '6978' ,`TaxRate` = '2.7863' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701159' WHERE `Matrix_Unique_ID` = '209839173' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T01:22:00.573' ,`MLSNumber` = '95566977' ,`ListAgentFullName` = 'Polina Solis' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.927964' ,`Longitude` = '-95.688687' ,`PhotoCount` = '40' ,`PostalCode` = '77433' ,`RoomCount` = '8' ,`ListPrice` = '549900.00' ,`Status` = 'Active' ,`StreetName` = 'Pecan Bayou' ,`StreetNumber` = '17910' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3548' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PRICE IMPROVEMENT! Welcome to a 2 story luxury home located in the GATED section of award winning community of Towne Lake. You cannot get any closer to the water at this price in Towne Lake. Home is within walking distance to all of the amenities; lakehouse with gym overlooking the lake, tennis courts, lazy river, splashpad, playground, private sandy beach, swimming pools. So close to the Towne Lake boardwalk with restaurants and entertainment! This home features gourmet Kitchen with granite oversized island/breakfast bar and 42 inch cabinets, SS appliances. Rich Hardwood flooring, tile in all wet areas, cozy fireplace with tile surround, massive game room up with enough room to add a 5th bedroom or a media room. Primary suite features oversized closet & luxurious bathroom. Extra workspace in tandem garage! Covered back patio complete w/outdoor kitchen. Zoned to exemplary schools. Refrigerator stays!' ,`Acres` = '0.1447' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 1 TOWNE LAKE SEC 17' ,`LotDesciption` = 'Water View' ,`LotSize` = '6305' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2180' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'RENNELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Towne Lake Sec 17' ,`TaxAmount` = '14218' ,`TaxRate` = '3.091' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701159' WHERE `Matrix_Unique_ID` = '209860378' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T01:22:00.573' ,`MLSNumber` = '89626095' ,`ListAgentFullName` = 'Tom Parks' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.693705' ,`Longitude` = '-95.479040' ,`PhotoCount` = '45' ,`PostalCode` = '77401' ,`RoomCount` = '14' ,`ListPrice` = '2100000.00' ,`Status` = 'Active' ,`StreetName` = 'Valerie' ,`StreetNumber` = '5318' ,`StreetSuffix` = 'Street' ,`City` = 'Bellaire' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5497' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Home in the Heart of Bellaire. This Custom Home was Built by the Original/current owner. Elegance and Pride run throughout. Starts with the long circular drive. Stately Home entrance leads to the an impressive Grand Entryway with Soaring ceilings, centered by a Beautiful Staircase. The 2-story marble living room, family/media room overlook a 20\' by 40\' Grecian style, heated pool. No time to go to the gym (extra room), You\'ll have your own here! One guest suite down, huge primary bedroom suite up! 3 large additional bedrooms up. Could configure 6. Huge poolside covered patio and above is a large balcony off the primary suite. The home features a huge game room. Gourmet kitchen features top of the line Appliances, Gaggenau Range that has indoor grill and fryer. Home features a driveway gate for extra security and room for additional parking. Your Whole home Generator supplying extra layer of security and comfort. A Truly must see only minutes from Galleria and Medical center.' ,`Acres` = '0.47' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bellaire Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK 10 BRAEBURN CNTRY CLUB ESTS SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '20475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Braeburn Cntry Club Estates Se' ,`TaxAmount` = '29879' ,`TaxRate` = '2.2271' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701159' WHERE `Matrix_Unique_ID` = '210181235' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T01:22:00.573' ,`MLSNumber` = '23372650' ,`ListAgentFullName` = 'Kate Glass' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.727121' ,`Longitude` = '-95.469543' ,`PhotoCount` = '11' ,`PostalCode` = '77056' ,`RoomCount` = '7' ,`ListPrice` = '640000.00' ,`Status` = 'Active' ,`StreetName` = 'Windswept' ,`StreetNumber` = '5326' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2530' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great Location! Nestled on the private street of Windswept Lane is this BEAUTIFUL, completely remodeled including addition (2017), Galleria GEM! Stunning finishes including marble counter tops, designer lighting/chandeliers, hardwood floors, and endless built-ins for extra storage. Flowing functional floor plan with 5 bedrooms which can flex for multipurpose use. Your luxurious primary suite features a wall of built-ins with window seat, double sink with marble countertops, floor to ceiling marble shower with seamless glass, and spacious walk-in closet with wall access into laundry room. Kitchen features soft-close cabinets, marble countertops, floating shelves, gas range and custom range hood. Exterior features large backyard and circle driveway for additional parking. Conveniently located within minutes of downtown and the medical center with quick access to major highways! Walking distance to highly rated shopping and dining! Buyers, your patience has paid off! Move-in Ready!!' ,`Acres` = '0.1771' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Galleria' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 17 BLK 12 LARCHMONT SEC 1' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '7713' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Convection Oven,Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SCHOOL AT ST GEORGE PLACE' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,French' ,`Subdivision` = 'Larchmont Sec 01' ,`TaxAmount` = '10987' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663701160' WHERE `Matrix_Unique_ID` = '210210450' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T01:22:00.573' ,`MLSNumber` = '34632089' ,`ListAgentFullName` = 'Alex Lyon' ,`ListOfficeName` = 'Full Circle Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.550163' ,`Longitude` = '-95.034614' ,`PhotoCount` = '50' ,`PostalCode` = '77565' ,`RoomCount` = '7' ,`ListPrice` = '1495000.00' ,`Status` = 'Active' ,`StreetName` = 'Shore' ,`StreetNumber` = '1203' ,`StreetSuffix` = 'Drive' ,`City` = 'Clear Lake Shores' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '4321' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Impressive waterfront retreat offering spectacular views of Clear Lake from every angle! Enjoy fishing & swimming from the 100 ft. dock. Cruising to local entertainment or a day on the lake is convenient with your personal boatlift steps away. 3 stories of covered patios for outdoor entertaining & watching unforgettable sunsets. Inside provides an open concept great room with gourmet kitchen & dining area all with views that will captivate your attention. The generously sized primary suite on the main level won\'t disappoint. Huge space on the ground level with full kitchen & bathroom perfect for guest quarters, multigenerational living, studious office or another entertaining room. The views continue up in a massive media/game room & 2 additional bedrooms. CLS offers golf cart friendly streets, scenic parks, community pool, pavilion & boat launch. Minutes from marinas, shopping & restaurants. CCISD, low taxes & no HOA! Be sure to read more on the Property Features List in attachments.' ,`Acres` = '0.1571' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 18 M MULDOON SUR LOTS 2232 THRU 2235 & PT OF LOTS 2230,' ,`LotDesciption` = 'Corner,Subdivision Lot,Waterfront' ,`LotSize` = '6842' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '3' ,`Style` = 'Craftsman' ,`Subdivision` = 'Clear Lake Shores' ,`TaxAmount` = '15485' ,`TaxRate` = '1.8341' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663701160' WHERE `Matrix_Unique_ID` = '210303976' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T01:22:00.573' ,`MLSNumber` = '3191582' ,`ListAgentFullName` = 'Tali Navon' ,`ListOfficeName` = '5th Stream Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.683498' ,`Longitude` = '-95.486098' ,`PhotoCount` = '13' ,`PostalCode` = '77096' ,`RoomCount` = '6' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Jason' ,`StreetNumber` = '5531' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1158' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Newly remodeled home with brand new appliances, new kitchen cabinets, Bathrooms newly tiled and new cabinets, new kitchen cabinets, hardwood floors resurfaced, freshly pained interior and exterior, attic blowup insulation. Very inviting with an open concept kitchen/dining/living area and lots of light. Lots of backyard space great for entertaining. Wonderful quiet neighborhood Located close to all major shopping, great schools, medical center, and Galleria. DID NOT FLOOD!!' ,`Acres` = '0.154' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Meyerland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 BARKLEY CIRCLE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6710' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HEROD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'FONDREN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Barkley Circle' ,`TaxAmount` = '5447' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701160' WHERE `Matrix_Unique_ID` = '210467300' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T01:22:00.573' ,`MLSNumber` = '95720345' ,`ListAgentFullName` = 'Helen Nguyen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.661272' ,`Longitude` = '-95.643241' ,`PhotoCount` = '39' ,`PostalCode` = '77498' ,`RoomCount` = '9' ,`ListPrice` = '494999.00' ,`Status` = 'Active' ,`StreetName` = 'Jackson Sawmill' ,`StreetNumber` = '14922' ,`StreetSuffix` = 'Lane' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3335' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cu-de-sac home with top notch upgrades. Excellent schools. Easy access to hwy 6, freeway 59, Beltway 8 and Westpark. Well maintained and gorgeous inside out.' ,`Acres` = '0.2584' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sugar Land North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WOODBRIDGE OF FBC SEC 12, BLOCK 1, LOT 7' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '11258' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '575' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'DRABEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KEMPNER HIGH SCHOOL' ,`SchoolMiddle` = 'SUGAR LAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Woodbridge Of Fbc Sec 12' ,`TaxAmount` = '7047' ,`TaxRate` = '2.2929' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701160' WHERE `Matrix_Unique_ID` = '210470814' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T01:22:00.573' ,`MLSNumber` = '37103424' ,`ListAgentFullName` = 'Dawn Faust' ,`ListOfficeName` = 'Flat Fee Discount Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.313668' ,`Longitude` = '-95.580610' ,`PhotoCount` = '17' ,`PostalCode` = '77316' ,`RoomCount` = '7' ,`ListPrice` = '799999.00' ,`Status` = 'Active' ,`StreetName` = 'Laramie' ,`StreetNumber` = '14377' ,`StreetSuffix` = 'Trail' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '3517' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'QUIET COUNTRY LIVING, MINUTES FROM LAKE CONROE AND WOODFOREST, 7 UNRESTRICTED BEAUTIFUL ACRES WITH\r\nMANY ESTABLISHED OAKS AND HICKORY TREES, READY FOR HORSES, STOCKED POND, FENCED PADDOCKS FOR\r\nHORSES AND LIVESTOCK WITH AVAILABLE WATER, 30x50 METAL BUILDING WITH ELECTRICITY AND COVERED SHEDS ON\r\nBOTH SIDES, SEPARATE INSULATED WELL HOUSE WITH WATER CONDITIONER, LOAFING SHED, HOUSE PLUMBED FOR\r\nGAS OR PROPANE HEAT AND HEATALATOR FIREPLACE.\r\nPROPERTY IS NOT IN FLOOD PLAIN.\r\nOWNER INSTALLED FENCE AROUND THE FRONT OF PROPERTY, AND BACK OF PROPERTY HAS METAL FENCE AROUND\r\nTHE BACK PROPERTY FOR PETS AND CHILDREN. THIS METAL FENCE HAS DOUBLE ENTRY GATE THAT PERMITS VEHICLE\r\nENTRANCE INTO YARD. Please see Realtor Remarks for Showing Instructions.' ,`Acres` = '7' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S810000 - PONDEROSA CITY, BLOCK 26-A, ACRES 7' ,`LotDesciption` = 'Other' ,`LotSize` = '304920' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Call Occupant' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Ponderosa City' ,`TaxAmount` = '9107' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701160' WHERE `Matrix_Unique_ID` = '210513130' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T01:22:00.573' ,`MLSNumber` = '65268291' ,`ListAgentFullName` = 'Kimberly Martino' ,`ListOfficeName` = 'Benevides & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.699875' ,`Longitude` = '-95.636122' ,`PhotoCount` = '22' ,`PostalCode` = '77083' ,`RoomCount` = '5' ,`ListPrice` = '385000.00' ,`Status` = 'Active' ,`StreetName` = 'Playa Bend' ,`StreetNumber` = '14239' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2325' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION, LOCATION, LOCATION! What an opportunity in Terra Del Sol! This home has been well maintained and is ready for it\'s new owner. It is situated on an oversized, corner lot. Spacious floorplan provides an 2 story family room with a wall of windows to let in that natural light. The kitchen features granite counter tops, ss appliances and a eat at bar area and is open to the family room for ease of entertaining. The owners retreat is downstairs with jetted tub, separate shower and walk in closet. Upstairs boast 4 generous sized bedrooms, 2 full bathrooms. No carpet throughout. There is a large covered patio to help keep you shady during those summer months. This home is conveniently located to just about everything; you have easy access to HWY 6, Westpark Toll and are surrounded by shopping and dining. Walking distance to the school and community park.' ,`Acres` = '0.114' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 4 TERRA DEL SOL SEC 9' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '4964' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '560' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'HICKS ELEMENTARY SCHOOL (ALIEF)' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'ALBRIGHT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Terra Del Sol' ,`TaxAmount` = '6934' ,`TaxRate` = '2.5785' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701160' WHERE `Matrix_Unique_ID` = '210562578' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T01:22:00.573' ,`MLSNumber` = '67386281' ,`ListAgentFullName` = 'Laura Bonck' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.792752' ,`Longitude` = '-95.532891' ,`PhotoCount` = '28' ,`PostalCode` = '77055' ,`RoomCount` = '9' ,`ListPrice` = '1100000.00' ,`Status` = 'Active' ,`StreetName` = 'Westview' ,`StreetNumber` = '9760' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '6143' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This one of a kind 5 Bed, 3 bath custom home sits on a corner lot in the wonderful Spring Branch. Walk inside to the retreat style home featuring a beautiful spiral staircase, lots of open space, natural light and tall ceilings. Downstairs features a big kitchen with stainless steel appliances and a gas range stove top. Formal Dining, Formal Living a Den/ Family room with a long bar for hosting friends and family. The downstairs Primary suite with a walk in gun safe is one of 2 Primary suites in the home. Upstairs the Game/Media room with option for theater seating. Two Bedrooms with tall ceilings, jack and jill bathrooms and walk in closets. The 2nd Primary Suite \r\nWith a private balcony this suite has no limits. The suite has 2 MASSIVE walk in closets with a closet island. The Massive Bathroom has a step up jacuzzi tub, 2-person shower. 2 sinks and its own private retreat style balcony. Call/text agent to schedule your tour today!' ,`Acres` = '0.24' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 7 BLK 13 SPRING BRANCH WOODS SEC 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '10454' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'WOODVIEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Spring Branch Woods Sec 02' ,`TaxAmount` = '35892' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701160' WHERE `Matrix_Unique_ID` = '210669449' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T01:22:00.573' ,`MLSNumber` = '98095386' ,`ListAgentFullName` = 'Michelle Wong' ,`ListOfficeName` = 'AlphaMax Realty Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.579297' ,`Longitude` = '-95.604496' ,`PhotoCount` = '34' ,`PostalCode` = '77479' ,`RoomCount` = '8' ,`ListPrice` = '429000.00' ,`Status` = 'Active' ,`StreetName` = 'Planters' ,`StreetNumber` = '3014' ,`StreetSuffix` = 'Street' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2259' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful & Spacious single-story Perry Design in highly sought after Colony Bend subdivision. Full renovation done in 2020, including new roof, luxury vinyl plank flooring in all the main space, full kitchen remodel with soft close cabinets, LED lights installed in main space, beautiful master bathroom with crown molding, soft closing cabinets, tile showers with rain shower faucet, speakers wired in living room, fresh paint in the whole house and more. Private driveway and two car detached garage. High vaulted ceilings in the family room with abundant natural light. Located in the heart of sugar land and zoned to excellent school district (Colony Bend Elementary, First Colony Middle, and Clements High). Walking trail leads to the shopping mall on William Trace.' ,`Acres` = '0.18' ,`Area` = '29' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'COLONY BEND SEC 2, BLOCK 9, LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7839' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '730' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'COLONY BEND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Colonial,Traditional' ,`Subdivision` = 'Colony Bend Sec 2' ,`TaxAmount` = '5813' ,`TaxRate` = '2.1584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701161' WHERE `Matrix_Unique_ID` = '210746750' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T01:22:00.573' ,`MLSNumber` = '95841887' ,`ListAgentFullName` = 'Trudy LeDoux' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.003366' ,`Longitude` = '-95.144652' ,`PhotoCount` = '46' ,`PostalCode` = '77346' ,`RoomCount` = '5' ,`ListPrice` = '270000.00' ,`Status` = 'Active' ,`StreetName` = 'Gamble Oak' ,`StreetNumber` = '19522' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2613' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Need a home with extra space? This is it! This three bedroom home in Atascocita boast all the typical amenities plus bonus spaces. You really must see to appreciate the space. Imagine living in Atacocita Pines, close to Lake Houston, the neighborhood has its own boat launch, pool, etc. This home has had recent updates including new ROOF, new appliances, paint, floors, bathrooms, lights, counters, etc. Light and bright, this home is welcoming for all your guests. Plus, the home retains its original double paned wooden windows. Such a treasure! Enjoy the outdoors, the extra large enclosed patio will be the space for you! Need flex space? There are two rooms out back that could be used for office space, excercise space, hobby space, etc. limited only by your imagination. Make an appointment today to see this one. You will love it!' ,`Acres` = '0.2926' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LTS 47 & 48 BLK 1 PINES OF ATASCOCITA SEC 1' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '12744' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '620' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'PINEFOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pines Atascocita Sec 01' ,`TaxAmount` = '4817' ,`TaxRate` = '2.216' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701161' WHERE `Matrix_Unique_ID` = '210792347' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T01:22:00.573' ,`MLSNumber` = '37456271' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Ziad Al Kayali' ,`SellingOfficeName` = 'Keller Williams Premier RealtyKaty' ,`Latitude` = '29.852738' ,`Longitude` = '-95.742516' ,`PhotoCount` = '8' ,`PostalCode` = '77449' ,`RoomCount` = '5' ,`ListPrice` = '350090.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Flowering Garden Lane' ,`StreetNumber` = '21503' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2170' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'IMPRESSIVE NEW D. R. HORTON BUILT 4 BEDROOM! Desirable Interior Layout with Two Bedrooms & Two Baths Downstairs! Impressive Foyer Opens Onto Gourmet Island Kitchen with Cabinetry Galore, Spacious Dining Area, & Living Room! Privately Located First Floor Primary Suite Offers Lovely Bath with Large Shower & Walk-In Closet! Guest Suite/Second Bedroom Downstairs with Adjoining Full Bath! Generously Sized Indoor Utility Room! Huge Gameroom/Media Room Up! Hard Surface Flooring in Living Area! Covered Patio Overlooks Tranquil Backyard! Ready for AUGUST 2022 MOVE IN!!! Hurry and call TODAY!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 - Block 2 - Section 21' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6344' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'GOLBOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'MCDONALD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Jasmine Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701161' WHERE `Matrix_Unique_ID` = '210829611' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T01:22:00.573' ,`MLSNumber` = '19832901' ,`ListAgentFullName` = 'Nicole Fenwick' ,`ListOfficeName` = 'Beard Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.656797' ,`Longitude` = '-95.596550' ,`PhotoCount` = '23' ,`PostalCode` = '77477' ,`RoomCount` = '8' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Meadowdale' ,`StreetNumber` = '12318' ,`StreetSuffix` = 'Drive' ,`City` = 'Meadows Place' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2911' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Large 2 story home nestled in the wonderful City of Meadows Place. As you enter in the front door you are greeted with an open concept floor plan on the 1st floor. Directly to your left is a space that can be used as a formal dining or an office space. It can be separated from the house by glass french doors. A beautiful double-sided fireplace brings the two large living spaces together. Long kitchen great for cooking with the family. Indoor laundry room. Half bath great for when entertaining guests. Primary Bedroom on the 1st floor!!! Complete with spacious in-suite bathroom and a multitude of closet space. 3 bedrooms upstairs with plenty of storage. NO HOA.' ,`Acres` = '' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Stafford Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'THE MEADOWS SEC 4, BLOCK 33, LOT 38' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8612' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'MEADOWS ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Meadows' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663701161' WHERE `Matrix_Unique_ID` = '210945598' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T01:22:00.573' ,`MLSNumber` = '17714643' ,`ListAgentFullName` = 'Heather Trocmet' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.241893' ,`Longitude` = '-95.488707' ,`PhotoCount` = '29' ,`PostalCode` = '77384' ,`RoomCount` = '9' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Carissa Holly' ,`StreetNumber` = '1006' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2950' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fully upgraded home in Jacobs reserve with easy access to Woodlands! You will love this fantastic one-story English Style Tudor home with 4 bed/3 bath & 3-car tandem garage! Built by top-of-the-line builder Emerald homes, this home offers an open concept floor plan (Avalon elev. C) with a formal dining room, dedicated study, and a huge family room with a fireplace, hand-scrapped hardwood floor, and soaring ceilings. Open to the family room is the chef’s kitchen with an island, granite counters, and GE Monogram appliances. Home boasts SmartHome features and a transferable warranty on a $35K roof and gutters (installed Aug 2022). Newly resurfaced front door and added front door protective screen, newly installed screen in porch with Northside sliding windows, newer courtyard brick floor, and recently reinforced side fence. Epoxy floor in garage and on the porch, home is super insulated! Greenbelt with mature trees next door provides privacy, several fruit trees in the backyard. MUST SEE!' ,`Acres` = '0.1865' ,`Area` = '15' ,`BuilderName` = 'Emerald home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S589102 - HOLLY TERRACE AT JACOBS RESERVE 02, BLOCK 1, LOT 3' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8122' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GALATAS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'English' ,`Subdivision` = 'Holly Terrace At Jacobs Reserv' ,`TaxAmount` = '11929' ,`TaxRate` = '2.7488' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701161' WHERE `Matrix_Unique_ID` = '210965404' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T01:22:00.573' ,`MLSNumber` = '81093047' ,`ListAgentFullName` = 'Bryan Hedges' ,`ListOfficeName` = 'Berkshire Hathaway HomeService' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.391796' ,`Longitude` = '-95.613650' ,`PhotoCount` = '32' ,`PostalCode` = '77356' ,`RoomCount` = '9' ,`ListPrice` = '289900.00' ,`Status` = 'Active' ,`StreetName` = 'Willowbend' ,`StreetNumber` = '3227' ,`StreetSuffix` = 'Road' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderfully updated home in Montgomery ISD for under $300k. This home has been cared for and updated by current owner over the past 4 years. 3 Bedroom with office or 4 Bedroom (there is closet in Office). New floors in living room. New Fireplace surround. Many other updates. Storage building in place in backyard. Great neighborhood with fantastic amenities. Golf Course, Yacht Club, Tennis Club, Lake Access and Community Pool. Award winning Montgomery schools including Madeley Ranch Elementary inside the subdivision. Schedule your appointment quickly before this one is gone.' ,`Acres` = '0.1653' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WALDEN 08, BLOCK 24, LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MADELEY RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Walden 08' ,`TaxAmount` = '4425' ,`TaxRate` = '2.2242' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701161' WHERE `Matrix_Unique_ID` = '210988216' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T01:22:00.573' ,`MLSNumber` = '7633346' ,`ListAgentFullName` = 'Evan Compean' ,`ListOfficeName` = 'Compean Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.811443' ,`Longitude` = '-95.400433' ,`PhotoCount` = '29' ,`PostalCode` = '77008' ,`RoomCount` = '7' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = '27th' ,`StreetNumber` = '219' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2491' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this adorable gated community conveniently located in the Heights. Spacious foyer greets you in this amazing floor plan! 2 (of 4) bedrooms are on the first floor share a Jack & Jill bathroom. Move upstairs to the main level greeted by handsome hardwood floors & an open plan, great for entertaining. Formal dining with pass through to kitchen which has ample cabinet and counter space! If you have an abundance of kitchen gadgets or a Costco addiction, then the huge pantry will make you smile;-) This layout showcases how defined spaces can remain open with effortless flow & breathability. Entertaining proves to be second nature by utilizing the centrally located kitchen with immediate access to the living area, dining room, & wine display bar. The primary retreat features a tray ceiling, bay window seating area, great walk-in closet, & resort-like bath. This location provides ideal access to the the city in all directions. So many places of interest are super close!' ,`Acres` = '0.0439' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 WEST 27TH PLACE' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '1911' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HELMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Victorian' ,`Subdivision` = 'West 27th Place' ,`TaxAmount` = '10471' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701162' WHERE `Matrix_Unique_ID` = '211050351' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T01:22:00.573' ,`MLSNumber` = '31716471' ,`ListAgentFullName` = 'Gayle Kennedy' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.714362' ,`Longitude` = '-95.352826' ,`PhotoCount` = '12' ,`PostalCode` = '77004' ,`RoomCount` = '7' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Rosedale' ,`StreetNumber` = '3837' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1342' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home was taken to the studs and fully renovated in 2018 and 2019. The foundation was leveled, plumbing replaced, electrical replaced, new double pane vinyl windows, roof replaced, new engineered hard wood flooring, new counters and cabinets and appliances. Just beautiful and waiting for you! The HVAC is a 16 SEER rated Carrier system to help lower the electrical bills. There are generous closets in each bedroom and the utility room is in the house with washer and dryer included in the sale. Come take a look today!' ,`Acres` = '0.1543' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 25 BLK 5 OAK MANOR SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6720' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOCKHART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Manor 1' ,`TaxAmount` = '3035' ,`TaxRate` = '2.6454' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1951' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701162' WHERE `Matrix_Unique_ID` = '211222480' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T01:22:00.573' ,`MLSNumber` = '68228620' ,`ListAgentFullName` = 'Adriane Taylor' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.143366' ,`Longitude` = '-95.433678' ,`PhotoCount` = '50' ,`PostalCode` = '77386' ,`RoomCount` = '10' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Hanna' ,`StreetNumber` = '26226' ,`StreetSuffix` = 'Road' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2456' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming Colonial Meets Modern Design! Situated On Nearly 1/2 An Acre Of A Private Wooded, Lot! Tasteful Updates In Kitchen Include; Custom Cabinetry W/Beautiful Hardware, Silestone Counters + Bar, KitchenAid Convection Microwave/Oven, 5-Burner Gas Cooktop W/Vent Hood. Fully Remodeled Primary Bath Has A Double Vanity & An Accessible Walk-In Shower W/Bench Seat. Second Floor Bath Has Updated Vanities, Fixtures, Floors, & Tile Surround Shower/Tub Combo. This Home Combines The Allure Of Classic Design W/State Of The Art Amenities Including Energy Star Appliances, LED Lights, High-Efficiency HVAC, Insulated Doors, Radiant Attic Barrier & More-All Helping To Keep Your Energy Costs Low. The Detached Oversized 2-Car Garage Provides Ample Space For Cars + Room For A Workshop/Mancave. Conveniently Located Across From The Woodlands - Full Of Restaurants, Shops, Hospitals, Entertainment Options & More. Zoned To Highly Acclaimed Conroe ISD, LOW Taxes, & NO HOA! What More Can You Ask For?!' ,`Acres` = '0.4649' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'SPRING OAKS, LOT 67' ,`LotDesciption` = 'Greenbelt,Subdivision Lot,Wooded' ,`LotSize` = '20250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'OAK RIDGE ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'Spring Oaks' ,`TaxAmount` = '3569' ,`TaxRate` = '2.0087' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701162' WHERE `Matrix_Unique_ID` = '211223078' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T01:22:00.573' ,`MLSNumber` = '57768017' ,`ListAgentFullName` = 'Gina Arriondo' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.743369' ,`Longitude` = '-95.617643' ,`PhotoCount` = '41' ,`PostalCode` = '77077' ,`RoomCount` = '6' ,`ListPrice` = '459500.00' ,`Status` = 'Active' ,`StreetName` = 'Pueblo Nuevo Path' ,`StreetNumber` = '1906' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2428' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Gorgeous, Modern 3-bedroom, 3.5-bath Waterfront Home is only minutes away from anywhere you want to be at Park & Lake Villas. The first level features an impressively spacious third bedroom or optional study with full bathroom, with access to the waterfront patio. The second level opens up to a magnificent family room coupled with the kitchen and dining area. Your amazing new kitchen is decorated with 42” cabinets, an island topped with Omega Stone in Rome, accented with marble patterned cabinets, and stainless steel appliances. Secluded away on the 3rd level is your grand owner’s suite and secondary bedroom with full bath. Your new Owner’s Bath flaunts large Modern Hearth Tiles across the floor and separate beautiful vanities with a large walk-in shower or grand tub. The private walk-in closet is amazing! Hardwood flooring and oversize marble tile throughout. You will love the convenience of this quaint new Houston community surrounded by a variety of recreational activities!' ,`Acres` = '0.037' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 1 REFLECTIONS SEC 2 2ND PAR R/P' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '1610' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2160' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DAILY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Controlled Access,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Mediterranean' ,`Subdivision` = 'Park & Lake Villa' ,`TaxAmount` = '9252' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701162' WHERE `Matrix_Unique_ID` = '211233944' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T01:22:00.573' ,`MLSNumber` = '44820575' ,`ListAgentFullName` = 'Jack McLemore' ,`ListOfficeName` = 'Listing Results, LLC' ,`SellingAgentFullName` = 'Lauren Taylor' ,`SellingOfficeName` = 'Compass RE Texas, LLC' ,`Latitude` = '29.819397' ,`Longitude` = '-95.534490' ,`PhotoCount` = '31' ,`PostalCode` = '77080' ,`RoomCount` = '12' ,`ListPrice` = '355000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Palo Pinto' ,`StreetNumber` = '2619' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2029' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This classic, white-washed, 2029 sf, brick home was built in 1968 and is now priced to sell. Luxury Vinyl plank flooring installed in 2022, roof replaced in 2016, all new PEX water line piping installed in 2016, and master bath renovated in 2016. Four bedrooms and two full baths. The home is located in the popular Spring Shadows neighborhood and zoned for Spring Bransh ISD. Enjoy a large backyard with mature trees and landscaping. Lots of potential for someone to update with paint and furnishings. Easy access to many entertainment and eating establishments.' ,`Acres` = '0.1809' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 54 BLK 6 SPRING SHADOWS SEC 4' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '7879' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '336' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'SPRING SHADOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING WOODS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Shadows Sec 04' ,`TaxAmount` = '6923' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701162' WHERE `Matrix_Unique_ID` = '211346874' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T00:36:45.770' ,`MLSNumber` = '25452564' ,`ListAgentFullName` = 'Huongthao Do' ,`ListOfficeName` = 'Exceed Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.580285' ,`Longitude` = '-95.603171' ,`PhotoCount` = '31' ,`PostalCode` = '77479' ,`RoomCount` = '6' ,`ListPrice` = '410000.00' ,`Status` = 'Active' ,`StreetName` = 'Edgewood' ,`StreetNumber` = '3034' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2796' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your beautiful newly updated 4 bedroom 2 1/2 bath with a nice private pool in the back yard home. House is featured with new fresh paint, new laminate flooring on stairs and upstairs. NO CARPET. Pool with safety iron fence. Zoned to highly desired FBISD (Clement High School). Conveniently close to First Colony Mall, restaurants, grocery stores, hospitals and Smart Financial Center. Low Tax Rate.' ,`Acres` = '0.1822' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'COLONY BEND SEC 2, BLOCK 6, LOT 16' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7935' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '730' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Enclosed,Gunite,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'COLONY BEND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Colony Bend Sec 2' ,`TaxAmount` = '6562' ,`TaxRate` = '2.1584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701162' WHERE `Matrix_Unique_ID` = '211663150' --> Updated record success